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_013 dependencies on IGS_GE_DATE

Line 590: l_default_date := igs_ge_date.igsdate('9999/01/01');

586:
587: END validate_record;
588:
589: BEGIN
590: l_default_date := igs_ge_date.igsdate('9999/01/01');
591:
592: l_prog_label := 'igs.plsql.igs_ad_imp_013.prc_pe_type';
593: l_label := 'igs.plsql.igs_ad_imp_013.prc_pe_type.';
594: l_enable_log := igs_ad_imp_001.g_enable_log;

Line 2078: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

2074: AND cred.status = '2'
2075: AND ( NOT EXISTS (SELECT 1 FROM IGS_PE_CREDENTIALS
2076: WHERE person_id = ad.person_id
2077: AND credential_type_id = cred.credential_type_id
2078: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2079: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) )
2080: OR ( p_rule = 'R' AND cred.match_ind IN ('16', '25') )
2081: )
2082: UNION ALL

Line 2079: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) )

2075: AND ( NOT EXISTS (SELECT 1 FROM IGS_PE_CREDENTIALS
2076: WHERE person_id = ad.person_id
2077: AND credential_type_id = cred.credential_type_id
2078: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2079: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) )
2080: OR ( p_rule = 'R' AND cred.match_ind IN ('16', '25') )
2081: )
2082: UNION ALL
2083: SELECT cst_update dmlmode, cred.rowid, ad.person_id, cred.*

Line 2093: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

2089: AND ( p_rule = 'I' OR (p_rule = 'R' AND cred.match_ind = cst_mi_val_21))
2090: AND EXISTS (SELECT 1 FROM IGS_PE_CREDENTIALS
2091: WHERE person_id = ad.person_id
2092: AND credential_type_id = cred.credential_type_id
2093: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2094: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))
2095: );
2096:
2097: CURSOR c_dup_cur(cp_pe_cr_rec c_pe_cr_cur%ROWTYPE) IS

Line 2094: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))

2090: AND EXISTS (SELECT 1 FROM IGS_PE_CREDENTIALS
2091: WHERE person_id = ad.person_id
2092: AND credential_type_id = cred.credential_type_id
2093: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2094: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))
2095: );
2096:
2097: CURSOR c_dup_cur(cp_pe_cr_rec c_pe_cr_cur%ROWTYPE) IS
2098: SELECT

Line 2105: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) = TRUNC(NVL(cp_pe_cr_rec.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')));

2101: igs_pe_credentials pcreds
2102: WHERE
2103: person_id = cp_pe_cr_rec.person_id
2104: AND credential_type_id = cp_pe_cr_rec.credential_type_id
2105: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) = TRUNC(NVL(cp_pe_cr_rec.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')));
2106:
2107:
2108: /*************************************************
2109: END Cursor Declarations

Line 2523: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

2519: FROM igs_pe_credentials cred_oss
2520: WHERE person_id = (SELECT person_id FROM igs_ad_interface_all
2521: WHERE interface_id = cred.interface_id)
2522: AND credential_type_id = cred.credential_type_id
2523: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2524: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))
2525: );
2526:
2527: END IF;

Line 2524: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))

2520: WHERE person_id = (SELECT person_id FROM igs_ad_interface_all
2521: WHERE interface_id = cred.interface_id)
2522: AND credential_type_id = cred.credential_type_id
2523: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2524: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))
2525: );
2526:
2527: END IF;
2528: COMMIT;

Line 2544: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

2540: FROM igs_pe_credentials cred_oss
2541: WHERE person_id = (SELECT person_id FROM igs_ad_interface_all
2542: WHERE interface_id = cred.interface_id)
2543: AND credential_type_id = cred.credential_type_id
2544: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2545: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))
2546: );
2547:
2548: END IF;

Line 2545: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))

2541: WHERE person_id = (SELECT person_id FROM igs_ad_interface_all
2542: WHERE interface_id = cred.interface_id)
2543: AND credential_type_id = cred.credential_type_id
2544: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2545: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))
2546: );
2547:
2548: END IF;
2549: COMMIT;

Line 2562: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

2558: AND EXISTS ( SELECT 1 FROM IGS_PE_CREDENTIALS
2559: WHERE person_id IN (SELECT PERSON_ID FROM IGS_AD_INTERFACE_ALL
2560: WHERE interface_id = cred.interface_id AND interface_run_id = p_interface_run_id)
2561: AND credential_type_id = cred.credential_type_id
2562: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2563: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))
2564: );
2565: END IF;
2566: COMMIT;

Line 2563: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))

2559: WHERE person_id IN (SELECT PERSON_ID FROM IGS_AD_INTERFACE_ALL
2560: WHERE interface_id = cred.interface_id AND interface_run_id = p_interface_run_id)
2561: AND credential_type_id = cred.credential_type_id
2562: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2563: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01')))
2564: );
2565: END IF;
2566: COMMIT;
2567:

Line 2620: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

2616: WHERE person_id IN (SELECT PERSON_ID FROM IGS_AD_INTERFACE_ALL
2617: WHERE interface_id = cred.interface_id
2618: AND interface_run_id = p_interface_run_id)
2619: AND credential_type_id = cred.credential_type_id
2620: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2621: TRUNC(NVL(cred.date_received, NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))))
2622: AND NVL(RATING_CODE, '-1') = NVL(cred.rating_code, NVL(RATING_CODE, '-1'))
2623: AND NVL(REVIEWER_ID, -1) = NVL(cred.reviewer_id, NVL(REVIEWER_ID, -1))
2624: AND NVL(REVIEWER_NOTES, '-1') = NVL(cred.reviewer_notes, NVL(REVIEWER_NOTES, '-1'))

Line 2621: TRUNC(NVL(cred.date_received, NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))))

2617: WHERE interface_id = cred.interface_id
2618: AND interface_run_id = p_interface_run_id)
2619: AND credential_type_id = cred.credential_type_id
2620: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2621: TRUNC(NVL(cred.date_received, NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))))
2622: AND NVL(RATING_CODE, '-1') = NVL(cred.rating_code, NVL(RATING_CODE, '-1'))
2623: AND NVL(REVIEWER_ID, -1) = NVL(cred.reviewer_id, NVL(REVIEWER_ID, -1))
2624: AND NVL(REVIEWER_NOTES, '-1') = NVL(cred.reviewer_notes, NVL(REVIEWER_NOTES, '-1'))
2625: AND NVL(RECOMMENDER_NAME, '-1') = NVL(cred.recommender_name, NVL(RECOMMENDER_NAME, '-1'))

Line 2643: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

2639: , dup_credential_id= (SELECT credential_id FROM igs_pe_credentials
2640: WHERE person_id IN (SELECT PERSON_ID FROM IGS_AD_INTERFACE_ALL
2641: WHERE interface_id = cred.interface_id AND interface_run_id = p_interface_run_id)
2642: AND credential_type_id = cred.credential_type_id
2643: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2644: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))))
2645: WHERE interface_run_id = p_interface_run_id
2646: AND status = '2'
2647: AND NVL (match_ind, '15') = '15'

Line 2644: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))))

2640: WHERE person_id IN (SELECT PERSON_ID FROM IGS_AD_INTERFACE_ALL
2641: WHERE interface_id = cred.interface_id AND interface_run_id = p_interface_run_id)
2642: AND credential_type_id = cred.credential_type_id
2643: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2644: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))))
2645: WHERE interface_run_id = p_interface_run_id
2646: AND status = '2'
2647: AND NVL (match_ind, '15') = '15'
2648: AND EXISTS (SELECT credential_id FROM igs_pe_credentials

Line 2652: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =

2648: AND EXISTS (SELECT credential_id FROM igs_pe_credentials
2649: WHERE person_id IN (SELECT PERSON_ID FROM IGS_AD_INTERFACE_ALL
2650: WHERE interface_id = cred.interface_id AND interface_run_id = p_interface_run_id)
2651: AND credential_type_id = cred.credential_type_id
2652: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2653: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))));
2654:
2655: END IF;
2656: COMMIT;

Line 2653: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))));

2649: WHERE person_id IN (SELECT PERSON_ID FROM IGS_AD_INTERFACE_ALL
2650: WHERE interface_id = cred.interface_id AND interface_run_id = p_interface_run_id)
2651: AND credential_type_id = cred.credential_type_id
2652: AND TRUNC(NVL(date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))) =
2653: TRUNC(NVL(cred.date_received, IGS_GE_DATE.IGSDATE('1700/01/01'))));
2654:
2655: END IF;
2656: COMMIT;
2657: