APPS.CSI_II_RELATIONSHIPS_PVT dependencies on CSI_TRANSACTIONS

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

781: BEGIN
782:
783: SELECT max(min(to_char(a.transaction_date,'dd-mon-rr hh24:mi:ss')))
784: INTO l_f_date
785: FROM csi_transactions a,csi_ii_relationships b,csi_ii_relationships_h c
786: WHERE b.relationship_id = c.relationship_id
787: AND c.transaction_id = a.transaction_id
788: AND c.full_dump_flag = 'Y'
789: AND a.transaction_date <= p_time_stamp

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

796: FROM_time_stamp:=l_f_date;
797: BEGIN
798: SELECT max(min(to_char(a.transaction_date,'dd-mon-rr hh24:mi:ss')))
799: INTO l_t_date
800: FROM csi_transactions a,csi_ii_relationships b,csi_ii_relationships_h c
801: WHERE b.relationship_id = c.relationship_id
802: AND c.transaction_id = a.transaction_id
803: AND a.transaction_date<= p_time_stamp
804: AND c.relationship_id = p_relationship_id

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

866: ,c.new_attribute14
867: ,c.old_attribute15
868: ,c.new_attribute15
869: ,c.full_dump_flag
870: FROM csi_transactions a,csi_ii_relationships b,csi_ii_relationships_h c
871: WHERE b.relationship_id = c.relationship_id
872: AND c.transaction_id = a.transaction_id
873: AND c.relationship_id = p_relationship_id
874: -- 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 891: FROM csi_transactions a,csi_ii_relationships_h b

887: to_time_stamp => l_t_time_stamp);
888:
889: SELECT max(to_char(a.transaction_date,'dd-mon-rr hh24:mi:ss'))
890: INTO l_to_date
891: FROM csi_transactions a,csi_ii_relationships_h b
892: WHERE a.transaction_id=b.transaction_id
893: AND b.relationship_id=p_rel_rec.relationship_id;
894:
895: -- 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 5113: csi_transactions_pvt.create_transaction

5109: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5110: RAISE fnd_api.g_exc_error;
5111: END IF;
5112:
5113: csi_transactions_pvt.create_transaction
5114: (
5115: p_api_version => p_api_version
5116: ,p_commit => p_commit
5117: ,p_init_msg_list => p_init_msg_list

Line 5943: csi_transactions_pvt.create_transaction

5939:
5940: /* IF x_return_status <> fnd_api.g_ret_sts_success THEN
5941: RAISE fnd_api.g_exc_error;
5942: END IF;*/
5943: csi_transactions_pvt.create_transaction
5944: (
5945: p_api_version => p_api_version
5946: ,p_commit => p_commit
5947: ,p_init_msg_list => p_init_msg_list

Line 6538: csi_transactions_pvt.create_transaction

6534: p_last_update_login => fnd_global.conc_login_id,
6535: p_object_version_number => fnd_api.g_miss_num);
6536:
6537:
6538: csi_transactions_pvt.create_transaction
6539: (
6540: p_api_version => p_api_version
6541: ,p_commit => p_commit
6542: ,p_init_msg_list => p_init_msg_list