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 46: rcv_table_functions.update_rti_row(p_rti_row);

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

Line 76: rcv_table_functions.update_rhi_row(p_rhi_row);

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

Line 104: rcv_table_functions.update_rhi_row(p_rhi_row);

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

Line 130: rcv_table_functions.update_rti_row(p_rti_row);

126: WHEN OTHERS THEN
127: handle_error(p_rti_row);
128: END; --exception handling block
129:
130: rcv_table_functions.update_rti_row(p_rti_row);
131: END prepare_pending_rti;
132:
133: PROCEDURE process_orphan_rti(
134: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

Line 143: rcv_table_functions.update_rti_row(p_rti_row);

139: EXCEPTION
140: WHEN OTHERS THEN
141: p_rti_row.processing_status_code := 'ERROR';
142: p_rti_row.processing_request_id := g_request_id;
143: rcv_table_functions.update_rti_row(p_rti_row);
144: END;
145:
146: PROCEDURE process_row(
147: p_rti_row IN OUT NOCOPY rcv_transactions_interface%ROWTYPE

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

238: /* EXECUTE PROCESSOR on row */
239: IF (p_rti_row.processing_status_code <> 'ERROR') THEN
240:
241: /* lcm chages : Start */
242: x_rhi_row := rcv_table_functions.get_rhi_row_from_id(p_rti_row.header_interface_id);
243:
244: IF ( rcv_table_functions.is_lcm_org (p_rti_row.to_organization_id) = 'Y'
245: AND rcv_table_functions.is_pre_rcv_org (p_rti_row.to_organization_id) = 'N') Then
246: --

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

240:
241: /* lcm chages : Start */
242: x_rhi_row := rcv_table_functions.get_rhi_row_from_id(p_rti_row.header_interface_id);
243:
244: IF ( rcv_table_functions.is_lcm_org (p_rti_row.to_organization_id) = 'Y'
245: AND rcv_table_functions.is_pre_rcv_org (p_rti_row.to_organization_id) = 'N') Then
246: --
247: IF ( p_rti_row.source_document_code = 'PO'
248: AND (p_rti_row.transaction_type = 'RECEIVE'

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

241: /* lcm chages : Start */
242: x_rhi_row := rcv_table_functions.get_rhi_row_from_id(p_rti_row.header_interface_id);
243:
244: IF ( rcv_table_functions.is_lcm_org (p_rti_row.to_organization_id) = 'Y'
245: AND rcv_table_functions.is_pre_rcv_org (p_rti_row.to_organization_id) = 'N') Then
246: --
247: IF ( p_rti_row.source_document_code = 'PO'
248: AND (p_rti_row.transaction_type = 'RECEIVE'
249: OR (p_rti_row.transaction_type = 'SHIP'

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

247: IF ( p_rti_row.source_document_code = 'PO'
248: AND (p_rti_row.transaction_type = 'RECEIVE'
249: OR (p_rti_row.transaction_type = 'SHIP'
250: AND p_rti_row.auto_transact_code in ('RECEIVE','DELIVER')))
251: AND rcv_table_functions.is_lcm_shipment (p_rti_row.po_line_location_id) = 'Y'
252: AND p_rti_row.lcm_shipment_line_id is null) THEN
253: --
254: asn_debug.put_line('Setting current row to status LC_PENDING');
255: p_rti_row.processing_status_code := 'LC_PENDING';

Line 268: rcv_table_functions.update_rhi_row(x_rhi_row);

264: x_rhi_row.processing_status_code := 'LC_PENDING';
265: x_rhi_row.receipt_num := x_header_record.header_record.receipt_num;
266: asn_debug.put_line('Generated new receipt_num for rhi : ' || x_rhi_row.receipt_num, null,14);
267: END IF;
268: rcv_table_functions.update_rhi_row(x_rhi_row);
269: END IF;
270: -- Bug 8343811: End
271: ELSE
272: /* If a non-lcm line and lcm line are tied to the same lpn_group_id, we

Line 324: rcv_table_functions.update_rhi_row(x_rhi_row);

320: IF (x_rhi_row.processing_status_code = 'ERROR') THEN
321: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);
322: x_rhi_row.processing_status_code := 'PENDING';
323: x_rhi_row.processing_request_id := g_request_id;
324: rcv_table_functions.update_rhi_row(x_rhi_row);
325: END IF;
326: ELSE
327: asn_debug.put_line('Setting current row to status RUNNING');
328: p_rti_row.processing_status_code := 'RUNNING';

Line 334: rcv_table_functions.update_rhi_row(x_rhi_row);

330: IF (x_rhi_row.processing_status_code IN ('PENDING', 'ERROR')) THEN
331: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);
332: x_rhi_row.processing_status_code := 'RUNNING';
333: x_rhi_row.processing_request_id := g_request_id;
334: rcv_table_functions.update_rhi_row(x_rhi_row);
335: END IF;
336: END IF;
337: --
338: END IF;

Line 349: rcv_table_functions.update_rhi_row(x_rhi_row);

345: IF (x_rhi_row.processing_status_code IN('PENDING', 'ERROR')) THEN
346: asn_debug.put_line('Setting header row status HEADER_INTERFACE_ID=' || x_rhi_row.header_interface_id);
347: x_rhi_row.processing_status_code := 'RUNNING';
348: x_rhi_row.processing_request_id := g_request_id;
349: rcv_table_functions.update_rhi_row(x_rhi_row);
350: END IF;
351: END IF;
352: /* lcm chages : End */
353:

Line 356: rcv_table_functions.update_rti_row(p_rti_row);

352: /* lcm chages : End */
353:
354: END IF;
355:
356: rcv_table_functions.update_rti_row(p_rti_row);
357: END;
358:
359: PROCEDURE explode_all_lpn IS
360: l_ret_status VARCHAR2(20);

Line 711: rcv_table_functions.g_default_org_id := p_org_id;

707:
708: g_group_id := NVL(p_group_id, 0);
709: g_request_id := NVL(p_request_id, 0);
710: g_processing_mode := p_processing_mode; -- Bug 6311798
711: rcv_table_functions.g_default_org_id := p_org_id;
712:
713: -- Bug 14370850
714: g_org_id := p_org_id;
715: