APPS.CSI_TRANSACTION_IMPORT_PVT dependencies on CSI_BATCH_TXN_LINES_S

Line 55: SELECT csi_batch_txn_lines_s.nextval

51: ORDER BY order_header_id;
52:
53: BEGIN
54:
55: SELECT csi_batch_txn_lines_s.nextval
56: INTO l_seq
57: FROM dual;
58:
59: OPEN l_header_cur;

Line 83: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.CSI_BATCH_TXN_LINES_S INCREMENT BY '||TO_CHAR(l_seq_incr);

79: END IF;
80:
81: --Adjust sequence
82: l_seq_incr := p_num_workers;
83: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.CSI_BATCH_TXN_LINES_S INCREMENT BY '||TO_CHAR(l_seq_incr);
84: SELECT csi_batch_txn_lines_s.nextval
85: INTO l_seq
86: FROM dual;
87: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.CSI_BATCH_TXN_LINES_S INCREMENT BY 1';

Line 84: SELECT csi_batch_txn_lines_s.nextval

80:
81: --Adjust sequence
82: l_seq_incr := p_num_workers;
83: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.CSI_BATCH_TXN_LINES_S INCREMENT BY '||TO_CHAR(l_seq_incr);
84: SELECT csi_batch_txn_lines_s.nextval
85: INTO l_seq
86: FROM dual;
87: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.CSI_BATCH_TXN_LINES_S INCREMENT BY 1';
88:

Line 87: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.CSI_BATCH_TXN_LINES_S INCREMENT BY 1';

83: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.CSI_BATCH_TXN_LINES_S INCREMENT BY '||TO_CHAR(l_seq_incr);
84: SELECT csi_batch_txn_lines_s.nextval
85: INTO l_seq
86: FROM dual;
87: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.CSI_BATCH_TXN_LINES_S INCREMENT BY 1';
88:
89: debug(' New Sequence Value '||l_seq);
90: end if;
91: