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 165: UPDATE rcv_shipment_headers

161:
162: IF NVL(p_header_record.header_record.test_flag, 'N') = 'Y' THEN
163: IF (p_header_record.header_record.receipt_num IS NOT NULL) THEN
164: BEGIN
165: UPDATE rcv_shipment_headers
166: SET receipt_num = p_header_record.header_record.receipt_num,
167: last_update_date = p_header_record.header_record.last_update_date,
168: last_updated_by = p_header_record.header_record.last_updated_by,
169: last_update_login = p_header_record.header_record.last_update_login,

Line 187: UPDATE rcv_shipment_headers

183: END IF;
184: RETURN;
185: END IF;
186: -- Bug 12591134: End
187: UPDATE rcv_shipment_headers
188: SET shipment_header_id = p_header_record.header_record.receipt_header_id,
189: last_update_date = p_header_record.header_record.last_update_date,
190: last_updated_by = p_header_record.header_record.last_updated_by,
191: creation_date = p_header_record.header_record.creation_date,

Line 780: FROM rcv_shipment_headers rsh,

776: rsl.primary_unit_of_measure primary_unit_of_measure,
777: rsl.requisition_line_id requisition_line_id,
778: rsl.po_line_location_id po_line_location_id,
779: rsl.employee_id employee_id
780: FROM rcv_shipment_headers rsh,
781: rcv_shipment_lines rsl,
782: po_requisition_lines_all porl
783: -- Following 2 lines are commented out for Bugfix 5201155
784: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)

Line 807: FROM rcv_shipment_headers rsh,

803: v_ship_from_org_id NUMBER,
804: v_shipment_line_id NUMBER -- Bug 8374257
805: ) IS
806: SELECT COUNT(*) AS line_count
807: FROM rcv_shipment_headers rsh,
808: rcv_shipment_lines rsl,
809: po_requisition_lines_all porl
810: -- Following 2 lines are commented out for Bugfix 5201155
811: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)

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

846: x_ship_to_organization_id NUMBER;
847: x_sob_id NUMBER := NULL;
848: x_secondary_available_qty NUMBER := 0;
849: x_full_name VARCHAR2(240) := NULL; -- Bug 2392074
850: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE; -- Bugfix 5201155
851: BEGIN
852: x_progress := '097';
853:
854: IF (g_asn_debug = 'Y') THEN

Line 920: FROM rcv_shipment_headers rsh,

916: */
917: BEGIN
918: SELECT distinct rsh.shipment_header_id
919: INTO l_shipment_header_id
920: FROM rcv_shipment_headers rsh,
921: rcv_shipment_lines rsl
922: WHERE shipment_num = temp_cascaded_table(current_n).shipment_num
923: AND rsh.shipment_header_id = rsl.shipment_header_id
924: AND rsl.to_organization_id = NVL(temp_cascaded_table(current_n).to_organization_id, to_organization_id)

Line 1661: FROM rcv_shipment_headers rsh

1657: IF ( x_cascaded_table(n).parent_transaction_id IS NULL
1658: OR x_cascaded_table(n).parent_transaction_id = 0) THEN
1659: SELECT rsh.shipment_header_id
1660: INTO l_shipment_header_id
1661: FROM rcv_shipment_headers rsh
1662: WHERE shipment_num = x_cascaded_table(n).shipment_num
1663: AND receipt_source_code = 'INTERNAL ORDER';
1664:
1665: SELECT rsl.shipment_line_id