eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_II_RELATIONSHIPS_PVT dependencies on CSI_II_RELATIONSHIPS_H

Line 756: | <-- csi_ii_relationships_h --> |

752:
753: END gen_relations_where;
754:
755: /*--------------------------------------------------------------------------------------------------------------+
756: | <-- csi_ii_relationships_h --> |
757: |full_dump_flag |
758: | y y y y y y |
759: | c |---------------------------------------------------------------------------- c |
760: | a | | | | | | | 11-may-01 a |

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 2704: FROM csi_ii_relationships_h

2700: -- Do not add the current record by default
2701: BEGIN
2702: SELECT 'x'
2703: INTO l_found
2704: FROM csi_ii_relationships_h
2705: WHERE relationship_id=l_rel_tbl(p_time_csr).relationship_id;
2706: EXCEPTION
2707: WHEN NO_DATA_FOUND THEN
2708: l_relationship_tbl(l_returned_rec_count) :=l_rel_tbl(p_time_csr);

Line 3576: FROM csi_ii_relationships_h

3572: ,old_attribute15
3573: ,new_attribute15
3574: ,full_dump_flag
3575: ,object_version_number
3576: FROM csi_ii_relationships_h
3577: WHERE csi_ii_relationships_h.relationship_history_id = p_rel_hist_id
3578: FOR UPDATE OF object_version_number;
3579:
3580: l_rel_hist_csr rel_hist_csr%ROWTYPE;

Line 3577: WHERE csi_ii_relationships_h.relationship_history_id = p_rel_hist_id

3573: ,new_attribute15
3574: ,full_dump_flag
3575: ,object_version_number
3576: FROM csi_ii_relationships_h
3577: WHERE csi_ii_relationships_h.relationship_history_id = p_rel_hist_id
3578: FOR UPDATE OF object_version_number;
3579:
3580: l_rel_hist_csr rel_hist_csr%ROWTYPE;
3581: l_rel_hist_id NUMBER;

Line 3607: FROM csi_ii_relationships_h h

3603: -- Start of modifications for Bug#2547034 on 09/20/02 - rtalluri
3604: BEGIN
3605: SELECT relationship_history_id
3606: INTO l_rel_hist_id
3607: FROM csi_ii_relationships_h h
3608: WHERE h.transaction_id = p_transaction_id
3609: AND h.relationship_id = p_old_relship_rec.relationship_id;
3610:
3611: OPEN rel_hist_csr(l_rel_hist_id);

Line 3617: csi_ii_relationships_h_pkg.update_row(

3613: CLOSE rel_hist_csr;
3614:
3615: IF l_rel_hist_csr.full_dump_flag = 'Y'
3616: THEN
3617: csi_ii_relationships_h_pkg.update_row(
3618: p_relationship_history_id => l_rel_hist_id ,
3619: p_relationship_id => fnd_api.g_miss_num ,
3620: p_transaction_id => fnd_api.g_miss_num ,
3621: p_old_subject_id => fnd_api.g_miss_num ,

Line 3988: csi_ii_relationships_h_pkg.update_row(

3984: l_rel_hist_csr.new_attribute15 := l_new_relship_rec.attribute15;
3985: END IF;
3986: --
3987:
3988: csi_ii_relationships_h_pkg.update_row(
3989: p_relationship_history_id => l_rel_hist_id ,
3990: p_relationship_id => fnd_api.g_miss_num ,
3991: p_transaction_id => fnd_api.g_miss_num ,
3992: p_old_subject_id => l_rel_hist_csr.old_subject_id ,

Line 4047: csi_ii_relationships_h_pkg.insert_row(

4043: EXCEPTION
4044: WHEN NO_DATA_FOUND THEN
4045: IF MOD(l_old_relship_rec.object_version_number+1,l_full_dump)=0 THEN
4046:
4047: csi_ii_relationships_h_pkg.insert_row(
4048: px_relationship_history_id => l_relship_hist_rec.relationship_history_id,
4049: p_relationship_id => l_old_relship_rec.relationship_id,
4050: p_transaction_id => l_transaction_id,
4051: p_old_subject_id => l_old_relship_rec.subject_id,

Line 4105: --Modified code for bug 8516781, FP bug 8551918 old and new Subject_ID are always populated in CSI_II_RELATIONSHIPS_H such that

4101: ELSE
4102:
4103: IF (l_new_relship_rec.subject_id = fnd_api.g_miss_num) OR
4104: NVL(l_old_relship_rec.subject_id,fnd_api.g_miss_num) = NVL(l_new_relship_rec.subject_id,fnd_api.g_miss_num) THEN
4105: --Modified code for bug 8516781, FP bug 8551918 old and new Subject_ID are always populated in CSI_II_RELATIONSHIPS_H such that
4106: --the parent's history always shows the subject ID which modified
4107: l_relship_hist_rec.old_subject_id := l_old_relship_rec.subject_id;
4108: l_relship_hist_rec.new_subject_id := l_old_relship_rec.subject_id;
4109: ELSIF

Line 4320: csi_ii_relationships_h_pkg.insert_row(

4316: THEN
4317: l_relship_hist_rec.new_active_end_date := p_sysdate;
4318: END IF;
4319:
4320: csi_ii_relationships_h_pkg.insert_row(
4321: px_relationship_history_id => l_relship_hist_rec.relationship_history_id,
4322: p_relationship_id => l_old_relship_rec.relationship_id,
4323: p_transaction_id => l_transaction_id,
4324: p_old_subject_id => l_relship_hist_rec.old_subject_id,

Line 5156: csi_ii_relationships_h_pkg.insert_row(

5152: IF x_return_status = fnd_api.g_ret_sts_success THEN
5153:
5154: l_relship_history_id := NULL;
5155:
5156: csi_ii_relationships_h_pkg.insert_row(
5157: px_relationship_history_id => l_relship_history_id,
5158: p_relationship_id => p_relationship_tbl(l_count).relationship_id,
5159: p_transaction_id => p_txn_rec.transaction_id,
5160: p_old_subject_id => NULL,

Line 7520: FROM csi_ii_relationships_h cih ,

7516: cih.object_version_number ,
7517: cir.relationship_type_code ,
7518: cir.object_id ,
7519: cih.creation_date
7520: FROM csi_ii_relationships_h cih ,
7521: csi_ii_relationships cir
7522: WHERE cih.transaction_id = i_transaction_id
7523: AND cih.relationship_id = cir.relationship_id;
7524: