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

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

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 1556: l_period_year_tbl PO_TBL_NUMBER;

1552: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1553: l_return_status VARCHAR2(1);
1554:
1555: -- variables used to call API to get gl_encumbered_period_name
1556: l_period_year_tbl PO_TBL_NUMBER;
1557: l_period_num_tbl PO_TBL_NUMBER;
1558: l_quarter_num_tbl PO_TBL_NUMBER;
1559: l_invalid_period_flag VARCHAR2(1);
1560:

Line 1557: l_period_num_tbl PO_TBL_NUMBER;

1553: l_return_status VARCHAR2(1);
1554:
1555: -- variables used to call API to get gl_encumbered_period_name
1556: l_period_year_tbl PO_TBL_NUMBER;
1557: l_period_num_tbl PO_TBL_NUMBER;
1558: l_quarter_num_tbl PO_TBL_NUMBER;
1559: l_invalid_period_flag VARCHAR2(1);
1560:
1561: -- variable used in workflow API call

Line 1558: l_quarter_num_tbl PO_TBL_NUMBER;

1554:
1555: -- variables used to call API to get gl_encumbered_period_name
1556: l_period_year_tbl PO_TBL_NUMBER;
1557: l_period_num_tbl PO_TBL_NUMBER;
1558: l_quarter_num_tbl PO_TBL_NUMBER;
1559: l_invalid_period_flag VARCHAR2(1);
1560:
1561: -- variable used in workflow API call
1562: l_charge_success BOOLEAN := TRUE;

Line 2428: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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

Line 2429: x_ship_to_ou_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 2437: l_index_tbl PO_TBL_NUMBER;

2433: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2434: d_position NUMBER;
2435:
2436: -- variable to hold derived result
2437: l_index_tbl PO_TBL_NUMBER;
2438: l_result_tbl PO_TBL_NUMBER;
2439: BEGIN
2440: d_position := 0;
2441:

Line 2438: l_result_tbl PO_TBL_NUMBER;

2434: d_position NUMBER;
2435:
2436: -- variable to hold derived result
2437: l_index_tbl PO_TBL_NUMBER;
2438: l_result_tbl PO_TBL_NUMBER;
2439: BEGIN
2440: d_position := 0;
2441:
2442: IF (PO_LOG.d_proc) THEN

Line 2447: x_ship_to_ou_id_tbl := PO_TBL_NUMBER();

2443: PO_LOG.proc_begin(d_module, 'p_ship_to_org_id_tbl', p_ship_to_org_id_tbl);
2444: PO_LOG.proc_begin(d_module, 'x_ship_to_ou_id_tbl', x_ship_to_ou_id_tbl);
2445: END IF;
2446:
2447: x_ship_to_ou_id_tbl := PO_TBL_NUMBER();
2448: x_ship_to_ou_id_tbl.EXTEND(p_index_tbl.COUNT);
2449:
2450: -- query database to get derived result in batch mode
2451: FORALL i IN 1..p_index_tbl.COUNT

Line 2524: x_deliver_to_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 2532: l_index_tbl PO_TBL_NUMBER;

2528: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2529: d_position NUMBER;
2530:
2531: -- variable to hold derived result
2532: l_index_tbl PO_TBL_NUMBER;
2533: l_result_tbl PO_TBL_NUMBER;
2534: BEGIN
2535: d_position := 0;
2536:

Line 2533: l_result_tbl PO_TBL_NUMBER;

2529: d_position NUMBER;
2530:
2531: -- variable to hold derived result
2532: l_index_tbl PO_TBL_NUMBER;
2533: l_result_tbl PO_TBL_NUMBER;
2534: BEGIN
2535: d_position := 0;
2536:
2537: IF (PO_LOG.d_proc) THEN

Line 2617: x_person_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 2625: l_index_tbl PO_TBL_NUMBER;

2621: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2622: d_position NUMBER;
2623:
2624: -- variable to hold derived result
2625: l_index_tbl PO_TBL_NUMBER;
2626: l_result_tbl PO_TBL_NUMBER;
2627: BEGIN
2628: d_position := 0;
2629:

Line 2626: l_result_tbl PO_TBL_NUMBER;

2622: d_position NUMBER;
2623:
2624: -- variable to hold derived result
2625: l_index_tbl PO_TBL_NUMBER;
2626: l_result_tbl PO_TBL_NUMBER;
2627: BEGIN
2628: d_position := 0;
2629:
2630: IF (PO_LOG.d_proc) THEN

Line 2716: l_index_tbl PO_TBL_NUMBER;

2712: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2713: d_position NUMBER;
2714:
2715: -- variable to hold derived result
2716: l_index_tbl PO_TBL_NUMBER;
2717: l_result_tbl PO_TBL_VARCHAR25;
2718: BEGIN
2719: d_position := 0;
2720:

Line 2801: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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

Line 2802: x_dest_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 2810: l_index_tbl PO_TBL_NUMBER;

2806: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2807: d_position NUMBER;
2808:
2809: -- variable to hold derived result
2810: l_index_tbl PO_TBL_NUMBER;
2811: l_result_tbl PO_TBL_NUMBER;
2812: BEGIN
2813: d_position := 0;
2814:

Line 2811: l_result_tbl PO_TBL_NUMBER;

2807: d_position NUMBER;
2808:
2809: -- variable to hold derived result
2810: l_index_tbl PO_TBL_NUMBER;
2811: l_result_tbl PO_TBL_NUMBER;
2812: BEGIN
2813: d_position := 0;
2814:
2815: IF (PO_LOG.d_proc) THEN

Line 2913: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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
2916: ) IS
2917:

Line 2915: x_wip_entity_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
2916: ) IS
2917:
2918: d_api_name CONSTANT VARCHAR2(30) := 'derive_wip_entity_id';
2919: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2923: l_index_tbl PO_TBL_NUMBER;

2919: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2920: d_position NUMBER;
2921:
2922: -- variable to hold derived result
2923: l_index_tbl PO_TBL_NUMBER;
2924: l_result_tbl PO_TBL_NUMBER;
2925: BEGIN
2926: d_position := 0;
2927:

Line 2924: l_result_tbl PO_TBL_NUMBER;

2920: d_position NUMBER;
2921:
2922: -- variable to hold derived result
2923: l_index_tbl PO_TBL_NUMBER;
2924: l_result_tbl PO_TBL_NUMBER;
2925: BEGIN
2926: d_position := 0;
2927:
2928: IF (PO_LOG.d_proc) THEN

Line 3014: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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
3017: ) IS
3018:

Line 3016: x_wip_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
3017: ) IS
3018:
3019: d_api_name CONSTANT VARCHAR2(30) := 'derive_wip_line_id';
3020: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3024: l_index_tbl PO_TBL_NUMBER;

3020: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3021: d_position NUMBER;
3022:
3023: -- variable to hold derived result
3024: l_index_tbl PO_TBL_NUMBER;
3025: l_result_tbl PO_TBL_NUMBER;
3026: BEGIN
3027: d_position := 0;
3028:

Line 3025: l_result_tbl PO_TBL_NUMBER;

3021: d_position NUMBER;
3022:
3023: -- variable to hold derived result
3024: l_index_tbl PO_TBL_NUMBER;
3025: l_result_tbl PO_TBL_NUMBER;
3026: BEGIN
3027: d_position := 0;
3028:
3029: IF (PO_LOG.d_proc) THEN

Line 3113: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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

Line 3114: p_txn_flow_header_id_tbl IN PO_TBL_NUMBER,

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
3117: ) IS
3118:

Line 3115: p_dest_charge_account_id_tbl IN PO_TBL_NUMBER,

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
3117: ) IS
3118:
3119: d_api_name CONSTANT VARCHAR2(30) := 'derive_ship_to_ou_coa_id';

Line 3116: x_ship_to_ou_coa_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
3117: ) IS
3118:
3119: d_api_name CONSTANT VARCHAR2(30) := 'derive_ship_to_ou_coa_id';
3120: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3124: l_index_tbl PO_TBL_NUMBER;

3120: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3121: d_position NUMBER;
3122:
3123: -- variable to hold derived result
3124: l_index_tbl PO_TBL_NUMBER;
3125: l_result_tbl PO_TBL_NUMBER;
3126: BEGIN
3127: d_position := 0;
3128:

Line 3125: l_result_tbl PO_TBL_NUMBER;

3121: d_position NUMBER;
3122:
3123: -- variable to hold derived result
3124: l_index_tbl PO_TBL_NUMBER;
3125: l_result_tbl PO_TBL_NUMBER;
3126: BEGIN
3127: d_position := 0;
3128:
3129: IF (PO_LOG.d_proc) THEN

Line 3219: p_dest_org_id_tbl IN PO_TBL_NUMBER,

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

Line 3220: x_bom_resource_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
3222:
3223: d_api_name CONSTANT VARCHAR2(30) := 'derive_bom_resource_id';
3224: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3228: l_index_tbl PO_TBL_NUMBER;

3224: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3225: d_position NUMBER;
3226:
3227: -- variable to hold derived result
3228: l_index_tbl PO_TBL_NUMBER;
3229: l_result_tbl PO_TBL_NUMBER;
3230: BEGIN
3231: d_position := 0;
3232:

Line 3229: l_result_tbl PO_TBL_NUMBER;

3225: d_position NUMBER;
3226:
3227: -- variable to hold derived result
3228: l_index_tbl PO_TBL_NUMBER;
3229: l_result_tbl PO_TBL_NUMBER;
3230: BEGIN
3231: d_position := 0;
3232:
3233: IF (PO_LOG.d_proc) THEN

Line 3786: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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,
3788: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3789: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3790: ) IS

Line 3787: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

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,
3788: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3789: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3790: ) IS
3791:

Line 3789: x_project_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 3797: l_index_tbl PO_TBL_NUMBER;

3793: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3794: d_position NUMBER;
3795:
3796: -- variable to hold derived result
3797: l_index_tbl PO_TBL_NUMBER;
3798: l_result_tbl PO_TBL_NUMBER;
3799: BEGIN
3800: d_position := 0;
3801:

Line 3798: l_result_tbl PO_TBL_NUMBER;

3794: d_position NUMBER;
3795:
3796: -- variable to hold derived result
3797: l_index_tbl PO_TBL_NUMBER;
3798: l_result_tbl PO_TBL_NUMBER;
3799: BEGIN
3800: d_position := 0;
3801:
3802: IF (PO_LOG.d_proc) THEN

Line 3909: p_project_id_tbl IN PO_TBL_NUMBER,

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,
3911: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3912: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3913: ) IS

Line 3910: p_ship_to_ou_id_tbl IN PO_TBL_NUMBER,

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,
3911: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3912: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3913: ) IS
3914:

Line 3912: x_task_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 3920: l_index_tbl PO_TBL_NUMBER;

3916: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3917: d_position NUMBER;
3918:
3919: -- variable to hold derived result
3920: l_index_tbl PO_TBL_NUMBER;
3921: l_result_tbl PO_TBL_NUMBER;
3922: BEGIN
3923: d_position := 0;
3924:

Line 3921: l_result_tbl PO_TBL_NUMBER;

3917: d_position NUMBER;
3918:
3919: -- variable to hold derived result
3920: l_index_tbl PO_TBL_NUMBER;
3921: l_result_tbl PO_TBL_NUMBER;
3922: BEGIN
3923: d_position := 0;
3924:
3925: IF (PO_LOG.d_proc) THEN

Line 4028: p_project_id_tbl IN PO_TBL_NUMBER,

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

Line 4038: l_index_tbl PO_TBL_NUMBER;

4034: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4035: d_position NUMBER;
4036:
4037: -- variable to hold derived result
4038: l_index_tbl PO_TBL_NUMBER;
4039: l_result_tbl PO_TBL_VARCHAR30;
4040: BEGIN
4041: d_position := 0;
4042:

Line 4128: p_project_id_tbl IN PO_TBL_NUMBER,

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

Line 4130: x_expenditure_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 4138: l_index_tbl PO_TBL_NUMBER;

4134: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4135: d_position NUMBER;
4136:
4137: -- variable to hold derived result
4138: l_index_tbl PO_TBL_NUMBER;
4139: l_result_tbl PO_TBL_NUMBER;
4140: BEGIN
4141: d_position := 0;
4142:

Line 4139: l_result_tbl PO_TBL_NUMBER;

4135: d_position NUMBER;
4136:
4137: -- variable to hold derived result
4138: l_index_tbl PO_TBL_NUMBER;
4139: l_result_tbl PO_TBL_NUMBER;
4140: BEGIN
4141: d_position := 0;
4142:
4143: IF (PO_LOG.d_proc) THEN

Line 4224: p_item_id_tbl IN PO_TBL_NUMBER,

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

Line 4225: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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

Line 4234: l_index_tbl PO_TBL_NUMBER;

4230: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4231: d_position NUMBER;
4232:
4233: -- variable to hold derived result
4234: l_index_tbl PO_TBL_NUMBER;
4235: l_result_tbl PO_TBL_VARCHAR1;
4236: BEGIN
4237: d_position := 0;
4238: