eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_BIZ_EVENTS_PVT dependencies on PON_AUCTION_HEADERS_ALL

Line 72: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;

68: x_return_status IN OUT NOCOPY VARCHAR2,
69: x_msg_count IN OUT NOCOPY NUMBER,
70: x_msg_data IN OUT NOCOPY VARCHAR2)
71: IS
72: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
73: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
74: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
75: l_open_bidding_date VARCHAR2(100);
76: l_close_bidding_date VARCHAR2(100);

Line 73: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

69: x_msg_count IN OUT NOCOPY NUMBER,
70: x_msg_data IN OUT NOCOPY VARCHAR2)
71: IS
72: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
73: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
74: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
75: l_open_bidding_date VARCHAR2(100);
76: l_close_bidding_date VARCHAR2(100);
77: l_publish_date VARCHAR2(100);

Line 74: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;

70: x_msg_data IN OUT NOCOPY VARCHAR2)
71: IS
72: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
73: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
74: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
75: l_open_bidding_date VARCHAR2(100);
76: l_close_bidding_date VARCHAR2(100);
77: l_publish_date VARCHAR2(100);
78:

Line 110: FROM PON_AUCTION_HEADERS_ALL

106: l_auction_title,
107: l_open_bidding_date,
108: l_close_bidding_date,
109: l_publish_date
110: FROM PON_AUCTION_HEADERS_ALL
111: WHERE AUCTION_HEADER_ID = p_auction_header_id;
112:
113: --
114: -- Add the parameters

Line 201: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

197: )
198: IS
199: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;
200: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;
201: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
202: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
203: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
204: l_publish_date VARCHAR2(100);
205: l_surr_bid_created_contct_id PON_BID_HEADERS.SURROG_BID_CREATED_CONTACT_ID%TYPE;

Line 243: FROM PON_BID_HEADERS B, PON_AUCTION_HEADERS_ALL A

239: l_trading_partner_id,
240: l_publish_date,
241: l_surr_bid_created_contct_id,
242: l_surrog_bid_created_tp_id
243: FROM PON_BID_HEADERS B, PON_AUCTION_HEADERS_ALL A
244: WHERE B.BID_NUMBER = p_bid_number
245: AND A.AUCTION_HEADER_ID = B.AUCTION_HEADER_ID;
246:
247: --

Line 345: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

341: )
342: IS
343: l_bid_number PON_BID_HEADERS. BID_NUMBER%TYPE;
344: l_auction_header_id PON_BID_HEADERS. AUCTION_HEADER_ID%TYPE;
345: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
346: l_trading_partner_contact_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
347: l_trading_partner_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
348: l_publish_date VARCHAR2(100);
349: l_last_update_date VARCHAR2(100);

Line 387: FROM PON_BID_HEADERS B, PON_AUCTION_HEADERS_ALL A

383: l_trading_partner_id,
384: l_publish_date,
385: l_last_update_date,
386: l_disqualify_reason
387: FROM PON_BID_HEADERS B, PON_AUCTION_HEADERS_ALL A
388: WHERE B.BID_NUMBER = p_bid_number
389: AND A.AUCTION_HEADER_ID = B.AUCTION_HEADER_ID;
390:
391:

Line 487: l_auction_header_id PON_AUCTION_HEADERS_ALL. AUCTION_HEADER_ID%TYPE;

483: x_msg_count IN OUT NOCOPY NUMBER,
484: x_msg_data IN OUT NOCOPY VARCHAR2
485: )
486: IS
487: l_auction_header_id PON_AUCTION_HEADERS_ALL. AUCTION_HEADER_ID%TYPE;
488: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
489: l_award_appr_ame_trans_id PON_AUCTION_HEADERS_ALL.AWARD_APPR_AME_TRANS_ID%TYPE;
490: l_award_appr_ame_txn_date VARCHAR2(100);
491: l_award_approval_status PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_STATUS%TYPE;

Line 488: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

484: x_msg_data IN OUT NOCOPY VARCHAR2
485: )
486: IS
487: l_auction_header_id PON_AUCTION_HEADERS_ALL. AUCTION_HEADER_ID%TYPE;
488: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
489: l_award_appr_ame_trans_id PON_AUCTION_HEADERS_ALL.AWARD_APPR_AME_TRANS_ID%TYPE;
490: l_award_appr_ame_txn_date VARCHAR2(100);
491: l_award_approval_status PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_STATUS%TYPE;
492: l_wf_award_approval_item_key PON_AUCTION_HEADERS_ALL.WF_AWARD_APPROVAL_ITEM_KEY%TYPE;

Line 489: l_award_appr_ame_trans_id PON_AUCTION_HEADERS_ALL.AWARD_APPR_AME_TRANS_ID%TYPE;

485: )
486: IS
487: l_auction_header_id PON_AUCTION_HEADERS_ALL. AUCTION_HEADER_ID%TYPE;
488: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
489: l_award_appr_ame_trans_id PON_AUCTION_HEADERS_ALL.AWARD_APPR_AME_TRANS_ID%TYPE;
490: l_award_appr_ame_txn_date VARCHAR2(100);
491: l_award_approval_status PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_STATUS%TYPE;
492: l_wf_award_approval_item_key PON_AUCTION_HEADERS_ALL.WF_AWARD_APPROVAL_ITEM_KEY%TYPE;
493:

Line 491: l_award_approval_status PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_STATUS%TYPE;

487: l_auction_header_id PON_AUCTION_HEADERS_ALL. AUCTION_HEADER_ID%TYPE;
488: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
489: l_award_appr_ame_trans_id PON_AUCTION_HEADERS_ALL.AWARD_APPR_AME_TRANS_ID%TYPE;
490: l_award_appr_ame_txn_date VARCHAR2(100);
491: l_award_approval_status PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_STATUS%TYPE;
492: l_wf_award_approval_item_key PON_AUCTION_HEADERS_ALL.WF_AWARD_APPROVAL_ITEM_KEY%TYPE;
493:
494: l_parameter_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
495:

Line 492: l_wf_award_approval_item_key PON_AUCTION_HEADERS_ALL.WF_AWARD_APPROVAL_ITEM_KEY%TYPE;

488: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
489: l_award_appr_ame_trans_id PON_AUCTION_HEADERS_ALL.AWARD_APPR_AME_TRANS_ID%TYPE;
490: l_award_appr_ame_txn_date VARCHAR2(100);
491: l_award_approval_status PON_AUCTION_HEADERS_ALL.AWARD_APPROVAL_STATUS%TYPE;
492: l_wf_award_approval_item_key PON_AUCTION_HEADERS_ALL.WF_AWARD_APPROVAL_ITEM_KEY%TYPE;
493:
494: l_parameter_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
495:
496: BEGIN

Line 525: FROM PON_AUCTION_HEADERS_ALL

521: l_award_appr_ame_trans_id,
522: l_award_appr_ame_txn_date,
523: l_award_approval_status,
524: l_wf_award_approval_item_key
525: FROM PON_AUCTION_HEADERS_ALL
526: WHERE AUCTION_HEADER_ID = p_auction_header_id;
527:
528: --
529: -- Add the parameters

Line 619: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;

615: x_msg_count IN OUT NOCOPY NUMBER,
616: x_msg_data IN OUT NOCOPY VARCHAR2
617: )
618: IS
619: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
620: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
621: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
622: l_source_reqs_flag PON_AUCTION_HEADERS_ALL.SOURCE_REQS_FLAG%TYPE;
623: l_share_award_decision PON_AUCTION_HEADERS_ALL.SHARE_AWARD_DECISION%TYPE;

Line 620: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

616: x_msg_data IN OUT NOCOPY VARCHAR2
617: )
618: IS
619: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
620: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
621: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
622: l_source_reqs_flag PON_AUCTION_HEADERS_ALL.SOURCE_REQS_FLAG%TYPE;
623: l_share_award_decision PON_AUCTION_HEADERS_ALL.SHARE_AWARD_DECISION%TYPE;
624: l_award_complete_date VARCHAR2(100);

Line 621: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;

617: )
618: IS
619: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
620: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
621: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
622: l_source_reqs_flag PON_AUCTION_HEADERS_ALL.SOURCE_REQS_FLAG%TYPE;
623: l_share_award_decision PON_AUCTION_HEADERS_ALL.SHARE_AWARD_DECISION%TYPE;
624: l_award_complete_date VARCHAR2(100);
625: l_requisition_based_flag VARCHAR2(3);

Line 622: l_source_reqs_flag PON_AUCTION_HEADERS_ALL.SOURCE_REQS_FLAG%TYPE;

618: IS
619: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
620: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
621: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
622: l_source_reqs_flag PON_AUCTION_HEADERS_ALL.SOURCE_REQS_FLAG%TYPE;
623: l_share_award_decision PON_AUCTION_HEADERS_ALL.SHARE_AWARD_DECISION%TYPE;
624: l_award_complete_date VARCHAR2(100);
625: l_requisition_based_flag VARCHAR2(3);
626:

Line 623: l_share_award_decision PON_AUCTION_HEADERS_ALL.SHARE_AWARD_DECISION%TYPE;

619: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
620: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
621: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
622: l_source_reqs_flag PON_AUCTION_HEADERS_ALL.SOURCE_REQS_FLAG%TYPE;
623: l_share_award_decision PON_AUCTION_HEADERS_ALL.SHARE_AWARD_DECISION%TYPE;
624: l_award_complete_date VARCHAR2(100);
625: l_requisition_based_flag VARCHAR2(3);
626:
627: l_parameter_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();

Line 660: FROM PON_AUCTION_HEADERS_ALL

656: l_source_reqs_flag,
657: l_share_award_decision,
658: l_award_complete_date,
659: l_requisition_based_flag
660: FROM PON_AUCTION_HEADERS_ALL
661: WHERE AUCTION_HEADER_ID = p_auction_header_id;
662:
663: --
664: -- Add the parameters

Line 765: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;

761: x_msg_count IN OUT NOCOPY NUMBER,
762: x_msg_data IN OUT NOCOPY VARCHAR2
763: )
764: IS
765: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
766: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER %TYPE;
767: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
768: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
769: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;

Line 766: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER %TYPE;

762: x_msg_data IN OUT NOCOPY VARCHAR2
763: )
764: IS
765: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
766: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER %TYPE;
767: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
768: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
769: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
770: l_wf_poncompl_item_key PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_ITEM_KEY%TYPE;

Line 767: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;

763: )
764: IS
765: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
766: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER %TYPE;
767: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
768: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
769: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
770: l_wf_poncompl_item_key PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_ITEM_KEY%TYPE;
771: l_wf_poncompl_current_round PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_CURRENT_ROUND%TYPE;

Line 768: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;

764: IS
765: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
766: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER %TYPE;
767: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
768: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
769: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
770: l_wf_poncompl_item_key PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_ITEM_KEY%TYPE;
771: l_wf_poncompl_current_round PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_CURRENT_ROUND%TYPE;
772: l_last_update_date VARCHAR2(100);

Line 769: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;

765: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
766: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER %TYPE;
767: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
768: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
769: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
770: l_wf_poncompl_item_key PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_ITEM_KEY%TYPE;
771: l_wf_poncompl_current_round PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_CURRENT_ROUND%TYPE;
772: l_last_update_date VARCHAR2(100);
773: l_source_reqs_flag PON_AUCTION_HEADERS_ALL.SOURCE_REQS_FLAG%TYPE;

Line 770: l_wf_poncompl_item_key PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_ITEM_KEY%TYPE;

766: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER %TYPE;
767: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
768: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
769: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
770: l_wf_poncompl_item_key PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_ITEM_KEY%TYPE;
771: l_wf_poncompl_current_round PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_CURRENT_ROUND%TYPE;
772: l_last_update_date VARCHAR2(100);
773: l_source_reqs_flag PON_AUCTION_HEADERS_ALL.SOURCE_REQS_FLAG%TYPE;
774: l_requisition_based_flag VARCHAR2(3);

Line 771: l_wf_poncompl_current_round PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_CURRENT_ROUND%TYPE;

767: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
768: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
769: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
770: l_wf_poncompl_item_key PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_ITEM_KEY%TYPE;
771: l_wf_poncompl_current_round PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_CURRENT_ROUND%TYPE;
772: l_last_update_date VARCHAR2(100);
773: l_source_reqs_flag PON_AUCTION_HEADERS_ALL.SOURCE_REQS_FLAG%TYPE;
774: l_requisition_based_flag VARCHAR2(3);
775:

Line 773: l_source_reqs_flag PON_AUCTION_HEADERS_ALL.SOURCE_REQS_FLAG%TYPE;

769: l_outcome_status PON_AUCTION_HEADERS_ALL.OUTCOME_STATUS%TYPE;
770: l_wf_poncompl_item_key PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_ITEM_KEY%TYPE;
771: l_wf_poncompl_current_round PON_AUCTION_HEADERS_ALL.WF_PONCOMPL_CURRENT_ROUND%TYPE;
772: l_last_update_date VARCHAR2(100);
773: l_source_reqs_flag PON_AUCTION_HEADERS_ALL.SOURCE_REQS_FLAG%TYPE;
774: l_requisition_based_flag VARCHAR2(3);
775:
776: l_parameter_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
777:

Line 819: FROM PON_AUCTION_HEADERS_ALL

815: l_wf_poncompl_item_key,
816: l_wf_poncompl_current_round,
817: l_last_update_date,
818: l_source_reqs_flag
819: FROM PON_AUCTION_HEADERS_ALL
820: WHERE AUCTION_HEADER_ID = p_auction_header_id;
821:
822: --
823: -- Add the parameters