DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on RCV_SHIPMENT_OBJECT_SV

Line 1565: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;

1561: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1562: n IN OUT NOCOPY BINARY_INTEGER,
1563: x_header_record IN rcv_roi_preprocessor.header_rec_type
1564: ) IS
1565: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
1566: x_to_organization_code VARCHAR2(5);
1567: BEGIN
1568: -- default org from header in case it is null at the line level
1569: asn_debug.put_line('error derive_ship_to_org_info' || x_cascaded_table(n).error_status);

Line 2248: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;

2244: PROCEDURE derive_from_org_info(
2245: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2246: n IN OUT NOCOPY BINARY_INTEGER
2247: ) IS
2248: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
2249: BEGIN
2250: IF (x_cascaded_table(n).error_status IN('S', 'W'))
2251: AND ( x_cascaded_table(n).from_organization_id IS NULL
2252: AND x_cascaded_table(n).from_organization_code IS NOT NULL) THEN

Line 2292: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;

2288: PROCEDURE derive_transit_org_info(
2289: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2290: n IN OUT NOCOPY BINARY_INTEGER
2291: ) IS
2292: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
2293: BEGIN
2294: IF (x_cascaded_table(n).error_status IN('S', 'W'))
2295: AND ( x_cascaded_table(n).intransit_owning_org_id IS NULL
2296: AND x_cascaded_table(n).intransit_owning_org_code IS NOT NULL) THEN

Line 2336: location_id_record rcv_shipment_object_sv.location_id_record_type;

2332: PROCEDURE derive_location_info(
2333: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2334: n IN OUT NOCOPY BINARY_INTEGER
2335: ) IS
2336: location_id_record rcv_shipment_object_sv.location_id_record_type;
2337: BEGIN
2338: IF (x_cascaded_table(n).error_status IN('S', 'W'))
2339: AND ( x_cascaded_table(n).location_id IS NULL
2340: AND x_cascaded_table(n).location_code IS NOT NULL) THEN

Line 2364: location_id_record rcv_shipment_object_sv.location_id_record_type;

2360: PROCEDURE derive_ship_to_location_info(
2361: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2362: n IN OUT NOCOPY BINARY_INTEGER
2363: ) IS
2364: location_id_record rcv_shipment_object_sv.location_id_record_type;
2365: BEGIN
2366: IF (x_cascaded_table(n).error_status IN('S', 'W'))
2367: AND ( x_cascaded_table(n).ship_to_location_id IS NULL
2368: AND x_cascaded_table(n).ship_to_location_code IS NOT NULL) THEN

Line 2448: employee_id_record rcv_shipment_object_sv.employee_id_record_type;

2444: PROCEDURE derive_deliver_to_person_info(
2445: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2446: n IN OUT NOCOPY BINARY_INTEGER
2447: ) IS
2448: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
2449: BEGIN
2450: IF (x_cascaded_table(n).error_status IN('S', 'W'))
2451: AND ( x_cascaded_table(n).deliver_to_person_id IS NULL
2452: AND x_cascaded_table(n).deliver_to_person_name IS NOT NULL) THEN

Line 2492: location_id_record rcv_shipment_object_sv.location_id_record_type;

2488: PROCEDURE derive_deliver_to_loc_info(
2489: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2490: n IN OUT NOCOPY BINARY_INTEGER
2491: ) IS
2492: location_id_record rcv_shipment_object_sv.location_id_record_type;
2493: BEGIN
2494: IF (x_cascaded_table(n).error_status IN('S', 'W'))
2495: AND ( x_cascaded_table(n).deliver_to_location_id IS NULL
2496: AND x_cascaded_table(n).deliver_to_location_code IS NOT NULL) THEN