APPS.IGS_AD_IMP_024 dependencies on IGS_AD_TERM_DETAILS

Line 714: AND (NOT EXISTS (SELECT 1 FROM IGS_AD_TERM_DETAILS term_oss

710: FROM igs_ad_trmdt_int term
711: WHERE interface_run_id = p_interface_run_id
712: AND term.status = '2'
713: AND INTERFACE_TERM_DTLS_ID BETWEEN cp_start_int_id AND cp_end_int_id
714: AND (NOT EXISTS (SELECT 1 FROM IGS_AD_TERM_DETAILS term_oss
715: WHERE transcript_id = term.transcript_id
716: AND term = term.term
717: AND TRUNC(start_Date) = TRUNC(term.start_Date)
718: AND TRUNC(end_Date) = TRUNC(term.end_Date) )

Line 728: AND EXISTS (SELECT 1 FROM IGS_AD_TERM_DETAILS term_oss

724: WHERE interface_run_id = p_interface_run_id
725: AND status = '2'
726: AND INTERFACE_TERM_DTLS_ID BETWEEN cp_start_int_id AND cp_end_int_id
727: AND ( p_rule = 'I' OR (p_rule = 'R' AND term.match_ind = cst_mi_val_21))
728: AND EXISTS (SELECT 1 FROM IGS_AD_TERM_DETAILS term_oss
729: WHERE transcript_id = term.transcript_id
730: AND term = term.term
731: AND TRUNC(start_Date) = TRUNC(term.start_Date)
732: AND TRUNC(end_Date) = TRUNC(term.end_Date)

Line 739: IGS_AD_TERM_DETAILS term_oss

735: CURSOR c_dup_cur(term_cur_rec term_cur%ROWTYPE) IS
736: SELECT
737: term_oss.rowid, term_oss.*
738: FROM
739: IGS_AD_TERM_DETAILS term_oss
740: WHERE transcript_id = term_cur_rec.transcript_id
741: AND term = term_cur_rec.term
742: AND TRUNC(start_Date) = TRUNC(term_cur_rec.start_Date)
743: AND TRUNC(end_Date) = TRUNC(term_cur_rec.end_Date) ;

Line 782: igs_ad_term_details_pkg.insert_row(

778: l_error_text VARCHAR2(2000):= NULL;
779: BEGIN
780: l_msg_at_index := igs_ge_msg_stack.count_msg;
781: SAVEPOINT before_create_term;
782: igs_ad_term_details_pkg.insert_row(
783: l_rowid,
784: l_term_details_id ,
785: p_term_dtls_record.TRANSCRIPT_ID ,
786: p_term_dtls_record.TERM ,

Line 875: igs_ad_term_details_pkg.update_row(

871: l_error_text VARCHAR2(2000):= NULL;
872: BEGIN
873: l_msg_at_index := igs_ge_msg_stack.count_msg;
874: SAVEPOINT before_update_term;
875: igs_ad_term_details_pkg.update_row(
876: X_ROWID => dup_cur_rec.rowid ,
877: X_TERM_DETAILS_ID => dup_cur_rec.term_details_id ,
878: X_TRANSCRIPT_ID => p_term_dtls_record.transcript_id ,
879: X_TERM => p_term_dtls_record.term ,

Line 997: AND 1 < ( SELECT COUNT(*) FROM IGS_AD_TERM_DETAILS term_oss

993: AND status = '2'
994: AND EXISTS ( SELECT 1 FROM igs_ad_tundt_int
995: WHERE interface_term_dtls_id = term.interface_term_dtls_id
996: AND status ='2')
997: AND 1 < ( SELECT COUNT(*) FROM IGS_AD_TERM_DETAILS term_oss
998: WHERE transcript_id = term.transcript_id
999: AND term = term.term
1000: AND TRUNC(start_Date) = TRUNC(term.start_Date)
1001: AND TRUNC(end_Date) = TRUNC(term.end_Date)

Line 1008: , term_Details_id = ( SELECT term_Details_id FROM IGS_AD_TERM_DETAILS term_oss

1004: UPDATE igs_ad_trmdt_int term
1005: SET
1006: status = '1'
1007: , match_ind = '19'
1008: , term_Details_id = ( SELECT term_Details_id FROM IGS_AD_TERM_DETAILS term_oss
1009: WHERE transcript_id = term.transcript_id
1010: AND term = term.term
1011: AND TRUNC(start_Date) = TRUNC(term.start_Date)
1012: AND TRUNC(end_Date) = TRUNC(term.end_Date)

Line 1017: AND EXISTS ( SELECT 1 FROM IGS_AD_TERM_DETAILS term_oss

1013: AND rownum <=1
1014: )
1015: WHERE interface_run_id = p_interface_run_id
1016: AND status = '2'
1017: AND EXISTS ( SELECT 1 FROM IGS_AD_TERM_DETAILS term_oss
1018: WHERE transcript_id = term.transcript_id
1019: AND term = term.term
1020: AND TRUNC(start_Date) = TRUNC(term.start_Date)
1021: AND TRUNC(end_Date) = TRUNC(term.end_Date)

Line 1090: AND EXISTS ( SELECT 1 FROM igs_ad_term_details

1086: , match_ind = '23'
1087: WHERE interface_run_id = p_interface_run_id
1088: AND status = '2'
1089: AND NVL (match_ind, '15') = '15'
1090: AND EXISTS ( SELECT 1 FROM igs_ad_term_details
1091: WHERE
1092: TRANSCRIPT_ID= term.transcript_id AND
1093: TERM = term.TERM AND
1094: TRUNC(START_DATE) = TRUNC(term.START_DATE) AND

Line 1109: , dup_term_dtls_id = ( SELECT term_details_id FROM IGS_AD_TERM_DETAILS term_oss

1105: UPDATE igs_ad_trmdt_int term
1106: SET
1107: status = '3'
1108: , match_ind = '20'
1109: , dup_term_dtls_id = ( SELECT term_details_id FROM IGS_AD_TERM_DETAILS term_oss
1110: WHERE transcript_id = term.transcript_id
1111: AND term = term.term
1112: AND TRUNC(start_Date) = TRUNC(term.start_Date)
1113: AND TRUNC(end_Date) = TRUNC(term.end_Date) )

Line 1117: AND EXISTS (SELECT 1 FROM IGS_AD_TERM_DETAILS term_oss

1113: AND TRUNC(end_Date) = TRUNC(term.end_Date) )
1114: WHERE interface_run_id = p_interface_run_id
1115: AND status = '2'
1116: AND NVL (match_ind, '15') = '15'
1117: AND EXISTS (SELECT 1 FROM IGS_AD_TERM_DETAILS term_oss
1118: WHERE transcript_id = term.transcript_id
1119: AND term = term.term
1120: AND TRUNC(start_Date) = TRUNC(term.start_Date)
1121: AND TRUNC(end_Date) = TRUNC(term.end_Date) );