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 2250: l_it_item_desc_tbl PO_TBL_VARCHAR2000;

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;
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;

Line 2260: l_job_item_desc_tbl PO_TBL_VARCHAR2000;

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;
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

Line 3568: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

3564:
3565: l_lines PO_LINES_VAL_TYPE := PO_LINES_VAL_TYPE();
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

Line 3569: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

3565: l_lines PO_LINES_VAL_TYPE := PO_LINES_VAL_TYPE();
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;

Line 3792: p_item_tbl IN PO_TBL_VARCHAR2000,

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

Line 4010: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,

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:
4014: d_api_name CONSTANT VARCHAR2(30) := 'derive_job_business_group_id';

Line 4111: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,

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,
4114: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4115: ) IS

Line 4112: p_job_name_tbl IN PO_TBL_VARCHAR2000,

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,
4114: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4115: ) IS
4116:

Line 4128: d_job_name_tbl PO_TBL_VARCHAR2000;

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
4132: d_position := 0;

Line 4329: p_category_tbl IN PO_TBL_VARCHAR2000,

4325: ------------------------------------------------------------------------
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';

Line 4413: p_ip_category_tbl IN PO_TBL_VARCHAR2000,

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
4416:
4417: d_api_name CONSTANT VARCHAR2(30) := 'derive_ip_category_id';

Line 5176: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,

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

Line 5192: l_item_desc_tbl PO_TBL_VARCHAR2000;

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;
5196: l_un_number_id_tbl PO_TBL_NUMBER;

Line 5210: x_item_desc_tbl := PO_TBL_VARCHAR2000();

5206: IF (PO_LOG.d_proc) THEN
5207: PO_LOG.proc_begin(d_module);
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();

Line 5355: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,

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:
5359: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_job';

Line 5367: l_item_desc_tbl PO_TBL_VARCHAR2000;

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;
5371:

Line 5376: x_item_desc_tbl := PO_TBL_VARCHAR2000();

5372: IF (PO_LOG.d_proc) THEN
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);