DBA Data[Home] [Help]

APPS.RCV_ROI_HEADER dependencies on RCV_ROI_PREPROCESSOR

Line 11: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

7: x_count NUMBER := 0;
8: x_in_this_op_unit NUMBER := 0; -- Bug 3359613
9:
10: PROCEDURE process_header(
11: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
12: ) IS
13: BEGIN
14: NULL;
15: END process_header;

Line 18: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

14: NULL;
15: END process_header;
16:
17: PROCEDURE process_cancellation(
18: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
19: ) IS
20: BEGIN
21: asn_debug.put_line('new_roi: in process_cancellation');
22: derive_vendor_header(p_header_record);

Line 52: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

48: END IF;
49: END process_cancellation;
50:
51: PROCEDURE process_vendor_header(
52: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
53: ) IS
54: l_shipment_header_id NUMBER;
55: l_receive_against_asn VARCHAR2(1) := 'N';
56: BEGIN

Line 131: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

127: END IF;
128: END process_vendor_header;
129:
130: PROCEDURE process_customer_header(
131: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
132: ) IS
133: BEGIN
134: asn_debug.put_line('new_roi: in process_customer_header');
135: rcv_rma_headers.derive_rma_header(p_header_record);

Line 165: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

161: END IF;
162: END process_customer_header;
163:
164: PROCEDURE process_internal_header(
165: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
166: ) IS
167: BEGIN
168: asn_debug.put_line('new_roi: in process_internal_header');
169: END process_internal_header;

Line 172: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

168: asn_debug.put_line('new_roi: in process_internal_header');
169: END process_internal_header;
170:
171: PROCEDURE process_internal_order_header(
172: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
173: ) IS
174: BEGIN
175: asn_debug.put_line('new_roi: in process_internal_order_header');
176: derive_internal_order_header(p_header_record);

Line 204: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

200: END IF;
201: END process_internal_order_header;
202:
203: PROCEDURE derive_vendor_header(
204: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
205: ) IS
206: BEGIN
207: -- Note.: the derive receipt source code was not done. DO we need it ??
208: --??? (RCVHISVB : lines 593 - 600)

Line 221: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

217: derive_shipment_header_id(p_header_record);
218: END derive_vendor_header;
219:
220: PROCEDURE default_vendor_header(
221: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
222: ) IS
223: BEGIN
224: rcv_roi_header_common.default_last_update_info(p_header_record);
225: rcv_roi_header_common.default_creation_info(p_header_record);

Line 277: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

273: END IF;
274: END default_vendor_header;
275:
276: PROCEDURE validate_vendor_header(
277: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
278: ) IS
279: BEGIN
280: rcv_roi_header_common.validate_trx_type(p_header_record);
281: validate_document_type(p_header_record);

Line 335: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

331: END IF;
332: END validate_vendor_header;
333:
334: PROCEDURE derive_customer_header(
335: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
336: ) IS
337: BEGIN
338: NULL;
339: END derive_customer_header;

Line 342: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

338: NULL;
339: END derive_customer_header;
340:
341: PROCEDURE default_customer_header(
342: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
343: ) IS
344: BEGIN
345: NULL;
346: END default_customer_header;

Line 349: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

345: NULL;
346: END default_customer_header;
347:
348: PROCEDURE validate_customer_header(
349: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
350: ) IS
351: BEGIN
352: NULL;
353: END validate_customer_header;

Line 356: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

352: NULL;
353: END validate_customer_header;
354:
355: PROCEDURE derive_internal_header(
356: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
357: ) IS
358: BEGIN
359: NULL;
360: END derive_internal_header;

Line 363: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

359: NULL;
360: END derive_internal_header;
361:
362: PROCEDURE default_internal_header(
363: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
364: ) IS
365: BEGIN
366: NULL;
367: END default_internal_header;

Line 370: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

366: NULL;
367: END default_internal_header;
368:
369: PROCEDURE validate_internal_header(
370: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
371: ) IS
372: BEGIN
373: NULL;
374: END validate_internal_header;

Line 378: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

374: END validate_internal_header;
375:
376: -- Wrapper to RCV_INT_ORDER_PP_PVT version, for consistency
377: PROCEDURE derive_internal_order_header(
378: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
379: ) IS
380: BEGIN
381: rcv_int_order_pp_pvt.derive_internal_order_header(p_header_record);
382: END derive_internal_order_header;

Line 386: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

382: END derive_internal_order_header;
383:
384: -- WRAPPER to RCV_INT_ORDER_PP_PVT version, for consistency
385: PROCEDURE default_internal_order_header(
386: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
387: ) IS
388: BEGIN
389: rcv_int_order_pp_pvt.default_internal_order_header(p_header_record);
390: END default_internal_order_header;

Line 394: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

390: END default_internal_order_header;
391:
392: -- WRAPPER to RCV_INT_ORDER_PP_PVT version, for consistency
393: PROCEDURE validate_internal_order_header(
394: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
395: ) IS
396: BEGIN
397: rcv_int_order_pp_pvt.validate_internal_order_header(p_header_record);
398: END validate_internal_order_header;

Line 401: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

397: rcv_int_order_pp_pvt.validate_internal_order_header(p_header_record);
398: END validate_internal_order_header;
399:
400: PROCEDURE derive_vendor_info(
401: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
402: ) IS
403: vendor_record rcv_shipment_header_sv.vendorrectype;
404: BEGIN
405: /* Derive Vendor Information */

Line 436: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

432: END IF;
433: END derive_vendor_info;
434:
435: PROCEDURE derive_vendor_site_info(
436: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
437: ) IS
438: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
439: BEGIN
440: /* derive vendor site information */

Line 475: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

471: END IF;
472: END derive_vendor_site_info;
473:
474: PROCEDURE derive_payment_terms_info(
475: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
476: ) IS
477: pay_record rcv_shipment_header_sv.payrectype;
478: BEGIN
479: /* Derive Payment Terms Information */

Line 510: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

506: END IF;
507: END derive_payment_terms_info;
508:
509: PROCEDURE derive_shipment_header_id(
510: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
511: ) IS
512: BEGIN
513: /* Derive shipment_header_id if transaction type = CANCEL */
514: -- added for support of cancel

Line 529: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

525: END IF;
526: END derive_shipment_header_id;
527:
528: PROCEDURE derive_shipment_info(
529: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
530: ) IS
531: BEGIN
532: IF p_header_record.header_record.receipt_header_id IS NOT NULL THEN
533: IF (g_asn_debug = 'Y') THEN

Line 617: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

613: p_header_record.error_record.error_message := SQLERRM;
614: END derive_shipment_info;
615:
616: PROCEDURE default_shipment_num(
617: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
618: ) IS
619: BEGIN
620: /* SHIPMENT NUMBER FOR ASBN if shipment_num IS NULL */
621: /* First choice for ASBN */

Line 646: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

642: END IF;
643: END default_shipment_num;
644:
645: PROCEDURE default_vendor_site_id(
646: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
647: ) IS
648:
649: /* 5953480 - declared below two variables, to get proper site value. */
650: count1 number :=0;

Line 718: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

714: END IF;
715: END default_vendor_site_id;
716:
717: PROCEDURE default_shipment_info(
718: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
719: ) IS
720: x_count NUMBER;
721: BEGIN
722: -- no need to derive shipment_header_id if it is already provided

Line 800: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

796: p_header_record.error_record.error_message := SQLERRM;
797: END default_shipment_info;
798:
799: PROCEDURE validate_document_type(
800: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
801: ) IS
802: lookup_record rcv_shipment_header_sv.lookuprectype;
803: BEGIN
804: /* Validate Document type */

Line 837: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

833: END IF;
834: END validate_document_type;
835:
836: PROCEDURE validate_currency_code(
837: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
838: ) IS
839: currency_record rcv_shipment_header_sv.currectype;
840: BEGIN
841: /* Validate Currency Code */

Line 873: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

869: END IF;
870: END validate_currency_code;
871:
872: PROCEDURE validate_receipt_date(
873: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
874: ) IS
875: BEGIN
876: /* Validation for Receipt Date > Shipped Date if Receipt Date is specified */
877: IF p_header_record.error_record.error_status IN('S', 'W')

Line 900: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

896: END IF;
897: END validate_receipt_date;
898:
899: PROCEDURE validate_vendor_info(
900: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
901: ) IS
902: vendor_record rcv_shipment_header_sv.vendorrectype;
903: BEGIN
904: /* Validate Vendor Information */

Line 983: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

979: END IF;
980: END validate_vendor_info;
981:
982: PROCEDURE validate_vendor_site_info(
983: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
984: ) IS
985: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
986: l_proc VARCHAR2(100);
987: BEGIN

Line 1169: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1165: END IF;
1166: END validate_vendor_site_info;
1167:
1168: PROCEDURE validate_asbn_specific_info(
1169: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1170: ) IS
1171: invoice_record rcv_shipment_header_sv.invrectype;
1172: tax_record rcv_shipment_header_sv.taxrectype;
1173: BEGIN

Line 1334: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1330: END IF; --}
1331: END validate_asbn_specific_info;
1332:
1333: PROCEDURE validate_shipment_number(
1334: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1335: ) IS
1336: x_shipment_header_id NUMBER;
1337: BEGIN
1338: -- Check for shipment number which is null, blank , zero

Line 1633: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1629: p_header_record.error_record.error_message := SQLERRM;
1630: END validate_shipment_number;
1631:
1632: PROCEDURE insert_shipment_header(
1633: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1634: ) IS
1635: BEGIN
1636: -- Set asn_type to null if asn_type is STD as the UI gets confused
1637:

Line 1834: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1830: p_header_record.error_record.error_message := SQLERRM;
1831: END insert_shipment_header;
1832:
1833: PROCEDURE update_shipment_header(
1834: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1835: ) IS
1836: BEGIN
1837: IF (g_asn_debug = 'Y') THEN
1838: asn_debug.put_line('Enter in update_shipment_header ');

Line 1883: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1879: p_header_record.error_record.error_message := SQLERRM;
1880: END update_shipment_header;
1881:
1882: PROCEDURE insert_cancelled_asn_lines(
1883: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1884: ) IS
1885: BEGIN
1886: -- delete any asn lines that have been sent
1887: