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_PDOI_LINE_PROCESS_PVT dependencies on PO_TBL_NUMBER

Line 19: p_vendor_id_tbl IN PO_TBL_NUMBER,

15: PROCEDURE derive_item_id
16: (
17: p_key IN po_session_gt.key%TYPE,
18: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
19: p_vendor_id_tbl IN PO_TBL_NUMBER,
20: p_intf_header_id_tbl IN PO_TBL_NUMBER,
21: p_intf_line_id_tbl IN PO_TBL_NUMBER,
22: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
23: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337

Line 20: p_intf_header_id_tbl IN PO_TBL_NUMBER,

16: (
17: p_key IN po_session_gt.key%TYPE,
18: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
19: p_vendor_id_tbl IN PO_TBL_NUMBER,
20: p_intf_header_id_tbl IN PO_TBL_NUMBER,
21: p_intf_line_id_tbl IN PO_TBL_NUMBER,
22: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
23: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
24: p_item_tbl IN PO_TBL_VARCHAR2000,

Line 21: p_intf_line_id_tbl IN PO_TBL_NUMBER,

17: p_key IN po_session_gt.key%TYPE,
18: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
19: p_vendor_id_tbl IN PO_TBL_NUMBER,
20: p_intf_header_id_tbl IN PO_TBL_NUMBER,
21: p_intf_line_id_tbl IN PO_TBL_NUMBER,
22: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
23: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
24: p_item_tbl IN PO_TBL_VARCHAR2000,
25: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

Line 23: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337

19: p_vendor_id_tbl IN PO_TBL_NUMBER,
20: p_intf_header_id_tbl IN PO_TBL_NUMBER,
21: p_intf_line_id_tbl IN PO_TBL_NUMBER,
22: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
23: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
24: p_item_tbl IN PO_TBL_VARCHAR2000,
25: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
26: x_error_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
27: );

Line 25: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

21: p_intf_line_id_tbl IN PO_TBL_NUMBER,
22: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
23: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
24: p_item_tbl IN PO_TBL_VARCHAR2000,
25: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
26: x_error_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
27: );
28:
29: PROCEDURE derive_item_revision

Line 32: p_item_id_tbl IN PO_TBL_NUMBER,

28:
29: PROCEDURE derive_item_revision
30: (
31: p_key IN po_session_gt.key%TYPE,
32: p_item_id_tbl IN PO_TBL_NUMBER,
33: x_item_revision_tbl IN OUT NOCOPY PO_TBL_VARCHAR5
34: );
35:
36: PROCEDURE derive_job_business_group_id

Line 41: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

37: (
38: p_key IN po_session_gt.key%TYPE,
39: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
40: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
41: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
42: );
43:
44: PROCEDURE derive_job_id
45: (

Line 51: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

47: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
48: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
49: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
50: p_job_name_tbl IN PO_TBL_VARCHAR2000,
51: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
52: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
53: );
54:
55: PROCEDURE derive_category_id

Line 52: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

48: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
49: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
50: p_job_name_tbl IN PO_TBL_VARCHAR2000,
51: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
52: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
53: );
54:
55: PROCEDURE derive_category_id
56: (

Line 59: x_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

55: PROCEDURE derive_category_id
56: (
57: p_key IN po_session_gt.key%TYPE,
58: p_category_tbl IN PO_TBL_VARCHAR2000,
59: x_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
60: );
61:
62: PROCEDURE derive_ip_category_id
63: (

Line 68: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

64: p_key IN po_session_gt.key%TYPE,
65: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
66: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
67: p_ip_category_tbl IN PO_TBL_VARCHAR2000,
68: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
69: );
70:
71: PROCEDURE derive_unit_of_measure
72: (

Line 85: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

81: p_key IN po_session_gt.key%TYPE,
82: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
83: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
84: p_line_type_tbl IN PO_TBL_VARCHAR30,
85: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
86: );
87:
88: PROCEDURE derive_un_number_id
89: (

Line 93: x_un_number_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

89: (
90: p_key IN po_session_gt.key%TYPE,
91: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
92: p_un_number_tbl IN PO_TBL_VARCHAR30,
93: x_un_number_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
94: );
95:
96: PROCEDURE derive_hazard_class_id
97: (

Line 101: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

97: (
98: p_key IN po_session_gt.key%TYPE,
99: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
100: p_hazard_class_tbl IN PO_TBL_VARCHAR100,
101: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
102: );
103:
104: PROCEDURE derive_template_id
105: (

Line 109: x_template_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

105: (
106: p_key IN po_session_gt.key%TYPE,
107: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
108: p_template_name_tbl IN PO_TBL_VARCHAR30,
109: x_template_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
110: );
111:
112: PROCEDURE default_info_from_line_type
113: (

Line 116: p_line_type_id_tbl IN PO_TBL_NUMBER,

112: PROCEDURE default_info_from_line_type
113: (
114: p_key IN po_session_gt.key%TYPE,
115: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
116: p_line_type_id_tbl IN PO_TBL_NUMBER,
117: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
118: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
119: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
120: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 120: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

116: p_line_type_id_tbl IN PO_TBL_NUMBER,
117: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
118: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
119: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
120: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
121: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
122: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER
123: );
124:

Line 122: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER

118: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
119: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
120: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
121: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
122: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER
123: );
124:
125: PROCEDURE default_info_from_item
126: (

Line 129: p_item_id_tbl IN PO_TBL_NUMBER,

125: PROCEDURE default_info_from_item
126: (
127: p_key IN po_session_gt.key%TYPE,
128: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
129: p_item_id_tbl IN PO_TBL_NUMBER,
130: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
131: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
132: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
133: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 132: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,

128: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
129: p_item_id_tbl IN PO_TBL_NUMBER,
130: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
131: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
132: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
133: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
134: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
135: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 133: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

129: p_item_id_tbl IN PO_TBL_NUMBER,
130: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
131: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
132: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
133: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
134: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
135: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
137: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30

Line 134: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,

130: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
131: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
132: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
133: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
134: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
135: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
137: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
138: );

Line 135: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,

131: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
132: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
133: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
134: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
135: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
137: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
138: );
139:

Line 136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,

132: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
133: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
134: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
135: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
137: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
138: );
139:
140: PROCEDURE default_info_from_job

Line 144: p_job_id_tbl IN PO_TBL_NUMBER,

140: PROCEDURE default_info_from_job
141: (
142: p_key IN po_session_gt.key%TYPE,
143: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
144: p_job_id_tbl IN PO_TBL_NUMBER,
145: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
146: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER
147: );
148:

Line 146: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER

142: p_key IN po_session_gt.key%TYPE,
143: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
144: p_job_id_tbl IN PO_TBL_NUMBER,
145: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
146: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER
147: );
148:
149: PROCEDURE default_po_cat_id_from_ip
150: (

Line 153: p_ip_category_id_tbl IN PO_TBL_NUMBER,

149: PROCEDURE default_po_cat_id_from_ip
150: (
151: p_key IN po_session_gt.key%TYPE,
152: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
153: p_ip_category_id_tbl IN PO_TBL_NUMBER,
154: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
155: );
156:
157: PROCEDURE default_ip_cat_id_from_po

Line 154: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

150: (
151: p_key IN po_session_gt.key%TYPE,
152: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
153: p_ip_category_id_tbl IN PO_TBL_NUMBER,
154: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
155: );
156:
157: PROCEDURE default_ip_cat_id_from_po
158: (

Line 161: p_po_category_id_tbl IN PO_TBL_NUMBER,

157: PROCEDURE default_ip_cat_id_from_po
158: (
159: p_key IN po_session_gt.key%TYPE,
160: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
161: p_po_category_id_tbl IN PO_TBL_NUMBER,
162: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
163: );
164:
165: PROCEDURE default_hc_id_from_un_number

Line 162: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

158: (
159: p_key IN po_session_gt.key%TYPE,
160: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
161: p_po_category_id_tbl IN PO_TBL_NUMBER,
162: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
163: );
164:
165: PROCEDURE default_hc_id_from_un_number
166: (

Line 170: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

166: (
167: p_key IN po_session_gt.key%TYPE,
168: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
169: p_un_number_tbl IN PO_TBL_VARCHAR30,
170: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
171: );
172:
173: PROCEDURE match_lines_on_line_num
174: (

Line 236: p_target_lines_index_tbl IN PO_TBL_NUMBER,

232: PROCEDURE set_action_add
233: (
234: p_key IN po_session_gt.key%TYPE,
235: p_group_num IN NUMBER,
236: p_target_lines_index_tbl IN PO_TBL_NUMBER,
237: p_check_line_num_assign IN VARCHAR2,
238: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
239: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
240: );

Line 318: l_dup_intf_header_id_tbl PO_TBL_NUMBER;

314: AND intf_lines.line_num = draft_lines.line_num
315: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
316:
317: -- duplicate lines in interface table
318: l_dup_intf_header_id_tbl PO_TBL_NUMBER;
319: l_dup_intf_line_id_tbl PO_TBL_NUMBER;
320: l_dup_intf_line_num_tbl PO_TBL_NUMBER;
321:
322: -- number of duplicate lines retrieved in each batch

Line 319: l_dup_intf_line_id_tbl PO_TBL_NUMBER;

315: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
316:
317: -- duplicate lines in interface table
318: l_dup_intf_header_id_tbl PO_TBL_NUMBER;
319: l_dup_intf_line_id_tbl PO_TBL_NUMBER;
320: l_dup_intf_line_num_tbl PO_TBL_NUMBER;
321:
322: -- number of duplicate lines retrieved in each batch
323: l_count NUMBER;

Line 320: l_dup_intf_line_num_tbl PO_TBL_NUMBER;

316:
317: -- duplicate lines in interface table
318: l_dup_intf_header_id_tbl PO_TBL_NUMBER;
319: l_dup_intf_line_id_tbl PO_TBL_NUMBER;
320: l_dup_intf_line_num_tbl PO_TBL_NUMBER;
321:
322: -- number of duplicate lines retrieved in each batch
323: l_count NUMBER;
324: BEGIN

Line 517: l_rej_intf_line_id_tbl PO_TBL_NUMBER;

513: AND NVL(intf_lines.action, PO_PDOI_CONSTANTS.g_ACTION_ADD) <>
514: PO_PDOI_CONSTANTS.g_ACTION_ADD;
515:
516: -- interface line id of lines that need to be rejected
517: l_rej_intf_line_id_tbl PO_TBL_NUMBER;
518: l_rej_intf_header_id_tbl PO_TBL_NUMBER;
519: l_rej_line_action_tbl PO_TBL_VARCHAR30;
520:
521: BEGIN

Line 518: l_rej_intf_header_id_tbl PO_TBL_NUMBER;

514: PO_PDOI_CONSTANTS.g_ACTION_ADD;
515:
516: -- interface line id of lines that need to be rejected
517: l_rej_intf_line_id_tbl PO_TBL_NUMBER;
518: l_rej_intf_header_id_tbl PO_TBL_NUMBER;
519: l_rej_line_action_tbl PO_TBL_VARCHAR30;
520:
521: BEGIN
522: d_position := 0;

Line 2245: l_li_category_id_tbl PO_TBL_NUMBER;

2241: -- table used to save the index of the each row
2242: l_index_tbl DBMS_SQL.NUMBER_TABLE;
2243:
2244: -- information defaulted from line type
2245: l_li_category_id_tbl PO_TBL_NUMBER;
2246: l_li_unit_of_measure_tbl PO_TBL_VARCHAR30;
2247: l_li_unit_price_tbl PO_TBL_NUMBER;
2248:
2249: -- information defaulted from item

Line 2247: l_li_unit_price_tbl PO_TBL_NUMBER;

2243:
2244: -- information defaulted from line type
2245: l_li_category_id_tbl PO_TBL_NUMBER;
2246: l_li_unit_of_measure_tbl PO_TBL_VARCHAR30;
2247: l_li_unit_price_tbl PO_TBL_NUMBER;
2248:
2249: -- information defaulted from item
2250: l_it_item_desc_tbl PO_TBL_VARCHAR2000;
2251: l_it_unit_of_measure_tbl PO_TBL_VARCHAR30;

Line 2252: l_it_unit_price_tbl PO_TBL_NUMBER;

2248:
2249: -- information defaulted from item
2250: l_it_item_desc_tbl PO_TBL_VARCHAR2000;
2251: l_it_unit_of_measure_tbl PO_TBL_VARCHAR30;
2252: l_it_unit_price_tbl PO_TBL_NUMBER;
2253: l_it_category_id_tbl PO_TBL_NUMBER;
2254: l_it_un_number_id_tbl PO_TBL_NUMBER;
2255: l_it_hazard_class_id_tbl PO_TBL_NUMBER;
2256: l_it_market_price_tbl PO_TBL_NUMBER;

Line 2253: l_it_category_id_tbl PO_TBL_NUMBER;

2249: -- information defaulted from item
2250: l_it_item_desc_tbl PO_TBL_VARCHAR2000;
2251: l_it_unit_of_measure_tbl PO_TBL_VARCHAR30;
2252: l_it_unit_price_tbl PO_TBL_NUMBER;
2253: l_it_category_id_tbl PO_TBL_NUMBER;
2254: l_it_un_number_id_tbl PO_TBL_NUMBER;
2255: l_it_hazard_class_id_tbl PO_TBL_NUMBER;
2256: l_it_market_price_tbl PO_TBL_NUMBER;
2257: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;

Line 2254: l_it_un_number_id_tbl PO_TBL_NUMBER;

2250: l_it_item_desc_tbl PO_TBL_VARCHAR2000;
2251: l_it_unit_of_measure_tbl PO_TBL_VARCHAR30;
2252: l_it_unit_price_tbl PO_TBL_NUMBER;
2253: l_it_category_id_tbl PO_TBL_NUMBER;
2254: l_it_un_number_id_tbl PO_TBL_NUMBER;
2255: l_it_hazard_class_id_tbl PO_TBL_NUMBER;
2256: l_it_market_price_tbl PO_TBL_NUMBER;
2257: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;
2258:

Line 2255: l_it_hazard_class_id_tbl PO_TBL_NUMBER;

2251: l_it_unit_of_measure_tbl PO_TBL_VARCHAR30;
2252: l_it_unit_price_tbl PO_TBL_NUMBER;
2253: l_it_category_id_tbl PO_TBL_NUMBER;
2254: l_it_un_number_id_tbl PO_TBL_NUMBER;
2255: l_it_hazard_class_id_tbl PO_TBL_NUMBER;
2256: l_it_market_price_tbl PO_TBL_NUMBER;
2257: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;
2258:
2259: -- information defaulted from job

Line 2256: l_it_market_price_tbl PO_TBL_NUMBER;

2252: l_it_unit_price_tbl PO_TBL_NUMBER;
2253: l_it_category_id_tbl PO_TBL_NUMBER;
2254: l_it_un_number_id_tbl PO_TBL_NUMBER;
2255: l_it_hazard_class_id_tbl PO_TBL_NUMBER;
2256: l_it_market_price_tbl PO_TBL_NUMBER;
2257: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;
2258:
2259: -- information defaulted from job
2260: l_job_item_desc_tbl PO_TBL_VARCHAR2000;

Line 2261: l_job_category_id_tbl PO_TBL_NUMBER;

2257: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;
2258:
2259: -- information defaulted from job
2260: l_job_item_desc_tbl PO_TBL_VARCHAR2000;
2261: l_job_category_id_tbl PO_TBL_NUMBER;
2262:
2263: -- information defaulted from ip category
2264: l_ic_category_id_tbl PO_TBL_NUMBER; -- bug5130037
2265:

Line 2264: l_ic_category_id_tbl PO_TBL_NUMBER; -- bug5130037

2260: l_job_item_desc_tbl PO_TBL_VARCHAR2000;
2261: l_job_category_id_tbl PO_TBL_NUMBER;
2262:
2263: -- information defaulted from ip category
2264: l_ic_category_id_tbl PO_TBL_NUMBER; -- bug5130037
2265:
2266:
2267: BEGIN
2268: d_position := 0;

Line 2352: l_ic_category_id_tbl := PO_TBL_NUMBER();

2348: );
2349:
2350: d_position := 40;
2351:
2352: l_ic_category_id_tbl := PO_TBL_NUMBER();
2353: l_ic_category_id_tbl.EXTEND(x_lines.rec_count);
2354:
2355: IF (PO_PDOI_PARAMS.g_request.document_type IN
2356: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

Line 2659: l_index_tbl PO_TBL_NUMBER;

2655: -- table used to save the index of the each row
2656: l_num_list DBMS_SQL.NUMBER_TABLE;
2657:
2658: -- information defaulted from existing po line
2659: l_index_tbl PO_TBL_NUMBER;
2660: l_order_type_tbl PO_TBL_VARCHAR30;
2661: l_item_id_tbl PO_TBL_NUMBER;
2662: l_job_id_tbl PO_TBL_NUMBER;
2663:

Line 2661: l_item_id_tbl PO_TBL_NUMBER;

2657:
2658: -- information defaulted from existing po line
2659: l_index_tbl PO_TBL_NUMBER;
2660: l_order_type_tbl PO_TBL_VARCHAR30;
2661: l_item_id_tbl PO_TBL_NUMBER;
2662: l_job_id_tbl PO_TBL_NUMBER;
2663:
2664: l_index NUMBER;
2665: BEGIN

Line 2662: l_job_id_tbl PO_TBL_NUMBER;

2658: -- information defaulted from existing po line
2659: l_index_tbl PO_TBL_NUMBER;
2660: l_order_type_tbl PO_TBL_VARCHAR30;
2661: l_item_id_tbl PO_TBL_NUMBER;
2662: l_job_id_tbl PO_TBL_NUMBER;
2663:
2664: l_index NUMBER;
2665: BEGIN
2666: d_position := 0;

Line 2786: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

2782:
2783: l_create_lines PO_PDOI_TYPES.lines_rec_type;
2784: l_update_lines PO_PDOI_TYPES.lines_rec_type;
2785:
2786: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2787: BEGIN
2788: d_position := 0;
2789:
2790: IF (PO_LOG.d_proc) THEN

Line 2982: l_obsoleted_loc_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

2978: d_position NUMBER;
2979:
2980: -- table to mark which line location needs to rejected in
2981: -- line location interface table
2982: l_obsoleted_loc_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2983: l_obsolete_rec_count NUMBER := 0;
2984:
2985: BEGIN
2986: d_position := 0;

Line 3219: l_expire_line_index_tbl PO_TBL_NUMBER;

3215: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3216: l_index NUMBER;
3217:
3218: -- store the index of lines that need to be expired
3219: l_expire_line_index_tbl PO_TBL_NUMBER;
3220:
3221: -- counter
3222: l_count NUMBER := 0;
3223: BEGIN

Line 3570: l_inventory_org_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3566: l_result_type VARCHAR2(30);
3567: l_results po_validation_results_type;
3568: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
3569: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
3570: l_inventory_org_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3571:
3572: BEGIN
3573: d_position := 0;
3574:

Line 3787: p_vendor_id_tbl IN PO_TBL_NUMBER,

3783: PROCEDURE derive_item_id
3784: (
3785: p_key IN po_session_gt.key%TYPE,
3786: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3787: p_vendor_id_tbl IN PO_TBL_NUMBER,
3788: p_intf_header_id_tbl IN PO_TBL_NUMBER,
3789: p_intf_line_id_tbl IN PO_TBL_NUMBER,
3790: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
3791: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337

Line 3788: p_intf_header_id_tbl IN PO_TBL_NUMBER,

3784: (
3785: p_key IN po_session_gt.key%TYPE,
3786: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3787: p_vendor_id_tbl IN PO_TBL_NUMBER,
3788: p_intf_header_id_tbl IN PO_TBL_NUMBER,
3789: p_intf_line_id_tbl IN PO_TBL_NUMBER,
3790: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
3791: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
3792: p_item_tbl IN PO_TBL_VARCHAR2000,

Line 3789: p_intf_line_id_tbl IN PO_TBL_NUMBER,

3785: p_key IN po_session_gt.key%TYPE,
3786: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3787: p_vendor_id_tbl IN PO_TBL_NUMBER,
3788: p_intf_header_id_tbl IN PO_TBL_NUMBER,
3789: p_intf_line_id_tbl IN PO_TBL_NUMBER,
3790: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
3791: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
3792: p_item_tbl IN PO_TBL_VARCHAR2000,
3793: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

Line 3791: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337

3787: p_vendor_id_tbl IN PO_TBL_NUMBER,
3788: p_intf_header_id_tbl IN PO_TBL_NUMBER,
3789: p_intf_line_id_tbl IN PO_TBL_NUMBER,
3790: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
3791: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
3792: p_item_tbl IN PO_TBL_VARCHAR2000,
3793: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
3794: x_error_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
3795: ) IS

Line 3793: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

3789: p_intf_line_id_tbl IN PO_TBL_NUMBER,
3790: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
3791: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
3792: p_item_tbl IN PO_TBL_VARCHAR2000,
3793: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
3794: x_error_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
3795: ) IS
3796:
3797: d_api_name CONSTANT VARCHAR2(30) := 'derive_item_id';

Line 3802: l_index_tbl PO_TBL_NUMBER;

3798: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3799: d_position NUMBER;
3800:
3801: -- tables to store the derived result
3802: l_index_tbl PO_TBL_NUMBER;
3803: l_result_tbl PO_TBL_NUMBER;
3804:
3805: -- variable to hold index of the current processing row
3806: l_index NUMBER;

Line 3803: l_result_tbl PO_TBL_NUMBER;

3799: d_position NUMBER;
3800:
3801: -- tables to store the derived result
3802: l_index_tbl PO_TBL_NUMBER;
3803: l_result_tbl PO_TBL_NUMBER;
3804:
3805: -- variable to hold index of the current processing row
3806: l_index NUMBER;
3807:

Line 3940: p_item_id_tbl IN PO_TBL_NUMBER,

3936: ------------------------------------------------------------------------
3937: PROCEDURE derive_item_revision
3938: (
3939: p_key IN po_session_gt.key%TYPE,
3940: p_item_id_tbl IN PO_TBL_NUMBER,
3941: x_item_revision_tbl IN OUT NOCOPY PO_TBL_VARCHAR5
3942: ) IS
3943:
3944: d_api_name CONSTANT VARCHAR2(30) := 'derive_item_revision';

Line 4011: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4007: (
4008: p_key IN po_session_gt.key%TYPE,
4009: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4010: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
4011: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4012: ) IS
4013:
4014: d_api_name CONSTANT VARCHAR2(30) := 'derive_job_business_group_id';
4015: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4019: l_index_tbl PO_TBL_NUMBER;

4015: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4016: d_position NUMBER;
4017:
4018: -- tables to store the derived result
4019: l_index_tbl PO_TBL_NUMBER;
4020: l_result_tbl PO_TBL_NUMBER;
4021: BEGIN
4022: d_position := 0;
4023:

Line 4020: l_result_tbl PO_TBL_NUMBER;

4016: d_position NUMBER;
4017:
4018: -- tables to store the derived result
4019: l_index_tbl PO_TBL_NUMBER;
4020: l_result_tbl PO_TBL_NUMBER;
4021: BEGIN
4022: d_position := 0;
4023:
4024: IF (PO_LOG.d_proc) THEN

Line 4113: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

4109: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4110: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
4111: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
4112: p_job_name_tbl IN PO_TBL_VARCHAR2000,
4113: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
4114: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4115: ) IS
4116:
4117: d_api_name CONSTANT VARCHAR2(30) := 'derive_job_id';

Line 4114: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4110: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
4111: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
4112: p_job_name_tbl IN PO_TBL_VARCHAR2000,
4113: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
4114: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4115: ) IS
4116:
4117: d_api_name CONSTANT VARCHAR2(30) := 'derive_job_id';
4118: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4122: l_index_tbl PO_TBL_NUMBER;

4118: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4119: d_position NUMBER;
4120:
4121: -- tables to store the derived result
4122: l_index_tbl PO_TBL_NUMBER;
4123: l_result_tbl PO_TBL_NUMBER;
4124:
4125: -- debug variables
4126: d_group_id NUMBER;

Line 4123: l_result_tbl PO_TBL_NUMBER;

4119: d_position NUMBER;
4120:
4121: -- tables to store the derived result
4122: l_index_tbl PO_TBL_NUMBER;
4123: l_result_tbl PO_TBL_NUMBER;
4124:
4125: -- debug variables
4126: d_group_id NUMBER;
4127: d_job_id_tbl PO_TBL_NUMBER;

Line 4127: d_job_id_tbl PO_TBL_NUMBER;

4123: l_result_tbl PO_TBL_NUMBER;
4124:
4125: -- debug variables
4126: d_group_id NUMBER;
4127: d_job_id_tbl PO_TBL_NUMBER;
4128: d_job_name_tbl PO_TBL_VARCHAR2000;
4129: d_bg_id_tbl PO_TBL_NUMBER;
4130:
4131: BEGIN

Line 4129: d_bg_id_tbl PO_TBL_NUMBER;

4125: -- debug variables
4126: d_group_id NUMBER;
4127: d_job_id_tbl PO_TBL_NUMBER;
4128: d_job_name_tbl PO_TBL_VARCHAR2000;
4129: d_bg_id_tbl PO_TBL_NUMBER;
4130:
4131: BEGIN
4132: d_position := 0;
4133:

Line 4330: x_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4326: PROCEDURE derive_category_id
4327: (
4328: p_key IN po_session_gt.key%TYPE,
4329: p_category_tbl IN PO_TBL_VARCHAR2000,
4330: x_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4331: ) IS
4332:
4333: d_api_name CONSTANT VARCHAR2(30) := 'derive_category_id';
4334: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4414: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4410: p_key IN po_session_gt.key%TYPE,
4411: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4412: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
4413: p_ip_category_tbl IN PO_TBL_VARCHAR2000,
4414: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4415: ) IS
4416:
4417: d_api_name CONSTANT VARCHAR2(30) := 'derive_ip_category_id';
4418: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4422: l_index_tbl PO_TBL_NUMBER;

4418: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4419: d_position NUMBER;
4420:
4421: -- tables to store the derived result
4422: l_index_tbl PO_TBL_NUMBER;
4423: l_result_tbl PO_TBL_NUMBER;
4424: BEGIN
4425: d_position := 0;
4426:

Line 4423: l_result_tbl PO_TBL_NUMBER;

4419: d_position NUMBER;
4420:
4421: -- tables to store the derived result
4422: l_index_tbl PO_TBL_NUMBER;
4423: l_result_tbl PO_TBL_NUMBER;
4424: BEGIN
4425: d_position := 0;
4426:
4427: IF (PO_LOG.d_proc) THEN

Line 4551: l_index_tbl PO_TBL_NUMBER;

4547: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4548: d_position NUMBER;
4549:
4550: -- tables to store the derived result
4551: l_index_tbl PO_TBL_NUMBER;
4552: l_result_tbl PO_TBL_VARCHAR30;
4553: BEGIN
4554: d_position := 0;
4555:

Line 4636: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4632: p_key IN po_session_gt.key%TYPE,
4633: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4634: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
4635: p_line_type_tbl IN PO_TBL_VARCHAR30,
4636: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4637: ) IS
4638:
4639: d_api_name CONSTANT VARCHAR2(30) := 'derive_line_type_id';
4640: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4644: l_index_tbl PO_TBL_NUMBER;

4640: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4641: d_position NUMBER;
4642:
4643: -- tables to store the derived result
4644: l_index_tbl PO_TBL_NUMBER;
4645: l_result_tbl PO_TBL_NUMBER;
4646: BEGIN
4647: d_position := 0;
4648:

Line 4645: l_result_tbl PO_TBL_NUMBER;

4641: d_position NUMBER;
4642:
4643: -- tables to store the derived result
4644: l_index_tbl PO_TBL_NUMBER;
4645: l_result_tbl PO_TBL_NUMBER;
4646: BEGIN
4647: d_position := 0;
4648:
4649: IF (PO_LOG.d_proc) THEN

Line 4732: x_un_number_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4728: (
4729: p_key IN po_session_gt.key%TYPE,
4730: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4731: p_un_number_tbl IN PO_TBL_VARCHAR30,
4732: x_un_number_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4733: ) IS
4734:
4735: d_api_name CONSTANT VARCHAR2(30) := 'derive_un_number_id';
4736: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4740: l_index_tbl PO_TBL_NUMBER;

4736: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4737: d_position NUMBER;
4738:
4739: -- tables to store the derived result
4740: l_index_tbl PO_TBL_NUMBER;
4741: l_result_tbl PO_TBL_NUMBER;
4742: BEGIN
4743: d_position := 0;
4744:

Line 4741: l_result_tbl PO_TBL_NUMBER;

4737: d_position NUMBER;
4738:
4739: -- tables to store the derived result
4740: l_index_tbl PO_TBL_NUMBER;
4741: l_result_tbl PO_TBL_NUMBER;
4742: BEGIN
4743: d_position := 0;
4744:
4745: IF (PO_LOG.d_proc) THEN

Line 4822: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4818: (
4819: p_key IN po_session_gt.key%TYPE,
4820: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4821: p_hazard_class_tbl IN PO_TBL_VARCHAR100,
4822: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4823: ) IS
4824:
4825: d_api_name CONSTANT VARCHAR2(30) := 'derive_hazard_class_id';
4826: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4830: l_index_tbl PO_TBL_NUMBER;

4826: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4827: d_position NUMBER;
4828:
4829: -- tables to store the derived result
4830: l_index_tbl PO_TBL_NUMBER;
4831: l_result_tbl PO_TBL_NUMBER;
4832: BEGIN
4833: d_position := 0;
4834:

Line 4831: l_result_tbl PO_TBL_NUMBER;

4827: d_position NUMBER;
4828:
4829: -- tables to store the derived result
4830: l_index_tbl PO_TBL_NUMBER;
4831: l_result_tbl PO_TBL_NUMBER;
4832: BEGIN
4833: d_position := 0;
4834:
4835: IF (PO_LOG.d_proc) THEN

Line 4911: x_template_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4907: (
4908: p_key IN po_session_gt.key%TYPE,
4909: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4910: p_template_name_tbl IN PO_TBL_VARCHAR30,
4911: x_template_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4912: ) IS
4913:
4914: d_api_name CONSTANT VARCHAR2(30) := 'derive_template_id';
4915: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4919: l_index_tbl PO_TBL_NUMBER;

4915: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4916: d_position NUMBER;
4917:
4918: -- tables to store the derived result
4919: l_index_tbl PO_TBL_NUMBER;
4920: l_result_tbl PO_TBL_NUMBER;
4921: BEGIN
4922: d_position := 0;
4923:

Line 4920: l_result_tbl PO_TBL_NUMBER;

4916: d_position NUMBER;
4917:
4918: -- tables to store the derived result
4919: l_index_tbl PO_TBL_NUMBER;
4920: l_result_tbl PO_TBL_NUMBER;
4921: BEGIN
4922: d_position := 0;
4923:
4924: IF (PO_LOG.d_proc) THEN

Line 5016: p_line_type_id_tbl IN PO_TBL_NUMBER,

5012: PROCEDURE default_info_from_line_type
5013: (
5014: p_key IN po_session_gt.key%TYPE,
5015: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5016: p_line_type_id_tbl IN PO_TBL_NUMBER,
5017: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5018: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5019: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5020: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 5020: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

5016: p_line_type_id_tbl IN PO_TBL_NUMBER,
5017: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5018: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5019: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5020: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5021: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5022: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER
5023: ) IS
5024:

Line 5022: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER

5018: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5019: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5020: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5021: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5022: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER
5023: ) IS
5024:
5025: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_line_type';
5026: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5030: l_index_tbl PO_TBL_NUMBER;

5026: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5027: d_position NUMBER;
5028:
5029: -- variables to hold result read from temp table
5030: l_index_tbl PO_TBL_NUMBER;
5031: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;
5032: l_purchase_basis_tbl PO_TBL_VARCHAR30;
5033: l_matching_basis_tbl PO_TBL_VARCHAR30;
5034: l_category_id_tbl PO_TBL_NUMBER;

Line 5034: l_category_id_tbl PO_TBL_NUMBER;

5030: l_index_tbl PO_TBL_NUMBER;
5031: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;
5032: l_purchase_basis_tbl PO_TBL_VARCHAR30;
5033: l_matching_basis_tbl PO_TBL_VARCHAR30;
5034: l_category_id_tbl PO_TBL_NUMBER;
5035: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5036: l_unit_price_tbl PO_TBL_NUMBER;
5037:
5038: -- current accessing index in the loop

Line 5036: l_unit_price_tbl PO_TBL_NUMBER;

5032: l_purchase_basis_tbl PO_TBL_VARCHAR30;
5033: l_matching_basis_tbl PO_TBL_VARCHAR30;
5034: l_category_id_tbl PO_TBL_NUMBER;
5035: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5036: l_unit_price_tbl PO_TBL_NUMBER;
5037:
5038: -- current accessing index in the loop
5039: l_index NUMBER;
5040: BEGIN

Line 5047: x_category_id_tbl := PO_TBL_NUMBER();

5043: IF (PO_LOG.d_proc) THEN
5044: PO_LOG.proc_begin(d_module);
5045: END IF;
5046:
5047: x_category_id_tbl := PO_TBL_NUMBER();
5048: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();
5049: x_unit_price_tbl := PO_TBL_NUMBER();
5050:
5051: x_category_id_tbl.EXTEND(p_index_tbl.COUNT);

Line 5049: x_unit_price_tbl := PO_TBL_NUMBER();

5045: END IF;
5046:
5047: x_category_id_tbl := PO_TBL_NUMBER();
5048: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();
5049: x_unit_price_tbl := PO_TBL_NUMBER();
5050:
5051: x_category_id_tbl.EXTEND(p_index_tbl.COUNT);
5052: x_unit_of_measure_tbl.EXTEND(p_index_tbl.COUNT);
5053: x_unit_price_tbl.EXTEND(p_index_tbl.COUNT);

Line 5175: p_item_id_tbl IN PO_TBL_NUMBER,

5171: PROCEDURE default_info_from_item
5172: (
5173: p_key IN po_session_gt.key%TYPE,
5174: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5175: p_item_id_tbl IN PO_TBL_NUMBER,
5176: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
5177: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5178: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5179: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 5178: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,

5174: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5175: p_item_id_tbl IN PO_TBL_NUMBER,
5176: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
5177: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5178: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5179: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5180: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5181: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5182: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 5179: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

5175: p_item_id_tbl IN PO_TBL_NUMBER,
5176: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
5177: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5178: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5179: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5180: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5181: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5182: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5183: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30

Line 5180: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,

5176: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
5177: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5178: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5179: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5180: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5181: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5182: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5183: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
5184: ) IS

Line 5181: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,

5177: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5178: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5179: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5180: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5181: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5182: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5183: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
5184: ) IS
5185:

Line 5182: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,

5178: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5179: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5180: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5181: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5182: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5183: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
5184: ) IS
5185:
5186: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_item';

Line 5191: l_index_tbl PO_TBL_NUMBER;

5187: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5188: d_position NUMBER;
5189:
5190: -- variables to hold result read from temp table
5191: l_index_tbl PO_TBL_NUMBER;
5192: l_item_desc_tbl PO_TBL_VARCHAR2000;
5193: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5194: l_unit_price_tbl PO_TBL_NUMBER;
5195: l_category_id_tbl PO_TBL_NUMBER;

Line 5194: l_unit_price_tbl PO_TBL_NUMBER;

5190: -- variables to hold result read from temp table
5191: l_index_tbl PO_TBL_NUMBER;
5192: l_item_desc_tbl PO_TBL_VARCHAR2000;
5193: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5194: l_unit_price_tbl PO_TBL_NUMBER;
5195: l_category_id_tbl PO_TBL_NUMBER;
5196: l_un_number_id_tbl PO_TBL_NUMBER;
5197: l_hazard_class_id_tbl PO_TBL_NUMBER;
5198: l_market_price_tbl PO_TBL_NUMBER;

Line 5195: l_category_id_tbl PO_TBL_NUMBER;

5191: l_index_tbl PO_TBL_NUMBER;
5192: l_item_desc_tbl PO_TBL_VARCHAR2000;
5193: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5194: l_unit_price_tbl PO_TBL_NUMBER;
5195: l_category_id_tbl PO_TBL_NUMBER;
5196: l_un_number_id_tbl PO_TBL_NUMBER;
5197: l_hazard_class_id_tbl PO_TBL_NUMBER;
5198: l_market_price_tbl PO_TBL_NUMBER;
5199: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30;

Line 5196: l_un_number_id_tbl PO_TBL_NUMBER;

5192: l_item_desc_tbl PO_TBL_VARCHAR2000;
5193: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5194: l_unit_price_tbl PO_TBL_NUMBER;
5195: l_category_id_tbl PO_TBL_NUMBER;
5196: l_un_number_id_tbl PO_TBL_NUMBER;
5197: l_hazard_class_id_tbl PO_TBL_NUMBER;
5198: l_market_price_tbl PO_TBL_NUMBER;
5199: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30;
5200:

Line 5197: l_hazard_class_id_tbl PO_TBL_NUMBER;

5193: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5194: l_unit_price_tbl PO_TBL_NUMBER;
5195: l_category_id_tbl PO_TBL_NUMBER;
5196: l_un_number_id_tbl PO_TBL_NUMBER;
5197: l_hazard_class_id_tbl PO_TBL_NUMBER;
5198: l_market_price_tbl PO_TBL_NUMBER;
5199: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30;
5200:
5201: -- current accessing index in the loop

Line 5198: l_market_price_tbl PO_TBL_NUMBER;

5194: l_unit_price_tbl PO_TBL_NUMBER;
5195: l_category_id_tbl PO_TBL_NUMBER;
5196: l_un_number_id_tbl PO_TBL_NUMBER;
5197: l_hazard_class_id_tbl PO_TBL_NUMBER;
5198: l_market_price_tbl PO_TBL_NUMBER;
5199: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30;
5200:
5201: -- current accessing index in the loop
5202: l_index NUMBER;

Line 5212: x_unit_price_tbl := PO_TBL_NUMBER();

5208: END IF;
5209:
5210: x_item_desc_tbl := PO_TBL_VARCHAR2000();
5211: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();
5212: x_unit_price_tbl := PO_TBL_NUMBER();
5213: x_category_id_tbl := PO_TBL_NUMBER();
5214: x_un_number_id_tbl := PO_TBL_NUMBER();
5215: x_hazard_class_id_tbl := PO_TBL_NUMBER();
5216: x_market_price_tbl := PO_TBL_NUMBER();

Line 5213: x_category_id_tbl := PO_TBL_NUMBER();

5209:
5210: x_item_desc_tbl := PO_TBL_VARCHAR2000();
5211: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();
5212: x_unit_price_tbl := PO_TBL_NUMBER();
5213: x_category_id_tbl := PO_TBL_NUMBER();
5214: x_un_number_id_tbl := PO_TBL_NUMBER();
5215: x_hazard_class_id_tbl := PO_TBL_NUMBER();
5216: x_market_price_tbl := PO_TBL_NUMBER();
5217: x_secondary_unit_of_meas_tbl := PO_TBL_VARCHAR30();

Line 5214: x_un_number_id_tbl := PO_TBL_NUMBER();

5210: x_item_desc_tbl := PO_TBL_VARCHAR2000();
5211: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();
5212: x_unit_price_tbl := PO_TBL_NUMBER();
5213: x_category_id_tbl := PO_TBL_NUMBER();
5214: x_un_number_id_tbl := PO_TBL_NUMBER();
5215: x_hazard_class_id_tbl := PO_TBL_NUMBER();
5216: x_market_price_tbl := PO_TBL_NUMBER();
5217: x_secondary_unit_of_meas_tbl := PO_TBL_VARCHAR30();
5218:

Line 5215: x_hazard_class_id_tbl := PO_TBL_NUMBER();

5211: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();
5212: x_unit_price_tbl := PO_TBL_NUMBER();
5213: x_category_id_tbl := PO_TBL_NUMBER();
5214: x_un_number_id_tbl := PO_TBL_NUMBER();
5215: x_hazard_class_id_tbl := PO_TBL_NUMBER();
5216: x_market_price_tbl := PO_TBL_NUMBER();
5217: x_secondary_unit_of_meas_tbl := PO_TBL_VARCHAR30();
5218:
5219: x_item_desc_tbl.EXTEND(p_index_tbl.COUNT);

Line 5216: x_market_price_tbl := PO_TBL_NUMBER();

5212: x_unit_price_tbl := PO_TBL_NUMBER();
5213: x_category_id_tbl := PO_TBL_NUMBER();
5214: x_un_number_id_tbl := PO_TBL_NUMBER();
5215: x_hazard_class_id_tbl := PO_TBL_NUMBER();
5216: x_market_price_tbl := PO_TBL_NUMBER();
5217: x_secondary_unit_of_meas_tbl := PO_TBL_VARCHAR30();
5218:
5219: x_item_desc_tbl.EXTEND(p_index_tbl.COUNT);
5220: x_unit_of_measure_tbl.EXTEND(p_index_tbl.COUNT);

Line 5354: p_job_id_tbl IN PO_TBL_NUMBER,

5350: PROCEDURE default_info_from_job
5351: (
5352: p_key IN po_session_gt.key%TYPE,
5353: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5354: p_job_id_tbl IN PO_TBL_NUMBER,
5355: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
5356: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER
5357: ) IS
5358:

Line 5356: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER

5352: p_key IN po_session_gt.key%TYPE,
5353: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5354: p_job_id_tbl IN PO_TBL_NUMBER,
5355: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
5356: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER
5357: ) IS
5358:
5359: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_job';
5360: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5366: l_index_tbl PO_TBL_NUMBER;

5362:
5363: l_index NUMBER;
5364:
5365: -- variables to hold result read from temp table
5366: l_index_tbl PO_TBL_NUMBER;
5367: l_item_desc_tbl PO_TBL_VARCHAR2000;
5368: l_category_id_tbl PO_TBL_NUMBER;
5369: BEGIN
5370: d_position := 0;

Line 5368: l_category_id_tbl PO_TBL_NUMBER;

5364:
5365: -- variables to hold result read from temp table
5366: l_index_tbl PO_TBL_NUMBER;
5367: l_item_desc_tbl PO_TBL_VARCHAR2000;
5368: l_category_id_tbl PO_TBL_NUMBER;
5369: BEGIN
5370: d_position := 0;
5371:
5372: IF (PO_LOG.d_proc) THEN

Line 5377: x_category_id_tbl := PO_TBL_NUMBER();

5373: PO_LOG.proc_begin(d_module);
5374: END IF;
5375:
5376: x_item_desc_tbl := PO_TBL_VARCHAR2000();
5377: x_category_id_tbl := PO_TBL_NUMBER();
5378:
5379: x_item_desc_tbl.EXTEND(p_index_tbl.COUNT);
5380: x_category_id_tbl.EXTEND(p_index_tbl.COUNT);
5381:

Line 5461: p_ip_category_id_tbl IN PO_TBL_NUMBER,

5457: PROCEDURE default_po_cat_id_from_ip
5458: (
5459: p_key IN po_session_gt.key%TYPE,
5460: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5461: p_ip_category_id_tbl IN PO_TBL_NUMBER,
5462: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5463: ) IS
5464:
5465: d_api_name CONSTANT VARCHAR2(30) := 'default_po_cat_id_from_ip';

Line 5462: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

5458: (
5459: p_key IN po_session_gt.key%TYPE,
5460: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5461: p_ip_category_id_tbl IN PO_TBL_NUMBER,
5462: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5463: ) IS
5464:
5465: d_api_name CONSTANT VARCHAR2(30) := 'default_po_cat_id_from_ip';
5466: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5470: l_index_tbl PO_TBL_NUMBER;

5466: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5467: d_position NUMBER;
5468:
5469: -- variables to hold result read from temp table
5470: l_index_tbl PO_TBL_NUMBER;
5471: l_result_tbl PO_TBL_NUMBER;
5472: BEGIN
5473: d_position := 0;
5474:

Line 5471: l_result_tbl PO_TBL_NUMBER;

5467: d_position NUMBER;
5468:
5469: -- variables to hold result read from temp table
5470: l_index_tbl PO_TBL_NUMBER;
5471: l_result_tbl PO_TBL_NUMBER;
5472: BEGIN
5473: d_position := 0;
5474:
5475: IF (PO_LOG.d_proc) THEN

Line 5549: p_po_category_id_tbl IN PO_TBL_NUMBER,

5545: PROCEDURE default_ip_cat_id_from_po
5546: (
5547: p_key IN po_session_gt.key%TYPE,
5548: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5549: p_po_category_id_tbl IN PO_TBL_NUMBER,
5550: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5551: ) IS
5552:
5553: d_api_name CONSTANT VARCHAR2(30) := 'default_ip_cat_id_from_po';

Line 5550: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

5546: (
5547: p_key IN po_session_gt.key%TYPE,
5548: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5549: p_po_category_id_tbl IN PO_TBL_NUMBER,
5550: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5551: ) IS
5552:
5553: d_api_name CONSTANT VARCHAR2(30) := 'default_ip_cat_id_from_po';
5554: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5558: l_index_tbl PO_TBL_NUMBER;

5554: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5555: d_position NUMBER;
5556:
5557: -- variables to hold result read from temp table
5558: l_index_tbl PO_TBL_NUMBER;
5559: l_result_tbl PO_TBL_NUMBER;
5560: BEGIN
5561: d_position := 0;
5562:

Line 5559: l_result_tbl PO_TBL_NUMBER;

5555: d_position NUMBER;
5556:
5557: -- variables to hold result read from temp table
5558: l_index_tbl PO_TBL_NUMBER;
5559: l_result_tbl PO_TBL_NUMBER;
5560: BEGIN
5561: d_position := 0;
5562:
5563: IF (PO_LOG.d_proc) THEN

Line 5638: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

5634: (
5635: p_key IN po_session_gt.key%TYPE,
5636: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5637: p_un_number_tbl IN PO_TBL_VARCHAR30,
5638: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5639: ) IS
5640:
5641: d_api_name CONSTANT VARCHAR2(30) := 'default_hc_id_from_un_number';
5642: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5646: l_index_tbl PO_TBL_NUMBER;

5642: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5643: d_position NUMBER;
5644:
5645: -- variables to hold result read from temp table
5646: l_index_tbl PO_TBL_NUMBER;
5647: l_result_tbl PO_TBL_NUMBER;
5648: BEGIN
5649: d_position := 0;
5650:

Line 5647: l_result_tbl PO_TBL_NUMBER;

5643: d_position NUMBER;
5644:
5645: -- variables to hold result read from temp table
5646: l_index_tbl PO_TBL_NUMBER;
5647: l_result_tbl PO_TBL_NUMBER;
5648: BEGIN
5649: d_position := 0;
5650:
5651: IF (PO_LOG.d_proc) THEN

Line 5736: l_index_tbl PO_TBL_NUMBER;

5732: -- hold the key value which is used to identify rows in temp table
5733: l_key po_session_gt.key%TYPE;
5734:
5735: -- po line that has been found as a match for current line
5736: l_index_tbl PO_TBL_NUMBER;
5737: l_result_tbl PO_TBL_NUMBER;
5738:
5739: -- hash table of po_line_id based on po_header_id and line num
5740: TYPE line_ref_type IS TABLE OF DBMS_SQL.NUMBER_TABLE INDEX BY PLS_INTEGER;

Line 5737: l_result_tbl PO_TBL_NUMBER;

5733: l_key po_session_gt.key%TYPE;
5734:
5735: -- po line that has been found as a match for current line
5736: l_index_tbl PO_TBL_NUMBER;
5737: l_result_tbl PO_TBL_NUMBER;
5738:
5739: -- hash table of po_line_id based on po_header_id and line num
5740: TYPE line_ref_type IS TABLE OF DBMS_SQL.NUMBER_TABLE INDEX BY PLS_INTEGER;
5741: l_line_reference_tbl line_ref_type;

Line 5888: l_index_tbl PO_TBL_NUMBER;

5884: l_processing_line_tbl DBMS_SQL.NUMBER_TABLE;
5885: l_num_list DBMS_SQL.NUMBER_TABLE;
5886:
5887: -- po line that has been found as a match for current line
5888: l_index_tbl PO_TBL_NUMBER;
5889: l_po_line_id_tbl PO_TBL_NUMBER;
5890: l_line_num_tbl PO_TBL_NUMBER;
5891: l_match_index_tbl PO_TBL_NUMBER;
5892:

Line 5889: l_po_line_id_tbl PO_TBL_NUMBER;

5885: l_num_list DBMS_SQL.NUMBER_TABLE;
5886:
5887: -- po line that has been found as a match for current line
5888: l_index_tbl PO_TBL_NUMBER;
5889: l_po_line_id_tbl PO_TBL_NUMBER;
5890: l_line_num_tbl PO_TBL_NUMBER;
5891: l_match_index_tbl PO_TBL_NUMBER;
5892:
5893: -- temp variable used in processing

Line 5890: l_line_num_tbl PO_TBL_NUMBER;

5886:
5887: -- po line that has been found as a match for current line
5888: l_index_tbl PO_TBL_NUMBER;
5889: l_po_line_id_tbl PO_TBL_NUMBER;
5890: l_line_num_tbl PO_TBL_NUMBER;
5891: l_match_index_tbl PO_TBL_NUMBER;
5892:
5893: -- temp variable used in processing
5894: l_index NUMBER;

Line 5891: l_match_index_tbl PO_TBL_NUMBER;

5887: -- po line that has been found as a match for current line
5888: l_index_tbl PO_TBL_NUMBER;
5889: l_po_line_id_tbl PO_TBL_NUMBER;
5890: l_line_num_tbl PO_TBL_NUMBER;
5891: l_match_index_tbl PO_TBL_NUMBER;
5892:
5893: -- temp variable used in processing
5894: l_index NUMBER;
5895: l_match_index NUMBER;

Line 6441: l_index_tbl PO_TBL_NUMBER;

6437: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
6438: d_position NUMBER;
6439:
6440: -- variables to hold matching result read from po_session_gt table
6441: l_index_tbl PO_TBL_NUMBER;
6442: l_po_line_id_tbl PO_TBL_NUMBER;
6443: l_line_num_tbl PO_TBL_NUMBER;
6444:
6445: l_index NUMBER;

Line 6442: l_po_line_id_tbl PO_TBL_NUMBER;

6438: d_position NUMBER;
6439:
6440: -- variables to hold matching result read from po_session_gt table
6441: l_index_tbl PO_TBL_NUMBER;
6442: l_po_line_id_tbl PO_TBL_NUMBER;
6443: l_line_num_tbl PO_TBL_NUMBER;
6444:
6445: l_index NUMBER;
6446: l_data_key po_session_gt.key%TYPE;

Line 6443: l_line_num_tbl PO_TBL_NUMBER;

6439:
6440: -- variables to hold matching result read from po_session_gt table
6441: l_index_tbl PO_TBL_NUMBER;
6442: l_po_line_id_tbl PO_TBL_NUMBER;
6443: l_line_num_tbl PO_TBL_NUMBER;
6444:
6445: l_index NUMBER;
6446: l_data_key po_session_gt.key%TYPE;
6447:

Line 6697: l_index_tbl PO_TBL_NUMBER;

6693:
6694: l_def_master_org_id NUMBER;
6695:
6696: -- variables to hold matching result read from po_session_gt table
6697: l_index_tbl PO_TBL_NUMBER;
6698: l_po_line_id_tbl PO_TBL_NUMBER;
6699: l_line_num_tbl PO_TBL_NUMBER;
6700:
6701: l_index NUMBER;

Line 6698: l_po_line_id_tbl PO_TBL_NUMBER;

6694: l_def_master_org_id NUMBER;
6695:
6696: -- variables to hold matching result read from po_session_gt table
6697: l_index_tbl PO_TBL_NUMBER;
6698: l_po_line_id_tbl PO_TBL_NUMBER;
6699: l_line_num_tbl PO_TBL_NUMBER;
6700:
6701: l_index NUMBER;
6702: l_data_key po_session_gt.key%TYPE;

Line 6699: l_line_num_tbl PO_TBL_NUMBER;

6695:
6696: -- variables to hold matching result read from po_session_gt table
6697: l_index_tbl PO_TBL_NUMBER;
6698: l_po_line_id_tbl PO_TBL_NUMBER;
6699: l_line_num_tbl PO_TBL_NUMBER;
6700:
6701: l_index NUMBER;
6702: l_data_key po_session_gt.key%TYPE;
6703:

Line 6997: l_index_tbl PO_TBL_NUMBER;

6993: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
6994: d_position NUMBER;
6995:
6996: -- variables to hold matching result read from po_session_gt table
6997: l_index_tbl PO_TBL_NUMBER;
6998: l_po_line_id_tbl PO_TBL_NUMBER;
6999: l_line_num_tbl PO_TBL_NUMBER;
7000:
7001: l_index NUMBER;

Line 6998: l_po_line_id_tbl PO_TBL_NUMBER;

6994: d_position NUMBER;
6995:
6996: -- variables to hold matching result read from po_session_gt table
6997: l_index_tbl PO_TBL_NUMBER;
6998: l_po_line_id_tbl PO_TBL_NUMBER;
6999: l_line_num_tbl PO_TBL_NUMBER;
7000:
7001: l_index NUMBER;
7002: l_data_key po_session_gt.key%TYPE;

Line 6999: l_line_num_tbl PO_TBL_NUMBER;

6995:
6996: -- variables to hold matching result read from po_session_gt table
6997: l_index_tbl PO_TBL_NUMBER;
6998: l_po_line_id_tbl PO_TBL_NUMBER;
6999: l_line_num_tbl PO_TBL_NUMBER;
7000:
7001: l_index NUMBER;
7002: l_data_key po_session_gt.key%TYPE;
7003:

Line 7255: l_index_tbl PO_TBL_NUMBER;

7251: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
7252: d_position NUMBER;
7253:
7254: -- variables to hold matching result read from po_session_gt table
7255: l_index_tbl PO_TBL_NUMBER;
7256: l_po_line_id_tbl PO_TBL_NUMBER;
7257: l_line_num_tbl PO_TBL_NUMBER;
7258:
7259: l_index NUMBER;

Line 7256: l_po_line_id_tbl PO_TBL_NUMBER;

7252: d_position NUMBER;
7253:
7254: -- variables to hold matching result read from po_session_gt table
7255: l_index_tbl PO_TBL_NUMBER;
7256: l_po_line_id_tbl PO_TBL_NUMBER;
7257: l_line_num_tbl PO_TBL_NUMBER;
7258:
7259: l_index NUMBER;
7260: l_data_key po_session_gt.key%TYPE;

Line 7257: l_line_num_tbl PO_TBL_NUMBER;

7253:
7254: -- variables to hold matching result read from po_session_gt table
7255: l_index_tbl PO_TBL_NUMBER;
7256: l_po_line_id_tbl PO_TBL_NUMBER;
7257: l_line_num_tbl PO_TBL_NUMBER;
7258:
7259: l_index NUMBER;
7260: l_data_key po_session_gt.key%TYPE;
7261:

Line 7510: l_index_tbl PO_TBL_NUMBER;

7506: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
7507: d_position NUMBER;
7508:
7509: -- variables to hold matching result read from po_session_gt table
7510: l_index_tbl PO_TBL_NUMBER;
7511: l_po_line_id_tbl PO_TBL_NUMBER;
7512: l_line_num_tbl PO_TBL_NUMBER;
7513:
7514: l_index NUMBER;

Line 7511: l_po_line_id_tbl PO_TBL_NUMBER;

7507: d_position NUMBER;
7508:
7509: -- variables to hold matching result read from po_session_gt table
7510: l_index_tbl PO_TBL_NUMBER;
7511: l_po_line_id_tbl PO_TBL_NUMBER;
7512: l_line_num_tbl PO_TBL_NUMBER;
7513:
7514: l_index NUMBER;
7515: l_data_key po_session_gt.key%TYPE;

Line 7512: l_line_num_tbl PO_TBL_NUMBER;

7508:
7509: -- variables to hold matching result read from po_session_gt table
7510: l_index_tbl PO_TBL_NUMBER;
7511: l_po_line_id_tbl PO_TBL_NUMBER;
7512: l_line_num_tbl PO_TBL_NUMBER;
7513:
7514: l_index NUMBER;
7515: l_data_key po_session_gt.key%TYPE;
7516:

Line 7721: p_target_lines_index_tbl IN PO_TBL_NUMBER,

7717: PROCEDURE set_action_add
7718: (
7719: p_key IN po_session_gt.key%TYPE,
7720: p_group_num IN NUMBER,
7721: p_target_lines_index_tbl IN PO_TBL_NUMBER,
7722: p_check_line_num_assign IN VARCHAR2,
7723: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7724: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7725: ) IS

Line 8030: l_remove_err_line_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

8026: l_intf_header_id NUMBER;
8027: l_num_errored_lines NUMBER;
8028: l_num_processed_lines NUMBER;
8029: l_num_valid_lines NUMBER;
8030: l_remove_err_line_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
8031:
8032: BEGIN
8033:
8034: d_position := 0;