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_VARCHAR30,
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_VARCHAR30,
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 734: l_index_tbl DBMS_SQL.NUMBER_TABLE;

730: -- key value used to identify rows in temp table
731: l_key po_session_gt.key%TYPE;
732:
733: -- table to hold index
734: l_index_tbl DBMS_SQL.NUMBER_TABLE;
735:
736: -- table to mark rows for which derivation will be performed on project fields
737: l_derive_project_info_row_tbl DBMS_SQL.NUMBER_TABLE;
738:

Line 737: l_derive_project_info_row_tbl DBMS_SQL.NUMBER_TABLE;

733: -- table to hold index
734: l_index_tbl DBMS_SQL.NUMBER_TABLE;
735:
736: -- table to mark rows for which derivation will be performed on project fields
737: l_derive_project_info_row_tbl DBMS_SQL.NUMBER_TABLE;
738:
739: -- variable to hold results for award id derivation logic API
740: l_msg_count NUMBER;
741: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1503: l_index_tbl DBMS_SQL.NUMBER_TABLE;

1499: -- key value used to identify row in temp table
1500: l_key po_session_gt.key%TYPE;
1501:
1502: -- table to hold index
1503: l_index_tbl DBMS_SQL.NUMBER_TABLE;
1504:
1505: -- flag to indicate whether po encumbrance is enabled
1506: l_po_encumbrance_flag VARCHAR2(1);
1507:

Line 2279: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2275: ------------------------------------------------------------------------
2276: PROCEDURE derive_ship_to_ou_id
2277: (
2278: p_key IN po_session_gt.key%TYPE,
2279: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2280: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2281: x_ship_to_ou_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2282: ) IS
2283:

Line 2374: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 2467: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2463: ------------------------------------------------------------------------
2464: PROCEDURE derive_deliver_to_person_id
2465: (
2466: p_key IN po_session_gt.key%TYPE,
2467: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2468: p_person_name_tbl IN PO_TBL_VARCHAR2000,
2469: x_person_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2470: ) IS
2471:

Line 2558: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2554: ------------------------------------------------------------------------
2555: PROCEDURE derive_dest_type_code
2556: (
2557: p_key IN po_session_gt.key%TYPE,
2558: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2559: p_dest_type_tbl IN PO_TBL_VARCHAR30,
2560: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2561: ) IS
2562:

Line 2651: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 2763: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2759: ------------------------------------------------------------------------
2760: PROCEDURE derive_wip_entity_id
2761: (
2762: p_key IN po_session_gt.key%TYPE,
2763: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2764: p_wip_entity_tbl IN PO_TBL_VARCHAR2000,
2765: p_dest_org_id_tbl IN PO_TBL_NUMBER,
2766: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
2767: x_wip_entity_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 2864: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2860: ------------------------------------------------------------------------
2861: PROCEDURE derive_wip_line_id
2862: (
2863: p_key IN po_session_gt.key%TYPE,
2864: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2865: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,
2866: p_dest_org_id_tbl IN PO_TBL_NUMBER,
2867: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
2868: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 2964: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2960: ------------------------------------------------------------------------
2961: PROCEDURE derive_ship_to_ou_coa_id
2962: (
2963: p_key IN po_session_gt.key%TYPE,
2964: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2965: p_dest_org_id_tbl IN PO_TBL_NUMBER,
2966: p_txn_flow_header_id_tbl IN PO_TBL_NUMBER,
2967: p_dest_charge_account_id_tbl IN PO_TBL_NUMBER,
2968: x_ship_to_ou_coa_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 3069: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3065: ------------------------------------------------------------------------
3066: PROCEDURE derive_bom_resource_id
3067: (
3068: p_key IN po_session_gt.key%TYPE,
3069: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3070: p_bom_resource_code_tbl IN PO_TBL_VARCHAR30,
3071: p_dest_org_id_tbl IN PO_TBL_NUMBER,
3072: x_bom_resource_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3073: ) IS

Line 3504: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3500: ------------------------------------------------------------------------
3501: PROCEDURE derive_project_info
3502: (
3503: p_key IN po_session_gt.key%TYPE,
3504: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3505: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3506: x_dists IN OUT NOCOPY PO_PDOI_TYPES.distributions_rec_type
3507: ) IS
3508:

Line 3505: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

3501: PROCEDURE derive_project_info
3502: (
3503: p_key IN po_session_gt.key%TYPE,
3504: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3505: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3506: x_dists IN OUT NOCOPY PO_PDOI_TYPES.distributions_rec_type
3507: ) IS
3508:
3509: d_api_name CONSTANT VARCHAR2(30) := 'derive_project_info';

Line 3629: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3625: ------------------------------------------------------------------------
3626: PROCEDURE derive_project_id
3627: (
3628: p_key IN po_session_gt.key%TYPE,
3629: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3630: p_project_tbl IN PO_TBL_VARCHAR30,
3631: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3632: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3633: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

Line 3634: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

3630: p_project_tbl IN PO_TBL_VARCHAR30,
3631: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3632: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3633: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
3634: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3635: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3636: ) IS
3637:
3638: d_api_name CONSTANT VARCHAR2(30) := 'derive_project_id';

Line 3752: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3748: ------------------------------------------------------------------------
3749: PROCEDURE derive_task_id
3750: (
3751: p_key IN po_session_gt.key%TYPE,
3752: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3753: p_task_tbl IN PO_TBL_VARCHAR30,
3754: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3755: p_project_id_tbl IN PO_TBL_NUMBER,
3756: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

Line 3757: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

3753: p_task_tbl IN PO_TBL_VARCHAR30,
3754: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3755: p_project_id_tbl IN PO_TBL_NUMBER,
3756: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,
3757: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3758: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3759: ) IS
3760:
3761: d_api_name CONSTANT VARCHAR2(30) := 'derive_task_id';

Line 3872: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 3875: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 3972: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 3975: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 4069: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4065: ------------------------------------------------------------------------
4066: PROCEDURE get_item_status
4067: (
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

Line 4353: l_index_tbl DBMS_SQL.number_table;

4349: d_api_name CONSTANT VARCHAR2(30) := 'populate_error_flag';
4350: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4351: d_position NUMBER;
4352:
4353: l_index_tbl DBMS_SQL.number_table;
4354:
4355: BEGIN
4356: d_position := 0;
4357: