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_BID_HEADERS

Line 99: x_trading_partner_id pon_bid_headers.trading_partner_id%type;

95: l_api_version CONSTANT NUMBER := 1.0;
96: l_procedure_name VARCHAR2(20) := 'MERGE_VENDOR';
97:
98: l_progress NUMBER;
99: x_trading_partner_id pon_bid_headers.trading_partner_id%type;
100: x_trading_partner_name pon_bid_headers.trading_partner_name%type;
101: x_vendor_site_code po_vendor_sites_all.vendor_site_code%type;
102: l_num_active_sites NUMBER;
103:

Line 100: x_trading_partner_name pon_bid_headers.trading_partner_name%type;

96: l_procedure_name VARCHAR2(20) := 'MERGE_VENDOR';
97:
98: l_progress NUMBER;
99: x_trading_partner_id pon_bid_headers.trading_partner_id%type;
100: x_trading_partner_name pon_bid_headers.trading_partner_name%type;
101: x_vendor_site_code po_vendor_sites_all.vendor_site_code%type;
102: l_num_active_sites NUMBER;
103:
104: BEGIN --{

Line 524: 1. pon_bid_headers

520: BEGIN --{
521:
522: /*
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: */

Line 533: /* Bug 4948321 : FTS for pon_bid_headers due to vendorId comparision.

529:
530: l_progress := 301;
531: fnd_file.put_line (fnd_file.log, l_progress|| 'Start : MERGE_SAME_VENDOR_DIFF_SITES');
532:
533: /* Bug 4948321 : FTS for pon_bid_headers due to vendorId comparision.
534: - Retrieve trading_partner_id from ap_suppliers and use that
535: in update query for pon_bid_headers.
536: */
537:

Line 535: in update query for pon_bid_headers.

531: fnd_file.put_line (fnd_file.log, l_progress|| 'Start : MERGE_SAME_VENDOR_DIFF_SITES');
532:
533: /* Bug 4948321 : FTS for pon_bid_headers due to vendorId comparision.
534: - Retrieve trading_partner_id from ap_suppliers and use that
535: in update query for pon_bid_headers.
536: */
537:
538: SELECT party_id
539: INTO l_trading_partner_id

Line 543: UPDATE pon_bid_headers pbh1

539: INTO l_trading_partner_id
540: FROM ap_suppliers
541: WHERE vendor_id=p_vendor_id;
542:
543: UPDATE pon_bid_headers pbh1
544: SET pbh1.vendor_site_id = p_vendor_site_id,
545: pbh1.vendor_site_code = decode(pbh1.vendor_site_code,null,null,'-1','-1',p_vendor_site_code),
546: pbh1.last_updated_by = -1,
547: pbh1.last_update_date = sysdate

Line 551: FROM pon_bid_headers pbh2

547: pbh1.last_update_date = sysdate
548: WHERE pbh1.trading_partner_id = l_trading_partner_id
549: AND pbh1.vendor_site_id = p_dup_vendor_site_id
550: AND NOT EXISTS (SELECT 'DUPLICATE'
551: FROM pon_bid_headers pbh2
552: WHERE pbh2.auction_header_id = pbh1.auction_header_id
553: AND pbh2.vendor_id = pbh1.vendor_id
554: AND pbh2.trading_partner_contact_id = pbh1.trading_partner_contact_id
555: AND pbh2.trading_partner_id = pbh1.trading_partner_id

Line 559: fnd_file.put_line (fnd_file.log, l_progress|| 'Done : pon_bid_headers');

555: AND pbh2.trading_partner_id = pbh1.trading_partner_id
556: AND pbh2.vendor_site_id = p_vendor_site_id);
557:
558: l_progress := 302;
559: fnd_file.put_line (fnd_file.log, l_progress|| 'Done : pon_bid_headers');
560:
561: -- Bug 5100555
562: -- This is done to update site code for reusable invitation list
563: -- putting separate query to take care of duplication of supplier

Line 674: 2. pon_bid_headers

670: /* CASE 2b - site being merged is not the last site
671:
672: Followling table will be updated while merging at Vendor level.
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: */

Line 689: FROM pon_bid_headers pbh1

685: pbip1.last_updated_by = -1,
686: pbip1.last_update_date = sysdate
687: WHERE pbip1.bid_trading_partner_id = p_dup_trading_partner_id
688: AND pbip1.bid_number IN (SELECT bid_number
689: FROM pon_bid_headers pbh1
690: WHERE pbh1.trading_partner_id = p_dup_trading_partner_id
691: AND pbh1.vendor_id = p_dup_vendor_id
692: AND pbh1.vendor_site_id= p_dup_vendor_site_id
693: AND NOT EXISTS (SELECT 'DUPLICATE'

Line 694: FROM pon_bid_headers pbh2

690: WHERE pbh1.trading_partner_id = p_dup_trading_partner_id
691: AND pbh1.vendor_id = p_dup_vendor_id
692: AND pbh1.vendor_site_id= p_dup_vendor_site_id
693: AND NOT EXISTS (SELECT 'DUPLICATE'
694: FROM pon_bid_headers pbh2
695: WHERE pbh2.auction_header_id = pbh1.auction_header_id
696: AND pbh2.vendor_id = p_vendor_id
697: AND pbh2.vendor_site_id = p_vendor_site_id
698: AND pbh2.trading_partner_id = p_trading_partner_id

Line 705: UPDATE pon_bid_headers pbh1

701:
702: l_progress := 501;
703: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_bid_item_prices ');
704:
705: UPDATE pon_bid_headers pbh1
706: SET pbh1.trading_partner_id = p_trading_partner_id,
707: pbh1.trading_partner_name = p_trading_partner_name,
708: pbh1.vendor_id = p_vendor_id,
709: pbh1.vendor_site_id = p_vendor_site_id,

Line 717: FROM pon_bid_headers pbh2

713: WHERE pbh1.trading_partner_id = p_dup_trading_partner_id
714: AND pbh1.vendor_id = p_dup_vendor_id
715: AND pbh1.vendor_site_id = p_dup_vendor_site_id
716: AND NOT EXISTS (SELECT 'DUPLICATE'
717: FROM pon_bid_headers pbh2
718: WHERE pbh2.auction_header_id = pbh1.auction_header_id
719: AND pbh2.vendor_id = p_vendor_id
720: AND pbh2.vendor_site_id = p_vendor_site_id
721: AND pbh2.trading_partner_id = p_trading_partner_id

Line 725: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_bid_headers');

721: AND pbh2.trading_partner_id = p_trading_partner_id
722: AND pbh2.trading_partner_contact_id = pbh1.trading_partner_contact_id);
723:
724: l_progress := 502;
725: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_bid_headers');
726:
727: -- Bug 5100555
728: -- This is done to update site code for reusable invitation list
729: -- putting separate query to take care of duplication of supplier

Line 848: 2. pon_bid_headers

844:
845: Followling table will be updated while merging last site
846:
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

Line 869: FROM pon_bid_headers pbh1

865: pbip1.last_updated_by = -1,
866: pbip1.last_update_date = sysdate
867: WHERE pbip1.bid_trading_partner_id = p_dup_trading_partner_id
868: AND pbip1.bid_number IN (SELECT bid_number
869: FROM pon_bid_headers pbh1
870: WHERE pbh1.trading_partner_id = p_dup_trading_partner_id
871: AND pbh1.vendor_id = p_dup_vendor_id
872: AND pbh1.vendor_site_id = decode(pbh1.vendor_site_id,-1,-1,p_dup_vendor_site_id)
873: AND NOT EXISTS (SELECT 'DUPLICATE'

Line 874: FROM pon_bid_headers pbh2

870: WHERE pbh1.trading_partner_id = p_dup_trading_partner_id
871: AND pbh1.vendor_id = p_dup_vendor_id
872: AND pbh1.vendor_site_id = decode(pbh1.vendor_site_id,-1,-1,p_dup_vendor_site_id)
873: AND NOT EXISTS (SELECT 'DUPLICATE'
874: FROM pon_bid_headers pbh2
875: WHERE pbh2.auction_header_id = pbh1.auction_header_id
876: AND pbh2.vendor_id = p_vendor_id
877: AND pbh2.vendor_site_id= decode(pbh2.vendor_site_id,-1,-1,p_vendor_site_id)
878: AND pbh2.trading_partner_id = p_trading_partner_id

Line 896: UPDATE pon_bid_headers pbh1

892:
893: l_progress := 703;
894: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_acknowledgements');
895:
896: UPDATE pon_bid_headers pbh1
897: SET pbh1.trading_partner_id = p_trading_partner_id,
898: pbh1.trading_partner_name = p_trading_partner_name,
899: pbh1.vendor_id = p_vendor_id,
900: pbh1.vendor_site_id = decode(pbh1.vendor_site_id,-1,-1,p_vendor_site_id),

Line 908: FROM pon_bid_headers pbh2

904: WHERE pbh1.trading_partner_id = p_dup_trading_partner_id
905: AND pbh1.vendor_id = p_dup_vendor_id
906: AND pbh1.vendor_site_id = decode(pbh1.vendor_site_id,-1,-1,p_dup_vendor_site_id)
907: AND NOT EXISTS (SELECT 'DUPLICATE'
908: FROM pon_bid_headers pbh2
909: WHERE pbh2.auction_header_id = pbh1.auction_header_id
910: AND pbh2.vendor_id = p_vendor_id
911: AND decode(pbh2.vendor_site_id,-1,p_vendor_site_id,pbh2.vendor_site_id) = p_vendor_site_id
912: AND decode(pbh2.vendor_site_code,'-1',p_vendor_site_code,null,p_vendor_site_code,pbh2.vendor_site_code) = p_vendor_site_code

Line 917: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_bid_headers');

913: AND pbh2.trading_partner_id = p_trading_partner_id
914: AND pbh2.trading_partner_contact_id = pbh1.trading_partner_contact_id);
915:
916: l_progress := 704;
917: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_bid_headers');
918:
919: SELECT pvs.vendor_site_code
920: INTO l_dup_vendor_site_code
921: FROM po_vendors pv, po_vendor_sites_all pvs

Line 1128: pon_bid_headers bh

1124: SYSDATE,
1125: bh.last_updated_by,
1126: 0
1127: FROM pon_auction_headers_all ah,
1128: pon_bid_headers bh
1129: WHERE bh.trading_partner_id = p_dup_trading_partner_id
1130: AND ah.auction_header_id = bh.auction_header_id
1131: AND NOT EXISTS (
1132: SELECT NULL

Line 1141: FROM pon_bid_headers bh2,

1137: )
1138: AND NOT EXISTS
1139: (
1140: SELECT NULL
1141: FROM pon_bid_headers bh2,
1142: pon_auction_headers_all ah2
1143: WHERE ah2.auction_header_id = bh2.auction_header_id
1144: AND ah.auction_header_id_orig_amend = ah2.auction_header_id_orig_amend
1145: AND bh2.bid_number > bh.bid_number