DBA Data[Home] [Help]

APPS.GML_RCV_STD_RCPT_APIS dependencies on INV_RCV_COMMON_APIS

Line 251: l_rcpt_match_table_detail INV_RCV_COMMON_APIS.cascaded_trans_tab_type; -- output for matching algorithm

247: p_country_code IN VARCHAR2 DEFAULT NULL
248: )
249: IS
250:
251: l_rcpt_match_table_detail INV_RCV_COMMON_APIS.cascaded_trans_tab_type; -- output for matching algorithm
252:
253: l_rcv_transaction_rec rcv_transaction_rec_tp; -- rcv_transaction block
254:
255: l_interface_transaction_id NUMBER := NULL;

Line 360: WHERE rti.group_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id

356:
357: CURSOR c_rti_txn_id IS
358: SELECT MAX(rti.interface_transaction_id)
359: FROM rcv_transactions_interface rti
360: WHERE rti.group_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id
361: GROUP BY decode(p_source_type,'ASNEXP',rti.interface_transaction_id,'SHIPMENTEXP',rti.interface_transaction_id,null) ;
362: -- GROUP BY rti.lpn_id;
363: BEGIN
364: NULL;