APPS.CSI_SYSTEMS_PVT dependencies on CSI_TRANSACTIONS

Line 417: FROM csi_transactions a, csi_systems_b b,csi_systems_h c

413: l_t_date VARCHAR2(25) := fnd_api.g_miss_char;
414: BEGIN
415: SELECT max(min(to_char(a.transaction_date,'dd-mon-rr hh24:mi:ss')))
416: INTO l_f_date
417: FROM csi_transactions a, csi_systems_b b,csi_systems_h c
418: WHERE b.system_id = c.system_id
419: AND c.transaction_id = a.transaction_id
420: AND c.full_dump_flag = 'Y'
421: AND a.transaction_date <=p_time_stamp

Line 432: FROM csi_transactions a, csi_systems_b b,csi_systems_h c

428: from_time_stamp:=l_f_date;
429: BEGIN
430: SELECT max(min(to_char(a.transaction_date,'dd-mon-rr hh24:mi:ss')))
431: INTO l_t_date
432: FROM csi_transactions a, csi_systems_b b,csi_systems_h c
433: WHERE b.system_id = c.system_id
434: AND c.transaction_id = a.transaction_id
435: AND a.transaction_date <=p_time_stamp
436: AND c.system_id = p_system_id

Line 527: FROM csi_transactions a,csi_systems_b b,csi_systems_h c

523: ,c.new_attribute15
524: ,c.full_dump_flag
525: ,c.old_operating_unit_id
526: ,c.new_operating_unit_id
527: FROM csi_transactions a,csi_systems_b b,csi_systems_h c
528: WHERE b.system_id = c.system_id
529: AND c.transaction_id = a.transaction_id
530: AND c.system_id = p_system_id
531: AND a.transaction_date BETWEEN to_date(p_f_time_stamp,'dd/mm/yyyy hh24:mi:ss')

Line 546: FROM csi_transactions a,csi_systems_h b

542: to_time_stamp => l_t_time_stamp);
543:
544: SELECT max(to_char(a.transaction_date,'dd/mm/yyyy hh24:mi:ss'))
545: INTO l_to_date
546: FROM csi_transactions a,csi_systems_h b
547: WHERE a.transaction_id=b.transaction_id
548: AND b.system_id=p_sys_rec.system_id;
549:
550: IF ( (l_f_time_stamp IS NOT NULL) AND (p_time_stamp>to_date(l_to_date,'dd/mm/yyyy hh24:mi:ss')) ) THEN

Line 2729: csi_transactions_pvt.create_transaction

2725: -- hint: primary key should be returned.
2726: -- x_system_id := px_system_id;
2727: l_system_id := x_system_id;
2728:
2729: csi_transactions_pvt.create_transaction
2730: (
2731: p_api_version => p_api_version
2732: ,p_commit => p_commit
2733: ,p_init_msg_list => p_init_msg_list

Line 3290: csi_transactions t

3286: BEGIN
3287: SELECT MAX(t.transaction_date)
3288: INTO l_transaction_date
3289: FROM csi_systems_h s,
3290: csi_transactions t
3291: WHERE s.system_id=p_system_rec.system_id
3292: AND s.transaction_id=t.transaction_id;
3293: -- srramakar. Exception handled right after select rather than at the end.
3294: -- Group function does not raise exception. Since it was there I am leaving as it is.

Line 3433: csi_transactions_pvt.create_transaction

3429: p_program_id => p_system_rec.program_id,
3430: p_program_update_date => p_system_rec.program_update_date);
3431: END IF;
3432:
3433: csi_transactions_pvt.create_transaction
3434: (
3435: p_api_version => p_api_version
3436: ,p_commit => p_commit
3437: ,p_init_msg_list => p_init_msg_list

Line 3625: UPDATE CSI_TRANSACTIONS

3621: l_batch_id := NULL;
3622: l_batch_type := NULL;
3623: END IF;
3624: --
3625: UPDATE CSI_TRANSACTIONS
3626: set contracts_invoked = 'Y'
3627: where transaction_id = p_txn_rec.transaction_id;
3628: --
3629: OKS_IBINT_PUB.IB_interface

Line 4147: csi_transactions_pvt.create_transaction

4143: -- This is because, as a part of bug # 2783027, we enforced system_id validation to make sure that
4144: -- no update is allowed on an instance that is attachaed to an expired system.
4145: -- In this case, if the system is already expired then cascade can't be done.
4146: --
4147: csi_transactions_pvt.create_transaction
4148: (
4149: p_api_version => p_api_version
4150: ,p_commit => p_commit
4151: ,p_init_msg_list => p_init_msg_list