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_NUMBER

Line 18: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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:
22: PROCEDURE derive_deliver_to_loc_id

Line 19: x_ship_to_ou_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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:
22: PROCEDURE derive_deliver_to_loc_id
23: (

Line 27: x_deliver_to_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
31: (

Line 35: x_person_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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:
38: PROCEDURE derive_dest_type_code
39: (

Line 51: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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:
55: PROCEDURE derive_wip_entity_id

Line 52: x_dest_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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:
55: PROCEDURE derive_wip_entity_id
56: (

Line 60: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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
63: );
64:

Line 62: x_wip_entity_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
63: );
64:
65: PROCEDURE derive_wip_line_id
66: (

Line 70: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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
73: );
74:

Line 72: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
73: );
74:
75: PROCEDURE derive_ship_to_ou_coa_id
76: (

Line 79: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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

Line 80: p_txn_flow_header_id_tbl IN PO_TBL_NUMBER,

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
83: );
84:

Line 81: p_dest_charge_account_id_tbl IN PO_TBL_NUMBER,

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
83: );
84:
85: PROCEDURE derive_bom_resource_id

Line 82: x_ship_to_ou_coa_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
83: );
84:
85: PROCEDURE derive_bom_resource_id
86: (

Line 90: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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: );
93:
94: PROCEDURE validate_null_for_project_info

Line 91: x_bom_resource_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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: );
93:
94: PROCEDURE validate_null_for_project_info
95: (

Line 114: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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,
116: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
117: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
118: );

Line 115: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

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,
116: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
117: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
118: );
119:

Line 117: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
121: (

Line 126: p_project_id_tbl IN PO_TBL_NUMBER,

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,
128: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
129: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
130: );

Line 127: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

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,
128: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
129: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
130: );
131:

Line 129: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
133: (

Line 137: p_project_id_tbl IN PO_TBL_NUMBER,

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

Line 147: p_project_id_tbl IN PO_TBL_NUMBER,

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

Line 149: x_expenditure_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
153: ( p_segment_name IN VARCHAR2,

Line 163: p_item_id_tbl IN PO_TBL_NUMBER,

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

Line 164: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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: );
167:
168: PROCEDURE default_account_ids

Line 1514: l_period_year_tbl PO_TBL_NUMBER;

1510: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1511: l_return_status VARCHAR2(1);
1512:
1513: -- variables used to call API to get gl_encumbered_period_name
1514: l_period_year_tbl PO_TBL_NUMBER;
1515: l_period_num_tbl PO_TBL_NUMBER;
1516: l_quarter_num_tbl PO_TBL_NUMBER;
1517: l_invalid_period_flag VARCHAR2(1);
1518:

Line 1515: l_period_num_tbl PO_TBL_NUMBER;

1511: l_return_status VARCHAR2(1);
1512:
1513: -- variables used to call API to get gl_encumbered_period_name
1514: l_period_year_tbl PO_TBL_NUMBER;
1515: l_period_num_tbl PO_TBL_NUMBER;
1516: l_quarter_num_tbl PO_TBL_NUMBER;
1517: l_invalid_period_flag VARCHAR2(1);
1518:
1519: -- variable used in workflow API call

Line 1516: l_quarter_num_tbl PO_TBL_NUMBER;

1512:
1513: -- variables used to call API to get gl_encumbered_period_name
1514: l_period_year_tbl PO_TBL_NUMBER;
1515: l_period_num_tbl PO_TBL_NUMBER;
1516: l_quarter_num_tbl PO_TBL_NUMBER;
1517: l_invalid_period_flag VARCHAR2(1);
1518:
1519: -- variable used in workflow API call
1520: l_charge_success BOOLEAN := TRUE;

Line 2280: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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:
2284: d_api_name CONSTANT VARCHAR2(30) := 'derive_ship_to_ou_id';

Line 2281: x_ship_to_ou_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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:
2284: d_api_name CONSTANT VARCHAR2(30) := 'derive_ship_to_ou_id';
2285: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2289: l_index_tbl PO_TBL_NUMBER;

2285: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2286: d_position NUMBER;
2287:
2288: -- variable to hold derived result
2289: l_index_tbl PO_TBL_NUMBER;
2290: l_result_tbl PO_TBL_NUMBER;
2291: BEGIN
2292: d_position := 0;
2293:

Line 2290: l_result_tbl PO_TBL_NUMBER;

2286: d_position NUMBER;
2287:
2288: -- variable to hold derived result
2289: l_index_tbl PO_TBL_NUMBER;
2290: l_result_tbl PO_TBL_NUMBER;
2291: BEGIN
2292: d_position := 0;
2293:
2294: IF (PO_LOG.d_proc) THEN

Line 2299: x_ship_to_ou_id_tbl := PO_TBL_NUMBER();

2295: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2296: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_id_tbl', x_ship_to_ou_id_tbl);
2297: END IF;
2298:
2299: x_ship_to_ou_id_tbl := PO_TBL_NUMBER();
2300: x_ship_to_ou_id_tbl.EXTEND(p_index_tbl.COUNT);
2301:
2302: -- query database to get derived result in batch mode
2303: FORALL i IN 1..p_index_tbl.COUNT

Line 2376: x_deliver_to_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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';
2380: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2384: l_index_tbl PO_TBL_NUMBER;

2380: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2381: d_position NUMBER;
2382:
2383: -- variable to hold derived result
2384: l_index_tbl PO_TBL_NUMBER;
2385: l_result_tbl PO_TBL_NUMBER;
2386: BEGIN
2387: d_position := 0;
2388:

Line 2385: l_result_tbl PO_TBL_NUMBER;

2381: d_position NUMBER;
2382:
2383: -- variable to hold derived result
2384: l_index_tbl PO_TBL_NUMBER;
2385: l_result_tbl PO_TBL_NUMBER;
2386: BEGIN
2387: d_position := 0;
2388:
2389: IF (PO_LOG.d_proc) THEN

Line 2469: x_person_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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:
2472: d_api_name CONSTANT VARCHAR2(30) := 'derive_deliver_to_person_id';
2473: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2477: l_index_tbl PO_TBL_NUMBER;

2473: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2474: d_position NUMBER;
2475:
2476: -- variable to hold derived result
2477: l_index_tbl PO_TBL_NUMBER;
2478: l_result_tbl PO_TBL_NUMBER;
2479: BEGIN
2480: d_position := 0;
2481:

Line 2478: l_result_tbl PO_TBL_NUMBER;

2474: d_position NUMBER;
2475:
2476: -- variable to hold derived result
2477: l_index_tbl PO_TBL_NUMBER;
2478: l_result_tbl PO_TBL_NUMBER;
2479: BEGIN
2480: d_position := 0;
2481:
2482: IF (PO_LOG.d_proc) THEN

Line 2568: l_index_tbl PO_TBL_NUMBER;

2564: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2565: d_position NUMBER;
2566:
2567: -- variable to hold derived result
2568: l_index_tbl PO_TBL_NUMBER;
2569: l_result_tbl PO_TBL_VARCHAR25;
2570: BEGIN
2571: d_position := 0;
2572:

Line 2653: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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:
2657: d_api_name CONSTANT VARCHAR2(30) := 'derive_dest_org_id';

Line 2654: x_dest_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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:
2657: d_api_name CONSTANT VARCHAR2(30) := 'derive_dest_org_id';
2658: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2662: l_index_tbl PO_TBL_NUMBER;

2658: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2659: d_position NUMBER;
2660:
2661: -- variable to hold derived result
2662: l_index_tbl PO_TBL_NUMBER;
2663: l_result_tbl PO_TBL_NUMBER;
2664: BEGIN
2665: d_position := 0;
2666:

Line 2663: l_result_tbl PO_TBL_NUMBER;

2659: d_position NUMBER;
2660:
2661: -- variable to hold derived result
2662: l_index_tbl PO_TBL_NUMBER;
2663: l_result_tbl PO_TBL_NUMBER;
2664: BEGIN
2665: d_position := 0;
2666:
2667: IF (PO_LOG.d_proc) THEN

Line 2765: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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
2768: ) IS
2769:

Line 2767: x_wip_entity_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
2768: ) IS
2769:
2770: d_api_name CONSTANT VARCHAR2(30) := 'derive_wip_entity_id';
2771: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2775: l_index_tbl PO_TBL_NUMBER;

2771: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2772: d_position NUMBER;
2773:
2774: -- variable to hold derived result
2775: l_index_tbl PO_TBL_NUMBER;
2776: l_result_tbl PO_TBL_NUMBER;
2777: BEGIN
2778: d_position := 0;
2779:

Line 2776: l_result_tbl PO_TBL_NUMBER;

2772: d_position NUMBER;
2773:
2774: -- variable to hold derived result
2775: l_index_tbl PO_TBL_NUMBER;
2776: l_result_tbl PO_TBL_NUMBER;
2777: BEGIN
2778: d_position := 0;
2779:
2780: IF (PO_LOG.d_proc) THEN

Line 2866: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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
2869: ) IS
2870:

Line 2868: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
2869: ) IS
2870:
2871: d_api_name CONSTANT VARCHAR2(30) := 'derive_wip_line_id';
2872: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2876: l_index_tbl PO_TBL_NUMBER;

2872: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2873: d_position NUMBER;
2874:
2875: -- variable to hold derived result
2876: l_index_tbl PO_TBL_NUMBER;
2877: l_result_tbl PO_TBL_NUMBER;
2878: BEGIN
2879: d_position := 0;
2880:

Line 2877: l_result_tbl PO_TBL_NUMBER;

2873: d_position NUMBER;
2874:
2875: -- variable to hold derived result
2876: l_index_tbl PO_TBL_NUMBER;
2877: l_result_tbl PO_TBL_NUMBER;
2878: BEGIN
2879: d_position := 0;
2880:
2881: IF (PO_LOG.d_proc) THEN

Line 2965: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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
2969: ) IS

Line 2966: p_txn_flow_header_id_tbl IN PO_TBL_NUMBER,

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
2969: ) IS
2970:

Line 2967: p_dest_charge_account_id_tbl IN PO_TBL_NUMBER,

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
2969: ) IS
2970:
2971: d_api_name CONSTANT VARCHAR2(30) := 'derive_ship_to_ou_coa_id';

Line 2968: x_ship_to_ou_coa_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
2969: ) IS
2970:
2971: d_api_name CONSTANT VARCHAR2(30) := 'derive_ship_to_ou_coa_id';
2972: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2976: l_index_tbl PO_TBL_NUMBER;

2972: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2973: d_position NUMBER;
2974:
2975: -- variable to hold derived result
2976: l_index_tbl PO_TBL_NUMBER;
2977: l_result_tbl PO_TBL_NUMBER;
2978: BEGIN
2979: d_position := 0;
2980:

Line 2977: l_result_tbl PO_TBL_NUMBER;

2973: d_position NUMBER;
2974:
2975: -- variable to hold derived result
2976: l_index_tbl PO_TBL_NUMBER;
2977: l_result_tbl PO_TBL_NUMBER;
2978: BEGIN
2979: d_position := 0;
2980:
2981: IF (PO_LOG.d_proc) THEN

Line 3071: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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
3074:
3075: d_api_name CONSTANT VARCHAR2(30) := 'derive_bom_resource_id';

Line 3072: x_bom_resource_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
3074:
3075: d_api_name CONSTANT VARCHAR2(30) := 'derive_bom_resource_id';
3076: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3080: l_index_tbl PO_TBL_NUMBER;

3076: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3077: d_position NUMBER;
3078:
3079: -- variable to hold derived result
3080: l_index_tbl PO_TBL_NUMBER;
3081: l_result_tbl PO_TBL_NUMBER;
3082: BEGIN
3083: d_position := 0;
3084:

Line 3081: l_result_tbl PO_TBL_NUMBER;

3077: d_position NUMBER;
3078:
3079: -- variable to hold derived result
3080: l_index_tbl PO_TBL_NUMBER;
3081: l_result_tbl PO_TBL_NUMBER;
3082: BEGIN
3083: d_position := 0;
3084:
3085: IF (PO_LOG.d_proc) THEN

Line 3632: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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,
3634: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3635: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3636: ) IS

Line 3633: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

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,
3634: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3635: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3636: ) IS
3637:

Line 3635: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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';
3639: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3643: l_index_tbl PO_TBL_NUMBER;

3639: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3640: d_position NUMBER;
3641:
3642: -- variable to hold derived result
3643: l_index_tbl PO_TBL_NUMBER;
3644: l_result_tbl PO_TBL_NUMBER;
3645: BEGIN
3646: d_position := 0;
3647:

Line 3644: l_result_tbl PO_TBL_NUMBER;

3640: d_position NUMBER;
3641:
3642: -- variable to hold derived result
3643: l_index_tbl PO_TBL_NUMBER;
3644: l_result_tbl PO_TBL_NUMBER;
3645: BEGIN
3646: d_position := 0;
3647:
3648: IF (PO_LOG.d_proc) THEN

Line 3755: p_project_id_tbl IN PO_TBL_NUMBER,

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,
3757: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3758: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3759: ) IS

Line 3756: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

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,
3757: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3758: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3759: ) IS
3760:

Line 3758: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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';
3762: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3766: l_index_tbl PO_TBL_NUMBER;

3762: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3763: d_position NUMBER;
3764:
3765: -- variable to hold derived result
3766: l_index_tbl PO_TBL_NUMBER;
3767: l_result_tbl PO_TBL_NUMBER;
3768: BEGIN
3769: d_position := 0;
3770:

Line 3767: l_result_tbl PO_TBL_NUMBER;

3763: d_position NUMBER;
3764:
3765: -- variable to hold derived result
3766: l_index_tbl PO_TBL_NUMBER;
3767: l_result_tbl PO_TBL_NUMBER;
3768: BEGIN
3769: d_position := 0;
3770:
3771: IF (PO_LOG.d_proc) THEN

Line 3874: p_project_id_tbl IN PO_TBL_NUMBER,

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

Line 3884: l_index_tbl PO_TBL_NUMBER;

3880: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3881: d_position NUMBER;
3882:
3883: -- variable to hold derived result
3884: l_index_tbl PO_TBL_NUMBER;
3885: l_result_tbl PO_TBL_VARCHAR30;
3886: BEGIN
3887: d_position := 0;
3888:

Line 3974: p_project_id_tbl IN PO_TBL_NUMBER,

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

Line 3976: x_expenditure_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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';
3980: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3984: l_index_tbl PO_TBL_NUMBER;

3980: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3981: d_position NUMBER;
3982:
3983: -- variable to hold derived result
3984: l_index_tbl PO_TBL_NUMBER;
3985: l_result_tbl PO_TBL_NUMBER;
3986: BEGIN
3987: d_position := 0;
3988:

Line 3985: l_result_tbl PO_TBL_NUMBER;

3981: d_position NUMBER;
3982:
3983: -- variable to hold derived result
3984: l_index_tbl PO_TBL_NUMBER;
3985: l_result_tbl PO_TBL_NUMBER;
3986: BEGIN
3987: d_position := 0;
3988:
3989: IF (PO_LOG.d_proc) THEN

Line 4070: p_item_id_tbl IN PO_TBL_NUMBER,

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

Line 4071: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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
4074:
4075: d_api_name CONSTANT VARCHAR2(30) := 'get_item_status';

Line 4080: l_index_tbl PO_TBL_NUMBER;

4076: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
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: