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.IGS_AD_IMP_024 dependencies on IGS_AD_TRMDT_INT

Line 487: AND EXISTS( SELECT 1 FROM IGS_AD_TRMDT_INT term

483: ,error_code = 'E708'
484: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E708', 8405)
485: WHERE interface_run_id = p_interface_run_id
486: AND status = '2'
487: AND EXISTS( SELECT 1 FROM IGS_AD_TRMDT_INT term
488: WHERE term.interface_transcript_id = trans.interface_transcript_id
489: AND status = '2')
490: AND 1 < ( SELECT count(*) FROM igs_ad_transcript trans_oss
491: WHERE education_id = trans.education_id

Line 644: UPDATE igs_ad_trmdt_int a

640: END IF;
641: COMMIT;
642:
643: --Term and units are not defined as independent categoies
644: UPDATE igs_ad_trmdt_int a
645: SET interface_run_id = p_interface_run_id,
646: (person_id,education_id, transcript_id)
647: = (SELECT person_id,education_id, NVL(update_transcript_id, transcript_id)
648: FROM igs_ad_txcpt_int

Line 658: UPDATE igs_ad_trmdt_int

654: AND status IN ('1','4'));
655:
656: -- If record failed only due to child record failure
657: -- then set status back to 1 and nullify error code/text
658: UPDATE igs_ad_trmdt_int
659: SET error_code = NULL,
660: error_text = NULL,
661: status = '1'
662: WHERE interface_run_id = p_interface_run_id

Line 671: tabname => 'IGS_AD_TRMDT_INT',

667: l_return := fnd_installation.get_app_info('IGS', l_status, l_industry, l_schema);
668:
669: -- Gather statistics of the table
670: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
671: tabname => 'IGS_AD_TRMDT_INT',
672: cascade => TRUE);
673:
674: process_term_details (p_interface_run_id, p_rule,p_enable_log);
675:

Line 682: FROM igs_ad_trmdt_int

678: SET interface_run_id = p_interface_run_id,
679: (person_id,education_id , transcript_id, term_details_id )
680: = (SELECT person_id,education_id ,
681: transcript_id, term_details_id
682: FROM igs_ad_trmdt_int
683: WHERE interface_term_dtls_id = a.interface_term_dtls_id)
684: WHERE status IN ('1','2','4')
685: AND interface_term_dtls_id IN (SELECT interface_term_dtls_id
686: FROM igs_ad_trmdt_int

Line 686: FROM igs_ad_trmdt_int

682: FROM igs_ad_trmdt_int
683: WHERE interface_term_dtls_id = a.interface_term_dtls_id)
684: WHERE status IN ('1','2','4')
685: AND interface_term_dtls_id IN (SELECT interface_term_dtls_id
686: FROM igs_ad_trmdt_int
687: WHERE interface_run_id = p_interface_run_id
688: AND status IN ('1','4'));
689:
690: -- Gather statistics of the table

Line 707: CURSOR term_cur (cp_start_int_id igs_ad_trmdt_int.INTERFACE_TERM_DTLS_ID%TYPE, --ARVSRINI--

703: p_interface_run_id igs_ad_interface_all.interface_run_id%TYPE,
704: p_rule VARCHAR2,
705: p_enable_log VARCHAR2) AS
706:
707: CURSOR term_cur (cp_start_int_id igs_ad_trmdt_int.INTERFACE_TERM_DTLS_ID%TYPE, --ARVSRINI--
708: cp_end_int_id igs_ad_trmdt_int.INTERFACE_TERM_DTLS_ID%TYPE) IS --ARVSRINI--IS
709: SELECT cst_insert dmlmode, term.rowid, term.*
710: FROM igs_ad_trmdt_int term
711: WHERE interface_run_id = p_interface_run_id

Line 708: cp_end_int_id igs_ad_trmdt_int.INTERFACE_TERM_DTLS_ID%TYPE) IS --ARVSRINI--IS

704: p_rule VARCHAR2,
705: p_enable_log VARCHAR2) AS
706:
707: CURSOR term_cur (cp_start_int_id igs_ad_trmdt_int.INTERFACE_TERM_DTLS_ID%TYPE, --ARVSRINI--
708: cp_end_int_id igs_ad_trmdt_int.INTERFACE_TERM_DTLS_ID%TYPE) IS --ARVSRINI--IS
709: SELECT cst_insert dmlmode, term.rowid, term.*
710: FROM igs_ad_trmdt_int term
711: WHERE interface_run_id = p_interface_run_id
712: AND term.status = '2'

Line 710: FROM igs_ad_trmdt_int term

706:
707: CURSOR term_cur (cp_start_int_id igs_ad_trmdt_int.INTERFACE_TERM_DTLS_ID%TYPE, --ARVSRINI--
708: cp_end_int_id igs_ad_trmdt_int.INTERFACE_TERM_DTLS_ID%TYPE) IS --ARVSRINI--IS
709: SELECT cst_insert dmlmode, term.rowid, term.*
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

Line 723: FROM igs_ad_trmdt_int term

719: OR ( p_rule = 'R' AND term.match_ind IN ('16', '25') )
720: )
721: UNION ALL
722: SELECT cst_update dmlmode, term.rowid, term.*
723: FROM igs_ad_trmdt_int term
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))

Line 771: l_term_details_id igs_ad_trmdt_int.term_details_id%TYPE;

767: -- (reverse chronological order - newest change first)
768: --------------------------------------------------------------------------
769: l_rowid VARCHAR2(25);
770: l_var VARCHAR2(25);
771: l_term_details_id igs_ad_trmdt_int.term_details_id%TYPE;
772: l_msg_at_index NUMBER := 0;
773: l_return_status VARCHAR2(1);
774: l_msg_count NUMBER ;
775: l_msg_data VARCHAR2(2000);

Line 795: UPDATE igs_ad_trmdt_int

791: NULL,
792: p_term_dtls_record.TOTAL_GPA_UNITS ,
793: p_term_dtls_record.GPA
794: );
795: UPDATE igs_ad_trmdt_int
796: SET status =cst_s_val_1,
797: error_code = cst_ec_val_NULL,
798: term_details_id = l_term_details_id
799: WHERE interface_term_dtls_id = p_term_dtls_record.interface_term_dtls_id;

Line 818: igs_ad_imp_001.logerrormessage(p_term_dtls_record.interface_term_dtls_id,l_msg_data,'IGS_AD_TRMDT_INT');

814: l_error_text := l_msg_data;
815: l_error_code := 'E322';
816:
817: IF p_enable_log = 'Y' THEN
818: igs_ad_imp_001.logerrormessage(p_term_dtls_record.interface_term_dtls_id,l_msg_data,'IGS_AD_TRMDT_INT');
819: END IF;
820: ELSE
821: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
822: l_error_code := 'E518';

Line 840: UPDATE igs_ad_trmdt_int

836: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
837: END IF;
838:
839: END IF;
840: UPDATE igs_ad_trmdt_int
841: SET status = cst_s_val_3,
842: error_code = l_error_code,
843: error_text = l_error_text,
844: match_ind = DECODE (

Line 864: l_term_details_id igs_ad_trmdt_int.term_details_id%TYPE;

860: -- (reverse chronological order - newest change first)
861: --------------------------------------------------------------------------
862: l_rowid VARCHAR2(25);
863: l_var VARCHAR2(25);
864: l_term_details_id igs_ad_trmdt_int.term_details_id%TYPE;
865: l_msg_at_index NUMBER := 0;
866: l_return_status VARCHAR2(1);
867: l_msg_count NUMBER ;
868: l_msg_data VARCHAR2(2000);

Line 888: UPDATE igs_ad_trmdt_int

884: X_TOTAL_UNIT_GP => dup_cur_rec.total_unit_gp,
885: X_TOTAL_GPA_UNITS => NVL(p_term_dtls_record.total_gpa_units, dup_cur_rec.total_gpa_units),
886: X_GPA => NVL(p_term_dtls_record.gpa, dup_cur_rec.gpa)
887: );
888: UPDATE igs_ad_trmdt_int
889: SET status =cst_s_val_1,
890: error_code = cst_ec_val_NULL,
891: term_details_id = dup_cur_rec.term_details_id
892: WHERE interface_term_dtls_id = p_term_dtls_record.interface_term_dtls_id;

Line 908: igs_ad_imp_001.logerrormessage( p_term_dtls_record.interface_term_dtls_id,l_msg_data,'IGS_AD_TRMDT_INT');

904: l_error_text := l_msg_data;
905: l_error_code := 'E014';
906:
907: IF p_enable_log = 'Y' THEN
908: igs_ad_imp_001.logerrormessage( p_term_dtls_record.interface_term_dtls_id,l_msg_data,'IGS_AD_TRMDT_INT');
909: END IF;
910: ELSE
911: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
912: l_error_code := 'E518';

Line 930: UPDATE igs_ad_trmdt_int

926: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
927: END IF;
928:
929: END IF;
930: UPDATE igs_ad_trmdt_int
931: SET status = cst_s_val_3,
932: error_code = l_error_code,
933: error_text = l_error_text,
934: match_ind = DECODE (

Line 946: UPDATE igs_ad_trmdt_int term

942:
943: BEGIN
944: -- jchin Bug 4629226 Put an error in the int table if record is associated with an external transcript
945:
946: UPDATE igs_ad_trmdt_int term
947: SET
948: status = '3'
949: ,error_code = 'E334'
950: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)

Line 964: UPDATE igs_ad_trmdt_int

960: COMMIT;
961:
962: --1. Set STATUS to 3 for interface records with RULE = E or I and MATCH IND is not null and not '15'
963: IF p_rule IN ('E', 'I') THEN
964: UPDATE igs_ad_trmdt_int
965: SET
966: status = '3'
967: , error_code = 'E700'
968: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

Line 977: UPDATE igs_ad_trmdt_int

973: COMMIT;
974:
975: -- 2. Set STATUS to 1 for interface records with RULE = R and MATCH IND = 17,18,19,22,23,24,27
976: IF p_rule = 'R' THEN
977: UPDATE igs_ad_trmdt_int
978: SET
979: status = '1', error_code = NULL
980: WHERE interface_run_id = p_interface_run_id
981: AND status = '2'

Line 987: UPDATE igs_ad_trmdt_int term

983: END IF;
984: COMMIT;
985: -- 5. Set STATUS to 1 and MATCH IND to 19 for interface records with RULE = E matching OSS record(s)
986: IF p_rule = 'E' THEN
987: UPDATE igs_ad_trmdt_int term
988: SET
989: status = '3'
990: , error_code = 'E708'
991: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E708', 8405)

Line 1004: UPDATE igs_ad_trmdt_int term

1000: AND TRUNC(start_Date) = TRUNC(term.start_Date)
1001: AND TRUNC(end_Date) = TRUNC(term.end_Date)
1002: );
1003:
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

Line 1043: FROM igs_ad_trmdt_int

1039: **********************************************************************************/
1040:
1041: l_total_records_prcessed := 0;
1042: SELECT COUNT( interface_term_dtls_id) INTO l_count_interface_trmdtls_id
1043: FROM igs_ad_trmdt_int
1044: WHERE interface_run_id = p_interface_run_id
1045: AND status =2 ;
1046:
1047: LOOP

Line 1053: FROM igs_ad_trmdt_int

1049:
1050: SELECT
1051: MIN(interface_term_dtls_id) , MAX(interface_term_dtls_id)
1052: INTO l_minint , l_maxint
1053: FROM igs_ad_trmdt_int
1054: WHERE interface_run_id = p_interface_run_id
1055: AND status =2
1056: AND rownum < =100;
1057:

Line 1083: UPDATE igs_ad_trmdt_int term

1079:
1080: /*Set STATUS to 1 and MATCH IND to 23 for interface records with RULE = R matching OSS record(s) in
1081: ALL updateable column values, if column nullification is not allowed then the 2 DECODE should be replaced by a single NVL*/
1082: IF p_rule = 'R' THEN
1083: UPDATE igs_ad_trmdt_int term
1084: SET
1085: status = '1'
1086: , match_ind = '23'
1087: WHERE interface_run_id = p_interface_run_id

Line 1105: UPDATE igs_ad_trmdt_int term

1101:
1102: --Set STATUS to 3 and MATCH IND = 20 for interface records with RULE = R and
1103: --MATCH IND <> 21, 25, ones failed above discrepancy check
1104: IF p_rule = 'R' THEN
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

Line 1129: UPDATE igs_ad_trmdt_int term

1125:
1126:
1127: --Set STATUS to 3 for interface records with RULE = R and invalid MATCH IND
1128: IF p_rule = 'R' THEN
1129: UPDATE igs_ad_trmdt_int term
1130: SET
1131: status = '3'
1132: , error_code = 'E700'
1133: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

Line 1390: igs_ad_trmdt_int term

1386: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)
1387: WHERE interface_run_id = p_interface_run_id
1388: AND status = '2'
1389: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int trans, igs_ad_code_classes_v code,
1390: igs_ad_trmdt_int term
1391: WHERE trans.interface_transcript_id = term.interface_transcript_id
1392: AND term.interface_term_dtls_id = unit.interface_term_dtls_id
1393: AND trans.transcript_source = code.code_id
1394: AND code.class = 'TRANSCRIPT_SOURCE'