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.PO_R12_CAT_UPG_DEF_PVT dependencies on PO_R12_CAT_UPG_TYPES

Line 16: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,

12: PROCEDURE default_info_from_vendor
13: (
14: p_key IN NUMBER,
15: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
16: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
17: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
18: );
19:
20: PROCEDURE default_vendor_sites

Line 17: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

13: (
14: p_key IN NUMBER,
15: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
16: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
17: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
18: );
19:
20: PROCEDURE default_vendor_sites
21: (

Line 30: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,

26: PROCEDURE default_info_from_vendor_site
27: (
28: p_key IN NUMBER,
29: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
30: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
31: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
32: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
33: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
34: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 31: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,

27: (
28: p_key IN NUMBER,
29: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
30: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
31: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
32: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
33: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
34: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
35: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,

Line 32: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,

28: p_key IN NUMBER,
29: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
30: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
31: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
32: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
33: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
34: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
35: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
36: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 33: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

29: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
30: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
31: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
32: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
33: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
34: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
35: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
36: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
37: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,

Line 34: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

30: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
31: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
32: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
33: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
34: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
35: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
36: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
37: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
38: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30

Line 35: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,

31: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
32: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
33: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
34: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
35: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
36: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
37: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
38: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30
39: );

Line 36: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

32: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
33: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
34: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
35: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
36: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
37: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
38: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30
39: );
40:

Line 37: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,

33: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
34: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
35: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
36: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
37: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
38: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30
39: );
40:
41: PROCEDURE default_vendor_contact_info

Line 38: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30

34: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
35: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
36: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
37: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
38: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30
39: );
40:
41: PROCEDURE default_vendor_contact_info
42: (

Line 87: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

83: l_progress VARCHAR2(3) := '000';
84:
85: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
86:
87: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
88: l_vendor_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
89: l_vendor_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
90:
91: l_site_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

Line 88: l_vendor_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;

84:
85: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
86:
87: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
88: l_vendor_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
89: l_vendor_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
90:
91: l_site_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
92: l_site_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

Line 89: l_vendor_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

85: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
86:
87: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
88: l_vendor_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
89: l_vendor_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
90:
91: l_site_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
92: l_site_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
93: l_site_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

Line 91: l_site_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

87: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
88: l_vendor_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
89: l_vendor_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
90:
91: l_site_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
92: l_site_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
93: l_site_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
94: l_site_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
95: l_site_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 92: l_site_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

88: l_vendor_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
89: l_vendor_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
90:
91: l_site_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
92: l_site_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
93: l_site_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
94: l_site_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
95: l_site_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
96: l_site_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;

Line 93: l_site_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

89: l_vendor_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
90:
91: l_site_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
92: l_site_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
93: l_site_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
94: l_site_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
95: l_site_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
96: l_site_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
97: l_site_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 94: l_site_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

90:
91: l_site_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
92: l_site_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
93: l_site_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
94: l_site_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
95: l_site_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
96: l_site_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
97: l_site_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
98: l_site_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;

Line 95: l_site_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

91: l_site_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
92: l_site_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
93: l_site_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
94: l_site_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
95: l_site_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
96: l_site_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
97: l_site_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
98: l_site_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
99: l_site_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

Line 96: l_site_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;

92: l_site_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
93: l_site_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
94: l_site_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
95: l_site_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
96: l_site_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
97: l_site_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
98: l_site_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
99: l_site_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
100:

Line 97: l_site_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

93: l_site_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
94: l_site_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
95: l_site_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
96: l_site_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
97: l_site_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
98: l_site_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
99: l_site_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
100:
101: l_vendor_contact_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 98: l_site_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;

94: l_site_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
95: l_site_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
96: l_site_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
97: l_site_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
98: l_site_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
99: l_site_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
100:
101: l_vendor_contact_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
102: l_is_fixed_rate VARCHAR2(10);

Line 99: l_site_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

95: l_site_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
96: l_site_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
97: l_site_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
98: l_site_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
99: l_site_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
100:
101: l_vendor_contact_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
102: l_is_fixed_rate VARCHAR2(10);
103:

Line 101: l_vendor_contact_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

97: l_site_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
98: l_site_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
99: l_site_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
100:
101: l_vendor_contact_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
102: l_is_fixed_rate VARCHAR2(10);
103:
104: l_key PO_SESSION_GT.key%TYPE;
105: i NUMBER;

Line 638: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,

634: PROCEDURE default_info_from_vendor
635: (
636: p_key IN NUMBER,
637: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
638: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
639: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
640: )
641: IS
642: l_api_name CONSTANT VARCHAR2(30) := 'default_info_from_vendor';

Line 639: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

635: (
636: p_key IN NUMBER,
637: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
638: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
639: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
640: )
641: IS
642: l_api_name CONSTANT VARCHAR2(30) := 'default_info_from_vendor';
643: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 648: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;

644: l_progress VARCHAR2(3) := '000';
645:
646: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
647:
648: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
649: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
650: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
651:
652: l_index NUMBER;

Line 649: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

645:
646: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
647:
648: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
649: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
650: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
651:
652: l_index NUMBER;
653: i NUMBER;

Line 650: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

646: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
647:
648: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
649: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
650: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
651:
652: l_index NUMBER;
653: i NUMBER;
654: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 654: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

650: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
651:
652: l_index NUMBER;
653: i NUMBER;
654: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
655: BEGIN
656: l_progress := '010';
657: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
658:

Line 756: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

752: l_progress VARCHAR2(3) := '000';
753:
754: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
755:
756: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
757: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
758:
759: l_index NUMBER;
760: i NUMBER;

Line 757: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

753:
754: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
755:
756: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
757: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
758:
759: l_index NUMBER;
760: i NUMBER;
761:

Line 762: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

758:
759: l_index NUMBER;
760: i NUMBER;
761:
762: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
763: BEGIN
764: l_progress := '010';
765:
766: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 864: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,

860: PROCEDURE default_info_from_vendor_site
861: (
862: p_key IN NUMBER,
863: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
864: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
865: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
866: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
867: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
868: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 865: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,

861: (
862: p_key IN NUMBER,
863: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
864: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
865: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
866: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
867: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
868: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
869: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,

Line 866: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,

862: p_key IN NUMBER,
863: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
864: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
865: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
866: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
867: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
868: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
869: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
870: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 867: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

863: p_headers_rec IN PO_R12_CAT_UPG_PVT.record_of_headers_type,
864: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
865: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
866: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
867: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
868: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
869: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
870: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
871: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,

Line 868: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

864: x_fob_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
865: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
866: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
867: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
868: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
869: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
870: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
871: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
872: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30

Line 869: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,

865: x_ship_via_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
866: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
867: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
868: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
869: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
870: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
871: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
872: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30
873: )

Line 870: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

866: x_freight_terms_lookup_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
867: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
868: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
869: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
870: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
871: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
872: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30
873: )
874: IS

Line 871: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,

867: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
868: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
869: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
870: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
871: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
872: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30
873: )
874: IS
875: l_api_name CONSTANT VARCHAR2(30) := 'default_info_from_vendor_site';

Line 872: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30

868: x_bill_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
869: x_invoice_currency_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15,
870: x_terms_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
871: x_pay_on_codes OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25,
872: x_shipping_controls OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30
873: )
874: IS
875: l_api_name CONSTANT VARCHAR2(30) := 'default_info_from_vendor_site';
876: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 881: l_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

877: l_progress VARCHAR2(3) := '000';
878:
879: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
880:
881: l_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
882: l_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
883: l_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
884: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
885: l_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 882: l_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

878:
879: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
880:
881: l_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
882: l_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
883: l_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
884: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
885: l_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
886: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;

Line 883: l_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

879: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
880:
881: l_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
882: l_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
883: l_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
884: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
885: l_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
886: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
887: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 884: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

880:
881: l_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
882: l_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
883: l_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
884: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
885: l_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
886: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
887: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
888: l_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;

Line 885: l_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

881: l_fob_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
882: l_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
883: l_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
884: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
885: l_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
886: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
887: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
888: l_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
889: l_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

Line 886: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;

882: l_ship_via_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
883: l_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
884: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
885: l_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
886: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
887: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
888: l_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
889: l_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
890: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 887: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

883: l_freight_terms_luc PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
884: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
885: l_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
886: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
887: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
888: l_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
889: l_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
890: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
891:

Line 888: l_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;

884: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
885: l_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
886: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
887: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
888: l_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
889: l_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
890: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
891:
892: l_index NUMBER;

Line 889: l_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

885: l_bill_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
886: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
887: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
888: l_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
889: l_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
890: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
891:
892: l_index NUMBER;
893: i NUMBER;

Line 890: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

886: l_currency_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
887: l_terms_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
888: l_shipping_controls PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
889: l_pay_on_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
890: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
891:
892: l_index NUMBER;
893: i NUMBER;
894: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 894: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

890: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
891:
892: l_index NUMBER;
893: i NUMBER;
894: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
895: BEGIN
896: l_progress := '010';
897:
898: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 1039: l_contact_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1035: l_progress VARCHAR2(3) := '000';
1036:
1037: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1038:
1039: l_contact_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1040: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1041: l_index NUMBER;
1042:
1043: i NUMBER;

Line 1040: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1036:
1037: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1038:
1039: l_contact_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1040: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1041: l_index NUMBER;
1042:
1043: i NUMBER;
1044: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1044: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1040: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1041: l_index NUMBER;
1042:
1043: i NUMBER;
1044: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1045: BEGIN
1046: l_progress := '010';
1047: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1048:

Line 1154: l_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1150: l_api_name CONSTANT VARCHAR2(30) := 'default_buyer';
1151: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
1152: l_progress VARCHAR2(3) := '000';
1153:
1154: l_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1155: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1156: l_index NUMBER;
1157:
1158: i NUMBER;

Line 1155: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1151: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
1152: l_progress VARCHAR2(3) := '000';
1153:
1154: l_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1155: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1156: l_index NUMBER;
1157:
1158: i NUMBER;
1159: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1159: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1155: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1156: l_index NUMBER;
1157:
1158: i NUMBER;
1159: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1160: BEGIN
1161: l_progress := '010';
1162: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1163:

Line 1355: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1351: PROCEDURE default_hdr_info
1352: (
1353: p_key IN PO_SESSION_GT.key%TYPE,
1354: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
1355: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1356: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1357: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1358: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1359: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 1356: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1352: (
1353: p_key IN PO_SESSION_GT.key%TYPE,
1354: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
1355: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1356: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1357: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1358: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1359: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1360: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

Line 1357: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1353: p_key IN PO_SESSION_GT.key%TYPE,
1354: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
1355: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1356: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1357: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1358: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1359: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1360: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1361: );

Line 1358: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1354: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
1355: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1356: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1357: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1358: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1359: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1360: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1361: );
1362:

Line 1359: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1355: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1356: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1357: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1358: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1359: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1360: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1361: );
1362:
1363: PROCEDURE copy_info_from_hdr

Line 1360: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1356: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1357: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1358: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1359: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1360: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1361: );
1362:
1363: PROCEDURE copy_info_from_hdr
1364: (

Line 1365: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1361: );
1362:
1363: PROCEDURE copy_info_from_hdr
1364: (
1365: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1366: p_po_header_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1367: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1368: );
1369:

Line 1366: p_po_header_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1362:
1363: PROCEDURE copy_info_from_hdr
1364: (
1365: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1366: p_po_header_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1367: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1368: );
1369:
1370: PROCEDURE default_line_type

Line 1373: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1369:
1370: PROCEDURE default_line_type
1371: (
1372: p_key IN PO_SESSION_GT.key%TYPE,
1373: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1374: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1375: );
1376:
1377: PROCEDURE default_info_from_line_type

Line 1398: p_location_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1394:
1395: PROCEDURE get_ship_to_org_from_location
1396: (
1397: p_key IN PO_SESSION_GT.key%TYPE,
1398: p_location_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1399: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1400: );
1401:
1402: -- END: Forward function declarations

Line 1399: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

1395: PROCEDURE get_ship_to_org_from_location
1396: (
1397: p_key IN PO_SESSION_GT.key%TYPE,
1398: p_location_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1399: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
1400: );
1401:
1402: -- END: Forward function declarations
1403:

Line 1439: l_hdr_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1435:
1436: l_key PO_SESSION_GT.key%TYPE;
1437: i NUMBER;
1438:
1439: l_hdr_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1440: l_hdr_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1441: l_hdr_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1442: l_hdr_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1443: l_hdr_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1440: l_hdr_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1436: l_key PO_SESSION_GT.key%TYPE;
1437: i NUMBER;
1438:
1439: l_hdr_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1440: l_hdr_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1441: l_hdr_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1442: l_hdr_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1443: l_hdr_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1444: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1441: l_hdr_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1437: i NUMBER;
1438:
1439: l_hdr_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1440: l_hdr_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1441: l_hdr_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1442: l_hdr_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1443: l_hdr_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1444: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1445:

Line 1442: l_hdr_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1438:
1439: l_hdr_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1440: l_hdr_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1441: l_hdr_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1442: l_hdr_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1443: l_hdr_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1444: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1445:
1446: l_it_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;

Line 1443: l_hdr_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1439: l_hdr_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1440: l_hdr_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1441: l_hdr_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1442: l_hdr_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1443: l_hdr_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1444: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1445:
1446: l_it_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;
1447: l_ship_to_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1444: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1440: l_hdr_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1441: l_hdr_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1442: l_hdr_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1443: l_hdr_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1444: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1445:
1446: l_it_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;
1447: l_ship_to_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1448:

Line 1446: l_it_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;

1442: l_hdr_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1443: l_hdr_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1444: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1445:
1446: l_it_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;
1447: l_ship_to_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1448:
1449: BEGIN
1450: l_progress := '010';

Line 1447: l_ship_to_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1443: l_hdr_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1444: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1445:
1446: l_it_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;
1447: l_ship_to_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1448:
1449: BEGIN
1450: l_progress := '010';
1451: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 1776: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1772: --End of Comments
1773: --------------------------------------------------------------------------------
1774: PROCEDURE copy_info_from_hdr
1775: (
1776: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1777: p_po_header_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1778: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1779: )
1780: IS

Line 1777: p_po_header_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1773: --------------------------------------------------------------------------------
1774: PROCEDURE copy_info_from_hdr
1775: (
1776: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1777: p_po_header_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1778: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1779: )
1780: IS
1781: l_api_name CONSTANT VARCHAR2(30) := 'copy_info_from_hdr';

Line 1835: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

1831: --------------------------------------------------------------------------------
1832: PROCEDURE default_line_type
1833: (
1834: p_key IN PO_SESSION_GT.key%TYPE,
1835: p_hdr_org_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
1836: x_lines_rec IN OUT NOCOPY PO_R12_CAT_UPG_PVT.record_of_lines_type
1837: )
1838: IS
1839: l_api_name CONSTANT VARCHAR2(30) := 'default_line_type';

Line 1845: l_line_type_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1841: l_progress VARCHAR2(3) := '000';
1842:
1843: l_size NUMBER := x_lines_rec.interface_line_id.COUNT;
1844:
1845: l_line_type_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1846: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1847: l_index NUMBER;
1848:
1849: i NUMBER;

Line 1846: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1842:
1843: l_size NUMBER := x_lines_rec.interface_line_id.COUNT;
1844:
1845: l_line_type_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1846: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1847: l_index NUMBER;
1848:
1849: i NUMBER;
1850: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1850: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1846: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1847: l_index NUMBER;
1848:
1849: i NUMBER;
1850: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1851: BEGIN
1852: l_progress := '010';
1853: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1854:

Line 1952: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1948: l_progress VARCHAR2(3) := '000';
1949:
1950: l_size NUMBER := x_lines_rec.interface_line_id.COUNT;
1951:
1952: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1953: l_order_type_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1954: l_purchase_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
1955: l_matching_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
1956:

Line 1953: l_order_type_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

1949:
1950: l_size NUMBER := x_lines_rec.interface_line_id.COUNT;
1951:
1952: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1953: l_order_type_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1954: l_purchase_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
1955: l_matching_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
1956:
1957: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 1954: l_purchase_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;

1950: l_size NUMBER := x_lines_rec.interface_line_id.COUNT;
1951:
1952: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1953: l_order_type_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1954: l_purchase_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
1955: l_matching_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
1956:
1957: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1958: l_index NUMBER;

Line 1955: l_matching_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;

1951:
1952: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1953: l_order_type_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1954: l_purchase_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
1955: l_matching_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
1956:
1957: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1958: l_index NUMBER;
1959: i NUMBER;

Line 1957: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

1953: l_order_type_lookup_codes PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1954: l_purchase_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
1955: l_matching_basis PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
1956:
1957: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1958: l_index NUMBER;
1959: i NUMBER;
1960: BEGIN
1961: l_progress := '010';

Line 2059: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2055: l_progress VARCHAR2(3) := '000';
2056:
2057: l_size NUMBER := x_lines_rec.interface_line_id.COUNT;
2058:
2059: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2060: l_un_number_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2061: l_hazard_class_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2062: l_market_prices PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2063: l_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;

Line 2060: l_un_number_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2056:
2057: l_size NUMBER := x_lines_rec.interface_line_id.COUNT;
2058:
2059: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2060: l_un_number_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2061: l_hazard_class_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2062: l_market_prices PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2063: l_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;
2064:

Line 2061: l_hazard_class_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2057: l_size NUMBER := x_lines_rec.interface_line_id.COUNT;
2058:
2059: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2060: l_un_number_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2061: l_hazard_class_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2062: l_market_prices PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2063: l_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;
2064:
2065: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2062: l_market_prices PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2058:
2059: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2060: l_un_number_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2061: l_hazard_class_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2062: l_market_prices PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2063: l_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;
2064:
2065: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2066: l_index NUMBER;

Line 2063: l_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;

2059: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2060: l_un_number_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2061: l_hazard_class_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2062: l_market_prices PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2063: l_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;
2064:
2065: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2066: l_index NUMBER;
2067: i NUMBER;

Line 2065: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2061: l_hazard_class_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2062: l_market_prices PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2063: l_inspection_required_flags PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR1;
2064:
2065: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2066: l_index NUMBER;
2067: i NUMBER;
2068: BEGIN
2069: l_progress := '010';

Line 2159: p_location_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

2155: --------------------------------------------------------------------------------
2156: PROCEDURE get_ship_to_org_from_location
2157: (
2158: p_key IN PO_SESSION_GT.key%TYPE,
2159: p_location_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2160: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
2161: )
2162: IS
2163: l_api_name CONSTANT VARCHAR2(30) := 'get_ship_to_org_from_location';

Line 2160: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

2156: PROCEDURE get_ship_to_org_from_location
2157: (
2158: p_key IN PO_SESSION_GT.key%TYPE,
2159: p_location_ids IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2160: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
2161: )
2162: IS
2163: l_api_name CONSTANT VARCHAR2(30) := 'get_ship_to_org_from_location';
2164: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2169: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2165: l_progress VARCHAR2(3) := '000';
2166:
2167: l_size NUMBER := p_location_ids.COUNT;
2168:
2169: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2170: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2171:
2172: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2173: l_index NUMBER;

Line 2170: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2166:
2167: l_size NUMBER := p_location_ids.COUNT;
2168:
2169: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2170: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2171:
2172: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2173: l_index NUMBER;
2174: i NUMBER;

Line 2172: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2168:
2169: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2170: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2171:
2172: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2173: l_index NUMBER;
2174: i NUMBER;
2175: BEGIN
2176: l_progress := '010';

Line 2271: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2267: l_progress VARCHAR2(3) := '000';
2268:
2269: l_size NUMBER := x_lines_rec.interface_line_id.COUNT;
2270:
2271: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2272: l_hazard_class_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2273:
2274: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2275: l_index NUMBER;

Line 2272: l_hazard_class_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2268:
2269: l_size NUMBER := x_lines_rec.interface_line_id.COUNT;
2270:
2271: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2272: l_hazard_class_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2273:
2274: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2275: l_index NUMBER;
2276: i NUMBER;

Line 2274: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2270:
2271: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2272: l_hazard_class_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2273:
2274: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2275: l_index NUMBER;
2276: i NUMBER;
2277: BEGIN
2278: l_progress := '010';

Line 2372: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

2368: PROCEDURE default_hdr_info
2369: (
2370: p_key IN PO_SESSION_GT.key%TYPE,
2371: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
2372: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2373: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2374: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2375: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2376: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

Line 2373: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

2369: (
2370: p_key IN PO_SESSION_GT.key%TYPE,
2371: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
2372: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2373: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2374: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2375: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2376: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2377: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

Line 2374: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

2370: p_key IN PO_SESSION_GT.key%TYPE,
2371: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
2372: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2373: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2374: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2375: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2376: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2377: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
2378: )

Line 2375: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

2371: p_lines_rec IN PO_R12_CAT_UPG_PVT.record_of_lines_type,
2372: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2373: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2374: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2375: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2376: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2377: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
2378: )
2379: IS

Line 2376: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

2372: x_org_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2373: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2374: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2375: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2376: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2377: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
2378: )
2379: IS
2380: l_api_name CONSTANT VARCHAR2(30) := 'default_hdr_info';

Line 2377: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

2373: x_vendor_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2374: x_vendor_site_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2375: x_ship_to_location_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2376: x_min_release_amounts OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
2377: x_po_header_ids OUT NOCOPY PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
2378: )
2379: IS
2380: l_api_name CONSTANT VARCHAR2(30) := 'default_hdr_info';
2381: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2386: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2382: l_progress VARCHAR2(3) := '000';
2383:
2384: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2385:
2386: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2387: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2388:
2389: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2390: l_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2387: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2383:
2384: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2385:
2386: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2387: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2388:
2389: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2390: l_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2391: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2389: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2385:
2386: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2387: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2388:
2389: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2390: l_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2391: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2392: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2393: l_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2390: l_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2386: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2387: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2388:
2389: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2390: l_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2391: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2392: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2393: l_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2394: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 2391: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2387: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2388:
2389: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2390: l_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2391: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2392: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2393: l_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2394: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2395:

Line 2392: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2388:
2389: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2390: l_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2391: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2392: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2393: l_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2394: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2395:
2396: l_index NUMBER;

Line 2393: l_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2389: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2390: l_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2391: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2392: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2393: l_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2394: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2395:
2396: l_index NUMBER;
2397: i NUMBER;

Line 2394: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2390: l_vendor_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2391: l_vendor_site_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2392: l_ship_to_location_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2393: l_min_release_amounts PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2394: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2395:
2396: l_index NUMBER;
2397: i NUMBER;
2398: BEGIN