DBA Data[Home] [Help]

APPS.CSI_INV_TXNSTUB_PKG dependencies on CSI_BATCH_TXN_LINES

Line 496: from csi_batch_txn_lines

492: begin
493: -- check rows being processed currently within order
494: select count(1)
495: into l_exists
496: from csi_batch_txn_lines
497: where order_header_id = l_order_line_rec.header_id
498: and (processed_flag = 1 or processed_flag = 2);
499: exception
500: when no_data_found then

Line 505: insert into CSI_BATCH_TXN_LINES

501: l_exists := 0;
502: end;
503:
504: if (l_exists = 1) then
505: insert into CSI_BATCH_TXN_LINES
506: (
507: BATCH_ID,
508: PROCESSED_FLAG,
509: ORDER_HEADER_ID,