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_DIST_PROCESS_PVT dependencies on PO_TBL_VARCHAR1

Line 26: p_deliver_to_loc_tbl IN PO_TBL_VARCHAR100,

22: PROCEDURE derive_deliver_to_loc_id
23: (
24: p_key IN po_session_gt.key%TYPE,
25: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
26: p_deliver_to_loc_tbl IN PO_TBL_VARCHAR100,
27: x_deliver_to_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
28: );
29:
30: PROCEDURE derive_deliver_to_person_id

Line 50: p_dest_org_tbl IN PO_TBL_VARCHAR100,

46: PROCEDURE derive_dest_org_id
47: (
48: p_key IN po_session_gt.key%TYPE,
49: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
50: p_dest_org_tbl IN PO_TBL_VARCHAR100,
51: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
52: x_dest_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
53: );
54:

Line 136: p_expenditure_tbl IN PO_TBL_VARCHAR100,

132: PROCEDURE derive_expenditure_type
133: (
134: p_key IN po_session_gt.key%TYPE,
135: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
136: p_expenditure_tbl IN PO_TBL_VARCHAR100,
137: p_project_id_tbl IN PO_TBL_NUMBER,
138: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
139: x_expenditure_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
140: );

Line 146: p_expenditure_org_tbl IN PO_TBL_VARCHAR100,

142: PROCEDURE derive_expenditure_org_id
143: (
144: p_key IN po_session_gt.key%TYPE,
145: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
146: p_expenditure_org_tbl IN PO_TBL_VARCHAR100,
147: p_project_id_tbl IN PO_TBL_NUMBER,
148: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
149: x_expenditure_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
150: );

Line 165: x_item_status_tbl OUT NOCOPY PO_TBL_VARCHAR1

161: p_key IN po_session_gt.key%TYPE,
162: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
163: p_item_id_tbl IN PO_TBL_NUMBER,
164: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
165: x_item_status_tbl OUT NOCOPY PO_TBL_VARCHAR1
166: );
167:
168: PROCEDURE default_account_ids
169: (

Line 2523: p_deliver_to_loc_tbl IN PO_TBL_VARCHAR100,

2519: PROCEDURE derive_deliver_to_loc_id
2520: (
2521: p_key IN po_session_gt.key%TYPE,
2522: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2523: p_deliver_to_loc_tbl IN PO_TBL_VARCHAR100,
2524: x_deliver_to_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2525: ) IS
2526:
2527: d_api_name CONSTANT VARCHAR2(30) := 'derive_deliver_to_loc_id';

Line 2800: p_dest_org_tbl IN PO_TBL_VARCHAR100,

2796: PROCEDURE derive_dest_org_id
2797: (
2798: p_key IN po_session_gt.key%TYPE,
2799: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2800: p_dest_org_tbl IN PO_TBL_VARCHAR100,
2801: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2802: x_dest_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2803: ) IS
2804:

Line 4027: p_expenditure_tbl IN PO_TBL_VARCHAR100,

4023: PROCEDURE derive_expenditure_type
4024: (
4025: p_key IN po_session_gt.key%TYPE,
4026: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4027: p_expenditure_tbl IN PO_TBL_VARCHAR100,
4028: p_project_id_tbl IN PO_TBL_NUMBER,
4029: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
4030: x_expenditure_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
4031: ) IS

Line 4127: p_expenditure_org_tbl IN PO_TBL_VARCHAR100,

4123: PROCEDURE derive_expenditure_org_id
4124: (
4125: p_key IN po_session_gt.key%TYPE,
4126: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4127: p_expenditure_org_tbl IN PO_TBL_VARCHAR100,
4128: p_project_id_tbl IN PO_TBL_NUMBER,
4129: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
4130: x_expenditure_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4131: ) IS

Line 4226: x_item_status_tbl OUT NOCOPY PO_TBL_VARCHAR1

4222: p_key IN po_session_gt.key%TYPE,
4223: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4224: p_item_id_tbl IN PO_TBL_NUMBER,
4225: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
4226: x_item_status_tbl OUT NOCOPY PO_TBL_VARCHAR1
4227: ) IS
4228:
4229: d_api_name CONSTANT VARCHAR2(30) := 'get_item_status';
4230: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4235: l_result_tbl PO_TBL_VARCHAR1;

4231: d_position NUMBER;
4232:
4233: -- variable to hold derived result
4234: l_index_tbl PO_TBL_NUMBER;
4235: l_result_tbl PO_TBL_VARCHAR1;
4236: BEGIN
4237: d_position := 0;
4238:
4239: IF (PO_LOG.d_proc) THEN

Line 4245: x_item_status_tbl := PO_TBL_VARCHAR1();

4241: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
4242: END IF;
4243:
4244: -- initialize out parameter
4245: x_item_status_tbl := PO_TBL_VARCHAR1();
4246: x_item_status_tbl.EXTEND(p_index_tbl.COUNT);
4247:
4248: FORALL i IN 1..p_index_tbl.COUNT
4249: INSERT INTO po_session_gt(key, num1, char1)