eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_PREPROCESSOR dependencies on RCV_HEADERS_INTERFACE

Line 265: FROM rcv_headers_interface rsh,

261: DECODE(NVL(poll.outsourced_assembly, get_oe_osa_flag(rti.oe_order_line_id)),
262: 1, 1,
263: NULL
264: ) osa_flag
265: FROM rcv_headers_interface rsh,
266: rcv_transactions_interface rti,
267: po_line_locations_all poll
268: WHERE rsh.asn_type = 'ASBN'
269: AND rsh.header_interface_id = rti.header_interface_id

Line 281: FROM rcv_headers_interface

277: * * records in RHI*/
278: /* Moved this cursor as well as its for loop to the rcv_dcp_pvt package */
279: /* CURSOR headers_cur_dcp(x_request_id NUMBER, x_group_id NUMBER) IS
280: SELECT *
281: FROM rcv_headers_interface
282: WHERE NVL(asn_type, 'STD') IN('ASN', 'ASBN', 'STD', 'WC')
283: AND processing_status_code IN('RUNNING', 'SUCCESS','ERROR','PENDING')
284: AND(NVL(validation_flag, 'N') = 'Y'
285: OR processing_status_code = 'SUCCESS') -- include success row for multi-line asn

Line 292: FROM rcv_headers_interface rhi

288: AND GROUP_ID = DECODE(x_group_id, 0, GROUP_ID, x_group_id); */
289: -- Bug 8831292
290: CURSOR errored_asn_rhi_cursor IS
291: SELECT *
292: FROM rcv_headers_interface rhi
293: WHERE asn_type IN ('ASN', 'ASBN')
294: AND processing_request_id = p_request_id
295: AND (group_id = p_group_id or p_group_id = 0)
296: AND (processing_status_code = 'ERROR'

Line 417: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

413: FOR bad_shikyu IN get_bad_asbn_shikyu LOOP --Shikyu project
414: BEGIN
415: rcv_error_pkg.set_error_message('RCV_BAD_ASBN_SHIKYU');
416: rcv_error_pkg.set_token('HEADER_INTERFACE_ID', bad_shikyu.header_interface_id);
417: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
418: 'HEADER_INTERFACE_ID',
419: x_group_id,
420: bad_shikyu.header_interface_id,
421: NULL,

Line 425: UPDATE rcv_headers_interface

421: NULL,
422: FALSE
423: );
424:
425: UPDATE rcv_headers_interface
426: SET processing_status_code = 'ERROR'
427: WHERE header_interface_id = bad_shikyu.header_interface_id;
428:
429: UPDATE rcv_transactions_interface

Line 699: UPDATE rcv_headers_interface

695: -- header errored out
696: -- 1) update rhi
697: -- x_header_record.header_record might still be null in this case
698: -- if no row found in RHI, a no_data_found exception will be raised
699: UPDATE rcv_headers_interface
700: SET processing_status_code = 'ERROR'
701: WHERE header_interface_id = x_cascaded_table(n).header_interface_id;
702:
703: x_header_record.header_record.processing_status_code := 'ERROR';

Line 706: /* Bug 4344351: Log a message indicating an error in RCV_HEADERS_INTERFACE table.*/

702:
703: x_header_record.header_record.processing_status_code := 'ERROR';
704: x_header_record.error_record.error_status := 'E';
705:
706: /* Bug 4344351: Log a message indicating an error in RCV_HEADERS_INTERFACE table.*/
707: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE','',FALSE);
708:
709: -- 2) update rti
710: IF (g_asn_debug = 'Y') THEN

Line 707: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE','',FALSE);

703: x_header_record.header_record.processing_status_code := 'ERROR';
704: x_header_record.error_record.error_status := 'E';
705:
706: /* Bug 4344351: Log a message indicating an error in RCV_HEADERS_INTERFACE table.*/
707: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE','',FALSE);
708:
709: -- 2) update rti
710: IF (g_asn_debug = 'Y') THEN
711: asn_debug.put_line('update_rti_error after rhi error ');

Line 734: UPDATE rcv_headers_interface

730:
731: x_cascaded_table(n).error_status := 'P';
732: x_cascaded_table(n).processing_status_code := 'PENDING';
733: ELSE -- }{ the header was processed successfully
734: UPDATE rcv_headers_interface
735: SET processing_status_code = 'SUCCESS',
736: validation_flag = 'N',
737: receipt_header_id = x_header_record.header_record.receipt_header_id
738: WHERE header_interface_id = x_header_record.header_record.header_interface_id

Line 928: from rcv_headers_interface

924: UPDATE rcv_shipment_headers
925: SET asn_status = null
926: WHERE (shipment_header_id = x_cascaded_table(n).shipment_header_id
927: OR shipment_num = (select shipment_num
928: from rcv_headers_interface
929: where header_interface_id =
930: x_cascaded_table(n).header_interface_id)
931: OR shipment_header_id = (select receipt_header_id
932: from rcv_headers_interface

Line 932: from rcv_headers_interface

928: from rcv_headers_interface
929: where header_interface_id =
930: x_cascaded_table(n).header_interface_id)
931: OR shipment_header_id = (select receipt_header_id
932: from rcv_headers_interface
933: where header_interface_id =
934: x_cascaded_table(n).header_interface_id))
935: AND asn_status = 'NEW_SHIP';
936:

Line 1049: UPDATE rcv_headers_interface

1045: IF (g_asn_debug = 'Y') THEN
1046: asn_debug.put_line('error out rhi for a fail all ASN transaction ');
1047: END IF;
1048:
1049: UPDATE rcv_headers_interface
1050: SET processing_status_code = 'ERROR',
1051: validation_flag = 'Y',
1052: receipt_header_id = NULL
1053: WHERE header_interface_id = x_cascaded_table(n).header_interface_id;-- bug 7684677

Line 1097: FROM rcv_transactions_interface rti, rcv_headers_interface rhi

1093: AND NOT EXISTS(SELECT rt.transaction_id
1094: FROM rcv_transactions rt
1095: WHERE shipment_header_id = x_header_record.header_record.receipt_header_id)
1096: AND NOT EXISTS(SELECT rti.interface_transaction_id "Running rows in RTI" -- take care of multi RECEIVE txns under one header
1097: FROM rcv_transactions_interface rti, rcv_headers_interface rhi
1098: WHERE rhi.header_interface_id = rti.header_interface_id
1099: AND rti.processing_status_code in ('RUNNING', 'PENDING')
1100: AND rhi.receipt_header_id = x_header_record.header_record.receipt_header_id);
1101:

Line 1110: UPDATE rcv_headers_interface rhi

1106: END IF;
1107: -- End bug 9268956
1108:
1109: IF x_cascaded_table(n).header_interface_id IS NOT NULL THEN --{
1110: UPDATE rcv_headers_interface rhi
1111: SET rhi.processing_status_code = 'ERROR',
1112: rhi.validation_flag = 'Y',
1113: rhi.receipt_header_id = NULL
1114: WHERE header_interface_id = x_cascaded_table(n).header_interface_id

Line 1144: rcv_headers_interface rhi

1140: WHERE shipment_header_id = l_ship_header_id
1141: AND asn_status = 'NEW_SHIP'
1142: AND NOT EXISTS ( SELECT rti.interface_transaction_id
1143: FROM rcv_transactions_interface rti,
1144: rcv_headers_interface rhi
1145: WHERE rhi.header_interface_id = rti.header_interface_id
1146: AND rti.processing_status_code in ('RUNNING', 'PENDING')
1147: AND rhi.receipt_header_id = l_ship_header_id );
1148:

Line 1717: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,

1713:
1714: PROCEDURE process_line(
1715: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1716: n IN OUT NOCOPY BINARY_INTEGER,
1717: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
1718: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1719: v_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1720: ) IS
1721: x_parent_id NUMBER;

Line 1718: x_asn_type IN rcv_headers_interface.asn_type%TYPE,

1714: PROCEDURE process_line(
1715: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1716: n IN OUT NOCOPY BINARY_INTEGER,
1717: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
1718: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
1719: v_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1720: ) IS
1721: x_parent_id NUMBER;
1722: x_progress VARCHAR2(3);

Line 2289: UPDATE rcv_headers_interface

2285: IF (g_asn_debug = 'Y') THEN
2286: asn_debug.put_line('update all rti rows to error');
2287: END IF;
2288:
2289: UPDATE rcv_headers_interface
2290: SET processing_status_code = 'ERROR'
2291: WHERE GROUP_ID = p_group_id;
2292:
2293: UPDATE rcv_transactions_interface