You are browsing the archive for Concurrent Requests & Reports.

Import Lines Spreadsheet for Negotiation Creation

 

NAME: Import Lines Spreadsheet for Negotiation Creation
SHORT CODE: PON_IMPORT_LINES
MODULE: Oracle Sourcing

Description: Import Lines Spreadsheet for Negotiation Creation
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 :
  • P_REQUESTED_BY_USER_ID :
  • P_REQUESTED_BY_PARTY_ID :
  • P_REQUESTED_BY_USER_NAME :
  • P_IMPORT_FILE_ID :
  • P_IMPORT_FILE_NAME :
  • P_USER_DATE_FORMAT :

 

Import Award Spreadsheet and store as draft award

 

NAME: Import Award Spreadsheet and store as draft award
SHORT CODE: PON_IMPORT_AWARD
MODULE: Oracle Sourcing

Description: Award By Spreadsheet: Import
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_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_CONTACT_ID : hz_parties.party_id or trading_partner_contact_id of the person who submitted this request
  • P_REQUESTED_DATE : date/time when this request was submitted
  • P_IMPORT_FILE_ID : file_id of the uploaded file stored in fnd_lobs
  • P_IMPORT_FILE_NAME : file_name of the uploaded file stored in fnd_lobs
  • P_IS_XML_IMPORT : if the imported file is Xml format

 

Generate and Store Sourcing Contracts Pdf

 

NAME: Generate and Store Sourcing Contracts Pdf
SHORT CODE: PON_GENERATE_PDF
MODULE: Oracle Sourcing

Description: Generates the Sourcing PDF with contracts and stores it in the contracts respository
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 pdf being stored
  • P_CLIENT_TIME_ZONE : Client Time Zone of the user.
  • P_SERVER_TIME_ZONE : Server Time Zone
  • P_DATE_FORMAT_MASK : Date Format Mask of the User