APPS.POS_EXCELASN_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 38: from rcv_transactions_interface

34:
35: cursor l_rtiError_csr(x_group_id in number)
36: is
37: select 1
38: from rcv_transactions_interface
39: where group_id = x_group_id
40: and (processing_status_code = 'ERROR' or transaction_status_code = 'ERROR');
41:
42: cursor l_rhiPending_csr(x_group_id in number)

Line 52: from rcv_transactions_interface

48:
49: cursor l_rtiPending_csr(x_group_id in number)
50: is
51: select 1
52: from rcv_transactions_interface
53: where group_id = x_group_id
54: and (processing_status_code in ('PENDING','RUNNING') or transaction_status_code = 'ERROR');
55:
56: cursor l_rhiExist_csr(x_group_id in number)

Line 72: rcv_transactions_interface rti

68: and rhi.header_interface_id = pie1.interface_header_id
69: union all
70: select 1
71: from po_interface_errors pie2,
72: rcv_transactions_interface rti
73: where rti.group_id = x_group_id
74: and rti.interface_transaction_id = pie2.interface_line_id;
75:
76:

Line 3078: select RCV_TRANSACTIONS_INTERFACE_S.nextval into l_intf_txn_id from dual;

3074: is
3075: l_intf_txn_id number;
3076: begin
3077: insert into pos_exasn_lines(line_id, quantity, license_plate_number) values(p_line_id, p_qty, p_lpn );
3078: select RCV_TRANSACTIONS_INTERFACE_S.nextval into l_intf_txn_id from dual;
3079: update pos_exasn_lines
3080: set (
3081: PRIMARY_UOM,
3082: LPN_GROUP_ID,

Line 3623: insert into rcv_transactions_interface

3619:
3620: procedure InsertIntoRTI
3621: is
3622: begin
3623: insert into rcv_transactions_interface
3624: ( INTERFACE_TRANSACTION_ID ,
3625: HEADER_INTERFACE_ID ,
3626: GROUP_ID ,
3627: TRANSACTION_TYPE ,