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.GMF_SYNC_VENDOR dependencies on PO_VENDORS

Line 18: v_segment1 PO_VENDORS.SEGMENT1%Type;

14: --Begin Bug 1677297 Mohit Kapoor
15: --Added following variables
16: v_vendor_id PO_VENDOR_SITES_ALL.VENDOR_ID%Type;
17: v_vendor_site_code PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%Type;
18: v_segment1 PO_VENDORS.SEGMENT1%Type;
19: v_total_vendors_failed number:=0;
20: v_total_vendors number:=0;
21: --End Bug 1677297
22:

Line 42: cursor c_po_vendors(p_vendor_id Number) is

38: for update of last_update_date;
39: --End Bug 1677297 Mohit Kapoor
40:
41: --Begin Bug 1677297 Mohit Kapoor Added cursor
42: cursor c_po_vendors(p_vendor_id Number) is
43: select v.segment1
44: from po_vendors v
45: where v.vendor_id = p_vendor_id;
46: -- End Bug 1677297

Line 44: from po_vendors v

40:
41: --Begin Bug 1677297 Mohit Kapoor Added cursor
42: cursor c_po_vendors(p_vendor_id Number) is
43: select v.segment1
44: from po_vendors v
45: where v.vendor_id = p_vendor_id;
46: -- End Bug 1677297
47:
48: begin

Line 87: open c_po_vendors(v_vendor_id);

83: exit when c_po_vendor_sites_all%NOTFOUND;
84:
85: GMF_Session_Vars.GL$VEND_DELIMITER := nvl(FND_PROFILE.VALUE('GL$VEND_DELIMITER'),'-');
86:
87: open c_po_vendors(v_vendor_id);
88: fetch c_po_vendors into v_segment1;
89: close c_po_vendors;
90:
91: PRINT (' '|| v_segment1 || GMF_Session_Vars.GL$VEND_DELIMITER || v_vendor_site_code );

Line 88: fetch c_po_vendors into v_segment1;

84:
85: GMF_Session_Vars.GL$VEND_DELIMITER := nvl(FND_PROFILE.VALUE('GL$VEND_DELIMITER'),'-');
86:
87: open c_po_vendors(v_vendor_id);
88: fetch c_po_vendors into v_segment1;
89: close c_po_vendors;
90:
91: PRINT (' '|| v_segment1 || GMF_Session_Vars.GL$VEND_DELIMITER || v_vendor_site_code );
92: v_total_vendors:=v_total_vendors+1;

Line 89: close c_po_vendors;

85: GMF_Session_Vars.GL$VEND_DELIMITER := nvl(FND_PROFILE.VALUE('GL$VEND_DELIMITER'),'-');
86:
87: open c_po_vendors(v_vendor_id);
88: fetch c_po_vendors into v_segment1;
89: close c_po_vendors;
90:
91: PRINT (' '|| v_segment1 || GMF_Session_Vars.GL$VEND_DELIMITER || v_vendor_site_code );
92: v_total_vendors:=v_total_vendors+1;
93: --End Bug 1677297