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 2375: p_deliver_to_loc_tbl IN PO_TBL_VARCHAR100,

2371: PROCEDURE derive_deliver_to_loc_id
2372: (
2373: p_key IN po_session_gt.key%TYPE,
2374: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2375: p_deliver_to_loc_tbl IN PO_TBL_VARCHAR100,
2376: x_deliver_to_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2377: ) IS
2378:
2379: d_api_name CONSTANT VARCHAR2(30) := 'derive_deliver_to_loc_id';

Line 2652: p_dest_org_tbl IN PO_TBL_VARCHAR100,

2648: PROCEDURE derive_dest_org_id
2649: (
2650: p_key IN po_session_gt.key%TYPE,
2651: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2652: p_dest_org_tbl IN PO_TBL_VARCHAR100,
2653: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2654: x_dest_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2655: ) IS
2656:

Line 3873: p_expenditure_tbl IN PO_TBL_VARCHAR100,

3869: PROCEDURE derive_expenditure_type
3870: (
3871: p_key IN po_session_gt.key%TYPE,
3872: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3873: p_expenditure_tbl IN PO_TBL_VARCHAR100,
3874: p_project_id_tbl IN PO_TBL_NUMBER,
3875: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3876: x_expenditure_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
3877: ) IS

Line 3973: p_expenditure_org_tbl IN PO_TBL_VARCHAR100,

3969: PROCEDURE derive_expenditure_org_id
3970: (
3971: p_key IN po_session_gt.key%TYPE,
3972: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3973: p_expenditure_org_tbl IN PO_TBL_VARCHAR100,
3974: p_project_id_tbl IN PO_TBL_NUMBER,
3975: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3976: x_expenditure_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3977: ) IS

Line 4072: x_item_status_tbl OUT NOCOPY PO_TBL_VARCHAR1

4068: p_key IN po_session_gt.key%TYPE,
4069: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4070: p_item_id_tbl IN PO_TBL_NUMBER,
4071: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
4072: x_item_status_tbl OUT NOCOPY PO_TBL_VARCHAR1
4073: ) IS
4074:
4075: d_api_name CONSTANT VARCHAR2(30) := 'get_item_status';
4076: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4081: l_result_tbl PO_TBL_VARCHAR1;

4077: d_position NUMBER;
4078:
4079: -- variable to hold derived result
4080: l_index_tbl PO_TBL_NUMBER;
4081: l_result_tbl PO_TBL_VARCHAR1;
4082: BEGIN
4083: d_position := 0;
4084:
4085: IF (PO_LOG.d_proc) THEN

Line 4091: x_item_status_tbl := PO_TBL_VARCHAR1();

4087: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
4088: END IF;
4089:
4090: -- initialize out parameter
4091: x_item_status_tbl := PO_TBL_VARCHAR1();
4092: x_item_status_tbl.EXTEND(p_index_tbl.COUNT);
4093:
4094: FORALL i IN 1..p_index_tbl.COUNT
4095: INSERT INTO po_session_gt(key, num1, char1)