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_VARCHAR2000

Line 24: p_item_tbl IN PO_TBL_VARCHAR2000,

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

Line 40: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,

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:
44: PROCEDURE derive_job_id

Line 49: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,

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,
52: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
53: );

Line 50: p_job_name_tbl IN PO_TBL_VARCHAR2000,

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,
52: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
53: );
54:

Line 58: p_category_tbl IN PO_TBL_VARCHAR2000,

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

Line 67: p_ip_category_tbl IN PO_TBL_VARCHAR2000,

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: );
70:
71: PROCEDURE derive_unit_of_measure

Line 130: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,

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,
134: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 145: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,

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:
149: PROCEDURE default_po_cat_id_from_ip

Line 3070: l_it_item_desc_tbl PO_TBL_VARCHAR2000;

3066: l_li_unit_of_measure_tbl PO_TBL_VARCHAR30;
3067: l_li_unit_price_tbl PO_TBL_NUMBER;
3068:
3069: -- information defaulted from item
3070: l_it_item_desc_tbl PO_TBL_VARCHAR2000;
3071: l_it_unit_of_measure_tbl PO_TBL_VARCHAR30;
3072: l_it_unit_price_tbl PO_TBL_NUMBER;
3073: l_it_category_id_tbl PO_TBL_NUMBER;
3074: l_it_un_number_id_tbl PO_TBL_NUMBER;

Line 3080: l_job_item_desc_tbl PO_TBL_VARCHAR2000;

3076: l_it_market_price_tbl PO_TBL_NUMBER;
3077: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;
3078:
3079: -- information defaulted from job
3080: l_job_item_desc_tbl PO_TBL_VARCHAR2000;
3081: l_job_category_id_tbl PO_TBL_NUMBER;
3082:
3083: -- information defaulted from ip category
3084: l_ic_category_id_tbl PO_TBL_NUMBER; -- bug5130037

Line 4467: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

4463:
4464: l_lines PO_LINES_VAL_TYPE := PO_LINES_VAL_TYPE();
4465: l_result_type VARCHAR2(30);
4466: l_results po_validation_results_type;
4467: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
4468: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
4469: l_inventory_org_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
4470:
4471: BEGIN

Line 4468: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

4464: l_lines PO_LINES_VAL_TYPE := PO_LINES_VAL_TYPE();
4465: l_result_type VARCHAR2(30);
4466: l_results po_validation_results_type;
4467: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
4468: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
4469: l_inventory_org_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
4470:
4471: BEGIN
4472: d_position := 0;

Line 4714: p_item_tbl IN PO_TBL_VARCHAR2000,

4710: p_intf_header_id_tbl IN PO_TBL_NUMBER,
4711: p_intf_line_id_tbl IN PO_TBL_NUMBER,
4712: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
4713: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
4714: p_item_tbl IN PO_TBL_VARCHAR2000,
4715: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
4716: x_error_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
4717: ) IS
4718:

Line 4932: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,

4928: PROCEDURE derive_job_business_group_id
4929: (
4930: p_key IN po_session_gt.key%TYPE,
4931: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4932: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
4933: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4934: ) IS
4935:
4936: d_api_name CONSTANT VARCHAR2(30) := 'derive_job_business_group_id';

Line 5033: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,

5029: (
5030: p_key IN po_session_gt.key%TYPE,
5031: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5032: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5033: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
5034: p_job_name_tbl IN PO_TBL_VARCHAR2000,
5035: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
5036: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5037: ) IS

Line 5034: p_job_name_tbl IN PO_TBL_VARCHAR2000,

5030: p_key IN po_session_gt.key%TYPE,
5031: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5032: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5033: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
5034: p_job_name_tbl IN PO_TBL_VARCHAR2000,
5035: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
5036: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5037: ) IS
5038:

Line 5050: d_job_name_tbl PO_TBL_VARCHAR2000;

5046:
5047: -- debug variables
5048: d_group_id NUMBER;
5049: d_job_id_tbl PO_TBL_NUMBER;
5050: d_job_name_tbl PO_TBL_VARCHAR2000;
5051: d_bg_id_tbl PO_TBL_NUMBER;
5052:
5053: BEGIN
5054: d_position := 0;

Line 5251: p_category_tbl IN PO_TBL_VARCHAR2000,

5247: ------------------------------------------------------------------------
5248: PROCEDURE derive_category_id
5249: (
5250: p_key IN po_session_gt.key%TYPE,
5251: p_category_tbl IN PO_TBL_VARCHAR2000,
5252: x_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5253: ) IS
5254:
5255: d_api_name CONSTANT VARCHAR2(30) := 'derive_category_id';

Line 5335: p_ip_category_tbl IN PO_TBL_VARCHAR2000,

5331: (
5332: p_key IN po_session_gt.key%TYPE,
5333: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5334: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5335: p_ip_category_tbl IN PO_TBL_VARCHAR2000,
5336: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5337: ) IS
5338:
5339: d_api_name CONSTANT VARCHAR2(30) := 'derive_ip_category_id';

Line 6098: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,

6094: (
6095: p_key IN po_session_gt.key%TYPE,
6096: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6097: p_item_id_tbl IN PO_TBL_NUMBER,
6098: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
6099: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
6100: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
6101: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
6102: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 6114: l_item_desc_tbl PO_TBL_VARCHAR2000;

6110: d_position NUMBER;
6111:
6112: -- variables to hold result read from temp table
6113: l_index_tbl PO_TBL_NUMBER;
6114: l_item_desc_tbl PO_TBL_VARCHAR2000;
6115: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
6116: l_unit_price_tbl PO_TBL_NUMBER;
6117: l_category_id_tbl PO_TBL_NUMBER;
6118: l_un_number_id_tbl PO_TBL_NUMBER;

Line 6132: x_item_desc_tbl := PO_TBL_VARCHAR2000();

6128: IF (PO_LOG.d_proc) THEN
6129: PO_LOG.proc_begin(d_module);
6130: END IF;
6131:
6132: x_item_desc_tbl := PO_TBL_VARCHAR2000();
6133: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();
6134: x_unit_price_tbl := PO_TBL_NUMBER();
6135: x_category_id_tbl := PO_TBL_NUMBER();
6136: x_un_number_id_tbl := PO_TBL_NUMBER();

Line 6277: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,

6273: (
6274: p_key IN po_session_gt.key%TYPE,
6275: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6276: p_job_id_tbl IN PO_TBL_NUMBER,
6277: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
6278: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER
6279: ) IS
6280:
6281: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_job';

Line 6289: l_item_desc_tbl PO_TBL_VARCHAR2000;

6285: l_index NUMBER;
6286:
6287: -- variables to hold result read from temp table
6288: l_index_tbl PO_TBL_NUMBER;
6289: l_item_desc_tbl PO_TBL_VARCHAR2000;
6290: l_category_id_tbl PO_TBL_NUMBER;
6291: BEGIN
6292: d_position := 0;
6293:

Line 6298: x_item_desc_tbl := PO_TBL_VARCHAR2000();

6294: IF (PO_LOG.d_proc) THEN
6295: PO_LOG.proc_begin(d_module);
6296: END IF;
6297:
6298: x_item_desc_tbl := PO_TBL_VARCHAR2000();
6299: x_category_id_tbl := PO_TBL_NUMBER();
6300:
6301: x_item_desc_tbl.EXTEND(p_index_tbl.COUNT);
6302: x_category_id_tbl.EXTEND(p_index_tbl.COUNT);