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 DBMS_SQL

Line 8: g_mtl_accrual_account_id_tbl DBMS_SQL.NUMBER_TABLE;

4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_DIST_PROCESS_PVT');
6:
7: g_sys_accrual_account_id NUMBER;
8: g_mtl_accrual_account_id_tbl DBMS_SQL.NUMBER_TABLE;
9: g_mtl_variance_account_id_tbl DBMS_SQL.NUMBER_TABLE;
10:
11: --------------------------------------------------------------------------
12: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------

Line 9: g_mtl_variance_account_id_tbl DBMS_SQL.NUMBER_TABLE;

5: PO_LOG.get_package_base('PO_PDOI_DIST_PROCESS_PVT');
6:
7: g_sys_accrual_account_id NUMBER;
8: g_mtl_accrual_account_id_tbl DBMS_SQL.NUMBER_TABLE;
9: g_mtl_variance_account_id_tbl DBMS_SQL.NUMBER_TABLE;
10:
11: --------------------------------------------------------------------------
12: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
13: --------------------------------------------------------------------------

Line 17: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

13: --------------------------------------------------------------------------
14: PROCEDURE derive_ship_to_ou_id
15: (
16: p_key IN po_session_gt.key%TYPE,
17: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
18: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
19: x_ship_to_ou_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
20: );
21:

Line 25: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 33: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

29:
30: PROCEDURE derive_deliver_to_person_id
31: (
32: p_key IN po_session_gt.key%TYPE,
33: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
34: p_person_name_tbl IN PO_TBL_VARCHAR2000,
35: x_person_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
36: );
37:

Line 41: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

37:
38: PROCEDURE derive_dest_type_code
39: (
40: p_key IN po_session_gt.key%TYPE,
41: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
42: p_dest_type_tbl IN PO_TBL_VARCHAR30,
43: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
44: );
45:

Line 49: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 58: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

54:
55: PROCEDURE derive_wip_entity_id
56: (
57: p_key IN po_session_gt.key%TYPE,
58: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
59: p_wip_entity_tbl IN PO_TBL_VARCHAR2000,
60: p_dest_org_id_tbl IN PO_TBL_NUMBER,
61: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
62: x_wip_entity_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 68: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

64:
65: PROCEDURE derive_wip_line_id
66: (
67: p_key IN po_session_gt.key%TYPE,
68: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
69: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,
70: p_dest_org_id_tbl IN PO_TBL_NUMBER,
71: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
72: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 78: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

74:
75: PROCEDURE derive_ship_to_ou_coa_id
76: (
77: p_key IN po_session_gt.key%TYPE,
78: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
79: p_dest_org_id_tbl IN PO_TBL_NUMBER,
80: p_txn_flow_header_id_tbl IN PO_TBL_NUMBER,
81: p_dest_charge_account_id_tbl IN PO_TBL_NUMBER,
82: x_ship_to_ou_coa_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 88: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

84:
85: PROCEDURE derive_bom_resource_id
86: (
87: p_key IN po_session_gt.key%TYPE,
88: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
89: p_bom_resource_code_tbl IN PO_TBL_VARCHAR30,
90: p_dest_org_id_tbl IN PO_TBL_NUMBER,
91: x_bom_resource_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
92: );

Line 103: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

99:
100: PROCEDURE derive_project_info
101: (
102: p_key IN po_session_gt.key%TYPE,
103: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
104: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
105: x_dists IN OUT NOCOPY PO_PDOI_TYPES.distributions_rec_type
106: );
107:

Line 104: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

100: PROCEDURE derive_project_info
101: (
102: p_key IN po_session_gt.key%TYPE,
103: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
104: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
105: x_dists IN OUT NOCOPY PO_PDOI_TYPES.distributions_rec_type
106: );
107:
108: PROCEDURE derive_project_id

Line 111: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

107:
108: PROCEDURE derive_project_id
109: (
110: p_key IN po_session_gt.key%TYPE,
111: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
112: p_project_tbl IN PO_TBL_VARCHAR30,
113: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
114: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
115: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

Line 116: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

112: p_project_tbl IN PO_TBL_VARCHAR30,
113: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
114: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
115: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
116: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
117: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
118: );
119:
120: PROCEDURE derive_task_id

Line 123: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

119:
120: PROCEDURE derive_task_id
121: (
122: p_key IN po_session_gt.key%TYPE,
123: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
124: p_task_tbl IN PO_TBL_VARCHAR2000, --- Bug#16505809
125: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
126: p_project_id_tbl IN PO_TBL_NUMBER,
127: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

Line 128: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

124: p_task_tbl IN PO_TBL_VARCHAR2000, --- Bug#16505809
125: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
126: p_project_id_tbl IN PO_TBL_NUMBER,
127: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
128: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
129: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
130: );
131:
132: PROCEDURE derive_expenditure_type

Line 135: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 138: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

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: );
141:
142: PROCEDURE derive_expenditure_org_id

Line 145: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 148: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

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: );
151:
152: PROCEDURE add_account_segment_clause

Line 162: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

158:
159: PROCEDURE get_item_status
160: (
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: );

Line 776: l_index_tbl DBMS_SQL.NUMBER_TABLE;

772: -- key value used to identify rows in temp table
773: l_key po_session_gt.key%TYPE;
774:
775: -- table to hold index
776: l_index_tbl DBMS_SQL.NUMBER_TABLE;
777:
778: -- table to mark rows for which derivation will be performed on project fields
779: l_derive_project_info_row_tbl DBMS_SQL.NUMBER_TABLE;
780:

Line 779: l_derive_project_info_row_tbl DBMS_SQL.NUMBER_TABLE;

775: -- table to hold index
776: l_index_tbl DBMS_SQL.NUMBER_TABLE;
777:
778: -- table to mark rows for which derivation will be performed on project fields
779: l_derive_project_info_row_tbl DBMS_SQL.NUMBER_TABLE;
780:
781: -- variable to hold results for award id derivation logic API
782: l_msg_count NUMBER;
783: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1545: l_index_tbl DBMS_SQL.NUMBER_TABLE;

1541: -- key value used to identify row in temp table
1542: l_key po_session_gt.key%TYPE;
1543:
1544: -- table to hold index
1545: l_index_tbl DBMS_SQL.NUMBER_TABLE;
1546:
1547: -- flag to indicate whether po encumbrance is enabled
1548: l_po_encumbrance_flag VARCHAR2(1);
1549:

Line 2427: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2423: ------------------------------------------------------------------------
2424: PROCEDURE derive_ship_to_ou_id
2425: (
2426: p_key IN po_session_gt.key%TYPE,
2427: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2428: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2429: x_ship_to_ou_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2430: ) IS
2431:

Line 2522: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 2615: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2611: ------------------------------------------------------------------------
2612: PROCEDURE derive_deliver_to_person_id
2613: (
2614: p_key IN po_session_gt.key%TYPE,
2615: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2616: p_person_name_tbl IN PO_TBL_VARCHAR2000,
2617: x_person_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2618: ) IS
2619:

Line 2706: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2702: ------------------------------------------------------------------------
2703: PROCEDURE derive_dest_type_code
2704: (
2705: p_key IN po_session_gt.key%TYPE,
2706: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2707: p_dest_type_tbl IN PO_TBL_VARCHAR30,
2708: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2709: ) IS
2710:

Line 2799: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 2911: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2907: ------------------------------------------------------------------------
2908: PROCEDURE derive_wip_entity_id
2909: (
2910: p_key IN po_session_gt.key%TYPE,
2911: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2912: p_wip_entity_tbl IN PO_TBL_VARCHAR2000,
2913: p_dest_org_id_tbl IN PO_TBL_NUMBER,
2914: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
2915: x_wip_entity_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 3012: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3008: ------------------------------------------------------------------------
3009: PROCEDURE derive_wip_line_id
3010: (
3011: p_key IN po_session_gt.key%TYPE,
3012: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3013: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,
3014: p_dest_org_id_tbl IN PO_TBL_NUMBER,
3015: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3016: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 3112: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3108: ------------------------------------------------------------------------
3109: PROCEDURE derive_ship_to_ou_coa_id
3110: (
3111: p_key IN po_session_gt.key%TYPE,
3112: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3113: p_dest_org_id_tbl IN PO_TBL_NUMBER,
3114: p_txn_flow_header_id_tbl IN PO_TBL_NUMBER,
3115: p_dest_charge_account_id_tbl IN PO_TBL_NUMBER,
3116: x_ship_to_ou_coa_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 3217: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3213: ------------------------------------------------------------------------
3214: PROCEDURE derive_bom_resource_id
3215: (
3216: p_key IN po_session_gt.key%TYPE,
3217: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3218: p_bom_resource_code_tbl IN PO_TBL_VARCHAR30,
3219: p_dest_org_id_tbl IN PO_TBL_NUMBER,
3220: x_bom_resource_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3221: ) IS

Line 3658: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3654: ------------------------------------------------------------------------
3655: PROCEDURE derive_project_info
3656: (
3657: p_key IN po_session_gt.key%TYPE,
3658: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3659: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3660: x_dists IN OUT NOCOPY PO_PDOI_TYPES.distributions_rec_type
3661: ) IS
3662:

Line 3659: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

3655: PROCEDURE derive_project_info
3656: (
3657: p_key IN po_session_gt.key%TYPE,
3658: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3659: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3660: x_dists IN OUT NOCOPY PO_PDOI_TYPES.distributions_rec_type
3661: ) IS
3662:
3663: d_api_name CONSTANT VARCHAR2(30) := 'derive_project_info';

Line 3783: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3779: ------------------------------------------------------------------------
3780: PROCEDURE derive_project_id
3781: (
3782: p_key IN po_session_gt.key%TYPE,
3783: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3784: p_project_tbl IN PO_TBL_VARCHAR30,
3785: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3786: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3787: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

Line 3788: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

3784: p_project_tbl IN PO_TBL_VARCHAR30,
3785: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3786: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3787: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
3788: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3789: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3790: ) IS
3791:
3792: d_api_name CONSTANT VARCHAR2(30) := 'derive_project_id';

Line 3906: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3902: ------------------------------------------------------------------------
3903: PROCEDURE derive_task_id
3904: (
3905: p_key IN po_session_gt.key%TYPE,
3906: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3907: p_task_tbl IN PO_TBL_VARCHAR2000, --- Bug#16505809
3908: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3909: p_project_id_tbl IN PO_TBL_NUMBER,
3910: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

Line 3911: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

3907: p_task_tbl IN PO_TBL_VARCHAR2000, --- Bug#16505809
3908: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3909: p_project_id_tbl IN PO_TBL_NUMBER,
3910: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
3911: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3912: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3913: ) IS
3914:
3915: d_api_name CONSTANT VARCHAR2(30) := 'derive_task_id';

Line 4026: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 4029: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

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
4032:
4033: d_api_name CONSTANT VARCHAR2(30) := 'derive_expenditure_type';

Line 4126: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 4129: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

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
4132:
4133: d_api_name CONSTANT VARCHAR2(30) := 'derive_expenditure_org_id';

Line 4223: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4219: ------------------------------------------------------------------------
4220: PROCEDURE get_item_status
4221: (
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

Line 4544: l_index_tbl DBMS_SQL.number_table;

4540: d_api_name CONSTANT VARCHAR2(30) := 'populate_error_flag';
4541: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4542: d_position NUMBER;
4543:
4544: l_index_tbl DBMS_SQL.number_table;
4545:
4546: BEGIN
4547: d_position := 0;
4548: