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_OPEN_INTERFACE_PVT dependencies on PON_BID_PARTIES_INTERFACE

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 1598: SELECT * FROM pon_bid_parties_interface WHERE batch_id=p_batch_id;

1594: )
1595: IS
1596: CURSOR c_invitee_supplier
1597: IS
1598: SELECT * FROM pon_bid_parties_interface WHERE batch_id=p_batch_id;
1599:
1600: c_invitee_supplier_rec c_invitee_supplier%ROWTYPE;
1601: l_BATCH_ID PON_BID_PARTIES_INTERFACE.BATCH_ID%TYPE;
1602: l_AUCTION_HEADER_ID PON_BID_PARTIES_INTERFACE.AUCTION_HEADER_ID%TYPE;

Line 1601: l_BATCH_ID PON_BID_PARTIES_INTERFACE.BATCH_ID%TYPE;

1597: IS
1598: SELECT * FROM pon_bid_parties_interface WHERE batch_id=p_batch_id;
1599:
1600: c_invitee_supplier_rec c_invitee_supplier%ROWTYPE;
1601: l_BATCH_ID PON_BID_PARTIES_INTERFACE.BATCH_ID%TYPE;
1602: l_AUCTION_HEADER_ID PON_BID_PARTIES_INTERFACE.AUCTION_HEADER_ID%TYPE;
1603: l_SEQUENCE PON_BID_PARTIES_INTERFACE.SEQUENCE_NUMBER%TYPE;
1604: l_VENDOR_NAME PON_BID_PARTIES_INTERFACE.VENDOR_NAME%TYPE;
1605: l_VENDOR_ID PON_BID_PARTIES_INTERFACE.VENDOR_ID%TYPE;

Line 1602: l_AUCTION_HEADER_ID PON_BID_PARTIES_INTERFACE.AUCTION_HEADER_ID%TYPE;

1598: SELECT * FROM pon_bid_parties_interface WHERE batch_id=p_batch_id;
1599:
1600: c_invitee_supplier_rec c_invitee_supplier%ROWTYPE;
1601: l_BATCH_ID PON_BID_PARTIES_INTERFACE.BATCH_ID%TYPE;
1602: l_AUCTION_HEADER_ID PON_BID_PARTIES_INTERFACE.AUCTION_HEADER_ID%TYPE;
1603: l_SEQUENCE PON_BID_PARTIES_INTERFACE.SEQUENCE_NUMBER%TYPE;
1604: l_VENDOR_NAME PON_BID_PARTIES_INTERFACE.VENDOR_NAME%TYPE;
1605: l_VENDOR_ID PON_BID_PARTIES_INTERFACE.VENDOR_ID%TYPE;
1606: l_VENDOR_SITE_ID PON_BID_PARTIES_INTERFACE.VENDOR_SITE_ID%TYPE;

Line 1603: l_SEQUENCE PON_BID_PARTIES_INTERFACE.SEQUENCE_NUMBER%TYPE;

1599:
1600: c_invitee_supplier_rec c_invitee_supplier%ROWTYPE;
1601: l_BATCH_ID PON_BID_PARTIES_INTERFACE.BATCH_ID%TYPE;
1602: l_AUCTION_HEADER_ID PON_BID_PARTIES_INTERFACE.AUCTION_HEADER_ID%TYPE;
1603: l_SEQUENCE PON_BID_PARTIES_INTERFACE.SEQUENCE_NUMBER%TYPE;
1604: l_VENDOR_NAME PON_BID_PARTIES_INTERFACE.VENDOR_NAME%TYPE;
1605: l_VENDOR_ID PON_BID_PARTIES_INTERFACE.VENDOR_ID%TYPE;
1606: l_VENDOR_SITE_ID PON_BID_PARTIES_INTERFACE.VENDOR_SITE_ID%TYPE;
1607: l_VENDOR_SITE_CODE PON_BID_PARTIES_INTERFACE.VENDOR_SITE_CODE%TYPE;

Line 1604: l_VENDOR_NAME PON_BID_PARTIES_INTERFACE.VENDOR_NAME%TYPE;

1600: c_invitee_supplier_rec c_invitee_supplier%ROWTYPE;
1601: l_BATCH_ID PON_BID_PARTIES_INTERFACE.BATCH_ID%TYPE;
1602: l_AUCTION_HEADER_ID PON_BID_PARTIES_INTERFACE.AUCTION_HEADER_ID%TYPE;
1603: l_SEQUENCE PON_BID_PARTIES_INTERFACE.SEQUENCE_NUMBER%TYPE;
1604: l_VENDOR_NAME PON_BID_PARTIES_INTERFACE.VENDOR_NAME%TYPE;
1605: l_VENDOR_ID PON_BID_PARTIES_INTERFACE.VENDOR_ID%TYPE;
1606: l_VENDOR_SITE_ID PON_BID_PARTIES_INTERFACE.VENDOR_SITE_ID%TYPE;
1607: l_VENDOR_SITE_CODE PON_BID_PARTIES_INTERFACE.VENDOR_SITE_CODE%TYPE;
1608: l_TRADING_PARTNER_CONTACT_NAME PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_NAME%TYPE;

Line 1605: l_VENDOR_ID PON_BID_PARTIES_INTERFACE.VENDOR_ID%TYPE;

1601: l_BATCH_ID PON_BID_PARTIES_INTERFACE.BATCH_ID%TYPE;
1602: l_AUCTION_HEADER_ID PON_BID_PARTIES_INTERFACE.AUCTION_HEADER_ID%TYPE;
1603: l_SEQUENCE PON_BID_PARTIES_INTERFACE.SEQUENCE_NUMBER%TYPE;
1604: l_VENDOR_NAME PON_BID_PARTIES_INTERFACE.VENDOR_NAME%TYPE;
1605: l_VENDOR_ID PON_BID_PARTIES_INTERFACE.VENDOR_ID%TYPE;
1606: l_VENDOR_SITE_ID PON_BID_PARTIES_INTERFACE.VENDOR_SITE_ID%TYPE;
1607: l_VENDOR_SITE_CODE PON_BID_PARTIES_INTERFACE.VENDOR_SITE_CODE%TYPE;
1608: l_TRADING_PARTNER_CONTACT_NAME PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_NAME%TYPE;
1609: l_TRADING_PARTNER_CONTACT_ID PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_ID%TYPE;

Line 1606: l_VENDOR_SITE_ID PON_BID_PARTIES_INTERFACE.VENDOR_SITE_ID%TYPE;

1602: l_AUCTION_HEADER_ID PON_BID_PARTIES_INTERFACE.AUCTION_HEADER_ID%TYPE;
1603: l_SEQUENCE PON_BID_PARTIES_INTERFACE.SEQUENCE_NUMBER%TYPE;
1604: l_VENDOR_NAME PON_BID_PARTIES_INTERFACE.VENDOR_NAME%TYPE;
1605: l_VENDOR_ID PON_BID_PARTIES_INTERFACE.VENDOR_ID%TYPE;
1606: l_VENDOR_SITE_ID PON_BID_PARTIES_INTERFACE.VENDOR_SITE_ID%TYPE;
1607: l_VENDOR_SITE_CODE PON_BID_PARTIES_INTERFACE.VENDOR_SITE_CODE%TYPE;
1608: l_TRADING_PARTNER_CONTACT_NAME PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_NAME%TYPE;
1609: l_TRADING_PARTNER_CONTACT_ID PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_ID%TYPE;
1610: l_ADDITIONAL_CONTACT_EMAIL PON_BID_PARTIES_INTERFACE.ADDITIONAL_CONTACT_EMAIL%TYPE;

Line 1607: l_VENDOR_SITE_CODE PON_BID_PARTIES_INTERFACE.VENDOR_SITE_CODE%TYPE;

1603: l_SEQUENCE PON_BID_PARTIES_INTERFACE.SEQUENCE_NUMBER%TYPE;
1604: l_VENDOR_NAME PON_BID_PARTIES_INTERFACE.VENDOR_NAME%TYPE;
1605: l_VENDOR_ID PON_BID_PARTIES_INTERFACE.VENDOR_ID%TYPE;
1606: l_VENDOR_SITE_ID PON_BID_PARTIES_INTERFACE.VENDOR_SITE_ID%TYPE;
1607: l_VENDOR_SITE_CODE PON_BID_PARTIES_INTERFACE.VENDOR_SITE_CODE%TYPE;
1608: l_TRADING_PARTNER_CONTACT_NAME PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_NAME%TYPE;
1609: l_TRADING_PARTNER_CONTACT_ID PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_ID%TYPE;
1610: l_ADDITIONAL_CONTACT_EMAIL PON_BID_PARTIES_INTERFACE.ADDITIONAL_CONTACT_EMAIL%TYPE;
1611: l_ACTION PON_BID_PARTIES_INTERFACE.ACTION%TYPE;

Line 1608: l_TRADING_PARTNER_CONTACT_NAME PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_NAME%TYPE;

1604: l_VENDOR_NAME PON_BID_PARTIES_INTERFACE.VENDOR_NAME%TYPE;
1605: l_VENDOR_ID PON_BID_PARTIES_INTERFACE.VENDOR_ID%TYPE;
1606: l_VENDOR_SITE_ID PON_BID_PARTIES_INTERFACE.VENDOR_SITE_ID%TYPE;
1607: l_VENDOR_SITE_CODE PON_BID_PARTIES_INTERFACE.VENDOR_SITE_CODE%TYPE;
1608: l_TRADING_PARTNER_CONTACT_NAME PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_NAME%TYPE;
1609: l_TRADING_PARTNER_CONTACT_ID PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_ID%TYPE;
1610: l_ADDITIONAL_CONTACT_EMAIL PON_BID_PARTIES_INTERFACE.ADDITIONAL_CONTACT_EMAIL%TYPE;
1611: l_ACTION PON_BID_PARTIES_INTERFACE.ACTION%TYPE;
1612: l_CREATION_DATE PON_BID_PARTIES_INTERFACE.CREATION_DATE%TYPE;

Line 1609: l_TRADING_PARTNER_CONTACT_ID PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_ID%TYPE;

1605: l_VENDOR_ID PON_BID_PARTIES_INTERFACE.VENDOR_ID%TYPE;
1606: l_VENDOR_SITE_ID PON_BID_PARTIES_INTERFACE.VENDOR_SITE_ID%TYPE;
1607: l_VENDOR_SITE_CODE PON_BID_PARTIES_INTERFACE.VENDOR_SITE_CODE%TYPE;
1608: l_TRADING_PARTNER_CONTACT_NAME PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_NAME%TYPE;
1609: l_TRADING_PARTNER_CONTACT_ID PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_ID%TYPE;
1610: l_ADDITIONAL_CONTACT_EMAIL PON_BID_PARTIES_INTERFACE.ADDITIONAL_CONTACT_EMAIL%TYPE;
1611: l_ACTION PON_BID_PARTIES_INTERFACE.ACTION%TYPE;
1612: l_CREATION_DATE PON_BID_PARTIES_INTERFACE.CREATION_DATE%TYPE;
1613: l_CREATED_BY PON_BID_PARTIES_INTERFACE.CREATED_BY%TYPE;

Line 1610: l_ADDITIONAL_CONTACT_EMAIL PON_BID_PARTIES_INTERFACE.ADDITIONAL_CONTACT_EMAIL%TYPE;

1606: l_VENDOR_SITE_ID PON_BID_PARTIES_INTERFACE.VENDOR_SITE_ID%TYPE;
1607: l_VENDOR_SITE_CODE PON_BID_PARTIES_INTERFACE.VENDOR_SITE_CODE%TYPE;
1608: l_TRADING_PARTNER_CONTACT_NAME PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_NAME%TYPE;
1609: l_TRADING_PARTNER_CONTACT_ID PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_ID%TYPE;
1610: l_ADDITIONAL_CONTACT_EMAIL PON_BID_PARTIES_INTERFACE.ADDITIONAL_CONTACT_EMAIL%TYPE;
1611: l_ACTION PON_BID_PARTIES_INTERFACE.ACTION%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;

Line 1611: l_ACTION PON_BID_PARTIES_INTERFACE.ACTION%TYPE;

1607: l_VENDOR_SITE_CODE PON_BID_PARTIES_INTERFACE.VENDOR_SITE_CODE%TYPE;
1608: l_TRADING_PARTNER_CONTACT_NAME PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_NAME%TYPE;
1609: l_TRADING_PARTNER_CONTACT_ID PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_ID%TYPE;
1610: l_ADDITIONAL_CONTACT_EMAIL PON_BID_PARTIES_INTERFACE.ADDITIONAL_CONTACT_EMAIL%TYPE;
1611: l_ACTION PON_BID_PARTIES_INTERFACE.ACTION%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;

Line 1612: l_CREATION_DATE PON_BID_PARTIES_INTERFACE.CREATION_DATE%TYPE;

1608: l_TRADING_PARTNER_CONTACT_NAME PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_NAME%TYPE;
1609: l_TRADING_PARTNER_CONTACT_ID PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_ID%TYPE;
1610: l_ADDITIONAL_CONTACT_EMAIL PON_BID_PARTIES_INTERFACE.ADDITIONAL_CONTACT_EMAIL%TYPE;
1611: l_ACTION PON_BID_PARTIES_INTERFACE.ACTION%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;

Line 1613: l_CREATED_BY PON_BID_PARTIES_INTERFACE.CREATED_BY%TYPE;

1609: l_TRADING_PARTNER_CONTACT_ID PON_BID_PARTIES_INTERFACE.TRADING_PARTNER_CONTACT_ID%TYPE;
1610: l_ADDITIONAL_CONTACT_EMAIL PON_BID_PARTIES_INTERFACE.ADDITIONAL_CONTACT_EMAIL%TYPE;
1611: l_ACTION PON_BID_PARTIES_INTERFACE.ACTION%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;

Line 1614: l_LAST_UPDATE_DATE PON_BID_PARTIES_INTERFACE.LAST_UPDATE_DATE%TYPE;

1610: l_ADDITIONAL_CONTACT_EMAIL PON_BID_PARTIES_INTERFACE.ADDITIONAL_CONTACT_EMAIL%TYPE;
1611: l_ACTION PON_BID_PARTIES_INTERFACE.ACTION%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;

Line 1615: l_LAST_UPDATED_BY PON_BID_PARTIES_INTERFACE.LAST_UPDATED_BY%TYPE;

1611: l_ACTION PON_BID_PARTIES_INTERFACE.ACTION%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);

Line 1638: print_Log('Error in PON_BID_PARTIES_INTERFACE table. Please check pon_interface_errors for more details' );

1634: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1635: END;
1636:
1637: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN
1638: print_Log('Error in PON_BID_PARTIES_INTERFACE table. Please check pon_interface_errors for more details' );
1639: FND_MESSAGE.SET_NAME('PON','PON_IMPORT_SUPPLIER_VAL_ERR');
1640: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_batch_Id);
1641: FND_MSG_PUB.ADD;
1642: RAISE FND_API.G_EXC_ERROR;

Line 1645: print_log('PON_BID_PARTIES_INTERFACE validation completed');

1641: FND_MSG_PUB.ADD;
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;
1644:
1645: print_log('PON_BID_PARTIES_INTERFACE validation completed');
1646:
1647:
1648: OPEN c_invitee_supplier;
1649: LOOP

Line 1827: 'PON_BID_PARTIES_INTERFACE',

1823: g_interface_type,
1824: 'PON_FIELD_MUST_BE_ENTERED',
1825: 'VENDOR_NAME',
1826: p_batch_id,
1827: 'PON_BID_PARTIES_INTERFACE',
1828: l_cp_user_id,
1829: SYSDATE,
1830: l_cp_user_id,
1831: SYSDATE,

Line 1856: 'PON_BID_PARTIES_INTERFACE',

1852: 'PON_IMPORT_INV_VENDOR',
1853: 'VENDOR_NAME',
1854: sel_vendor_name,
1855: p_batch_id,
1856: 'PON_BID_PARTIES_INTERFACE',
1857: l_cp_user_id,
1858: SYSDATE,
1859: l_cp_user_id,
1860: SYSDATE,

Line 1885: 'PON_BID_PARTIES_INTERFACE',

1881: 'PON_IMPORT_INV_VENDORID',
1882: 'VENDOR_ID',
1883: sel_vendor_id,
1884: p_batch_id,
1885: 'PON_BID_PARTIES_INTERFACE',
1886: l_cp_user_id,
1887: SYSDATE,
1888: l_cp_user_id,
1889: SYSDATE,

Line 1914: 'PON_BID_PARTIES_INTERFACE',

1910: 'PON_IMPORT_INV_VENDORNAME',
1911: 'VENDOR_NAME',
1912: sel_vendor_NAME,
1913: p_batch_id,
1914: 'PON_BID_PARTIES_INTERFACE',
1915: l_cp_user_id,
1916: SYSDATE,
1917: l_cp_user_id,
1918: SYSDATE,

Line 1944: 'PON_BID_PARTIES_INTERFACE',

1940: 'PON_IMPORT_INV_VENDORSITE',
1941: 'VENDOR_SITE',
1942: sel_vendor_site_code,
1943: p_batch_id,
1944: 'PON_BID_PARTIES_INTERFACE',
1945: l_cp_user_id,
1946: SYSDATE,
1947: l_cp_user_id,
1948: SYSDATE,

Line 1973: 'PON_BID_PARTIES_INTERFACE',

1969: 'PON_IMPORT_INV_VENDORSITEID',
1970: 'SITE_ID',
1971: sel_vendor_site_id,
1972: p_batch_id,
1973: 'PON_BID_PARTIES_INTERFACE',
1974: l_cp_user_id,
1975: SYSDATE,
1976: l_cp_user_id,
1977: SYSDATE,

Line 2002: 'PON_BID_PARTIES_INTERFACE',

1998: 'PON_IMPORT_INV_VENDORSITECODE',
1999: 'SITE_CODE',
2000: sel_vendor_site_code,
2001: p_batch_id,
2002: 'PON_BID_PARTIES_INTERFACE',
2003: l_cp_user_id,
2004: SYSDATE,
2005: l_cp_user_id,
2006: SYSDATE,

Line 2032: 'PON_BID_PARTIES_INTERFACE',

2028: 'PON_IMPORT_INV_VENDORTPC',
2029: 'TPC',
2030: sel_tpc_id,
2031: p_batch_id,
2032: 'PON_BID_PARTIES_INTERFACE',
2033: l_cp_user_id,
2034: SYSDATE,
2035: l_cp_user_id,
2036: SYSDATE,

Line 2058: 'PON_BID_PARTIES_INTERFACE',

2054: g_interface_type,
2055: 'PON_FIELD_MUST_BE_ENTERED',
2056: 'trading_partner_contact_name',
2057: p_batch_id,
2058: 'PON_BID_PARTIES_INTERFACE',
2059: NULL,
2060: l_cp_user_id,
2061: SYSDATE,
2062: l_cp_user_id,

Line 2073: FROM pon_bid_parties_interface

2069: vendor_site_id sel_vendor_site_id,
2070: trading_partner_contact_id sel_tpc_id,
2071: trading_partner_contact_name sel_tpc_name,
2072: additional_contact_email sel_add_mail
2073: FROM pon_bid_parties_interface
2074: WHERE batch_id = p_batch_id
2075: AND action='INSERT';
2076:
2077: END validate_invited_suppliers;

Line 3899: update pon_bid_parties_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;

3895: update pon_auction_headers_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
3896: update pon_item_prices_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3897: update PON_AUC_ATTRIBUTES_INTERFACE SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3898: update pon_attribute_scores_interface SET batch_id = p_batch_id, LINE_NUMBER = interface_line_id WHERE interface_header_id = p_batch_id;
3899: update pon_bid_parties_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
3900: update PON_NEG_TEAM_INTERFACE SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
3901: update PON_AUC_PRICE_ELEMENTS_INT SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3902: BEGIN
3903: update pon_auc_payments_interface SET batch_id = p_batch_id, document_disp_line_number = interface_line_id WHERE interface_header_id = p_batch_id;

Line 4906: update pon_bid_parties_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;

4902:
4903: update pon_item_prices_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4904: update PON_AUC_ATTRIBUTES_INTERFACE SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4905: update pon_attribute_scores_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4906: update pon_bid_parties_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4907: update PON_NEG_TEAM_INTERFACE SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4908: update PON_AUC_PRICE_ELEMENTS_INT SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4909: update pon_auc_price_breaks_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4910: update pon_auc_price_differ_int SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;

Line 7129: update pon_bid_parties_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;

7125: update pon_auction_headers_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
7126: update pon_item_prices_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7127: update PON_AUC_ATTRIBUTES_INTERFACE SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7128: update pon_attribute_scores_interface SET batch_id = p_batch_id, LINE_NUMBER = interface_line_id WHERE interface_header_id = p_batch_id;
7129: update pon_bid_parties_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
7130: update PON_NEG_TEAM_INTERFACE SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
7131: update PON_AUC_PRICE_ELEMENTS_INT SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7132: update pon_auc_price_breaks_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7133: update pon_auc_price_differ_int SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;

Line 7209: update pon_bid_parties_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;

7205: print_log(' Updating interface tables with auction_header_id ' || x_auction_header_id);
7206: update pon_item_prices_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7207: update PON_AUC_ATTRIBUTES_INTERFACE SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7208: update pon_attribute_scores_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7209: update pon_bid_parties_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7210: update PON_NEG_TEAM_INTERFACE SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7211: update PON_AUC_PRICE_ELEMENTS_INT SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7212: update pon_auc_price_breaks_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7213: update pon_auc_price_differ_int SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;