[Home] [Help]
745:
746: END gen_relations_where;
747:
748: /*--------------------------------------------------------------------------------------------------------------+
749: | <-- csi_ii_relationships_h --> |
750: |full_dump_flag |
751: | y y y y y y |
752: | c |---------------------------------------------------------------------------- c |
753: | a | | | | | | | 11-may-01 a |
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
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
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')
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
2573: -- Do not add the current record by default
2574: BEGIN
2575: SELECT 'x'
2576: INTO l_found
2577: FROM csi_ii_relationships_h
2578: WHERE relationship_id=l_rel_tbl(p_time_csr).relationship_id;
2579: EXCEPTION
2580: WHEN NO_DATA_FOUND THEN
2581: l_relationship_tbl(l_returned_rec_count) :=l_rel_tbl(p_time_csr);
3424: ,old_attribute15
3425: ,new_attribute15
3426: ,full_dump_flag
3427: ,object_version_number
3428: FROM csi_ii_relationships_h
3429: WHERE csi_ii_relationships_h.relationship_history_id = p_rel_hist_id
3430: FOR UPDATE OF object_version_number;
3431:
3432: l_rel_hist_csr rel_hist_csr%ROWTYPE;
3425: ,new_attribute15
3426: ,full_dump_flag
3427: ,object_version_number
3428: FROM csi_ii_relationships_h
3429: WHERE csi_ii_relationships_h.relationship_history_id = p_rel_hist_id
3430: FOR UPDATE OF object_version_number;
3431:
3432: l_rel_hist_csr rel_hist_csr%ROWTYPE;
3433: l_rel_hist_id NUMBER;
3455: -- Start of modifications for Bug#2547034 on 09/20/02 - rtalluri
3456: BEGIN
3457: SELECT relationship_history_id
3458: INTO l_rel_hist_id
3459: FROM csi_ii_relationships_h h
3460: WHERE h.transaction_id = p_transaction_id
3461: AND h.relationship_id = p_old_relship_rec.relationship_id;
3462:
3463: OPEN rel_hist_csr(l_rel_hist_id);
3465: CLOSE rel_hist_csr;
3466:
3467: IF l_rel_hist_csr.full_dump_flag = 'Y'
3468: THEN
3469: csi_ii_relationships_h_pkg.update_row(
3470: p_relationship_history_id => l_rel_hist_id ,
3471: p_relationship_id => fnd_api.g_miss_num ,
3472: p_transaction_id => fnd_api.g_miss_num ,
3473: p_old_subject_id => fnd_api.g_miss_num ,
3836: l_rel_hist_csr.new_attribute15 := l_new_relship_rec.attribute15;
3837: END IF;
3838: --
3839:
3840: csi_ii_relationships_h_pkg.update_row(
3841: p_relationship_history_id => l_rel_hist_id ,
3842: p_relationship_id => fnd_api.g_miss_num ,
3843: p_transaction_id => fnd_api.g_miss_num ,
3844: p_old_subject_id => l_rel_hist_csr.old_subject_id ,
3895: EXCEPTION
3896: WHEN NO_DATA_FOUND THEN
3897: IF MOD(l_old_relship_rec.object_version_number+1,l_full_dump)=0 THEN
3898:
3899: csi_ii_relationships_h_pkg.insert_row(
3900: px_relationship_history_id => l_relship_hist_rec.relationship_history_id,
3901: p_relationship_id => l_old_relship_rec.relationship_id,
3902: p_transaction_id => l_transaction_id,
3903: p_old_subject_id => l_old_relship_rec.subject_id,
4166: THEN
4167: l_relship_hist_rec.new_active_end_date := p_sysdate;
4168: END IF;
4169:
4170: csi_ii_relationships_h_pkg.insert_row(
4171: px_relationship_history_id => l_relship_hist_rec.relationship_history_id,
4172: p_relationship_id => l_old_relship_rec.relationship_id,
4173: p_transaction_id => l_transaction_id,
4174: p_old_subject_id => l_relship_hist_rec.old_subject_id,
4984: IF x_return_status = fnd_api.g_ret_sts_success THEN
4985:
4986: l_relship_history_id := NULL;
4987:
4988: csi_ii_relationships_h_pkg.insert_row(
4989: px_relationship_history_id => l_relship_history_id,
4990: p_relationship_id => p_relationship_tbl(l_count).relationship_id,
4991: p_transaction_id => p_txn_rec.transaction_id,
4992: p_old_subject_id => NULL,
7249: cih.object_version_number ,
7250: cir.relationship_type_code ,
7251: cir.object_id ,
7252: cih.creation_date
7253: FROM csi_ii_relationships_h cih ,
7254: csi_ii_relationships cir
7255: WHERE cih.transaction_id = i_transaction_id
7256: AND cih.relationship_id = cir.relationship_id;
7257: