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_VENDORMERGE_GRP dependencies on PON_PF_SUPPLIER_FORMULA

Line 527: 4. pon_pf_supplier_formula

523: Followling table will be updated while merging at SITE Level.
524: 1. pon_bid_headers
525: 2. pon_bidding_parties
526: 3. pon_party_line_exclusions
527: 4. pon_pf_supplier_formula
528: */
529:
530: l_progress := 301;
531: fnd_file.put_line (fnd_file.log, l_progress|| 'Start : MERGE_SAME_VENDOR_DIFF_SITES');

Line 614: UPDATE pon_pf_supplier_formula ppsf1

610:
611: l_progress := 304;
612: fnd_file.put_line (fnd_file.log, l_progress|| 'Done : pon_party_line_exclusions');
613:
614: UPDATE pon_pf_supplier_formula ppsf1
615: SET ppsf1.vendor_site_id = p_vendor_site_id
616: WHERE ppsf1.vendor_site_id = p_dup_vendor_site_id
617: AND NOT EXISTS (SELECT 'DUPLICATE'
618: FROM pon_pf_supplier_formula ppsf2

Line 618: FROM pon_pf_supplier_formula ppsf2

614: UPDATE pon_pf_supplier_formula ppsf1
615: SET ppsf1.vendor_site_id = p_vendor_site_id
616: WHERE ppsf1.vendor_site_id = p_dup_vendor_site_id
617: AND NOT EXISTS (SELECT 'DUPLICATE'
618: FROM pon_pf_supplier_formula ppsf2
619: WHERE ppsf2.auction_header_id = ppsf1.auction_header_id
620: AND ppsf2.trading_partner_id = ppsf1.trading_partner_id
621: AND ppsf2.vendor_site_id = p_vendor_site_id);
622:

Line 624: fnd_file.put_line (fnd_file.log, l_progress|| 'Done : pon_pf_supplier_formula');

620: AND ppsf2.trading_partner_id = ppsf1.trading_partner_id
621: AND ppsf2.vendor_site_id = p_vendor_site_id);
622:
623: l_progress := 305;
624: fnd_file.put_line (fnd_file.log, l_progress|| 'Done : pon_pf_supplier_formula');
625:
626: EXCEPTION WHEN NO_DATA_FOUND THEN
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628:

Line 677: 5. pon_pf_supplier_formula

673: 1. pon_bid_item_prices
674: 2. pon_bid_headers
675: 3. pon_bidding_parties
676: 4. pon_party_line_exclusions
677: 5. pon_pf_supplier_formula
678: */
679:
680: l_progress := 500;
681: fnd_file.put_line (fnd_file.log, l_progress|| ' Start : MERGE_DIFF_VENDOR_AND_SITE');

Line 785: UPDATE pon_pf_supplier_formula ppsf1

781:
782: l_progress := 505;
783: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_party_line_exclusions');
784:
785: UPDATE pon_pf_supplier_formula ppsf1
786: SET ppsf1.trading_partner_id = p_trading_partner_id,
787: ppsf1.vendor_site_id = p_vendor_site_id,
788: ppsf1.last_updated_by = -1,
789: ppsf1.last_update_date = sysdate

Line 793: FROM pon_pf_supplier_formula ppsf2

789: ppsf1.last_update_date = sysdate
790: WHERE ppsf1.trading_partner_id = p_dup_trading_partner_id
791: AND ppsf1.vendor_site_id = p_dup_vendor_site_id
792: AND NOT EXISTS (SELECT 'DUPLICATE'
793: FROM pon_pf_supplier_formula ppsf2
794: WHERE ppsf2.auction_header_id = ppsf1.auction_header_id
795: AND ppsf2.trading_partner_id = p_trading_partner_id
796: AND ppsf2.vendor_site_id = p_vendor_site_id);
797: l_progress := 506;

Line 798: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_pf_supplier_formula');

794: WHERE ppsf2.auction_header_id = ppsf1.auction_header_id
795: AND ppsf2.trading_partner_id = p_trading_partner_id
796: AND ppsf2.vendor_site_id = p_vendor_site_id);
797: l_progress := 506;
798: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_pf_supplier_formula');
799:
800: EXCEPTION WHEN NO_DATA_FOUND THEN
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
802:

Line 851: 5. pon_pf_supplier_formula

847: 1. pon_bid_item_prices
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

Line 970: UPDATE pon_pf_supplier_formula ppsf1

966:
967: l_progress := 707;
968: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_party_line_exclusions');
969:
970: UPDATE pon_pf_supplier_formula ppsf1
971: SET ppsf1.trading_partner_id = p_trading_partner_id,
972: ppsf1.vendor_site_id = decode(ppsf1.vendor_site_id,-1,-1,p_vendor_site_id),
973: ppsf1.last_updated_by = -1,
974: ppsf1.last_update_date = sysdate

Line 978: FROM pon_pf_supplier_formula ppsf2

974: ppsf1.last_update_date = sysdate
975: WHERE ppsf1.trading_partner_id = p_dup_trading_partner_id
976: AND ppsf1.vendor_site_id = decode(ppsf1.vendor_site_id,-1,-1,p_dup_vendor_site_id)
977: AND NOT EXISTS (SELECT 'DUPLICATE'
978: FROM pon_pf_supplier_formula ppsf2
979: WHERE ppsf2.auction_header_id = ppsf1.auction_header_id
980: AND ppsf2.trading_partner_id = p_trading_partner_id
981: AND ppsf2.vendor_site_id = decode(ppsf1.vendor_site_id,-1,-1,p_vendor_site_id));
982:

Line 984: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_pf_supplier_formula');

980: AND ppsf2.trading_partner_id = p_trading_partner_id
981: AND ppsf2.vendor_site_id = decode(ppsf1.vendor_site_id,-1,-1,p_vendor_site_id));
982:
983: l_progress := 708;
984: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_pf_supplier_formula');
985:
986: /*
987: We are comparing w.r.t AUCTION_HEADER_ID_ORIG_AMEND becuase
988: the UK is definied on this field.