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

Line 1284: AND NVL(TRUNC(mi.start_dt),IGS_GE_DATE.igsdate('4712/12/31')) = NVL(TRUNC(pe.start_dt),IGS_GE_DATE.igsdate('4712/12/31'))

1280: AND NVL(UPPER(mi.county),'NulL') = NVL(UPPER(pe.county),'NulL')
1281: AND NVL(UPPER(mi.province),'NulL') = NVL(UPPER(pe.province),'NulL')
1282: AND NVL(UPPER(mi.city),'NulL') = NVL(UPPER(pe.city),'NulL')
1283: AND NVL(UPPER(mi.state),'NulL') = NVL(UPPER(pe.state),'NulL')
1284: AND NVL(TRUNC(mi.start_dt),IGS_GE_DATE.igsdate('4712/12/31')) = NVL(TRUNC(pe.start_dt),IGS_GE_DATE.igsdate('4712/12/31'))
1285: AND NVL(TRUNC(mi.end_dt),IGS_GE_DATE.igsdate('4712/12/31')) = NVL(TRUNC(pe.end_dt),IGS_GE_DATE.igsdate('4712/12/31'))
1286: AND NVL(UPPER(mi.correspondence),'N') = NVL(UPPER(pe.correspondence),'N')
1287: AND NVL(UPPER(mi.postal_code),'NulL') = NVL(UPPER(pe.postal_code),'NulL')
1288: AND NVL(UPPER(mi.other_details_1),'NulL') = NVL(UPPER(pe.other_details_1),'NulL')

Line 1285: AND NVL(TRUNC(mi.end_dt),IGS_GE_DATE.igsdate('4712/12/31')) = NVL(TRUNC(pe.end_dt),IGS_GE_DATE.igsdate('4712/12/31'))

1281: AND NVL(UPPER(mi.province),'NulL') = NVL(UPPER(pe.province),'NulL')
1282: AND NVL(UPPER(mi.city),'NulL') = NVL(UPPER(pe.city),'NulL')
1283: AND NVL(UPPER(mi.state),'NulL') = NVL(UPPER(pe.state),'NulL')
1284: AND NVL(TRUNC(mi.start_dt),IGS_GE_DATE.igsdate('4712/12/31')) = NVL(TRUNC(pe.start_dt),IGS_GE_DATE.igsdate('4712/12/31'))
1285: AND NVL(TRUNC(mi.end_dt),IGS_GE_DATE.igsdate('4712/12/31')) = NVL(TRUNC(pe.end_dt),IGS_GE_DATE.igsdate('4712/12/31'))
1286: AND NVL(UPPER(mi.correspondence),'N') = NVL(UPPER(pe.correspondence),'N')
1287: AND NVL(UPPER(mi.postal_code),'NulL') = NVL(UPPER(pe.postal_code),'NulL')
1288: AND NVL(UPPER(mi.other_details_1),'NulL') = NVL(UPPER(pe.other_details_1),'NulL')
1289: AND NVL(UPPER(mi.other_details_2),'NulL') = NVL(UPPER(pe.other_details_2),'NulL')

Line 3956: l_default_date DATE := IGS_GE_DATE.IGSDATE('4712/12/01');

3952: l_msg_data VARCHAR2(2000);
3953: l_msg_count NUMBER;
3954: l_party_last_update_date DATE;
3955: l_person_profile_id NUMBER;
3956: l_default_date DATE := IGS_GE_DATE.IGSDATE('4712/12/01');
3957:
3958: PROCEDURE Validate_Person_Statistics(p_per_stat per_stat%ROWTYPE, p_success OUT NOCOPY VARCHAR2, p_error_code OUT NOCOPY VARCHAR2)
3959: IS
3960: l_var VARCHAR2(1);

Line 5162: NVL(TRUNC(cp_end_date),IGS_GE_DATE.igsdate('4712/12/31')) BETWEEN START_DATE

5158: SELECT count(1) FROM IGS_PE_EIT
5159: WHERE person_id = cp_person_id
5160: AND INFORMATION_TYPE = cp_information_type
5161: AND (
5162: NVL(TRUNC(cp_end_date),IGS_GE_DATE.igsdate('4712/12/31')) BETWEEN START_DATE
5163: AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31')) OR
5164: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31')) OR
5165: (cp_start_Date < START_DATE AND
5166: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date ,IGS_GE_DATE.igsdate('4712/12/31')) )

Line 5163: AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31')) OR

5159: WHERE person_id = cp_person_id
5160: AND INFORMATION_TYPE = cp_information_type
5161: AND (
5162: NVL(TRUNC(cp_end_date),IGS_GE_DATE.igsdate('4712/12/31')) BETWEEN START_DATE
5163: AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31')) OR
5164: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31')) OR
5165: (cp_start_Date < START_DATE AND
5166: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date ,IGS_GE_DATE.igsdate('4712/12/31')) )
5167: );

Line 5164: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31')) OR

5160: AND INFORMATION_TYPE = cp_information_type
5161: AND (
5162: NVL(TRUNC(cp_end_date),IGS_GE_DATE.igsdate('4712/12/31')) BETWEEN START_DATE
5163: AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31')) OR
5164: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31')) OR
5165: (cp_start_Date < START_DATE AND
5166: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date ,IGS_GE_DATE.igsdate('4712/12/31')) )
5167: );
5168: BEGIN

Line 5166: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date ,IGS_GE_DATE.igsdate('4712/12/31')) )

5162: NVL(TRUNC(cp_end_date),IGS_GE_DATE.igsdate('4712/12/31')) BETWEEN START_DATE
5163: AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31')) OR
5164: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31')) OR
5165: (cp_start_Date < START_DATE AND
5166: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date ,IGS_GE_DATE.igsdate('4712/12/31')) )
5167: );
5168: BEGIN
5169: -- Call Log header
5170: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 5361: IF p_biodemo_rec.start_date > NVL(p_biodemo_rec.end_date, IGS_GE_DATE.IGSDATE('4712/12/31')) THEN

5357:
5358: END IF; -- pei_information1 IS NOT NULL
5359:
5360: -- validate start and end dates
5361: IF p_biodemo_rec.start_date > NVL(p_biodemo_rec.end_date, IGS_GE_DATE.IGSDATE('4712/12/31')) THEN
5362: l_error := 'E108';
5363: RAISE no_data_found;
5364: END IF;
5365:

Line 5509: AND NVL(TRUNC(pe.end_date),IGS_GE_DATE.IGSDATE('4712/12/01'))=

5505: AND NVL(UPPER(pe.pei_information2),'2') = NVL(UPPER(mi.pei_information2),'2')
5506: AND NVL(UPPER(pe.pei_information3),'3') = NVL(UPPER(mi.pei_information3),'3')
5507: AND NVL(UPPER(pe.pei_information4),'4') = NVL(UPPER(mi.pei_information4),'4')
5508: AND NVL(UPPER(pe.pei_information5),'5') = NVL(UPPER(mi.pei_information5),'5')
5509: AND NVL(TRUNC(pe.end_date),IGS_GE_DATE.IGSDATE('4712/12/01'))=
5510: NVL(TRUNC(mi.end_date),IGS_GE_DATE.IGSDATE('4712/12/01'))
5511: );
5512: END IF;
5513:

Line 5510: NVL(TRUNC(mi.end_date),IGS_GE_DATE.IGSDATE('4712/12/01'))

5506: AND NVL(UPPER(pe.pei_information3),'3') = NVL(UPPER(mi.pei_information3),'3')
5507: AND NVL(UPPER(pe.pei_information4),'4') = NVL(UPPER(mi.pei_information4),'4')
5508: AND NVL(UPPER(pe.pei_information5),'5') = NVL(UPPER(mi.pei_information5),'5')
5509: AND NVL(TRUNC(pe.end_date),IGS_GE_DATE.IGSDATE('4712/12/01'))=
5510: NVL(TRUNC(mi.end_date),IGS_GE_DATE.IGSDATE('4712/12/01'))
5511: );
5512: END IF;
5513:
5514: --6 If rule is R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20

Line 5569: AND (NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))

5565: SELECT COUNT(1) FROM IGS_PE_EIT
5566: WHERE person_id = cp_person_id
5567: AND INFORMATION_TYPE = cp_information_type
5568: AND start_date <> cp_start_date
5569: AND (NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))
5570: OR
5571: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))
5572: OR
5573: ( cp_start_date < START_DATE AND

Line 5571: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))

5567: AND INFORMATION_TYPE = cp_information_type
5568: AND start_date <> cp_start_date
5569: AND (NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))
5570: OR
5571: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))
5572: OR
5573: ( cp_start_date < START_DATE AND
5574: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) ) );
5575:

Line 5574: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) ) );

5570: OR
5571: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))
5572: OR
5573: ( cp_start_date < START_DATE AND
5574: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) ) );
5575:
5576: l_count NUMBER(3);
5577: BEGIN
5578: OPEN date_overlap(biodem_rec.start_date,biodem_rec.end_date,

Line 5664: AND (NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))

5660: SELECT count(1) FROM IGS_PE_EIT
5661: WHERE person_id = cp_person_id
5662: AND INFORMATION_TYPE = cp_information_type
5663: AND start_date <> cp_start_date
5664: AND (NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))
5665: OR
5666: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))
5667: OR
5668: ( cp_start_date < START_DATE AND

Line 5666: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))

5662: AND INFORMATION_TYPE = cp_information_type
5663: AND start_date <> cp_start_date
5664: AND (NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))
5665: OR
5666: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))
5667: OR
5668: ( cp_start_date < START_DATE AND
5669: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) ) );
5670: l_count NUMBER(3);

Line 5669: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) ) );

5665: OR
5666: cp_start_date BETWEEN START_DATE AND NVL(END_DATE,IGS_GE_DATE.igsdate('4712/12/31'))
5667: OR
5668: ( cp_start_date < START_DATE AND
5669: NVL(end_date,IGS_GE_DATE.igsdate('4712/12/31'))< NVL(cp_end_date,IGS_GE_DATE.igsdate('4712/12/31')) ) );
5670: l_count NUMBER(3);
5671: BEGIN
5672: OPEN date_overlap(biodem_rec.start_date,biodem_rec.end_date,
5673: biodem_rec.information_type,biodem_rec.person_id);