You are browsing the archive for Concurrent Requests & Reports.

Publish bid for super large negotiations

 

NAME: Publish bid for super large negotiations
SHORT CODE: PON_PUBLISH_BID_CP
MODULE: Oracle Sourcing

Description: Publish bid for super large negotiations
Navigation: Oracle Sourcing Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_auction_header_id : Auction header ID of the super large negotiation
  • p_bid_number : Bid number of the bid to be published
  • p_rebid_flag : Rebid flag, Y if rebid, N if fresh bid
  • p_publish_date : Publish date in string form
  • p_date_mask : Date format mask for p_publish_date
  • p_tp_id : Trading partner ID
  • p_tpc_id : Trading partner contact ID
  • p_user_type : SUPPLIER or BUYER
  • p_user_id : FND User ID

 

Download Negotiation Lines for New Round/Amendment

 

NAME: Download Negotiation Lines for New Round/Amendment
SHORT CODE: PON_LINES_DOWNLOAD
MODULE: Oracle Sourcing

Description: Download Negotiation Lines for New Round/Amendment
Navigation: Oracle Sourcing Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_AUCTION_HEADER_ID : The auction header id
  • P_INSTRUCTION_FILE_ID : The instruction file Id
  • P_USER_NAME : The user name of the user who initiated the request
  • P_USER_ID : The user id of the user who initiated the request

 

Response spreadsheet upload

 

NAME: Response spreadsheet upload
SHORT CODE: PON_IMPORT_RESPONSE
MODULE: Oracle Sourcing

Description: Upload a response spreadsheet
Navigation: Oracle Sourcing Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_AUCTION_HEADER_ID : Negotiation auction header id
  • P_BID_NUMBER : Bid number
  • P_DOWNLOAD_BID_NUM : Download bid number
  • P_USER_TYPE : BUYER or SUPPLIER
  • P_IMPORT_FILE_ID : File id in FND_LOBS
  • P_IMPORT_FILE_NAME : File name in FND_LOBS
  • P_IMPORT_FILE_FORMAT :