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 11764: select CSI_TRANSACTIONS_S.nextval

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

Line 11767: select CSI_TRANSACTIONS_S.nextval

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

Line 12378: select CSI_TRANSACTIONS_S.nextval

12374: Raise Process_next;
12375: End;
12376: --
12377: Begin
12378: select CSI_TRANSACTIONS_S.nextval
12379: into v_txn_id
12380: from DUAL;
12381: End;
12382: --

Line 12860: select CSI_TRANSACTIONS_S.nextval

12856: Raise Process_next;
12857: End;
12858: --
12859: Begin
12860: select CSI_TRANSACTIONS_S.nextval
12861: into v_txn_id
12862: from DUAL;
12863: End;
12864: --

Line 13847: select CSI_TRANSACTIONS_S.nextval

13843: ,last_vld_organization_id = organization_id_mig(i)
13844: where instance_id = v_instance_id;
13845: --
13846: Begin
13847: select CSI_TRANSACTIONS_S.nextval
13848: into v_txn_id
13849: from DUAL;
13850: End;
13851: --

Line 13922: select CSI_TRANSACTIONS_S.nextval

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

Line 14604: select CSI_TRANSACTIONS_S.nextval

14600: Raise comp_error;
14601: when others then
14602: Raise comp_error;
14603: End;
14604: select CSI_TRANSACTIONS_S.nextval
14605: into l_txn_id from dual;
14606: --
14607: OPEN CSI_CUR;
14608: LOOP