DBA Data[Home] [Help]

APPS.CSI_INV_TXNSTUB_PKG dependencies on CSI_BATCH_TXN_LINES

Line 473: from csi_batch_txn_lines

469: begin
470: -- check rows being processed currently within order
471: select count(1)
472: into l_exists
473: from csi_batch_txn_lines
474: where order_header_id = l_order_line_rec.header_id
475: and (processed_flag = 1 or processed_flag = 2);
476: exception
477: when no_data_found then

Line 482: insert into CSI_BATCH_TXN_LINES

478: l_exists := 0;
479: end;
480:
481: if (l_exists = 1) then
482: insert into CSI_BATCH_TXN_LINES
483: (
484: BATCH_ID,
485: PROCESSED_FLAG,
486: ORDER_HEADER_ID,