APPS.CSI_II_RELATIONSHIPS_PVT dependencies on CSI_TRANSACTIONS

Line 778: FROM csi_transactions a,csi_ii_relationships b,csi_ii_relationships_h c

774: BEGIN
775:
776: SELECT max(min(to_char(a.transaction_date,'dd-mon-rr hh24:mi:ss')))
777: INTO l_f_date
778: FROM csi_transactions a,csi_ii_relationships b,csi_ii_relationships_h c
779: WHERE b.relationship_id = c.relationship_id
780: AND c.transaction_id = a.transaction_id
781: AND c.full_dump_flag = 'Y'
782: AND a.transaction_date <= p_time_stamp

Line 793: FROM csi_transactions a,csi_ii_relationships b,csi_ii_relationships_h c

789: FROM_time_stamp:=l_f_date;
790: BEGIN
791: SELECT max(min(to_char(a.transaction_date,'dd-mon-rr hh24:mi:ss')))
792: INTO l_t_date
793: FROM csi_transactions a,csi_ii_relationships b,csi_ii_relationships_h c
794: WHERE b.relationship_id = c.relationship_id
795: AND c.transaction_id = a.transaction_id
796: AND a.transaction_date<= p_time_stamp
797: AND c.relationship_id = p_relationship_id

Line 863: FROM csi_transactions a,csi_ii_relationships b,csi_ii_relationships_h c

859: ,c.new_attribute14
860: ,c.old_attribute15
861: ,c.new_attribute15
862: ,c.full_dump_flag
863: FROM csi_transactions a,csi_ii_relationships b,csi_ii_relationships_h c
864: WHERE b.relationship_id = c.relationship_id
865: AND c.transaction_id = a.transaction_id
866: AND c.relationship_id = p_relationship_id
867: -- AND a.transaction_date BETWEEN fnd_date.canonical_to_date(p_f_time_stamp) --to_date(p_f_time_stamp,'dd-mon-rr hh24:mi:ss')

Line 884: FROM csi_transactions a,csi_ii_relationships_h b

880: to_time_stamp => l_t_time_stamp);
881:
882: SELECT max(to_char(a.transaction_date,'dd-mon-rr hh24:mi:ss'))
883: INTO l_to_date
884: FROM csi_transactions a,csi_ii_relationships_h b
885: WHERE a.transaction_id=b.transaction_id
886: AND b.relationship_id=p_rel_rec.relationship_id;
887:
888: -- IF ( (l_f_time_stamp IS NOT NULL) AND (p_time_stamp>fnd_date.canonical_to_date(l_to_date) ) )-- to_date(l_to_date,'dd-mon-rr hh24:mi:ss')) ) THEN

Line 4945: csi_transactions_pvt.create_transaction

4941: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4942: RAISE fnd_api.g_exc_error;
4943: END IF;
4944:
4945: csi_transactions_pvt.create_transaction
4946: (
4947: p_api_version => p_api_version
4948: ,p_commit => p_commit
4949: ,p_init_msg_list => p_init_msg_list

Line 5766: csi_transactions_pvt.create_transaction

5762:
5763: /* IF x_return_status <> fnd_api.g_ret_sts_success THEN
5764: RAISE fnd_api.g_exc_error;
5765: END IF;*/
5766: csi_transactions_pvt.create_transaction
5767: (
5768: p_api_version => p_api_version
5769: ,p_commit => p_commit
5770: ,p_init_msg_list => p_init_msg_list

Line 6289: csi_transactions_pvt.create_transaction

6285: p_last_update_login => fnd_global.conc_login_id,
6286: p_object_version_number => fnd_api.g_miss_num);
6287:
6288:
6289: csi_transactions_pvt.create_transaction
6290: (
6291: p_api_version => p_api_version
6292: ,p_commit => p_commit
6293: ,p_init_msg_list => p_init_msg_list