APPS.RCV_ROI_PREPROCESSOR dependencies on RCV_TRANSACTIONS_INTERFACE

Line 40: select rcv_transactions_interface.*,

36: -- existing in rti for the given request and group ids
37: -- including the child / headerless transactions
38: -- such as corrections, transfers, inspections, returns, and deliveries.
39: cursor txns_cur (x_request_id NUMBER, x_group_id NUMBER) is
40: select rcv_transactions_interface.*,
41: rowid row_id,
42: uom_class unit_of_measure_class,
43: ship_to_org_id ship_to_organization_id,
44: receipt_code receipt_days_exception_code,

Line 51: from rcv_transactions_interface

47: error_code error_status,
48: error_text error_message,
49: derive_values derive,
50: cascaded_table_index derive_index
51: from rcv_transactions_interface
52: where (processing_request_id = x_request_id)
53: and (group_id = x_group_id or x_group_id = 0)
54: and processing_status_code in ('RUNNING')
55: and nvl(validation_flag,'N') = 'Y'

Line 99: rcv_headers_interface and rcv_transactions_interface.

95: PROCEDURE NAME: Preprocessor()
96:
97: DESCRIPTION: Derives, defaults, and validates entries in the
98: Receiving Open Interface tables,
99: rcv_headers_interface and rcv_transactions_interface.
100: The preprocessor also handles ASN/ASBN imports,
101: creating the appropriate lines in rcv_shipment_headers
102: and rcv_shipment_lines.
103:

Line 137: x_interface_txn_id IN OUT NOCOPY rcv_transactions_interface.interface_transaction_id%type,

133: v_header_record IN OUT NOCOPY RCV_ROI_PREPROCESSOR.header_rec_type
134: );
135:
136: PROCEDURE explode_lpn_failed(
137: x_interface_txn_id IN OUT NOCOPY rcv_transactions_interface.interface_transaction_id%type,
138: x_group_id NUMBER,
139: x_lpn_group_id NUMBER
140: );
141:

Line 143: (p_group_id IN rcv_transactions_interface.group_id%type,

139: x_lpn_group_id NUMBER
140: );
141:
142: PROCEDURE update_rti_error
143: (p_group_id IN rcv_transactions_interface.group_id%type,
144: p_interface_id IN rcv_transactions_interface.interface_transaction_id%type,
145: p_header_interface_id IN rcv_transactions_interface.header_interface_id%type,
146: p_lpn_group_id IN rcv_transactions_interface.lpn_group_id%type);
147:

Line 144: p_interface_id IN rcv_transactions_interface.interface_transaction_id%type,

140: );
141:
142: PROCEDURE update_rti_error
143: (p_group_id IN rcv_transactions_interface.group_id%type,
144: p_interface_id IN rcv_transactions_interface.interface_transaction_id%type,
145: p_header_interface_id IN rcv_transactions_interface.header_interface_id%type,
146: p_lpn_group_id IN rcv_transactions_interface.lpn_group_id%type);
147:
148: --Shikyu project

Line 145: p_header_interface_id IN rcv_transactions_interface.header_interface_id%type,

141:
142: PROCEDURE update_rti_error
143: (p_group_id IN rcv_transactions_interface.group_id%type,
144: p_interface_id IN rcv_transactions_interface.interface_transaction_id%type,
145: p_header_interface_id IN rcv_transactions_interface.header_interface_id%type,
146: p_lpn_group_id IN rcv_transactions_interface.lpn_group_id%type);
147:
148: --Shikyu project
149: FUNCTION get_oe_osa_flag(

Line 146: p_lpn_group_id IN rcv_transactions_interface.lpn_group_id%type);

142: PROCEDURE update_rti_error
143: (p_group_id IN rcv_transactions_interface.group_id%type,
144: p_interface_id IN rcv_transactions_interface.interface_transaction_id%type,
145: p_header_interface_id IN rcv_transactions_interface.header_interface_id%type,
146: p_lpn_group_id IN rcv_transactions_interface.lpn_group_id%type);
147:
148: --Shikyu project
149: FUNCTION get_oe_osa_flag(
150: p_oe_order_line_id NUMBER