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 DBMS_SQL

Line 18: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

14:
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,

Line 39: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

35:
36: PROCEDURE derive_job_business_group_id
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:

Line 47: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

43:
44: PROCEDURE derive_job_id
45: (
46: p_key IN po_session_gt.key%TYPE,
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,

Line 65: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

61:
62: PROCEDURE derive_ip_category_id
63: (
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: );

Line 74: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

70:
71: PROCEDURE derive_unit_of_measure
72: (
73: p_key IN po_session_gt.key%TYPE,
74: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
75: p_uom_code_tbl IN PO_TBL_VARCHAR5,
76: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
77: );
78:

Line 82: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

78:
79: PROCEDURE derive_line_type_id
80: (
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: );

Line 91: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

87:
88: PROCEDURE derive_un_number_id
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:

Line 99: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

95:
96: PROCEDURE derive_hazard_class_id
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:

Line 107: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

103:
104: PROCEDURE derive_template_id
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:

Line 115: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

111:
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,

Line 128: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

124:
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,

Line 143: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

139:
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: );

Line 152: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

148:
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:

Line 160: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

156:
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:

Line 168: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

164:
165: PROCEDURE default_hc_id_from_un_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:

Line 175: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

171: );
172:
173: PROCEDURE match_lines_on_line_num
174: (
175: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
176: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
177: );
178:
179: PROCEDURE match_lines_on_item_info

Line 187: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,

183:
184: PROCEDURE copy_lines
185: (
186: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,
187: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,
188: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
189: );
190:
191: PROCEDURE uniqueness_check_on_desc

Line 195: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

191: PROCEDURE uniqueness_check_on_desc
192: (
193: p_key IN po_session_gt.key%TYPE,
194: p_group_num IN NUMBER,
195: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
196: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
197: );
198:
199: PROCEDURE uniqueness_check_on_item

Line 203: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

199: PROCEDURE uniqueness_check_on_item
200: (
201: p_key IN po_session_gt.key%TYPE,
202: p_group_num IN NUMBER,
203: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
204: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
205: );
206:
207: PROCEDURE uniqueness_check_on_vpn

Line 211: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

207: PROCEDURE uniqueness_check_on_vpn
208: (
209: p_key IN po_session_gt.key%TYPE,
210: p_group_num IN NUMBER,
211: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
212: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
213: );
214:
215: PROCEDURE uniqueness_check_on_job

Line 219: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

215: PROCEDURE uniqueness_check_on_job
216: (
217: p_key IN po_session_gt.key%TYPE,
218: p_group_num IN NUMBER,
219: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
220: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
221: );
222:
223: PROCEDURE uniqueness_check_on_line_num

Line 227: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

223: PROCEDURE uniqueness_check_on_line_num
224: (
225: p_key IN po_session_gt.key%TYPE,
226: p_group_num IN NUMBER,
227: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
228: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
229: );
230:
231:

Line 238: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

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: );
241:
242:

Line 1533: l_index_tbl DBMS_SQL.NUMBER_TABLE;

1529: -- key of temp table used to identify the derived result
1530: l_key po_session_gt.key%TYPE;
1531:
1532: -- table used to save the index of the each row
1533: l_index_tbl DBMS_SQL.NUMBER_TABLE;
1534: BEGIN
1535: d_position := 0;
1536:
1537: IF (PO_LOG.d_proc) THEN

Line 2031: l_index_tbl DBMS_SQL.NUMBER_TABLE;

2027: -- key of temp table used to identify the derived result
2028: l_key po_session_gt.key%TYPE;
2029:
2030: -- table used to save the index of the each row
2031: l_index_tbl DBMS_SQL.NUMBER_TABLE;
2032: BEGIN
2033: d_position := 0;
2034:
2035: IF (PO_LOG.d_proc) THEN

Line 2242: l_index_tbl DBMS_SQL.NUMBER_TABLE;

2238: -- key of temp table used to identify the derived result
2239: l_key po_session_gt.key%TYPE;
2240:
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;

Line 2656: l_num_list DBMS_SQL.NUMBER_TABLE;

2652: -- key of temp table used to identify the derived result
2653: l_key po_session_gt.key%TYPE;
2654:
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;

Line 2781: l_index_tbl DBMS_SQL.NUMBER_TABLE;

2777: d_api_name CONSTANT VARCHAR2(30) := 'match_lines';
2778: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2779: d_position NUMBER;
2780:
2781: l_index_tbl DBMS_SQL.NUMBER_TABLE;
2782:
2783: l_create_lines PO_PDOI_TYPES.lines_rec_type;
2784: l_update_lines PO_PDOI_TYPES.lines_rec_type;
2785:

Line 3202: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

3198: PROCEDURE uniqueness_check
3199: (
3200: p_type IN NUMBER,
3201: p_group_num IN NUMBER,
3202: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
3203: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
3204: x_expire_line_id_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
3205: ) IS
3206:

Line 3204: x_expire_line_id_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE

3200: p_type IN NUMBER,
3201: p_group_num IN NUMBER,
3202: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
3203: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
3204: x_expire_line_id_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
3205: ) IS
3206:
3207: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check';
3208: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3215: l_index_tbl DBMS_SQL.NUMBER_TABLE;

3211: -- key of temp table used to identify the records
3212: l_key po_session_gt.key%TYPE;
3213:
3214: -- table storing the index of records within the batch
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;

Line 3469: l_create_index_tbl DBMS_SQL.NUMBER_TABLE;

3465: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3466: d_position NUMBER;
3467:
3468: -- store index of rows to be copied to different records
3469: l_create_index_tbl DBMS_SQL.NUMBER_TABLE;
3470: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
3471: BEGIN
3472: d_position := 0;
3473:

Line 3470: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;

3466: d_position NUMBER;
3467:
3468: -- store index of rows to be copied to different records
3469: l_create_index_tbl DBMS_SQL.NUMBER_TABLE;
3470: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
3471: BEGIN
3472: d_position := 0;
3473:
3474: IF (PO_LOG.d_proc) THEN

Line 3786: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3782: ------------------------------------------------------------------------
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,

Line 3809: l_error_exist_tbl DBMS_SQL.NUMBER_TABLE;

3805: -- variable to hold index of the current processing row
3806: l_index NUMBER;
3807:
3808: -- variables to indicate whether multiple_buyer_part error is already inserted
3809: l_error_exist_tbl DBMS_SQL.NUMBER_TABLE;
3810: BEGIN
3811: d_position := 0;
3812:
3813: IF (PO_LOG.d_proc) THEN

Line 4009: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4005: ------------------------------------------------------------------------
4006: PROCEDURE derive_job_business_group_id
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:

Line 4109: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4105: ------------------------------------------------------------------------
4106: PROCEDURE derive_job_id
4107: (
4108: p_key IN po_session_gt.key%TYPE,
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,

Line 4411: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4407: ------------------------------------------------------------------------
4408: PROCEDURE derive_ip_category_id
4409: (
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

Line 4541: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4537: ------------------------------------------------------------------------
4538: PROCEDURE derive_unit_of_measure
4539: (
4540: p_key IN po_session_gt.key%TYPE,
4541: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4542: p_uom_code_tbl IN PO_TBL_VARCHAR5,
4543: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
4544: ) IS
4545:

Line 4633: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4629: ------------------------------------------------------------------------
4630: PROCEDURE derive_line_type_id
4631: (
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

Line 4730: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4726: ------------------------------------------------------------------------
4727: PROCEDURE derive_un_number_id
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:

Line 4820: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4816: ------------------------------------------------------------------------
4817: PROCEDURE derive_hazard_class_id
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:

Line 4909: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4905: ------------------------------------------------------------------------
4906: PROCEDURE derive_template_id
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:

Line 5015: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5011: ------------------------------------------------------------------------
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,

Line 5174: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5170: ------------------------------------------------------------------------
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,

Line 5353: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5349: ------------------------------------------------------------------------
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

Line 5460: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5456: ------------------------------------------------------------------------
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:

Line 5548: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5544: ------------------------------------------------------------------------
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:

Line 5636: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5632: ------------------------------------------------------------------------
5633: PROCEDURE default_hc_id_from_un_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:

Line 5724: p_index_tbl DBMS_SQL.NUMBER_TABLE,

5720: --End of Comments
5721: ------------------------------------------------------------------------
5722: PROCEDURE match_lines_on_line_num
5723: (
5724: p_index_tbl DBMS_SQL.NUMBER_TABLE,
5725: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
5726: ) IS
5727:
5728: d_api_name CONSTANT VARCHAR2(30) := 'match_lines_on_line_num';

Line 5740: TYPE line_ref_type IS TABLE OF DBMS_SQL.NUMBER_TABLE INDEX BY PLS_INTEGER;

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;
5742: l_po_header_id NUMBER;
5743: l_line_num NUMBER;
5744:

Line 5884: l_processing_line_tbl DBMS_SQL.NUMBER_TABLE;

5880: l_key po_session_gt.key%TYPE;
5881: l_data_key po_session_gt.key%TYPE;
5882:
5883: -- identify lines that are going to be processed
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;

Line 5885: l_num_list DBMS_SQL.NUMBER_TABLE;

5881: l_data_key po_session_gt.key%TYPE;
5882:
5883: -- identify lines that are going to be processed
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;

Line 6217: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,

6213: ------------------------------------------------------------------------
6214: PROCEDURE copy_lines
6215: (
6216: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,
6217: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6218: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6219: ) IS
6220:
6221: d_api_name CONSTANT VARCHAR2(30) := 'copy_lines';

Line 6432: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

6428: PROCEDURE uniqueness_check_on_desc
6429: (
6430: p_key IN po_session_gt.key%TYPE,
6431: p_group_num IN NUMBER,
6432: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
6433: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6434: ) IS
6435:
6436: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_desc';

Line 6686: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

6682: PROCEDURE uniqueness_check_on_item
6683: (
6684: p_key IN po_session_gt.key%TYPE,
6685: p_group_num IN NUMBER,
6686: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
6687: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6688: ) IS
6689:
6690: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_item';

Line 6988: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

6984: PROCEDURE uniqueness_check_on_vpn
6985: (
6986: p_key IN po_session_gt.key%TYPE,
6987: p_group_num IN NUMBER,
6988: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
6989: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6990: ) IS
6991:
6992: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_vpn';

Line 7246: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

7242: PROCEDURE uniqueness_check_on_job
7243: (
7244: p_key IN po_session_gt.key%TYPE,
7245: p_group_num IN NUMBER,
7246: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7247: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7248: ) IS
7249:
7250: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_job';

Line 7501: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

7497: PROCEDURE uniqueness_check_on_line_num
7498: (
7499: p_key IN po_session_gt.key%TYPE,
7500: p_group_num IN NUMBER,
7501: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7502: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7503: ) IS
7504:
7505: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_line_num';

Line 7723: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

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
7726:
7727:

Line 7833: l_index_tbl DBMS_SQL.NUMBER_TABLE;

7829:
7830: l_key po_session_gt.key%TYPE;
7831:
7832: -- table used to save the index of the each row
7833: l_index_tbl DBMS_SQL.NUMBER_TABLE;
7834: l_index NUMBER;
7835: BEGIN
7836: d_position := 0;
7837:

Line 7950: l_index_tbl DBMS_SQL.number_table;

7946: d_api_name CONSTANT VARCHAR2(30) := 'populate_error_flag';
7947: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
7948: d_position NUMBER;
7949:
7950: l_index_tbl DBMS_SQL.number_table;
7951:
7952: BEGIN
7953: d_position := 0;
7954: