DBA Data[Home] [Help]

APPS.RCV_HEADERS_INTERFACE_SV dependencies on RCV_SHIPMENT_HEADER_SV

Line 9: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype

5: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
6:
7: -- Bug 2506961
8: PROCEDURE genreceiptnum(
9: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype
10: );
11:
12: vendor_record rcv_shipment_header_sv.vendorrectype;
13: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;

Line 12: vendor_record rcv_shipment_header_sv.vendorrectype;

8: PROCEDURE genreceiptnum(
9: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype
10: );
11:
12: vendor_record rcv_shipment_header_sv.vendorrectype;
13: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
14: from_org_record rcv_shipment_object_sv.organization_id_record_type;
15: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
16: loc_record rcv_shipment_object_sv.location_id_record_type;

Line 13: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;

9: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype
10: );
11:
12: vendor_record rcv_shipment_header_sv.vendorrectype;
13: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
14: from_org_record rcv_shipment_object_sv.organization_id_record_type;
15: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
16: loc_record rcv_shipment_object_sv.location_id_record_type;
17: emp_record rcv_shipment_object_sv.employee_id_record_type;

Line 18: pay_record rcv_shipment_header_sv.payrectype;

14: from_org_record rcv_shipment_object_sv.organization_id_record_type;
15: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
16: loc_record rcv_shipment_object_sv.location_id_record_type;
17: emp_record rcv_shipment_object_sv.employee_id_record_type;
18: pay_record rcv_shipment_header_sv.payrectype;
19: freight_record rcv_shipment_header_sv.freightrectype;
20: lookup_record rcv_shipment_header_sv.lookuprectype;
21: currency_record rcv_shipment_header_sv.currectype;
22: invoice_record rcv_shipment_header_sv.invrectype;

Line 19: freight_record rcv_shipment_header_sv.freightrectype;

15: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
16: loc_record rcv_shipment_object_sv.location_id_record_type;
17: emp_record rcv_shipment_object_sv.employee_id_record_type;
18: pay_record rcv_shipment_header_sv.payrectype;
19: freight_record rcv_shipment_header_sv.freightrectype;
20: lookup_record rcv_shipment_header_sv.lookuprectype;
21: currency_record rcv_shipment_header_sv.currectype;
22: invoice_record rcv_shipment_header_sv.invrectype;
23: tax_record rcv_shipment_header_sv.taxrectype;

Line 20: lookup_record rcv_shipment_header_sv.lookuprectype;

16: loc_record rcv_shipment_object_sv.location_id_record_type;
17: emp_record rcv_shipment_object_sv.employee_id_record_type;
18: pay_record rcv_shipment_header_sv.payrectype;
19: freight_record rcv_shipment_header_sv.freightrectype;
20: lookup_record rcv_shipment_header_sv.lookuprectype;
21: currency_record rcv_shipment_header_sv.currectype;
22: invoice_record rcv_shipment_header_sv.invrectype;
23: tax_record rcv_shipment_header_sv.taxrectype;
24: x_sysdate DATE := SYSDATE;

Line 21: currency_record rcv_shipment_header_sv.currectype;

17: emp_record rcv_shipment_object_sv.employee_id_record_type;
18: pay_record rcv_shipment_header_sv.payrectype;
19: freight_record rcv_shipment_header_sv.freightrectype;
20: lookup_record rcv_shipment_header_sv.lookuprectype;
21: currency_record rcv_shipment_header_sv.currectype;
22: invoice_record rcv_shipment_header_sv.invrectype;
23: tax_record rcv_shipment_header_sv.taxrectype;
24: x_sysdate DATE := SYSDATE;
25: x_count NUMBER := 0;

Line 22: invoice_record rcv_shipment_header_sv.invrectype;

18: pay_record rcv_shipment_header_sv.payrectype;
19: freight_record rcv_shipment_header_sv.freightrectype;
20: lookup_record rcv_shipment_header_sv.lookuprectype;
21: currency_record rcv_shipment_header_sv.currectype;
22: invoice_record rcv_shipment_header_sv.invrectype;
23: tax_record rcv_shipment_header_sv.taxrectype;
24: x_sysdate DATE := SYSDATE;
25: x_count NUMBER := 0;
26: x_location_id NUMBER;

Line 23: tax_record rcv_shipment_header_sv.taxrectype;

19: freight_record rcv_shipment_header_sv.freightrectype;
20: lookup_record rcv_shipment_header_sv.lookuprectype;
21: currency_record rcv_shipment_header_sv.currectype;
22: invoice_record rcv_shipment_header_sv.invrectype;
23: tax_record rcv_shipment_header_sv.taxrectype;
24: x_sysdate DATE := SYSDATE;
25: x_count NUMBER := 0;
26: x_location_id NUMBER;
27:

Line 34: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype

30: | PROCEDURE NAME: derive_shipment_header() |
31: | |
32: +===========================================================================*/
33: PROCEDURE derive_shipment_header(
34: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype
35: ) IS
36: BEGIN
37: /* Derive Vendor Information */
38: IF p_header_record.error_record.error_status IN('S', 'W') THEN

Line 256: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype

252: | PROCEDURE NAME: default_shipment_header() |
253: | |
254: +===========================================================================*/
255: PROCEDURE default_shipment_header(
256: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype
257: ) IS
258: v_rcv_type po_system_parameters.user_defined_receipt_num_code%TYPE;
259: v_count NUMBER := 0;
260: temp_count NUMBER;

Line 553: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype

549: | PROCEDURE NAME: validate_shipment_header() |
550: | |
551: +===========================================================================*/
552: PROCEDURE validate_shipment_header(
553: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype
554: ) IS
555: BEGIN
556: /* Validate Transaction Type */
557: IF (g_asn_debug = 'Y') THEN

Line 1315: p_inv_rec IN OUT NOCOPY rcv_shipment_header_sv.invrectype

1311: NULL;
1312: END validate_shipment_header;
1313:
1314: PROCEDURE validate_invoice_amount(
1315: p_inv_rec IN OUT NOCOPY rcv_shipment_header_sv.invrectype
1316: ) IS
1317: CURSOR c IS
1318: SELECT invoice_amount_limit
1319: FROM po_vendor_sites_all --Bug 5219141 Replace po_vendor_sites by po_vendor_sites_all

Line 1348: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype

1344: p_inv_rec.error_record.error_message := rcv_error_pkg.get_last_message;
1345: END validate_invoice_amount;
1346:
1347: PROCEDURE insert_shipment_header(
1348: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype
1349: ) IS
1350: BEGIN
1351: -- Set asn_type to null if asn_type is STD as the UI gets confused
1352:

Line 1533: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype

1529: | PROCEDURE NAME: derive_ship_to_org_from_rti() |
1530: | |
1531: +===========================================================================*/
1532: PROCEDURE derive_ship_to_org_from_rti(
1533: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype
1534: ) IS
1535: x_header_interface_id NUMBER;
1536: x_to_organization_code VARCHAR2(3);
1537: BEGIN

Line 1632: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype

1628: /* ksareddy - 2506961 - need to support automatic receipt in parallel processing
1629: lock and release the rcv_parameters table only to get the receipt number
1630: */
1631: PROCEDURE genreceiptnum(
1632: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype
1633: ) IS
1634: l_count NUMBER;
1635: PRAGMA AUTONOMOUS_TRANSACTION;
1636: BEGIN