DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on RCV_SHIPMENT_OBJECT_SV

Line 1138: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;

1134: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1135: n IN OUT NOCOPY BINARY_INTEGER,
1136: x_header_record IN rcv_roi_preprocessor.header_rec_type
1137: ) IS
1138: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
1139: x_to_organization_code VARCHAR2(5);
1140: BEGIN
1141: -- default org from header in case it is null at the line level
1142: asn_debug.put_line('error derive_ship_to_org_info' || x_cascaded_table(n).error_status);

Line 1766: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;

1762: PROCEDURE derive_from_org_info(
1763: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1764: n IN OUT NOCOPY BINARY_INTEGER
1765: ) IS
1766: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
1767: BEGIN
1768: IF (x_cascaded_table(n).error_status IN('S', 'W'))
1769: AND ( x_cascaded_table(n).from_organization_id IS NULL
1770: AND x_cascaded_table(n).from_organization_code IS NOT NULL) THEN

Line 1810: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;

1806: PROCEDURE derive_transit_org_info(
1807: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1808: n IN OUT NOCOPY BINARY_INTEGER
1809: ) IS
1810: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
1811: BEGIN
1812: IF (x_cascaded_table(n).error_status IN('S', 'W'))
1813: AND ( x_cascaded_table(n).intransit_owning_org_id IS NULL
1814: AND x_cascaded_table(n).intransit_owning_org_code IS NOT NULL) THEN

Line 1854: location_id_record rcv_shipment_object_sv.location_id_record_type;

1850: PROCEDURE derive_location_info(
1851: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1852: n IN OUT NOCOPY BINARY_INTEGER
1853: ) IS
1854: location_id_record rcv_shipment_object_sv.location_id_record_type;
1855: BEGIN
1856: IF (x_cascaded_table(n).error_status IN('S', 'W'))
1857: AND ( x_cascaded_table(n).location_id IS NULL
1858: AND x_cascaded_table(n).location_code IS NOT NULL) THEN

Line 1882: location_id_record rcv_shipment_object_sv.location_id_record_type;

1878: PROCEDURE derive_ship_to_location_info(
1879: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1880: n IN OUT NOCOPY BINARY_INTEGER
1881: ) IS
1882: location_id_record rcv_shipment_object_sv.location_id_record_type;
1883: BEGIN
1884: IF (x_cascaded_table(n).error_status IN('S', 'W'))
1885: AND ( x_cascaded_table(n).ship_to_location_id IS NULL
1886: AND x_cascaded_table(n).ship_to_location_code IS NOT NULL) THEN

Line 1966: employee_id_record rcv_shipment_object_sv.employee_id_record_type;

1962: PROCEDURE derive_deliver_to_person_info(
1963: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1964: n IN OUT NOCOPY BINARY_INTEGER
1965: ) IS
1966: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
1967: BEGIN
1968: IF (x_cascaded_table(n).error_status IN('S', 'W'))
1969: AND ( x_cascaded_table(n).deliver_to_person_id IS NULL
1970: AND x_cascaded_table(n).deliver_to_person_name IS NOT NULL) THEN

Line 2010: location_id_record rcv_shipment_object_sv.location_id_record_type;

2006: PROCEDURE derive_deliver_to_loc_info(
2007: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2008: n IN OUT NOCOPY BINARY_INTEGER
2009: ) IS
2010: location_id_record rcv_shipment_object_sv.location_id_record_type;
2011: BEGIN
2012: IF (x_cascaded_table(n).error_status IN('S', 'W'))
2013: AND ( x_cascaded_table(n).deliver_to_location_id IS NULL
2014: AND x_cascaded_table(n).deliver_to_location_code IS NOT NULL) THEN