DBA Data[Home] [Help]

APPS.PO_PDOI_DIST_PROCESS_PVT dependencies on PO_TBL_VARCHAR100

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