APPS.PON_VENDORMERGE_GRP dependencies on PON_SUPPLIER_ACCESS

Line 852: 6. pon_supplier_access

848: 2. pon_bid_headers
849: 3. pon_bidding_parties
850: 4. pon_party_line_exclusions
851: 5. pon_pf_supplier_formula
852: 6. pon_supplier_access
853: 7. pon_threads
854: 8. pon_thread_entries
855: 9. pon_te_recipients
856: 10. pon_supplier_activities

Line 991: UPDATE pon_supplier_access psa1

987: We are comparing w.r.t AUCTION_HEADER_ID_ORIG_AMEND becuase
988: the UK is definied on this field.
989: */
990:
991: UPDATE pon_supplier_access psa1
992: SET psa1.supplier_trading_partner_id = p_trading_partner_id,
993: psa1.last_updated_by = -1,
994: psa1.last_update_date = sysdate
995: WHERE psa1.supplier_trading_partner_id = p_dup_trading_partner_id

Line 997: FROM pon_supplier_access psa2

993: psa1.last_updated_by = -1,
994: psa1.last_update_date = sysdate
995: WHERE psa1.supplier_trading_partner_id = p_dup_trading_partner_id
996: AND NOT EXISTS (SELECT 'DUPLICATE'
997: FROM pon_supplier_access psa2
998: WHERE psa2.auction_header_id_orig_amend = psa1.auction_header_id_orig_amend
999: AND psa2.supplier_trading_partner_id = p_trading_partner_id);
1000:
1001: l_progress := 709;

Line 1002: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_supplier_access');

998: WHERE psa2.auction_header_id_orig_amend = psa1.auction_header_id_orig_amend
999: AND psa2.supplier_trading_partner_id = p_trading_partner_id);
1000:
1001: l_progress := 709;
1002: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_supplier_access');
1003:
1004: /*
1005: We are comparing w.r.t AUCTION_HEADER_ID_ORIG_AMEND becuase
1006: the UK is definied on this field.