APPS.RCV_ROI_TRANSACTION dependencies on RCV_HEADERS_INTERFACE

Line 615: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,

611:
612: PROCEDURE default_vendor_rcv_line(
613: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
614: n IN BINARY_INTEGER,
615: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
616: x_header_record IN rcv_roi_preprocessor.header_rec_type
617: ) IS
618: x_progress VARCHAR2(3);
619: x_locator_control NUMBER;

Line 1152: x_asn_type IN rcv_headers_interface.asn_type%TYPE,

1148:
1149: PROCEDURE validate_vendor_rcv_line(
1150: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1151: n IN BINARY_INTEGER,
1152: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1153: x_header_record IN rcv_roi_preprocessor.header_rec_type
1154: ) IS
1155: l_parent_deliver_to_person_id NUMBER := null; --Bug#6375015
1156: l_skip_validation NUMBER := 0; --Bug#6375015

Line 1490: x_asn_type IN rcv_headers_interface.asn_type%TYPE,

1486:
1487: PROCEDURE validate_amt_based_rcv_line(
1488: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1489: n IN BINARY_INTEGER,
1490: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1491: x_header_record IN rcv_roi_preprocessor.header_rec_type
1492: ) IS
1493: BEGIN
1494: IF (g_asn_debug = 'Y') THEN

Line 2102: from rcv_headers_interface

2098: */
2099: If ( x_cascaded_table(n).header_interface_id is not null) then
2100: select asn_type
2101: into l_asn_type
2102: from rcv_headers_interface
2103: where header_interface_id =
2104: x_cascaded_table(n).header_interface_id;
2105: end if;
2106:

Line 8359: x_asn_type IN rcv_headers_interface.asn_type%TYPE

8355: PROCEDURE validate_tax_code(
8356: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8357: n IN BINARY_INTEGER,
8358: /* Bug3454491 (4) */
8359: x_asn_type IN rcv_headers_interface.asn_type%TYPE
8360: ) IS
8361: tax_name_record rcv_shipment_line_sv.tax_name_record_type;
8362: BEGIN
8363: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN

Line 8828: x_asn_type IN rcv_headers_interface.asn_type%TYPE

8824: PROCEDURE validate_consigned_inventory(
8825: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8826: n IN BINARY_INTEGER,
8827: /* Bug3454491 (5) */
8828: x_asn_type IN rcv_headers_interface.asn_type%TYPE
8829: ) IS
8830: l_consigned_po_rec rcv_shipment_line_sv.po_line_location_id_rtype;
8831: l_consumption_po_rec rcv_shipment_line_sv.document_num_record_type;
8832: l_consumption_release_rec rcv_shipment_line_sv.release_id_record_type;

Line 10055: UPDATE rcv_headers_interface rhi

10051: WHERE header_interface_id=l_header_interface_id
10052: AND processing_status_code='ERROR';
10053:
10054: IF (l_count=l_cnt AND l_trx_type in ('SHIP','RECEIVE') AND l_src_doc_code='PO') THEN
10055: UPDATE rcv_headers_interface rhi
10056: SET processing_status_code='ERROR'
10057: WHERE header_interface_id=l_header_interface_id;
10058:
10059: asn_debug.put_line('Deleting the rsh record with shipment_header_id = '||l_ship_head_id);

Line 10069: /* update rcv_headers_interface rhi

10065: WHERE rt.shipment_header_id = rsh.shipment_header_id);
10066: END IF;
10067: END IF;
10068:
10069: /* update rcv_headers_interface rhi
10070: set processing_status_code='ERROR'
10071: where header_interface_id=l_header_interface_id
10072: and not exists(select 1 from rcv_transactions_interface
10073: where header_interface_id=l_header_interface_id

Line 17157: x_asn_type IN rcv_headers_interface.asn_type%type,

17153:
17154: PROCEDURE validate_lcm_line
17155: ( x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
17156: n IN binary_integer,
17157: x_asn_type IN rcv_headers_interface.asn_type%type,
17158: x_header_record IN rcv_roi_preprocessor.header_rec_type
17159: ) IS
17160:
17161: l_pre_rcv_flag VARCHAR2(1);