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_NORMALIZE_DATA_PKG dependencies on RCV_TABLE_FUNCTIONS

Line 44: rcv_table_functions.update_rti_row(p_rti_row);

40: );
41: /*END BUG: 5598140*/
42: END IF;
43:
44: rcv_table_functions.update_rti_row(p_rti_row);
45:
46: IF (g_multiple_groups = FALSE) THEN
47: COMMIT; --We don't want to erase what we've done so far
48: --RAISE rcv_error_pkg.e_fatal_error;

Line 74: rcv_table_functions.update_rhi_row(p_rhi_row);

70:
71: p_rhi_row.processing_status_code := 'ERROR';
72: p_rhi_row.processing_request_id := g_request_id;
73:
74: rcv_table_functions.update_rhi_row(p_rhi_row);
75: COMMIT;
76: END IF;
77: EXCEPTION
78: WHEN OTHERS THEN

Line 102: rcv_table_functions.update_rhi_row(p_rhi_row);

98: AND processing_status_code IN('PENDING', 'RUNNING')
99: AND transaction_status_code = 'PENDING';
100: END; --exception handling block
101:
102: rcv_table_functions.update_rhi_row(p_rhi_row);
103: END prepare_pending_rhi;
104:
105: PROCEDURE prepare_pending_rti(
106: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

Line 122: rcv_table_functions.update_rti_row(p_rti_row);

118: WHEN OTHERS THEN
119: handle_error(p_rti_row);
120: END; --exception handling block
121:
122: rcv_table_functions.update_rti_row(p_rti_row);
123: END prepare_pending_rti;
124:
125: PROCEDURE process_orphan_rti(
126: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

Line 135: rcv_table_functions.update_rti_row(p_rti_row);

131: EXCEPTION
132: WHEN OTHERS THEN
133: p_rti_row.processing_status_code := 'ERROR';
134: p_rti_row.processing_request_id := g_request_id;
135: rcv_table_functions.update_rti_row(p_rti_row);
136: END;
137:
138: PROCEDURE process_row(
139: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

Line 229: x_rhi_row := rcv_table_functions.get_rhi_row_from_id(p_rti_row.header_interface_id);

225: /* EXECUTE PROCESSOR on row */
226: IF (p_rti_row.processing_status_code <> 'ERROR') THEN
227:
228: /* lcm chages : Start */
229: x_rhi_row := rcv_table_functions.get_rhi_row_from_id(p_rti_row.header_interface_id);
230:
231: IF ( rcv_table_functions.is_lcm_org (p_rti_row.to_organization_id) = 'Y'
232: AND rcv_table_functions.is_pre_rcv_org (p_rti_row.to_organization_id) = 'N') Then
233: --

Line 231: IF ( rcv_table_functions.is_lcm_org (p_rti_row.to_organization_id) = 'Y'

227:
228: /* lcm chages : Start */
229: x_rhi_row := rcv_table_functions.get_rhi_row_from_id(p_rti_row.header_interface_id);
230:
231: IF ( rcv_table_functions.is_lcm_org (p_rti_row.to_organization_id) = 'Y'
232: AND rcv_table_functions.is_pre_rcv_org (p_rti_row.to_organization_id) = 'N') Then
233: --
234: IF (p_rti_row.source_document_code = 'PO'
235: AND (p_rti_row.transaction_type = 'RECEIVE'

Line 232: AND rcv_table_functions.is_pre_rcv_org (p_rti_row.to_organization_id) = 'N') Then

228: /* lcm chages : Start */
229: x_rhi_row := rcv_table_functions.get_rhi_row_from_id(p_rti_row.header_interface_id);
230:
231: IF ( rcv_table_functions.is_lcm_org (p_rti_row.to_organization_id) = 'Y'
232: AND rcv_table_functions.is_pre_rcv_org (p_rti_row.to_organization_id) = 'N') Then
233: --
234: IF (p_rti_row.source_document_code = 'PO'
235: AND (p_rti_row.transaction_type = 'RECEIVE'
236: OR (p_rti_row.transaction_type = 'SHIP'

Line 238: AND rcv_table_functions.is_lcm_shipment (p_rti_row.po_line_location_id) = 'Y'

234: IF (p_rti_row.source_document_code = 'PO'
235: AND (p_rti_row.transaction_type = 'RECEIVE'
236: OR (p_rti_row.transaction_type = 'SHIP'
237: AND p_rti_row.auto_transact_code in ('RECEIVE','DELIVER')))
238: AND rcv_table_functions.is_lcm_shipment (p_rti_row.po_line_location_id) = 'Y'
239: AND p_rti_row.lcm_shipment_line_id is null) THEN
240: --
241: asn_debug.put_line('Setting current row to status LC_PENDING');
242: p_rti_row.processing_status_code := 'LC_PENDING';

Line 289: rcv_table_functions.update_rhi_row(x_rhi_row);

285: IF (x_rhi_row.processing_status_code = 'ERROR') THEN
286: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);
287: x_rhi_row.processing_status_code := 'PENDING';
288: x_rhi_row.processing_request_id := g_request_id;
289: rcv_table_functions.update_rhi_row(x_rhi_row);
290: END IF;
291: ELSE
292: asn_debug.put_line('Setting current row to status RUNNING');
293: p_rti_row.processing_status_code := 'RUNNING';

Line 299: rcv_table_functions.update_rhi_row(x_rhi_row);

295: IF (x_rhi_row.processing_status_code IN ('PENDING', 'ERROR')) THEN
296: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);
297: x_rhi_row.processing_status_code := 'RUNNING';
298: x_rhi_row.processing_request_id := g_request_id;
299: rcv_table_functions.update_rhi_row(x_rhi_row);
300: END IF;
301: END IF;
302: --
303: END IF;

Line 314: rcv_table_functions.update_rhi_row(x_rhi_row);

310: IF (x_rhi_row.processing_status_code IN('PENDING', 'ERROR')) THEN
311: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);
312: x_rhi_row.processing_status_code := 'RUNNING';
313: x_rhi_row.processing_request_id := g_request_id;
314: rcv_table_functions.update_rhi_row(x_rhi_row);
315: END IF;
316: END IF;
317: /* lcm chages : End */
318:

Line 321: rcv_table_functions.update_rti_row(p_rti_row);

317: /* lcm chages : End */
318:
319: END IF;
320:
321: rcv_table_functions.update_rti_row(p_rti_row);
322: END;
323:
324: PROCEDURE explode_all_lpn IS
325: l_ret_status VARCHAR2(20);

Line 507: rcv_table_functions.g_default_org_id := p_org_id;

503:
504: g_group_id := NVL(p_group_id, 0);
505: g_request_id := NVL(p_request_id, 0);
506: g_processing_mode := p_processing_mode; -- Bug 6311798
507: rcv_table_functions.g_default_org_id := p_org_id;
508:
509: IF g_group_id = 0 THEN
510: OPEN c_get_group_id;
511: FETCH c_get_group_id INTO g_group_id;