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 206: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 223: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 279: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 337: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 344: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 351: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 358: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 365: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 372: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 380: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 388: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 396: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 403: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 438: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 477: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 512: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 531: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 619: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 648: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 720: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 802: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 839: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 875: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 902: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

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

Line 979: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

975: END IF;
976: END validate_vendor_info;
977:
978: PROCEDURE validate_vendor_site_info(
979: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
980: ) IS
981: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
982: l_proc VARCHAR2(100);
983: BEGIN

Line 1143: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1139: END IF;
1140: END validate_vendor_site_info;
1141:
1142: PROCEDURE validate_asbn_specific_info(
1143: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1144: ) IS
1145: invoice_record rcv_shipment_header_sv.invrectype;
1146: tax_record rcv_shipment_header_sv.taxrectype;
1147: BEGIN

Line 1308: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1304: END IF; --}
1305: END validate_asbn_specific_info;
1306:
1307: PROCEDURE validate_shipment_number(
1308: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1309: ) IS
1310: x_shipment_header_id NUMBER;
1311: BEGIN
1312: -- Check for shipment number which is null, blank , zero

Line 1607: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1603: p_header_record.error_record.error_message := SQLERRM;
1604: END validate_shipment_number;
1605:
1606: PROCEDURE insert_shipment_header(
1607: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1608: ) IS
1609: BEGIN
1610: -- Set asn_type to null if asn_type is STD as the UI gets confused
1611:

Line 1808: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1804: p_header_record.error_record.error_message := SQLERRM;
1805: END insert_shipment_header;
1806:
1807: PROCEDURE update_shipment_header(
1808: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1809: ) IS
1810: BEGIN
1811: IF (g_asn_debug = 'Y') THEN
1812: asn_debug.put_line('Enter in update_shipment_header ');

Line 1857: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

1853: p_header_record.error_record.error_message := SQLERRM;
1854: END update_shipment_header;
1855:
1856: PROCEDURE insert_cancelled_asn_lines(
1857: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1858: ) IS
1859: BEGIN
1860: -- delete any asn lines that have been sent
1861: