NAME: Generate and Store Sourcing Analysis/Award Spreadsheet
SHORT CODE: PON_EXPORT_AWARD
MODULE: Oracle Sourcing

Description: Award By Spreadsheet: Export
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 current negotiation
• P_DOWNLOAD_BID_STATUS : the status of the bids being downloaded (active, shortlisted, all, etc.)
• P_EXPORT_SCENARIO : either auto-award spreadsheet or normal spreadsheet
• P_REQUEST_ID :
• P_REQUESTED_BY_USER_ID : fnd_user.user_id of the person who submitted this request
• P_REQUESTED_BY_USER_NAME : fnd_user.user_name of the person who submitted this request
• P_REQUESTED_BY_USER_TYPE : either buyer or supplier users can export a spreadsheet
• P_REQUESTED_BY_DATE : date/time when this request was submitted
• P_HAS_AWARD_PRIVILEGE : Indicates whether this person can award the negotiation
• P_INSTRUCTION_FILE_ID : file_id of the instruction file that was saved in fnd_lobs at run time
• P_INSTRUCTION_FILE_NAME : file_name of the instruction file
• P_REQUEST_ACTION_TYPE : used to determine the type of email we will send to the request