APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_BIDDING_PARTIES

Line 1576: --Description : Warpper on PON APIs to copy the data from PON_BID_PARTIES_INTERFACE interface table to PON_BIDDING_PARTIES table

1572: END insert_collabteam_member;
1573: -----------------------------------------------------------------------
1574: --Start of Comments
1575: --Name: invite_supplier
1576: --Description : Warpper on PON APIs to copy the data from PON_BID_PARTIES_INTERFACE interface table to PON_BIDDING_PARTIES table
1577: --Parameters:
1578: --IN:
1579: -- p_api_version
1580: -- p_init_msg_list

Line 1616: l_LAST_AMENDMENT_UPDATE PON_BIDDING_PARTIES.LAST_AMENDMENT_UPDATE%TYPE;

1612: l_CREATION_DATE PON_BID_PARTIES_INTERFACE.CREATION_DATE%TYPE;
1613: l_CREATED_BY PON_BID_PARTIES_INTERFACE.CREATED_BY%TYPE;
1614: l_LAST_UPDATE_DATE PON_BID_PARTIES_INTERFACE.LAST_UPDATE_DATE%TYPE;
1615: l_LAST_UPDATED_BY PON_BID_PARTIES_INTERFACE.LAST_UPDATED_BY%TYPE;
1616: l_LAST_AMENDMENT_UPDATE PON_BIDDING_PARTIES.LAST_AMENDMENT_UPDATE%TYPE;
1617: L_ORG_ID PON_AUCTION_HEADERS_ALL.ORG_ID%TYPE;
1618: l_TRADING_PARTNER_ID PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
1619: l_STATUS VARCHAR2(10);
1620: BEGIN

Line 1719: FROM PON_BIDDING_PARTIES

1715:
1716: -- check if the Supplier has been invited multiple times for the same Supplier Site or without a Supplier Site selection
1717: BEGIN
1718: SELECT 'Y' INTO l_status
1719: FROM PON_BIDDING_PARTIES
1720: WHERE TRADING_PARTNER_NAME=L_VENDOR_NAME
1721: AND VENDOR_SITE_ID =NVL(L_VENDOR_SITE_ID,VENDOR_SITE_ID)
1722: AND auction_header_id =l_auction_header_id;
1723: EXCEPTION

Line 1749: /* Insert Into PON_BIDDING_PARTIES */

1745: l_LAST_AMENDMENT_UPDATE:= NULL;
1746: END;
1747: l_LAST_AMENDMENT_UPDATE:= NVL(l_LAST_AMENDMENT_UPDATE,0);
1748:
1749: /* Insert Into PON_BIDDING_PARTIES */
1750: INSERT
1751: INTO PON_BIDDING_PARTIES
1752: (
1753: AUCTION_HEADER_ID ,

Line 1751: INTO PON_BIDDING_PARTIES

1747: l_LAST_AMENDMENT_UPDATE:= NVL(l_LAST_AMENDMENT_UPDATE,0);
1748:
1749: /* Insert Into PON_BIDDING_PARTIES */
1750: INSERT
1751: INTO PON_BIDDING_PARTIES
1752: (
1753: AUCTION_HEADER_ID ,
1754: LIST_ID ,
1755: SEQUENCE ,

Line 3840: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;

3836: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
3837: DELETE FROM pon_auc_payments_shipments WHERE auction_header_id = l_auction_header_id;
3838: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;
3839: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;
3840: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;
3841: DELETE FROM pon_attribute_scores WHERE auction_header_id = l_auction_header_id;
3842: DELETE FROM pon_auction_sections WHERE auction_header_id = l_auction_header_id;
3843: DELETE FROM pon_auction_headers_ext_b WHERE auction_header_id = l_auction_header_id;
3844: DELETE FROM pon_auction_headers_ext_tl WHERE auction_header_id = l_auction_header_id;

Line 7056: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;

7052: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
7053: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
7054: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;
7055: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;
7056: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;
7057: DELETE FROM pon_attribute_scores WHERE auction_header_id = l_auction_header_id;
7058: DELETE FROM pon_auction_sections WHERE auction_header_id = l_auction_header_id;
7059: DELETE FROM pon_auction_headers_ext_b WHERE auction_header_id = l_auction_header_id;
7060: DELETE FROM pon_auction_headers_ext_tl WHERE auction_header_id = l_auction_header_id;