DBA Data[Home] [Help]

APPS.RCV_INT_ORDER_PP_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 128: the receipt number created in RCV_SHIPMENT_HEADERS table, through

124:
125: /* Bug 4907179: Logging error in PO_INTERFACE_ERRORS table and erroring out the transaction, as
126: we are not able to default the shipment_header_id.
127: Reason: If shipment_header_id is not defaulted, we won't be able to stamp
128: the receipt number created in RCV_SHIPMENT_HEADERS table, through
129: rcv_int_order_pp_pvt.update_header() procedure.*/
130: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
131: rcv_error_pkg.set_error_message('RCV_NO_SHIPMENT_NUM', p_header_record.error_record.error_message);
132: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPMENT_NUM', false);/* Bug 4907179 */

Line 139: FROM rcv_shipment_headers

135: END IF;
136:
137: SELECT MAX(shipment_header_id)
138: INTO p_header_record.header_record.receipt_header_id
139: FROM rcv_shipment_headers
140: WHERE shipment_num = p_header_record.header_record.shipment_num
141: AND receipt_source_code IN('INVENTORY', 'INTERNAL ORDER');
142: EXCEPTION
143: WHEN OTHERS THEN

Line 157: UPDATE rcv_shipment_headers

153: PROCEDURE update_header(
154: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
155: ) IS
156: BEGIN
157: UPDATE rcv_shipment_headers
158: SET shipment_header_id = p_header_record.header_record.receipt_header_id,
159: last_update_date = p_header_record.header_record.last_update_date,
160: last_updated_by = p_header_record.header_record.last_updated_by,
161: creation_date = p_header_record.header_record.creation_date,

Line 737: FROM rcv_shipment_headers rsh,

733: rsl.primary_unit_of_measure primary_unit_of_measure,
734: rsl.requisition_line_id requisition_line_id,
735: rsl.po_line_location_id po_line_location_id,
736: rsl.employee_id employee_id
737: FROM rcv_shipment_headers rsh,
738: rcv_shipment_lines rsl,
739: po_requisition_lines_all porl
740: -- Following 2 lines are commented out for Bugfix 5201155
741: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)

Line 762: FROM rcv_shipment_headers rsh,

758: v_ship_to_org_id NUMBER,
759: v_ship_from_org_id NUMBER
760: ) IS
761: SELECT COUNT(*) AS line_count
762: FROM rcv_shipment_headers rsh,
763: rcv_shipment_lines rsl,
764: po_requisition_lines_all porl
765: -- Following 2 lines are commented out for Bugfix 5201155
766: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)

Line 804: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE; -- Bugfix 5201155

800: x_ship_to_organization_id NUMBER;
801: x_sob_id NUMBER := NULL;
802: x_secondary_available_qty NUMBER := 0;
803: x_full_name VARCHAR2(240) := NULL; -- Bug 2392074
804: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE; -- Bugfix 5201155
805: BEGIN
806: x_progress := '097';
807:
808: IF (g_asn_debug = 'Y') THEN

Line 874: FROM rcv_shipment_headers rsh,

870: */
871: BEGIN
872: SELECT distinct rsh.shipment_header_id
873: INTO l_shipment_header_id
874: FROM rcv_shipment_headers rsh,
875: rcv_shipment_lines rsl
876: WHERE shipment_num = temp_cascaded_table(current_n).shipment_num
877: AND rsh.shipment_header_id = rsl.shipment_header_id
878: AND rsl.to_organization_id = NVL(temp_cascaded_table(current_n).to_organization_id, to_organization_id)

Line 1602: FROM rcv_shipment_headers rsh

1598: IF ( x_cascaded_table(n).parent_transaction_id IS NULL
1599: OR x_cascaded_table(n).parent_transaction_id = 0) THEN
1600: SELECT rsh.shipment_header_id
1601: INTO l_shipment_header_id
1602: FROM rcv_shipment_headers rsh
1603: WHERE shipment_num = x_cascaded_table(n).shipment_num
1604: AND receipt_source_code = 'INTERNAL ORDER';
1605:
1606: SELECT rsl.shipment_line_id