[Home] [Help]
71: g_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;
72:
73: -- START Forward declarations for package private procedures:
74: PROCEDURE log_changes (
75: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
76: );
77:
78: PROCEDURE init_globals (
79: p_chg IN PO_CHANGES_REC_TYPE,
75: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
76: );
77:
78: PROCEDURE init_globals (
79: p_chg IN PO_CHANGES_REC_TYPE,
80: p_update_source IN VARCHAR2
81: );
82:
83: PROCEDURE process_inputs (
80: p_update_source IN VARCHAR2
81: );
82:
83: PROCEDURE process_inputs (
84: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: p_approval_background_flag IN VARCHAR2,
87: p_mass_update_releases IN VARCHAR2 -- Bug 3373453
88: );
87: p_mass_update_releases IN VARCHAR2 -- Bug 3373453
88: );
89:
90: PROCEDURE preprocess_changes (
91: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
92: x_return_status OUT NOCOPY VARCHAR2
93: );
94:
95: PROCEDURE verify_inputs (
92: x_return_status OUT NOCOPY VARCHAR2
93: );
94:
95: PROCEDURE verify_inputs (
96: p_chg IN PO_CHANGES_REC_TYPE,
97: x_return_status OUT NOCOPY VARCHAR2
98: );
99:
100: PROCEDURE check_type_specific_fields (
97: x_return_status OUT NOCOPY VARCHAR2
98: );
99:
100: PROCEDURE check_type_specific_fields (
101: p_chg IN PO_CHANGES_REC_TYPE,
102: x_return_status OUT NOCOPY VARCHAR2
103: );
104:
105: PROCEDURE check_new_qty_price_amt (
102: x_return_status OUT NOCOPY VARCHAR2
103: );
104:
105: PROCEDURE check_new_qty_price_amt (
106: p_chg IN PO_CHANGES_REC_TYPE,
107: p_entity_type IN VARCHAR2,
108: i IN NUMBER,
109: x_return_status OUT NOCOPY VARCHAR2
110: );
109: x_return_status OUT NOCOPY VARCHAR2
110: );
111:
112: FUNCTION is_split_shipment_num_unique (
113: p_chg IN PO_CHANGES_REC_TYPE,
114: i IN NUMBER
115: ) RETURN BOOLEAN;
116:
117: FUNCTION line_has_qty_amt_change (
114: i IN NUMBER
115: ) RETURN BOOLEAN;
116:
117: FUNCTION line_has_qty_amt_change (
118: p_chg IN PO_CHANGES_REC_TYPE,
119: i IN NUMBER
120: ) RETURN BOOLEAN;
121:
122: FUNCTION ship_has_qty_amt_change (
119: i IN NUMBER
120: ) RETURN BOOLEAN;
121:
122: FUNCTION ship_has_qty_amt_change (
123: p_chg IN PO_CHANGES_REC_TYPE,
124: i IN NUMBER
125: ) RETURN BOOLEAN;
126:
127: FUNCTION dist_has_qty_amt_change (
124: i IN NUMBER
125: ) RETURN BOOLEAN;
126:
127: FUNCTION dist_has_qty_amt_change (
128: p_chg IN PO_CHANGES_REC_TYPE,
129: i IN NUMBER
130: ) RETURN BOOLEAN;
131:
132: FUNCTION line_has_ship_qty_amt_change (
129: i IN NUMBER
130: ) RETURN BOOLEAN;
131:
132: FUNCTION line_has_ship_qty_amt_change (
133: p_chg IN PO_CHANGES_REC_TYPE,
134: i IN NUMBER
135: ) RETURN BOOLEAN;
136:
137: FUNCTION ship_has_dist_qty_amt_change (
134: i IN NUMBER
135: ) RETURN BOOLEAN;
136:
137: FUNCTION ship_has_dist_qty_amt_change (
138: p_chg IN PO_CHANGES_REC_TYPE,
139: i IN NUMBER
140: ) RETURN BOOLEAN;
141:
142: PROCEDURE derive_changes (
139: i IN NUMBER
140: ) RETURN BOOLEAN;
141:
142: PROCEDURE derive_changes (
143: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
144: x_return_status OUT NOCOPY VARCHAR2
145: );
146:
147: PROCEDURE derive_secondary_quantity (
144: x_return_status OUT NOCOPY VARCHAR2
145: );
146:
147: PROCEDURE derive_secondary_quantity (
148: p_chg IN PO_CHANGES_REC_TYPE,
149: p_entity_type IN VARCHAR2,
150: p_entity_id IN NUMBER,
151: x_derived_quantity2 OUT NOCOPY PO_LINES.secondary_quantity%TYPE,
152: x_return_status OUT NOCOPY VARCHAR2
176: p_po_line_id IN PO_LINES.po_line_id%TYPE
177: ) RETURN NUMBER;
178:
179: PROCEDURE derive_qty_amt_rollups (
180: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
181: );
182:
183: PROCEDURE derive_qty_amt_rolldowns (
184: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
180: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
181: );
182:
183: PROCEDURE derive_qty_amt_rolldowns (
184: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
185: );
186:
187: PROCEDURE validate_changes (
188: p_chg IN PO_CHANGES_REC_TYPE,
184: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
185: );
186:
187: PROCEDURE validate_changes (
188: p_chg IN PO_CHANGES_REC_TYPE,
189: p_run_submission_checks IN VARCHAR2,
190: x_return_status OUT NOCOPY VARCHAR2
191: );
192:
190: x_return_status OUT NOCOPY VARCHAR2
191: );
192:
193: PROCEDURE validate_line_changes (
194: p_chg IN PO_CHANGES_REC_TYPE,
195: x_return_status OUT NOCOPY VARCHAR2
196: );
197:
198: PROCEDURE validate_shipment_changes (
195: x_return_status OUT NOCOPY VARCHAR2
196: );
197:
198: PROCEDURE validate_shipment_changes (
199: p_chg IN PO_CHANGES_REC_TYPE,
200: x_return_status OUT NOCOPY VARCHAR2
201: );
202:
203: PROCEDURE validate_distribution_changes (
200: x_return_status OUT NOCOPY VARCHAR2
201: );
202:
203: PROCEDURE validate_distribution_changes (
204: p_chg IN PO_CHANGES_REC_TYPE,
205: x_return_status OUT NOCOPY VARCHAR2
206: );
207:
208: PROCEDURE apply_changes (
205: x_return_status OUT NOCOPY VARCHAR2
206: );
207:
208: PROCEDURE apply_changes (
209: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
210: p_override_date IN DATE,
211: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
212: x_return_status OUT NOCOPY VARCHAR2
213: );
212: x_return_status OUT NOCOPY VARCHAR2
213: );
214:
215: PROCEDURE create_split_shipments (
216: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
217: );
218:
219: PROCEDURE create_split_distributions (
220: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
216: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
217: );
218:
219: PROCEDURE create_split_distributions (
220: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
221: );
222:
223: PROCEDURE delete_records (
224: p_chg IN PO_CHANGES_REC_TYPE
220: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
221: );
222:
223: PROCEDURE delete_records (
224: p_chg IN PO_CHANGES_REC_TYPE
225: );
226:
227: PROCEDURE calculate_taxes (
228: p_chg IN PO_CHANGES_REC_TYPE
224: p_chg IN PO_CHANGES_REC_TYPE
225: );
226:
227: PROCEDURE calculate_taxes (
228: p_chg IN PO_CHANGES_REC_TYPE
229: );
230: -- END Forward declarations for package private procedures
231:
232: -------------------------------------------------------------------------------
317: PROCEDURE update_document (
318: p_api_version IN NUMBER,
319: p_init_msg_list IN VARCHAR2,
320: x_return_status OUT NOCOPY VARCHAR2,
321: p_changes IN OUT NOCOPY PO_CHANGES_REC_TYPE,
322: p_run_submission_checks IN VARCHAR2,
323: p_launch_approvals_flag IN VARCHAR2,
324: p_buyer_id IN NUMBER,
325: p_update_source IN VARCHAR2,
506: -- None.
507: --End of Comments
508: -------------------------------------------------------------------------------
509: PROCEDURE log_changes (
510: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
511: ) IS
512: BEGIN
513: IF (g_fnd_debug = 'Y')
514: AND (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
529: -- None.
530: --End of Comments
531: -------------------------------------------------------------------------------
532: PROCEDURE init_globals (
533: p_chg IN PO_CHANGES_REC_TYPE,
534: p_update_source IN VARCHAR2
535: ) IS
536: l_proc_name CONSTANT VARCHAR2(30) := 'INIT_GLOBALS';
537: l_result BOOLEAN;
702: -- None.
703: --End of Comments
704: -------------------------------------------------------------------------------
705: PROCEDURE verify_document_ids (
706: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
707: x_return_status OUT NOCOPY VARCHAR2
708: ) IS
709: l_dummy NUMBER;
710: l_proc_name CONSTANT VARCHAR2(30) := 'VERIFY_DOCUMENT_IDS';
923: -- Locks the document to be modified.
924: --End of Comments
925: -------------------------------------------------------------------------------
926: PROCEDURE process_inputs (
927: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
928: x_return_status OUT NOCOPY VARCHAR2,
929: p_approval_background_flag IN VARCHAR2,
930: p_mass_update_releases IN VARCHAR2 -- Bug 3373453
931: ) IS
1104: -- None.
1105: --End of Comments
1106: -------------------------------------------------------------------------------
1107: PROCEDURE populate_line_cached_fields (
1108: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
1109: i IN NUMBER
1110: ) IS
1111: l_org_id NUMBER;
1112: BEGIN
1196: -- None.
1197: --End of Comments
1198: -------------------------------------------------------------------------------
1199: PROCEDURE populate_ship_cached_fields (
1200: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
1201: i IN NUMBER
1202: ) IS
1203: l_parent_line_loc_id PO_LINE_LOCATIONS.line_location_id%TYPE;
1204: BEGIN
1354: -- None.
1355: --End of Comments
1356: -------------------------------------------------------------------------------
1357: PROCEDURE populate_dist_cached_fields (
1358: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
1359: i IN NUMBER
1360: ) IS
1361: l_parent_dist_id PO_DISTRIBUTIONS.po_distribution_id%TYPE;
1362: BEGIN
1478: -- None.
1479: --End of Comments
1480: -------------------------------------------------------------------------------
1481: PROCEDURE preprocess_changes (
1482: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
1483: x_return_status OUT NOCOPY VARCHAR2
1484: ) IS
1485: l_proc_name CONSTANT VARCHAR2(20) := 'PREPROCESS_CHANGES';
1486: l_progress VARCHAR2(3) := '000';
1685: -- document type); these checks should be placed in verify_inputs.
1686: --End of Comments
1687: -------------------------------------------------------------------------------
1688: PROCEDURE verify_inputs (
1689: p_chg IN PO_CHANGES_REC_TYPE,
1690: x_return_status OUT NOCOPY VARCHAR2
1691: ) IS
1692: l_proc_name CONSTANT VARCHAR2(30) := 'VERIFY_INPUTS';
1693: l_progress VARCHAR2(3) := '000';
2177: -- None.
2178: --End of Comments
2179: -------------------------------------------------------------------------------
2180: PROCEDURE check_type_specific_fields (
2181: p_chg IN PO_CHANGES_REC_TYPE,
2182: x_return_status OUT NOCOPY VARCHAR2
2183: ) IS
2184: l_proc_name CONSTANT VARCHAR2(30) := 'CHECK_TYPE_SPECIFIC_FIELDS';
2185: l_progress VARCHAR2(3) := '000';
2602: -- None.
2603: --End of Comments
2604: -------------------------------------------------------------------------------
2605: PROCEDURE check_new_qty_price_amt (
2606: p_chg IN PO_CHANGES_REC_TYPE,
2607: p_entity_type IN VARCHAR2,
2608: i IN NUMBER,
2609: x_return_status OUT NOCOPY VARCHAR2
2610: ) IS
2731: -- None.
2732: --End of Comments
2733: -------------------------------------------------------------------------------
2734: FUNCTION is_split_shipment_num_unique (
2735: p_chg IN PO_CHANGES_REC_TYPE,
2736: i IN NUMBER
2737: ) RETURN BOOLEAN IS
2738: l_po_line_id PO_LINES.po_line_id%TYPE;
2739: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;
2778: -- None.
2779: --End of Comments
2780: -------------------------------------------------------------------------------
2781: FUNCTION line_has_qty_amt_change (
2782: p_chg IN PO_CHANGES_REC_TYPE,
2783: i IN NUMBER
2784: ) RETURN BOOLEAN IS
2785: BEGIN
2786: RETURN (p_chg.line_changes.quantity(i) IS NOT NULL)
2806: -- None.
2807: --End of Comments
2808: -------------------------------------------------------------------------------
2809: FUNCTION ship_has_qty_amt_change (
2810: p_chg IN PO_CHANGES_REC_TYPE,
2811: i IN NUMBER
2812: ) RETURN BOOLEAN IS
2813: BEGIN
2814: RETURN (p_chg.shipment_changes.quantity(i) IS NOT NULL)
2835: -- None.
2836: --End of Comments
2837: -------------------------------------------------------------------------------
2838: FUNCTION dist_has_qty_amt_change (
2839: p_chg IN PO_CHANGES_REC_TYPE,
2840: i IN NUMBER
2841: ) RETURN BOOLEAN IS
2842: BEGIN
2843: RETURN (p_chg.distribution_changes.quantity_ordered(i) IS NOT NULL)
2863: -- None.
2864: --End of Comments
2865: -------------------------------------------------------------------------------
2866: FUNCTION line_has_ship_qty_amt_change (
2867: p_chg IN PO_CHANGES_REC_TYPE,
2868: i IN NUMBER
2869: ) RETURN BOOLEAN IS
2870: l_po_line_id NUMBER;
2871: BEGIN
2904: -- None.
2905: --End of Comments
2906: -------------------------------------------------------------------------------
2907: FUNCTION ship_has_dist_qty_amt_change (
2908: p_chg IN PO_CHANGES_REC_TYPE,
2909: i IN NUMBER
2910: ) RETURN BOOLEAN IS
2911: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
2912: l_parent_line_loc_id PO_LINE_LOCATIONS.line_location_id%TYPE;
2972: -- None.
2973: --End of Comments
2974: -------------------------------------------------------------------------------
2975: PROCEDURE derive_changes (
2976: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
2977: x_return_status OUT NOCOPY VARCHAR2
2978:
2979:
2980: ) IS
3833: -- None.
3834: --End of Comments
3835: -------------------------------------------------------------------------------
3836: PROCEDURE derive_secondary_quantity (
3837: p_chg IN PO_CHANGES_REC_TYPE,
3838: p_entity_type IN VARCHAR2,
3839: p_entity_id IN NUMBER,
3840: x_derived_quantity2 OUT NOCOPY PO_LINES.secondary_quantity%TYPE,
3841: x_return_status OUT NOCOPY VARCHAR2
4287: -- None.
4288: --End of Comments
4289: -------------------------------------------------------------------------------
4290: PROCEDURE derive_qty_amt_rollups (
4291: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
4292: ) IS
4293: l_proc_name CONSTANT VARCHAR2(30) := 'DERIVE_QTY_AMT_ROLLUPS';
4294: l_progress VARCHAR2(3) := '000';
4295:
4646: -- None.
4647: --End of Comments
4648: -------------------------------------------------------------------------------
4649: PROCEDURE derive_qty_amt_rolldowns (
4650: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
4651: ) IS
4652: l_proc_name CONSTANT VARCHAR2(30) := 'DERIVE_QTY_AMT_ROLLDOWNS';
4653: l_progress VARCHAR2(3) := '000';
4654:
4975: -- None.
4976: --End of Comments
4977: -------------------------------------------------------------------------------
4978: PROCEDURE validate_changes (
4979: p_chg IN PO_CHANGES_REC_TYPE,
4980: p_run_submission_checks IN VARCHAR2,
4981: x_return_status OUT NOCOPY VARCHAR2
4982: ) IS
4983: l_proc_name CONSTANT VARCHAR2(30) := 'VALIDATE_CHANGES';
5134: -- None.
5135: --End of Comments
5136: -------------------------------------------------------------------------------
5137: PROCEDURE validate_line_changes (
5138: p_chg IN PO_CHANGES_REC_TYPE,
5139: x_return_status OUT NOCOPY VARCHAR2
5140: ) IS
5141: l_proc_name CONSTANT VARCHAR2(30) := 'VALIDATE_LINE_CHANGES';
5142: l_progress VARCHAR2(3) := '000';
5682: -- None.
5683: --End of Comments
5684: -------------------------------------------------------------------------------
5685: PROCEDURE validate_shipment_changes (
5686: p_chg IN PO_CHANGES_REC_TYPE,
5687: x_return_status OUT NOCOPY VARCHAR2
5688: ) IS
5689:
5690: /* sschinch 09/08/04 begin INVCONV */
6241: -- None.
6242: --End of Comments
6243: -------------------------------------------------------------------------------
6244: PROCEDURE validate_distribution_changes (
6245: p_chg IN PO_CHANGES_REC_TYPE,
6246: x_return_status OUT NOCOPY VARCHAR2
6247: ) IS
6248: l_proc_name CONSTANT VARCHAR2(30) := 'VALIDATE_DISTRIBUTION_CHANGES';
6249: l_progress VARCHAR2(3) := '000';
6556: -- None.
6557: --End of Comments
6558: -------------------------------------------------------------------------------
6559: PROCEDURE unreserve
6560: ( p_chg IN PO_CHANGES_REC_TYPE,
6561: p_override_date IN DATE,
6562: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
6563: x_return_status OUT NOCOPY VARCHAR2
6564: ) IS
6672: -- None.
6673: --End of Comments
6674: -------------------------------------------------------------------------------
6675: PROCEDURE apply_changes (
6676: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
6677: p_override_date IN DATE,
6678: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
6679: x_return_status OUT NOCOPY VARCHAR2
6680: ) IS
7094: -- None.
7095: --End of Comments
7096: -------------------------------------------------------------------------------
7097: PROCEDURE create_split_shipments (
7098: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
7099: ) IS
7100: l_proc_name CONSTANT VARCHAR2(30) := 'CREATE_SPLIT_SHIPMENTS';
7101: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
7102: l_parent_line_loc_id PO_LINE_LOCATIONS.line_location_id%TYPE;
7496: -- None.
7497: --End of Comments
7498: -------------------------------------------------------------------------------
7499: PROCEDURE create_split_distributions (
7500: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
7501: ) IS
7502: l_proc_name CONSTANT VARCHAR2(30) := 'CREATE_SPLIT_DISTRIBUTIONS';
7503: l_module CONSTANT VARCHAR2(80) := g_module_prefix || l_proc_name;
7504: l_progress VARCHAR2(3) := '000';
7891: -- None.
7892: --End of Comments
7893: -------------------------------------------------------------------------------
7894: PROCEDURE delete_records (
7895: p_chg IN PO_CHANGES_REC_TYPE
7896: ) IS
7897: l_proc_name CONSTANT VARCHAR2(30) := 'DELETE_RECORDS';
7898: l_module CONSTANT VARCHAR2(80) := g_module_prefix || l_proc_name;
7899: l_progress VARCHAR2(3) := '000';
7986: -- None.
7987: --End of Comments
7988: -------------------------------------------------------------------------------
7989: PROCEDURE calculate_taxes (
7990: p_chg IN PO_CHANGES_REC_TYPE
7991: ) IS
7992:
7993: BEGIN
7994: NULL;
8226: -- None.
8227: --End of Comments
8228: -------------------------------------------------------------------------------
8229: PROCEDURE add_line_change_to_index (
8230: p_chg IN PO_CHANGES_REC_TYPE,
8231: i IN NUMBER
8232: ) IS
8233: l_po_line_id NUMBER;
8234: BEGIN
8261: -- None.
8262: --End of Comments
8263: -------------------------------------------------------------------------------
8264: PROCEDURE add_ship_change_to_index (
8265: p_chg IN PO_CHANGES_REC_TYPE,
8266: i IN NUMBER
8267: ) IS
8268: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
8269: l_po_line_id PO_LINES.po_line_id%TYPE;
8312: -- None.
8313: --End of Comments
8314: -------------------------------------------------------------------------------
8315: PROCEDURE add_dist_change_to_index (
8316: p_chg IN PO_CHANGES_REC_TYPE,
8317: i IN NUMBER
8318: ) IS
8319: l_po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE;
8320: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
8392: -- get_line_change returns NULL, while find_line_change creates a new change.
8393: --End of Comments
8394: -------------------------------------------------------------------------------
8395: FUNCTION find_line_change (
8396: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
8397: p_po_line_id IN PO_LINES.po_line_id%TYPE
8398: ) RETURN NUMBER IS
8399: i NUMBER;
8400: BEGIN
8452: -- None.
8453: --End of Comments
8454: -------------------------------------------------------------------------------
8455: FUNCTION find_ship_change (
8456: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
8457: p_line_location_id IN PO_LINE_LOCATIONS.line_location_id%TYPE
8458: ) RETURN NUMBER IS
8459: i NUMBER;
8460: BEGIN
8512: -- None.
8513: --End of Comments
8514: -------------------------------------------------------------------------------
8515: FUNCTION find_dist_change (
8516: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
8517: p_po_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE
8518: ) RETURN NUMBER IS
8519: i NUMBER;
8520: BEGIN
8545: -- None.
8546: --End of Comments
8547: -------------------------------------------------------------------------------
8548: FUNCTION get_split_ship_change (
8549: p_chg IN PO_CHANGES_REC_TYPE,
8550: p_po_line_id IN PO_LINES.po_line_id%TYPE,
8551: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8552: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8553: ) RETURN NUMBER IS
8586: -- None.
8587: --End of Comments
8588: -------------------------------------------------------------------------------
8589: FUNCTION get_split_dist_change (
8590: p_chg IN PO_CHANGES_REC_TYPE,
8591: p_parent_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE,
8592: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8593: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8594: ) RETURN NUMBER IS
8628: -- None.
8629: --End of Comments
8630: -------------------------------------------------------------------------------
8631: FUNCTION find_split_dist_change (
8632: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
8633: p_parent_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE,
8634: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8635: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8636: ) RETURN NUMBER IS