APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_TRANSACTIONS_S

Line 1446: SELECT csi_transactions_s.nextval

1442: END IF;
1443: -- Get the Transaction Type ID for Txn Type MIGRATED
1444: v_txn_type_id := correction_txn_type_id;
1445:
1446: SELECT csi_transactions_s.nextval
1447: INTO l_txn_id
1448: FROM sys.dual;
1449:
1450: --

Line 10735: select CSI_TRANSACTIONS_S.nextval

10731: IF l_inst_tbl.count = 0 THEN
10732: RAISE Comp_error;
10733: END IF;
10734: --
10735: select CSI_TRANSACTIONS_S.nextval
10736: into l_txn_id from dual;
10737: --
10738: INSERT INTO CSI_TRANSACTIONS(
10739: TRANSACTION_ID

Line 11370: select CSI_TRANSACTIONS_S.nextval

11366: --
11367: commit;
11368: END IF;
11369: --
11370: select CSI_TRANSACTIONS_S.nextval
11371: into v_txn_id from dual;
11372: --
11373: OPEN CSI_CUR;
11374: LOOP

Line 11763: select CSI_TRANSACTIONS_S.nextval

11759: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
11760: Raise comp_error;
11761: End;
11762: --
11763: select CSI_TRANSACTIONS_S.nextval
11764: into v_srl_txn_id from dual;
11765: --
11766: select CSI_TRANSACTIONS_S.nextval
11767: into v_lot_txn_id from dual;

Line 11766: select CSI_TRANSACTIONS_S.nextval

11762: --
11763: select CSI_TRANSACTIONS_S.nextval
11764: into v_srl_txn_id from dual;
11765: --
11766: select CSI_TRANSACTIONS_S.nextval
11767: into v_lot_txn_id from dual;
11768: --
11769: /* commenting the following cursors for the bug 5989350 ,Since there is
11770: no need to nullify the serial and lot number for the instances

Line 12373: select CSI_TRANSACTIONS_S.nextval

12369: Raise Process_next;
12370: End;
12371: --
12372: Begin
12373: select CSI_TRANSACTIONS_S.nextval
12374: into v_txn_id
12375: from DUAL;
12376: End;
12377: --

Line 12855: select CSI_TRANSACTIONS_S.nextval

12851: Raise Process_next;
12852: End;
12853: --
12854: Begin
12855: select CSI_TRANSACTIONS_S.nextval
12856: into v_txn_id
12857: from DUAL;
12858: End;
12859: --

Line 13842: select CSI_TRANSACTIONS_S.nextval

13838: ,last_vld_organization_id = organization_id_mig(i)
13839: where instance_id = v_instance_id;
13840: --
13841: Begin
13842: select CSI_TRANSACTIONS_S.nextval
13843: into v_txn_id
13844: from DUAL;
13845: End;
13846: --

Line 13917: select CSI_TRANSACTIONS_S.nextval

13913: -- If instance is not found then create the INV instance
13914: -- For each record, we insert a record into CSI_TRANSACTIONS. This Transaction ID will be used
13915: -- to populate the History Record.
13916: Begin
13917: select CSI_TRANSACTIONS_S.nextval
13918: into v_txn_id
13919: from DUAL;
13920: End;
13921: --

Line 14599: select CSI_TRANSACTIONS_S.nextval

14595: Raise comp_error;
14596: when others then
14597: Raise comp_error;
14598: End;
14599: select CSI_TRANSACTIONS_S.nextval
14600: into l_txn_id from dual;
14601: --
14602: OPEN CSI_CUR;
14603: LOOP