DBA Data[Home] [Help]

APPS.POS_ASN dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 1130: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_line_id from dual;

1126: BEGIN
1127:
1128: FOR c_rec in c_lines LOOP
1129:
1130: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_line_id from dual;
1131:
1132: insert into rcv_transactions_interface
1133: ( INTERFACE_TRANSACTION_ID ,
1134: HEADER_INTERFACE_ID ,

Line 1393: update rcv_transactions_interface set

1389: validation_flag = 'N',
1390: processing_status_code = 'SUCCESS'
1391: where header_interface_id = l_header_id;
1392:
1393: update rcv_transactions_interface set
1394: PROCESSING_STATUS_CODE = 'PENDING',
1395: TRANSACTION_STATUS_CODE = 'PENDING'
1396: where header_interface_id = l_header_id;
1397: