DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV dependencies on RCV_SHIPMENT_LINE_SV

Line 7: transaction_record rcv_shipment_line_sv.transaction_record_type;

3:
4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
6: cascaded_table rcv_shipment_object_sv.cascaded_trans_tab_type;
7: transaction_record rcv_shipment_line_sv.transaction_record_type;
8: item_id_record rcv_shipment_line_sv.item_id_record_type;
9: document_num_record rcv_shipment_line_sv.document_num_record_type;
10: release_id_record rcv_shipment_line_sv.release_id_record_type;
11: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;

Line 8: item_id_record rcv_shipment_line_sv.item_id_record_type;

4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
6: cascaded_table rcv_shipment_object_sv.cascaded_trans_tab_type;
7: transaction_record rcv_shipment_line_sv.transaction_record_type;
8: item_id_record rcv_shipment_line_sv.item_id_record_type;
9: document_num_record rcv_shipment_line_sv.document_num_record_type;
10: release_id_record rcv_shipment_line_sv.release_id_record_type;
11: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
12: po_line_location_id_record rcv_shipment_line_sv.po_line_location_id_rtype;

Line 9: document_num_record rcv_shipment_line_sv.document_num_record_type;

5: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
6: cascaded_table rcv_shipment_object_sv.cascaded_trans_tab_type;
7: transaction_record rcv_shipment_line_sv.transaction_record_type;
8: item_id_record rcv_shipment_line_sv.item_id_record_type;
9: document_num_record rcv_shipment_line_sv.document_num_record_type;
10: release_id_record rcv_shipment_line_sv.release_id_record_type;
11: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
12: po_line_location_id_record rcv_shipment_line_sv.po_line_location_id_rtype;
13: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;

Line 10: release_id_record rcv_shipment_line_sv.release_id_record_type;

6: cascaded_table rcv_shipment_object_sv.cascaded_trans_tab_type;
7: transaction_record rcv_shipment_line_sv.transaction_record_type;
8: item_id_record rcv_shipment_line_sv.item_id_record_type;
9: document_num_record rcv_shipment_line_sv.document_num_record_type;
10: release_id_record rcv_shipment_line_sv.release_id_record_type;
11: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
12: po_line_location_id_record rcv_shipment_line_sv.po_line_location_id_rtype;
13: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
14: organization_id_record rcv_shipment_object_sv.organization_id_record_type;

Line 11: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;

7: transaction_record rcv_shipment_line_sv.transaction_record_type;
8: item_id_record rcv_shipment_line_sv.item_id_record_type;
9: document_num_record rcv_shipment_line_sv.document_num_record_type;
10: release_id_record rcv_shipment_line_sv.release_id_record_type;
11: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
12: po_line_location_id_record rcv_shipment_line_sv.po_line_location_id_rtype;
13: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
14: organization_id_record rcv_shipment_object_sv.organization_id_record_type;
15: intransit_owning_org_record rcv_shipment_line_sv.intransit_owning_org_rtype;

Line 12: po_line_location_id_record rcv_shipment_line_sv.po_line_location_id_rtype;

8: item_id_record rcv_shipment_line_sv.item_id_record_type;
9: document_num_record rcv_shipment_line_sv.document_num_record_type;
10: release_id_record rcv_shipment_line_sv.release_id_record_type;
11: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
12: po_line_location_id_record rcv_shipment_line_sv.po_line_location_id_rtype;
13: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
14: organization_id_record rcv_shipment_object_sv.organization_id_record_type;
15: intransit_owning_org_record rcv_shipment_line_sv.intransit_owning_org_rtype;
16: location_id_record rcv_shipment_object_sv.location_id_record_type;

Line 15: intransit_owning_org_record rcv_shipment_line_sv.intransit_owning_org_rtype;

11: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
12: po_line_location_id_record rcv_shipment_line_sv.po_line_location_id_rtype;
13: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
14: organization_id_record rcv_shipment_object_sv.organization_id_record_type;
15: intransit_owning_org_record rcv_shipment_line_sv.intransit_owning_org_rtype;
16: location_id_record rcv_shipment_object_sv.location_id_record_type;
17: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
18: category_id_record rcv_shipment_line_sv.category_id_record_type;
19: employee_id_record rcv_shipment_object_sv.employee_id_record_type;

Line 17: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;

13: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
14: organization_id_record rcv_shipment_object_sv.organization_id_record_type;
15: intransit_owning_org_record rcv_shipment_line_sv.intransit_owning_org_rtype;
16: location_id_record rcv_shipment_object_sv.location_id_record_type;
17: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
18: category_id_record rcv_shipment_line_sv.category_id_record_type;
19: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
20: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;
21: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;

Line 18: category_id_record rcv_shipment_line_sv.category_id_record_type;

14: organization_id_record rcv_shipment_object_sv.organization_id_record_type;
15: intransit_owning_org_record rcv_shipment_line_sv.intransit_owning_org_rtype;
16: location_id_record rcv_shipment_object_sv.location_id_record_type;
17: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
18: category_id_record rcv_shipment_line_sv.category_id_record_type;
19: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
20: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;
21: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;
22: deliver_to_person_id_record rcv_shipment_line_sv.deliver_to_person_id_rtype;

Line 20: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;

16: location_id_record rcv_shipment_object_sv.location_id_record_type;
17: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
18: category_id_record rcv_shipment_line_sv.category_id_record_type;
19: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
20: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;
21: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;
22: deliver_to_person_id_record rcv_shipment_line_sv.deliver_to_person_id_rtype;
23: locator_id_record rcv_shipment_line_sv.locator_id_record_type;
24: reason_id_record rcv_shipment_line_sv.reason_id_record_type;

Line 21: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;

17: sub_item_id_record rcv_shipment_line_sv.sub_item_id_record_type;
18: category_id_record rcv_shipment_line_sv.category_id_record_type;
19: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
20: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;
21: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;
22: deliver_to_person_id_record rcv_shipment_line_sv.deliver_to_person_id_rtype;
23: locator_id_record rcv_shipment_line_sv.locator_id_record_type;
24: reason_id_record rcv_shipment_line_sv.reason_id_record_type;
25: quantity_shipped_record rcv_shipment_line_sv.quantity_shipped_record_type;

Line 22: deliver_to_person_id_record rcv_shipment_line_sv.deliver_to_person_id_rtype;

18: category_id_record rcv_shipment_line_sv.category_id_record_type;
19: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
20: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;
21: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;
22: deliver_to_person_id_record rcv_shipment_line_sv.deliver_to_person_id_rtype;
23: locator_id_record rcv_shipment_line_sv.locator_id_record_type;
24: reason_id_record rcv_shipment_line_sv.reason_id_record_type;
25: quantity_shipped_record rcv_shipment_line_sv.quantity_shipped_record_type;
26: expected_receipt_record rcv_shipment_line_sv.expected_receipt_record_type;

Line 23: locator_id_record rcv_shipment_line_sv.locator_id_record_type;

19: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
20: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;
21: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;
22: deliver_to_person_id_record rcv_shipment_line_sv.deliver_to_person_id_rtype;
23: locator_id_record rcv_shipment_line_sv.locator_id_record_type;
24: reason_id_record rcv_shipment_line_sv.reason_id_record_type;
25: quantity_shipped_record rcv_shipment_line_sv.quantity_shipped_record_type;
26: expected_receipt_record rcv_shipment_line_sv.expected_receipt_record_type;
27: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;

Line 24: reason_id_record rcv_shipment_line_sv.reason_id_record_type;

20: routing_header_id_record rcv_shipment_line_sv.routing_header_id_rec_type;
21: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;
22: deliver_to_person_id_record rcv_shipment_line_sv.deliver_to_person_id_rtype;
23: locator_id_record rcv_shipment_line_sv.locator_id_record_type;
24: reason_id_record rcv_shipment_line_sv.reason_id_record_type;
25: quantity_shipped_record rcv_shipment_line_sv.quantity_shipped_record_type;
26: expected_receipt_record rcv_shipment_line_sv.expected_receipt_record_type;
27: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;
28: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;

Line 25: quantity_shipped_record rcv_shipment_line_sv.quantity_shipped_record_type;

21: routing_step_id_record rcv_shipment_line_sv.routing_step_id_rec_type;
22: deliver_to_person_id_record rcv_shipment_line_sv.deliver_to_person_id_rtype;
23: locator_id_record rcv_shipment_line_sv.locator_id_record_type;
24: reason_id_record rcv_shipment_line_sv.reason_id_record_type;
25: quantity_shipped_record rcv_shipment_line_sv.quantity_shipped_record_type;
26: expected_receipt_record rcv_shipment_line_sv.expected_receipt_record_type;
27: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;
28: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
29: asl_record rcv_shipment_line_sv.ref_integrity_record_type;

Line 26: expected_receipt_record rcv_shipment_line_sv.expected_receipt_record_type;

22: deliver_to_person_id_record rcv_shipment_line_sv.deliver_to_person_id_rtype;
23: locator_id_record rcv_shipment_line_sv.locator_id_record_type;
24: reason_id_record rcv_shipment_line_sv.reason_id_record_type;
25: quantity_shipped_record rcv_shipment_line_sv.quantity_shipped_record_type;
26: expected_receipt_record rcv_shipment_line_sv.expected_receipt_record_type;
27: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;
28: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
29: asl_record rcv_shipment_line_sv.ref_integrity_record_type;
30: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;

Line 27: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;

23: locator_id_record rcv_shipment_line_sv.locator_id_record_type;
24: reason_id_record rcv_shipment_line_sv.reason_id_record_type;
25: quantity_shipped_record rcv_shipment_line_sv.quantity_shipped_record_type;
26: expected_receipt_record rcv_shipment_line_sv.expected_receipt_record_type;
27: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;
28: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
29: asl_record rcv_shipment_line_sv.ref_integrity_record_type;
30: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
31: tax_name_record rcv_shipment_line_sv.tax_name_record_type;

Line 28: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;

24: reason_id_record rcv_shipment_line_sv.reason_id_record_type;
25: quantity_shipped_record rcv_shipment_line_sv.quantity_shipped_record_type;
26: expected_receipt_record rcv_shipment_line_sv.expected_receipt_record_type;
27: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;
28: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
29: asl_record rcv_shipment_line_sv.ref_integrity_record_type;
30: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
31: tax_name_record rcv_shipment_line_sv.tax_name_record_type;
32: --FRKHAN 12/18/98 add record type for country of origin

Line 29: asl_record rcv_shipment_line_sv.ref_integrity_record_type;

25: quantity_shipped_record rcv_shipment_line_sv.quantity_shipped_record_type;
26: expected_receipt_record rcv_shipment_line_sv.expected_receipt_record_type;
27: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;
28: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
29: asl_record rcv_shipment_line_sv.ref_integrity_record_type;
30: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
31: tax_name_record rcv_shipment_line_sv.tax_name_record_type;
32: --FRKHAN 12/18/98 add record type for country of origin
33: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;

Line 30: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;

26: expected_receipt_record rcv_shipment_line_sv.expected_receipt_record_type;
27: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;
28: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
29: asl_record rcv_shipment_line_sv.ref_integrity_record_type;
30: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
31: tax_name_record rcv_shipment_line_sv.tax_name_record_type;
32: --FRKHAN 12/18/98 add record type for country of origin
33: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;
34: vendor_record rcv_shipment_header_sv.vendorrectype;

Line 31: tax_name_record rcv_shipment_line_sv.tax_name_record_type;

27: quantity_invoiced_record rcv_shipment_line_sv.quantity_invoiced_record_type;
28: ref_integrity_record rcv_shipment_line_sv.ref_integrity_record_type;
29: asl_record rcv_shipment_line_sv.ref_integrity_record_type;
30: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
31: tax_name_record rcv_shipment_line_sv.tax_name_record_type;
32: --FRKHAN 12/18/98 add record type for country of origin
33: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;
34: vendor_record rcv_shipment_header_sv.vendorrectype;
35: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;

Line 33: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;

29: asl_record rcv_shipment_line_sv.ref_integrity_record_type;
30: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
31: tax_name_record rcv_shipment_line_sv.tax_name_record_type;
32: --FRKHAN 12/18/98 add record type for country of origin
33: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;
34: vendor_record rcv_shipment_header_sv.vendorrectype;
35: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
36: cum_quantity_record rcv_shipment_line_sv.cum_quantity_record_type;
37: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;

Line 36: cum_quantity_record rcv_shipment_line_sv.cum_quantity_record_type;

32: --FRKHAN 12/18/98 add record type for country of origin
33: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;
34: vendor_record rcv_shipment_header_sv.vendorrectype;
35: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
36: cum_quantity_record rcv_shipment_line_sv.cum_quantity_record_type;
37: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
38: employee_record rcv_shipment_line_sv.employee_record_type;
39: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
40: location_record rcv_shipment_line_sv.location_record_type;

Line 37: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;

33: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;
34: vendor_record rcv_shipment_header_sv.vendorrectype;
35: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
36: cum_quantity_record rcv_shipment_line_sv.cum_quantity_record_type;
37: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
38: employee_record rcv_shipment_line_sv.employee_record_type;
39: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
40: location_record rcv_shipment_line_sv.location_record_type;
41: subinventory_record rcv_shipment_line_sv.subinventory_record_type;

Line 38: employee_record rcv_shipment_line_sv.employee_record_type;

34: vendor_record rcv_shipment_header_sv.vendorrectype;
35: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
36: cum_quantity_record rcv_shipment_line_sv.cum_quantity_record_type;
37: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
38: employee_record rcv_shipment_line_sv.employee_record_type;
39: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
40: location_record rcv_shipment_line_sv.location_record_type;
41: subinventory_record rcv_shipment_line_sv.subinventory_record_type;
42: locator_record rcv_shipment_line_sv.locator_record_type;

Line 39: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;

35: vendor_site_record rcv_shipment_header_sv.vendorsiterectype;
36: cum_quantity_record rcv_shipment_line_sv.cum_quantity_record_type;
37: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
38: employee_record rcv_shipment_line_sv.employee_record_type;
39: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
40: location_record rcv_shipment_line_sv.location_record_type;
41: subinventory_record rcv_shipment_line_sv.subinventory_record_type;
42: locator_record rcv_shipment_line_sv.locator_record_type;
43: item_revision_record rcv_shipment_line_sv.item_id_record_type;

Line 40: location_record rcv_shipment_line_sv.location_record_type;

36: cum_quantity_record rcv_shipment_line_sv.cum_quantity_record_type;
37: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
38: employee_record rcv_shipment_line_sv.employee_record_type;
39: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
40: location_record rcv_shipment_line_sv.location_record_type;
41: subinventory_record rcv_shipment_line_sv.subinventory_record_type;
42: locator_record rcv_shipment_line_sv.locator_record_type;
43: item_revision_record rcv_shipment_line_sv.item_id_record_type;
44: /* */

Line 41: subinventory_record rcv_shipment_line_sv.subinventory_record_type;

37: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
38: employee_record rcv_shipment_line_sv.employee_record_type;
39: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
40: location_record rcv_shipment_line_sv.location_record_type;
41: subinventory_record rcv_shipment_line_sv.subinventory_record_type;
42: locator_record rcv_shipment_line_sv.locator_record_type;
43: item_revision_record rcv_shipment_line_sv.item_id_record_type;
44: /* */
45: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;

Line 42: locator_record rcv_shipment_line_sv.locator_record_type;

38: employee_record rcv_shipment_line_sv.employee_record_type;
39: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
40: location_record rcv_shipment_line_sv.location_record_type;
41: subinventory_record rcv_shipment_line_sv.subinventory_record_type;
42: locator_record rcv_shipment_line_sv.locator_record_type;
43: item_revision_record rcv_shipment_line_sv.item_id_record_type;
44: /* */
45: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
46: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;

Line 43: item_revision_record rcv_shipment_line_sv.item_id_record_type;

39: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
40: location_record rcv_shipment_line_sv.location_record_type;
41: subinventory_record rcv_shipment_line_sv.subinventory_record_type;
42: locator_record rcv_shipment_line_sv.locator_record_type;
43: item_revision_record rcv_shipment_line_sv.item_id_record_type;
44: /* */
45: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
46: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;
47: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;

Line 45: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;

41: subinventory_record rcv_shipment_line_sv.subinventory_record_type;
42: locator_record rcv_shipment_line_sv.locator_record_type;
43: item_revision_record rcv_shipment_line_sv.item_id_record_type;
44: /* */
45: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
46: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;
47: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;
48: e_validation_error EXCEPTION;
49:

Line 46: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;

42: locator_record rcv_shipment_line_sv.locator_record_type;
43: item_revision_record rcv_shipment_line_sv.item_id_record_type;
44: /* */
45: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
46: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;
47: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;
48: e_validation_error EXCEPTION;
49:
50: /* */

Line 47: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;

43: item_revision_record rcv_shipment_line_sv.item_id_record_type;
44: /* */
45: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
46: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;
47: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;
48: e_validation_error EXCEPTION;
49:
50: /* */
51:

Line 3891: x_locator_id_record IN OUT NOCOPY rcv_shipment_line_sv.locator_id_record_type

3887: PROCEDURE NAME: get_locator_id()
3888:
3889: ===========================================================================*/
3890: PROCEDURE get_locator_id(
3891: x_locator_id_record IN OUT NOCOPY rcv_shipment_line_sv.locator_id_record_type
3892: ) IS
3893: BEGIN
3894: IF (g_asn_debug = 'Y') THEN
3895: asn_debug.put_line('inside get_locator_id');

Line 3925: x_routing_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_header_id_rec_type

3921: PROCEDURE NAME: get_routing_header_id()
3922:
3923: ===========================================================================*/
3924: PROCEDURE get_routing_header_id(
3925: x_routing_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_header_id_rec_type
3926: ) IS
3927: BEGIN
3928: SELECT MAX(routing_header_id)
3929: INTO x_routing_header_id_record.routing_header_id

Line 3950: x_routing_step_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_step_id_rec_type

3946: PROCEDURE NAME: get_routing_step_id()
3947:
3948: ===========================================================================*/
3949: PROCEDURE get_routing_step_id(
3950: x_routing_step_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_step_id_rec_type
3951: ) IS
3952: BEGIN
3953: SELECT MAX(routing_step_id)
3954: INTO x_routing_step_id_record.routing_step_id

Line 3975: x_reason_id_record IN OUT NOCOPY rcv_shipment_line_sv.reason_id_record_type

3971: PROCEDURE NAME: get_reason_id()
3972:
3973: ===========================================================================*/
3974: PROCEDURE get_reason_id(
3975: x_reason_id_record IN OUT NOCOPY rcv_shipment_line_sv.reason_id_record_type
3976: ) IS
3977: BEGIN
3978: SELECT MAX(reason_id)
3979: INTO x_reason_id_record.reason_id

Line 4000: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

3996: PROCEDURE NAME: default_item_revision()
3997:
3998: ============================================================================*/
3999: PROCEDURE default_item_revision(
4000: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
4001: ) IS
4002: x_revision_control_flag VARCHAR2(1);
4003: x_number_of_inv_dest NUMBER;
4004: x_item_rev_exists BOOLEAN;

Line 4283: x_po_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.document_num_record_type

4279: PROCEDURE NAME: get_po_header_id()
4280:
4281: ===========================================================================*/
4282: PROCEDURE get_po_header_id(
4283: x_po_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.document_num_record_type
4284: ) IS
4285: BEGIN
4286: /* type_lookup_code will never be SCHEDULED in po_headers. This
4287: * should be PLANNED. Because of this, for PLANNED POs get_po_header_id

Line 4316: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

4312: PROCEDURE NAME: get_item_id()
4313:
4314: ===========================================================================*/
4315: PROCEDURE get_item_id(
4316: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
4317: ) IS
4318: BEGIN
4319: IF (x_item_id_record.item_num IS NOT NULL) THEN
4320: SELECT MIN(inventory_item_id),

Line 4365: x_sub_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.sub_item_id_record_type

4361: PROCEDURE NAME: get_sub_item_id()
4362:
4363: ===========================================================================*/
4364: PROCEDURE get_sub_item_id(
4365: x_sub_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.sub_item_id_record_type
4366: ) IS
4367: BEGIN
4368: IF (x_sub_item_id_record.substitute_item_num IS NOT NULL) THEN
4369: SELECT MAX(inventory_item_id)

Line 4398: x_po_line_id_record IN OUT NOCOPY rcv_shipment_line_sv.po_line_id_record_type

4394: PROCEDURE NAME: get_po_line_id()
4395:
4396: ===========================================================================*/
4397: PROCEDURE get_po_line_id(
4398: x_po_line_id_record IN OUT NOCOPY rcv_shipment_line_sv.po_line_id_record_type
4399: ) IS
4400: BEGIN
4401: SELECT po_line_id,
4402: item_id