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,