DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on RCV_SHIPMENT_LINE_SV

Line 14: x_quantity_shipped_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type

10: PROCEDURE NAME: validate_quantity_shipped()
11:
12: ===========================================================================*/
13: PROCEDURE validate_quantity_shipped(
14: x_quantity_shipped_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type
15: ) IS
16: x_progress VARCHAR2(3);
17: x_available_qty NUMBER := 0;
18: x_tolerable_qty NUMBER := 0;

Line 75: x_expected_receipt_rec IN OUT NOCOPY rcv_shipment_line_sv.expected_receipt_record_type

71: PROCEDURE NAME: validate_expected_receipt_date()
72:
73: ===========================================================================*/
74: PROCEDURE validate_expected_receipt_date(
75: x_expected_receipt_rec IN OUT NOCOPY rcv_shipment_line_sv.expected_receipt_record_type
76: ) IS
77: x_progress VARCHAR2(3);
78: x_error_status VARCHAR2(1);
79: BEGIN

Line 104: x_quantity_invoiced_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_invoiced_record_type

100: PROCEDURE NAME: validate_quantity_invoiced (ASBN only)
101:
102: ===========================================================================*/
103: PROCEDURE validate_quantity_invoiced(
104: x_quantity_invoiced_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_invoiced_record_type
105: ) IS
106: x_progress VARCHAR2(3);
107: x_error_status VARCHAR2(1);
108: BEGIN

Line 131: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type

127: PROCEDURE NAME: validate_uom()
128:
129: ===========================================================================*/
130: PROCEDURE validate_uom(
131: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type
132: ) IS
133: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE := NULL;
134: x_unit_meas_lookup_code_lines po_lines.unit_meas_lookup_code%TYPE := NULL;
135: x_progress VARCHAR2(3);

Line 290: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,

286: PROCEDURE NAME: validate_item()
287:
288: ===========================================================================*/
289: PROCEDURE validate_item(
290: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
291: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
292: ) IS -- bug 608353
293: x_progress VARCHAR2(3);
294: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;

Line 409: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

405: PROCEDURE NAME: validate_item_description()
406:
407: ===========================================================================*/
408: PROCEDURE validate_item_description(
409: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
410: ) IS
411: x_progress VARCHAR2(3);
412: x_error_status VARCHAR2(1);
413: BEGIN

Line 436: x_sub_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.sub_item_id_record_type

432: PROCEDURE NAME: validate_substitute_item()
433:
434: ===========================================================================*/
435: PROCEDURE validate_substitute_item(
436: x_sub_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.sub_item_id_record_type
437: ) IS
438: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
439: x_progress VARCHAR2(3);
440: x_vendor_id po_vendors.vendor_id%TYPE := NULL;

Line 576: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

572: PROCEDURE NAME: validate_item_revision()
573:
574: ===========================================================================*/
575: PROCEDURE validate_item_revision(
576: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
577: ) IS
578: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
579: x_progress VARCHAR2(3);
580: x_revision_control_flag VARCHAR2(1);

Line 687: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,

683: PROCEDURE NAME: validate_ref_integ()
684:
685: ===========================================================================*/
686: PROCEDURE validate_ref_integ(
687: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,
688: v_header_record IN rcv_shipment_header_sv.headerrectype
689: ) IS
690: x_po_vendor_id po_headers.vendor_id%TYPE := NULL;
691: x_po_line_id po_lines.po_line_id%TYPE;

Line 788: x_freight_carrier_record IN OUT NOCOPY rcv_shipment_line_sv.freight_carrier_record_type

784: PROCEDURE NAME: validate_freight_carrier()
785:
786: ===========================================================================*/
787: PROCEDURE validate_freight_carrier(
788: x_freight_carrier_record IN OUT NOCOPY rcv_shipment_line_sv.freight_carrier_record_type
789: ) IS
790: x_freight_code org_freight_code_val_v.freight_code%TYPE;
791: x_progress VARCHAR2(3);
792: x_error_status VARCHAR2(1);

Line 834: x_tax_name_record IN OUT NOCOPY rcv_shipment_line_sv.tax_name_record_type

830: PROCEDURE NAME: validate_tax_code() (ASBN only)
831:
832: ===========================================================================*/
833: PROCEDURE validate_tax_code(
834: x_tax_name_record IN OUT NOCOPY rcv_shipment_line_sv.tax_name_record_type
835: ) IS
836: x_name ap_tax_codes.NAME%TYPE := NULL;
837: x_progress VARCHAR2(3);
838: x_error_status VARCHAR2(1);

Line 882: x_asl_record IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type

878: PROCEDURE NAME: validate_asl()
879:
880: ===========================================================================*/
881: PROCEDURE validate_asl(
882: x_asl_record IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type
883: ) IS
884: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := 'Y';
885: x_success VARCHAR2(10) := NULL;
886: x_progress VARCHAR2(3);

Line 943: x_cum_quantity_record IN OUT NOCOPY rcv_shipment_line_sv.cum_quantity_record_type

939: PROCEDURE NAME: validate_cum_quantity_shipped()
940:
941: ===========================================================================*/
942: PROCEDURE validate_cum_quantity_shipped(
943: x_cum_quantity_record IN OUT NOCOPY rcv_shipment_line_sv.cum_quantity_record_type
944: ) IS
945: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := 'Y';
946: x_success VARCHAR2(1) := NULL;
947: x_progress VARCHAR2(3);

Line 1103: x_po_lookup_code_record IN OUT NOCOPY rcv_shipment_line_sv.po_lookup_code_record_type

1099: PROCEDURE NAME: validate_po_lookup_code()
1100:
1101: ===========================================================================*/
1102: PROCEDURE validate_po_lookup_code(
1103: x_po_lookup_code_record IN OUT NOCOPY rcv_shipment_line_sv.po_lookup_code_record_type
1104: ) IS
1105: x_progress VARCHAR2(3) := NULL;
1106: x_lookup_code VARCHAR2(25) := NULL;
1107: x_error_status VARCHAR2(1);

Line 1143: x_subinventory_record IN OUT NOCOPY rcv_shipment_line_sv.subinventory_record_type

1139: PROCEDURE NAME: validate_subinventory()
1140:
1141: ===========================================================================*/
1142: PROCEDURE validate_subinventory(
1143: x_subinventory_record IN OUT NOCOPY rcv_shipment_line_sv.subinventory_record_type
1144: ) IS
1145: x_progress VARCHAR2(3) := NULL;
1146: x_subinventory VARCHAR2(10) := NULL;
1147: x_error_status VARCHAR2(1);

Line 1216: x_location_record IN OUT NOCOPY rcv_shipment_line_sv.location_record_type

1212: PROCEDURE NAME: validate_location()
1213:
1214: ===========================================================================*/
1215: PROCEDURE validate_location(
1216: x_location_record IN OUT NOCOPY rcv_shipment_line_sv.location_record_type
1217: ) IS
1218: x_progress VARCHAR2(3) := NULL;
1219: x_location NUMBER;
1220: x_error_status VARCHAR2(1);

Line 1307: x_employee_record IN OUT NOCOPY rcv_shipment_line_sv.employee_record_type

1303: PROCEDURE NAME: validate_employee()
1304:
1305: ===========================================================================*/
1306: PROCEDURE validate_employee(
1307: x_employee_record IN OUT NOCOPY rcv_shipment_line_sv.employee_record_type
1308: ) IS
1309: x_progress VARCHAR2(3) := NULL;
1310: x_full_name VARCHAR2(240) := NULL;
1311: x_error_status VARCHAR2(1);

Line 1359: x_locator_record IN OUT NOCOPY rcv_shipment_line_sv.locator_record_type

1355: PROCEDURE NAME: validate_locator()
1356:
1357: ===========================================================================*/
1358: PROCEDURE validate_locator(
1359: x_locator_record IN OUT NOCOPY rcv_shipment_line_sv.locator_record_type
1360: ) IS
1361: x_progress VARCHAR2(3) := NULL;
1362: x_locator VARCHAR2(81) := NULL;
1363: x_error_status VARCHAR2(1);

Line 1494: x_country_of_origin_record IN OUT NOCOPY rcv_shipment_line_sv.country_of_origin_record_type

1490: PROCEDURE NAME: validate_country_of_origin()
1491:
1492: ===========================================================================*/
1493: PROCEDURE validate_country_of_origin(
1494: x_country_of_origin_record IN OUT NOCOPY rcv_shipment_line_sv.country_of_origin_record_type
1495: ) IS
1496: x_code fnd_territories_vl.territory_code%TYPE := NULL;
1497: x_progress VARCHAR2(3);
1498: x_error_status VARCHAR2(1);

Line 1532: x_consigned_po_rec IN OUT NOCOPY rcv_shipment_line_sv.po_line_location_id_rtype

1528: /*===========================================================================
1529: PROCEDURE NAME: validate_consigned_po()
1530: ===========================================================================*/
1531: PROCEDURE validate_consigned_po(
1532: x_consigned_po_rec IN OUT NOCOPY rcv_shipment_line_sv.po_line_location_id_rtype
1533: ) IS
1534: l_consigned_po_flag po_line_locations_all.consigned_flag%TYPE;
1535: x_error_status VARCHAR2(1);
1536: BEGIN

Line 1570: x_consumption_po_rec IN OUT NOCOPY rcv_shipment_line_sv.document_num_record_type

1566: /*===========================================================================
1567: PROCEDURE NAME: validate_consumption_po()
1568: ===========================================================================*/
1569: PROCEDURE validate_consumption_po(
1570: x_consumption_po_rec IN OUT NOCOPY rcv_shipment_line_sv.document_num_record_type
1571: ) IS
1572: l_consumption_po_flag po_headers_all.consigned_consumption_flag%TYPE;
1573: x_error_status VARCHAR2(1);
1574: BEGIN

Line 1608: x_consumption_release_rec IN OUT NOCOPY rcv_shipment_line_sv.release_id_record_type

1604: /*===========================================================================
1605: PROCEDURE NAME: validate_consumption_release()
1606: ===========================================================================*/
1607: PROCEDURE validate_consumption_release(
1608: x_consumption_release_rec IN OUT NOCOPY rcv_shipment_line_sv.release_id_record_type
1609: ) IS
1610: l_consumption_release_flag po_releases_all.consigned_consumption_flag%TYPE;
1611: x_error_status VARCHAR2(1);
1612: BEGIN