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_DOCUMENT_UPDATE_PVT dependencies on PO_CHANGES_REC_TYPE

Line 79: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

75: g_doc_style_id NUMBER;
76:
77: -- START Forward declarations for package private procedures:
78: PROCEDURE log_changes (
79: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
80: );
81:
82: PROCEDURE init_globals (
83: p_chg IN PO_CHANGES_REC_TYPE,

Line 83: p_chg IN PO_CHANGES_REC_TYPE,

79: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
80: );
81:
82: PROCEDURE init_globals (
83: p_chg IN PO_CHANGES_REC_TYPE,
84: p_update_source IN VARCHAR2
85: );
86:
87: PROCEDURE process_inputs (

Line 88: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

84: p_update_source IN VARCHAR2
85: );
86:
87: PROCEDURE process_inputs (
88: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: p_approval_background_flag IN VARCHAR2,
91: p_mass_update_releases IN VARCHAR2 -- Bug 3373453
92: );

Line 95: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

91: p_mass_update_releases IN VARCHAR2 -- Bug 3373453
92: );
93:
94: PROCEDURE preprocess_changes (
95: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
96: x_return_status OUT NOCOPY VARCHAR2
97: );
98:
99: PROCEDURE verify_inputs (

Line 100: p_chg IN PO_CHANGES_REC_TYPE,

96: x_return_status OUT NOCOPY VARCHAR2
97: );
98:
99: PROCEDURE verify_inputs (
100: p_chg IN PO_CHANGES_REC_TYPE,
101: x_return_status OUT NOCOPY VARCHAR2
102: );
103:
104: PROCEDURE check_type_specific_fields (

Line 105: p_chg IN PO_CHANGES_REC_TYPE,

101: x_return_status OUT NOCOPY VARCHAR2
102: );
103:
104: PROCEDURE check_type_specific_fields (
105: p_chg IN PO_CHANGES_REC_TYPE,
106: x_return_status OUT NOCOPY VARCHAR2
107: );
108:
109: PROCEDURE check_new_qty_price_amt (

Line 110: p_chg IN PO_CHANGES_REC_TYPE,

106: x_return_status OUT NOCOPY VARCHAR2
107: );
108:
109: PROCEDURE check_new_qty_price_amt (
110: p_chg IN PO_CHANGES_REC_TYPE,
111: p_entity_type IN VARCHAR2,
112: i IN NUMBER,
113: x_return_status OUT NOCOPY VARCHAR2
114: );

Line 117: p_chg IN PO_CHANGES_REC_TYPE,

113: x_return_status OUT NOCOPY VARCHAR2
114: );
115:
116: FUNCTION is_split_shipment_num_unique (
117: p_chg IN PO_CHANGES_REC_TYPE,
118: i IN NUMBER
119: ) RETURN BOOLEAN;
120:
121: FUNCTION line_has_qty_amt_change (

Line 122: p_chg IN PO_CHANGES_REC_TYPE,

118: i IN NUMBER
119: ) RETURN BOOLEAN;
120:
121: FUNCTION line_has_qty_amt_change (
122: p_chg IN PO_CHANGES_REC_TYPE,
123: i IN NUMBER
124: ) RETURN BOOLEAN;
125:
126: FUNCTION ship_has_qty_amt_change (

Line 127: p_chg IN PO_CHANGES_REC_TYPE,

123: i IN NUMBER
124: ) RETURN BOOLEAN;
125:
126: FUNCTION ship_has_qty_amt_change (
127: p_chg IN PO_CHANGES_REC_TYPE,
128: i IN NUMBER
129: ) RETURN BOOLEAN;
130:
131: FUNCTION dist_has_qty_amt_change (

Line 132: p_chg IN PO_CHANGES_REC_TYPE,

128: i IN NUMBER
129: ) RETURN BOOLEAN;
130:
131: FUNCTION dist_has_qty_amt_change (
132: p_chg IN PO_CHANGES_REC_TYPE,
133: i IN NUMBER
134: ) RETURN BOOLEAN;
135:
136: FUNCTION line_has_ship_qty_amt_change (

Line 137: p_chg IN PO_CHANGES_REC_TYPE,

133: i IN NUMBER
134: ) RETURN BOOLEAN;
135:
136: FUNCTION line_has_ship_qty_amt_change (
137: p_chg IN PO_CHANGES_REC_TYPE,
138: i IN NUMBER
139: ) RETURN BOOLEAN;
140:
141: FUNCTION ship_has_dist_qty_amt_change (

Line 142: p_chg IN PO_CHANGES_REC_TYPE,

138: i IN NUMBER
139: ) RETURN BOOLEAN;
140:
141: FUNCTION ship_has_dist_qty_amt_change (
142: p_chg IN PO_CHANGES_REC_TYPE,
143: i IN NUMBER
144: ) RETURN BOOLEAN;
145:
146: PROCEDURE derive_changes (

Line 147: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

143: i IN NUMBER
144: ) RETURN BOOLEAN;
145:
146: PROCEDURE derive_changes (
147: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
148: x_return_status OUT NOCOPY VARCHAR2
149: );
150:
151: PROCEDURE derive_secondary_quantity (

Line 152: p_chg IN PO_CHANGES_REC_TYPE,

148: x_return_status OUT NOCOPY VARCHAR2
149: );
150:
151: PROCEDURE derive_secondary_quantity (
152: p_chg IN PO_CHANGES_REC_TYPE,
153: p_entity_type IN VARCHAR2,
154: p_entity_id IN NUMBER,
155: x_derived_quantity2 OUT NOCOPY PO_LINES.secondary_quantity%TYPE,
156: x_return_status OUT NOCOPY VARCHAR2

Line 184: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

180: p_po_line_id IN PO_LINES.po_line_id%TYPE
181: ) RETURN NUMBER;
182:
183: PROCEDURE derive_qty_amt_rollups (
184: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
185: );
186:
187: PROCEDURE derive_qty_amt_rolldowns (
188: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

Line 188: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

184: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
185: );
186:
187: PROCEDURE derive_qty_amt_rolldowns (
188: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
189: );
190:
191: PROCEDURE validate_changes (
192: p_chg IN PO_CHANGES_REC_TYPE,

Line 192: p_chg IN PO_CHANGES_REC_TYPE,

188: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
189: );
190:
191: PROCEDURE validate_changes (
192: p_chg IN PO_CHANGES_REC_TYPE,
193: p_run_submission_checks IN VARCHAR2,
194: x_return_status OUT NOCOPY VARCHAR2,
195: p_req_chg_initiator IN VARCHAR2 DEFAULT NULL --Bug 14549341
196: );

Line 199: p_chg IN PO_CHANGES_REC_TYPE,

195: p_req_chg_initiator IN VARCHAR2 DEFAULT NULL --Bug 14549341
196: );
197:
198: PROCEDURE validate_line_changes (
199: p_chg IN PO_CHANGES_REC_TYPE,
200: x_return_status OUT NOCOPY VARCHAR2
201: );
202:
203: PROCEDURE validate_shipment_changes (

Line 204: p_chg IN PO_CHANGES_REC_TYPE,

200: x_return_status OUT NOCOPY VARCHAR2
201: );
202:
203: PROCEDURE validate_shipment_changes (
204: p_chg IN PO_CHANGES_REC_TYPE,
205: x_return_status OUT NOCOPY VARCHAR2
206: );
207:
208: PROCEDURE validate_distribution_changes (

Line 209: p_chg IN PO_CHANGES_REC_TYPE,

205: x_return_status OUT NOCOPY VARCHAR2
206: );
207:
208: PROCEDURE validate_distribution_changes (
209: p_chg IN PO_CHANGES_REC_TYPE,
210: x_return_status OUT NOCOPY VARCHAR2
211: );
212:
213: PROCEDURE apply_changes (

Line 214: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

210: x_return_status OUT NOCOPY VARCHAR2
211: );
212:
213: PROCEDURE apply_changes (
214: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
215: p_override_date IN DATE,
216: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
217: x_return_status OUT NOCOPY VARCHAR2
218: );

Line 221: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

217: x_return_status OUT NOCOPY VARCHAR2
218: );
219:
220: PROCEDURE create_split_shipments (
221: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
222: );
223:
224: PROCEDURE create_split_distributions (
225: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

Line 225: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

221: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
222: );
223:
224: PROCEDURE create_split_distributions (
225: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
226: );
227:
228: PROCEDURE delete_records (
229: p_chg IN PO_CHANGES_REC_TYPE

Line 229: p_chg IN PO_CHANGES_REC_TYPE

225: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
226: );
227:
228: PROCEDURE delete_records (
229: p_chg IN PO_CHANGES_REC_TYPE
230: );
231:
232: PROCEDURE calculate_taxes (
233: p_chg IN PO_CHANGES_REC_TYPE

Line 233: p_chg IN PO_CHANGES_REC_TYPE

229: p_chg IN PO_CHANGES_REC_TYPE
230: );
231:
232: PROCEDURE calculate_taxes (
233: p_chg IN PO_CHANGES_REC_TYPE
234: );
235: -- END Forward declarations for package private procedures
236:
237: -------------------------------------------------------------------------------

Line 326: p_changes IN OUT NOCOPY PO_CHANGES_REC_TYPE,

322: PROCEDURE update_document (
323: p_api_version IN NUMBER,
324: p_init_msg_list IN VARCHAR2,
325: x_return_status OUT NOCOPY VARCHAR2,
326: p_changes IN OUT NOCOPY PO_CHANGES_REC_TYPE,
327: p_run_submission_checks IN VARCHAR2,
328: p_launch_approvals_flag IN VARCHAR2,
329: p_buyer_id IN NUMBER,
330: p_update_source IN VARCHAR2,

Line 517: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

513: -- None.
514: --End of Comments
515: -------------------------------------------------------------------------------
516: PROCEDURE log_changes (
517: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
518: ) IS
519: BEGIN
520: IF (g_fnd_debug = 'Y')
521: AND (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 540: p_chg IN PO_CHANGES_REC_TYPE,

536: -- None.
537: --End of Comments
538: -------------------------------------------------------------------------------
539: PROCEDURE init_globals (
540: p_chg IN PO_CHANGES_REC_TYPE,
541: p_update_source IN VARCHAR2
542: ) IS
543: l_proc_name CONSTANT VARCHAR2(30) := 'INIT_GLOBALS';
544: l_result BOOLEAN;

Line 720: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

716: -- None.
717: --End of Comments
718: -------------------------------------------------------------------------------
719: PROCEDURE verify_document_ids (
720: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
721: x_return_status OUT NOCOPY VARCHAR2
722: ) IS
723: l_dummy NUMBER;
724: l_proc_name CONSTANT VARCHAR2(30) := 'VERIFY_DOCUMENT_IDS';

Line 941: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

937: -- Locks the document to be modified.
938: --End of Comments
939: -------------------------------------------------------------------------------
940: PROCEDURE process_inputs (
941: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
942: x_return_status OUT NOCOPY VARCHAR2,
943: p_approval_background_flag IN VARCHAR2,
944: p_mass_update_releases IN VARCHAR2 -- Bug 3373453
945: ) IS

Line 1131: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

1127: -- None.
1128: --End of Comments
1129: -------------------------------------------------------------------------------
1130: PROCEDURE populate_line_cached_fields (
1131: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
1132: i IN NUMBER
1133: ) IS
1134: l_org_id NUMBER;
1135: BEGIN

Line 1223: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

1219: -- None.
1220: --End of Comments
1221: -------------------------------------------------------------------------------
1222: PROCEDURE populate_ship_cached_fields (
1223: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
1224: i IN NUMBER
1225: ) IS
1226: l_parent_line_loc_id PO_LINE_LOCATIONS.line_location_id%TYPE;
1227: BEGIN

Line 1381: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

1377: -- None.
1378: --End of Comments
1379: -------------------------------------------------------------------------------
1380: PROCEDURE populate_dist_cached_fields (
1381: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
1382: i IN NUMBER
1383: ) IS
1384: l_parent_dist_id PO_DISTRIBUTIONS.po_distribution_id%TYPE;
1385: BEGIN

Line 1505: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

1501: -- None.
1502: --End of Comments
1503: -------------------------------------------------------------------------------
1504: PROCEDURE preprocess_changes (
1505: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
1506: x_return_status OUT NOCOPY VARCHAR2
1507: ) IS
1508: l_proc_name CONSTANT VARCHAR2(20) := 'PREPROCESS_CHANGES';
1509: l_progress VARCHAR2(3) := '000';

Line 1712: p_chg IN PO_CHANGES_REC_TYPE,

1708: -- document type); these checks should be placed in verify_inputs.
1709: --End of Comments
1710: -------------------------------------------------------------------------------
1711: PROCEDURE verify_inputs (
1712: p_chg IN PO_CHANGES_REC_TYPE,
1713: x_return_status OUT NOCOPY VARCHAR2
1714: ) IS
1715: l_proc_name CONSTANT VARCHAR2(30) := 'VERIFY_INPUTS';
1716: l_progress VARCHAR2(3) := '000';

Line 2204: p_chg IN PO_CHANGES_REC_TYPE,

2200: -- None.
2201: --End of Comments
2202: -------------------------------------------------------------------------------
2203: PROCEDURE check_type_specific_fields (
2204: p_chg IN PO_CHANGES_REC_TYPE,
2205: x_return_status OUT NOCOPY VARCHAR2
2206: ) IS
2207: l_proc_name CONSTANT VARCHAR2(30) := 'CHECK_TYPE_SPECIFIC_FIELDS';
2208: l_progress VARCHAR2(3) := '000';

Line 2629: p_chg IN PO_CHANGES_REC_TYPE,

2625: -- None.
2626: --End of Comments
2627: -------------------------------------------------------------------------------
2628: PROCEDURE check_new_qty_price_amt (
2629: p_chg IN PO_CHANGES_REC_TYPE,
2630: p_entity_type IN VARCHAR2,
2631: i IN NUMBER,
2632: x_return_status OUT NOCOPY VARCHAR2
2633: ) IS

Line 2758: p_chg IN PO_CHANGES_REC_TYPE,

2754: -- None.
2755: --End of Comments
2756: -------------------------------------------------------------------------------
2757: FUNCTION is_split_shipment_num_unique (
2758: p_chg IN PO_CHANGES_REC_TYPE,
2759: i IN NUMBER
2760: ) RETURN BOOLEAN IS
2761: l_po_line_id PO_LINES.po_line_id%TYPE;
2762: l_split_shipment_num PO_LINE_LOCATIONS.shipment_num%TYPE;

Line 2805: p_chg IN PO_CHANGES_REC_TYPE,

2801: -- None.
2802: --End of Comments
2803: -------------------------------------------------------------------------------
2804: FUNCTION line_has_qty_amt_change (
2805: p_chg IN PO_CHANGES_REC_TYPE,
2806: i IN NUMBER
2807: ) RETURN BOOLEAN IS
2808: BEGIN
2809: RETURN (p_chg.line_changes.quantity(i) IS NOT NULL)

Line 2833: p_chg IN PO_CHANGES_REC_TYPE,

2829: -- None.
2830: --End of Comments
2831: -------------------------------------------------------------------------------
2832: FUNCTION ship_has_qty_amt_change (
2833: p_chg IN PO_CHANGES_REC_TYPE,
2834: i IN NUMBER
2835: ) RETURN BOOLEAN IS
2836: BEGIN
2837: RETURN (p_chg.shipment_changes.quantity(i) IS NOT NULL)

Line 2862: p_chg IN PO_CHANGES_REC_TYPE,

2858: -- None.
2859: --End of Comments
2860: -------------------------------------------------------------------------------
2861: FUNCTION dist_has_qty_amt_change (
2862: p_chg IN PO_CHANGES_REC_TYPE,
2863: i IN NUMBER
2864: ) RETURN BOOLEAN IS
2865: BEGIN
2866: RETURN (p_chg.distribution_changes.quantity_ordered(i) IS NOT NULL)

Line 2890: p_chg IN PO_CHANGES_REC_TYPE,

2886: -- None.
2887: --End of Comments
2888: -------------------------------------------------------------------------------
2889: FUNCTION line_has_ship_qty_amt_change (
2890: p_chg IN PO_CHANGES_REC_TYPE,
2891: i IN NUMBER
2892: ) RETURN BOOLEAN IS
2893: l_po_line_id NUMBER;
2894: BEGIN

Line 2931: p_chg IN PO_CHANGES_REC_TYPE,

2927: -- None.
2928: --End of Comments
2929: -------------------------------------------------------------------------------
2930: FUNCTION ship_has_dist_qty_amt_change (
2931: p_chg IN PO_CHANGES_REC_TYPE,
2932: i IN NUMBER
2933: ) RETURN BOOLEAN IS
2934: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
2935: l_parent_line_loc_id PO_LINE_LOCATIONS.line_location_id%TYPE;

Line 2999: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

2995: -- None.
2996: --End of Comments
2997: -------------------------------------------------------------------------------
2998: PROCEDURE derive_changes (
2999: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
3000: x_return_status OUT NOCOPY VARCHAR2
3001:
3002:
3003: ) IS

Line 3874: p_chg IN PO_CHANGES_REC_TYPE,

3870: -- None.
3871: --End of Comments
3872: -------------------------------------------------------------------------------
3873: PROCEDURE derive_secondary_quantity (
3874: p_chg IN PO_CHANGES_REC_TYPE,
3875: p_entity_type IN VARCHAR2,
3876: p_entity_id IN NUMBER,
3877: x_derived_quantity2 OUT NOCOPY PO_LINES.secondary_quantity%TYPE,
3878: x_return_status OUT NOCOPY VARCHAR2

Line 4328: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

4324: -- None.
4325: --End of Comments
4326: -------------------------------------------------------------------------------
4327: PROCEDURE derive_qty_amt_rollups (
4328: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
4329: ) IS
4330: l_proc_name CONSTANT VARCHAR2(30) := 'DERIVE_QTY_AMT_ROLLUPS';
4331: l_progress VARCHAR2(3) := '000';
4332:

Line 4687: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

4683: -- None.
4684: --End of Comments
4685: -------------------------------------------------------------------------------
4686: PROCEDURE derive_qty_amt_rolldowns (
4687: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
4688: ) IS
4689: l_proc_name CONSTANT VARCHAR2(30) := 'DERIVE_QTY_AMT_ROLLDOWNS';
4690: l_progress VARCHAR2(3) := '000';
4691:

Line 5016: p_chg IN PO_CHANGES_REC_TYPE,

5012: -- None.
5013: --End of Comments
5014: -------------------------------------------------------------------------------
5015: PROCEDURE validate_changes (
5016: p_chg IN PO_CHANGES_REC_TYPE,
5017: p_run_submission_checks IN VARCHAR2,
5018: x_return_status OUT NOCOPY VARCHAR2,
5019: p_req_chg_initiator IN VARCHAR2 DEFAULT NULL --Bug 14549341
5020: ) IS

Line 5177: p_chg IN PO_CHANGES_REC_TYPE,

5173: -- None.
5174: --End of Comments
5175: -------------------------------------------------------------------------------
5176: PROCEDURE validate_line_changes (
5177: p_chg IN PO_CHANGES_REC_TYPE,
5178: x_return_status OUT NOCOPY VARCHAR2
5179: ) IS
5180: l_proc_name CONSTANT VARCHAR2(30) := 'VALIDATE_LINE_CHANGES';
5181: l_progress VARCHAR2(3) := '000';

Line 5731: p_chg IN PO_CHANGES_REC_TYPE,

5727: -- None.
5728: --End of Comments
5729: -------------------------------------------------------------------------------
5730: PROCEDURE validate_shipment_changes (
5731: p_chg IN PO_CHANGES_REC_TYPE,
5732: x_return_status OUT NOCOPY VARCHAR2
5733: ) IS
5734:
5735: /* sschinch 09/08/04 begin INVCONV */

Line 6295: p_chg IN PO_CHANGES_REC_TYPE,

6291: -- None.
6292: --End of Comments
6293: -------------------------------------------------------------------------------
6294: PROCEDURE validate_distribution_changes (
6295: p_chg IN PO_CHANGES_REC_TYPE,
6296: x_return_status OUT NOCOPY VARCHAR2
6297: ) IS
6298: l_proc_name CONSTANT VARCHAR2(30) := 'VALIDATE_DISTRIBUTION_CHANGES';
6299: l_progress VARCHAR2(3) := '000';

Line 6616: ( p_chg IN PO_CHANGES_REC_TYPE,

6612: -- None.
6613: --End of Comments
6614: -------------------------------------------------------------------------------
6615: PROCEDURE unreserve
6616: ( p_chg IN PO_CHANGES_REC_TYPE,
6617: p_override_date IN DATE,
6618: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
6619: x_return_status OUT NOCOPY VARCHAR2
6620: ) IS

Line 6732: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

6728: -- None.
6729: --End of Comments
6730: -------------------------------------------------------------------------------
6731: PROCEDURE apply_changes (
6732: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
6733: p_override_date IN DATE,
6734: p_buyer_id IN PO_HEADERS.agent_id%TYPE,
6735: x_return_status OUT NOCOPY VARCHAR2
6736: ) IS

Line 7210: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

7206: -- None.
7207: --End of Comments
7208: -------------------------------------------------------------------------------
7209: PROCEDURE create_split_shipments (
7210: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
7211: ) IS
7212: l_proc_name CONSTANT VARCHAR2(30) := 'CREATE_SPLIT_SHIPMENTS';
7213: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
7214: l_parent_line_loc_id PO_LINE_LOCATIONS.line_location_id%TYPE;

Line 7612: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE

7608: -- None.
7609: --End of Comments
7610: -------------------------------------------------------------------------------
7611: PROCEDURE create_split_distributions (
7612: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE
7613: ) IS
7614: l_proc_name CONSTANT VARCHAR2(30) := 'CREATE_SPLIT_DISTRIBUTIONS';
7615: l_module CONSTANT VARCHAR2(80) := g_module_prefix || l_proc_name;
7616: l_progress VARCHAR2(3) := '000';

Line 8007: p_chg IN PO_CHANGES_REC_TYPE

8003: -- None.
8004: --End of Comments
8005: -------------------------------------------------------------------------------
8006: PROCEDURE delete_records (
8007: p_chg IN PO_CHANGES_REC_TYPE
8008: ) IS
8009: l_proc_name CONSTANT VARCHAR2(30) := 'DELETE_RECORDS';
8010: l_module CONSTANT VARCHAR2(80) := g_module_prefix || l_proc_name;
8011: l_progress VARCHAR2(3) := '000';

Line 8125: p_chg IN PO_CHANGES_REC_TYPE

8121: -- None.
8122: --End of Comments
8123: -------------------------------------------------------------------------------
8124: PROCEDURE calculate_taxes (
8125: p_chg IN PO_CHANGES_REC_TYPE
8126: ) IS
8127:
8128: BEGIN
8129: NULL;

Line 8365: p_chg IN PO_CHANGES_REC_TYPE,

8361: -- None.
8362: --End of Comments
8363: -------------------------------------------------------------------------------
8364: PROCEDURE add_line_change_to_index (
8365: p_chg IN PO_CHANGES_REC_TYPE,
8366: i IN NUMBER
8367: ) IS
8368: l_po_line_id NUMBER;
8369: BEGIN

Line 8400: p_chg IN PO_CHANGES_REC_TYPE,

8396: -- None.
8397: --End of Comments
8398: -------------------------------------------------------------------------------
8399: PROCEDURE add_ship_change_to_index (
8400: p_chg IN PO_CHANGES_REC_TYPE,
8401: i IN NUMBER
8402: ) IS
8403: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;
8404: l_po_line_id PO_LINES.po_line_id%TYPE;

Line 8451: p_chg IN PO_CHANGES_REC_TYPE,

8447: -- None.
8448: --End of Comments
8449: -------------------------------------------------------------------------------
8450: PROCEDURE add_dist_change_to_index (
8451: p_chg IN PO_CHANGES_REC_TYPE,
8452: i IN NUMBER
8453: ) IS
8454: l_po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE;
8455: l_line_location_id PO_LINE_LOCATIONS.line_location_id%TYPE;

Line 8531: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

8527: -- get_line_change returns NULL, while find_line_change creates a new change.
8528: --End of Comments
8529: -------------------------------------------------------------------------------
8530: FUNCTION find_line_change (
8531: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
8532: p_po_line_id IN PO_LINES.po_line_id%TYPE
8533: ) RETURN NUMBER IS
8534: i NUMBER;
8535: BEGIN

Line 8591: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

8587: -- None.
8588: --End of Comments
8589: -------------------------------------------------------------------------------
8590: FUNCTION find_ship_change (
8591: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
8592: p_line_location_id IN PO_LINE_LOCATIONS.line_location_id%TYPE
8593: ) RETURN NUMBER IS
8594: i NUMBER;
8595: BEGIN

Line 8651: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

8647: -- None.
8648: --End of Comments
8649: -------------------------------------------------------------------------------
8650: FUNCTION find_dist_change (
8651: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
8652: p_po_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE
8653: ) RETURN NUMBER IS
8654: i NUMBER;
8655: BEGIN

Line 8684: p_chg IN PO_CHANGES_REC_TYPE,

8680: -- None.
8681: --End of Comments
8682: -------------------------------------------------------------------------------
8683: FUNCTION get_split_ship_change (
8684: p_chg IN PO_CHANGES_REC_TYPE,
8685: p_po_line_id IN PO_LINES.po_line_id%TYPE,
8686: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8687: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8688: ) RETURN NUMBER IS

Line 8725: p_chg IN PO_CHANGES_REC_TYPE,

8721: -- None.
8722: --End of Comments
8723: -------------------------------------------------------------------------------
8724: FUNCTION get_split_dist_change (
8725: p_chg IN PO_CHANGES_REC_TYPE,
8726: p_parent_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE,
8727: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8728: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8729: ) RETURN NUMBER IS

Line 8767: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,

8763: -- None.
8764: --End of Comments
8765: -------------------------------------------------------------------------------
8766: FUNCTION find_split_dist_change (
8767: p_chg IN OUT NOCOPY PO_CHANGES_REC_TYPE,
8768: p_parent_distribution_id IN PO_DISTRIBUTIONS.po_distribution_id%TYPE,
8769: p_parent_line_loc_id IN PO_LINE_LOCATIONS.line_location_id%TYPE,
8770: p_split_shipment_num IN PO_LINE_LOCATIONS.shipment_num%TYPE
8771: ) RETURN NUMBER IS