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.BEN_EXT_THREAD dependencies on HR_API

Line 3715: l_cad_date_from := hr_api.g_sot ;

3711:
3712: if p_data_typ_cd in ('C') then
3713: if l_cad_exists = 'Y' then
3714: if l_cad_val1 in ('CHAD','CHED') then
3715: l_cad_date_from := hr_api.g_sot ;
3716: l_cad_date_to := hr_api.g_eot ;
3717: Else
3718: l_cad_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val1,
3719: p_abs_date => p_effective_date,

Line 3716: l_cad_date_to := hr_api.g_eot ;

3712: if p_data_typ_cd in ('C') then
3713: if l_cad_exists = 'Y' then
3714: if l_cad_val1 in ('CHAD','CHED') then
3715: l_cad_date_from := hr_api.g_sot ;
3716: l_cad_date_to := hr_api.g_eot ;
3717: Else
3718: l_cad_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val1,
3719: p_abs_date => p_effective_date,
3720: p_ext_dfn_id => p_ext_dfn_id);

Line 3729: l_cad_date_from := hr_api.g_sot ;

3725:
3726:
3727: if l_ced_exists = 'Y' then
3728: if l_ced_val1 in ('CHAD','CHED') then
3729: l_cad_date_from := hr_api.g_sot ;
3730: l_cad_date_to := hr_api.g_eot ;
3731: Else
3732: l_ced_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val1,
3733: p_abs_date => p_effective_date,

Line 3730: l_cad_date_to := hr_api.g_eot ;

3726:
3727: if l_ced_exists = 'Y' then
3728: if l_ced_val1 in ('CHAD','CHED') then
3729: l_cad_date_from := hr_api.g_sot ;
3730: l_cad_date_to := hr_api.g_eot ;
3731: Else
3732: l_ced_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val1,
3733: p_abs_date => p_effective_date,
3734: p_ext_dfn_id => p_ext_dfn_id);

Line 4329: l_cad_date_from := hr_api.g_sot ;

4325: if g_debug then
4326: hr_utility.set_location(' called from benxthrd 1 '|| l_cad_val1 ,514);
4327: end if;
4328: if l_cad_val1 in ('CHAD','CHED') then
4329: l_cad_date_from := hr_api.g_sot ;
4330: l_cad_date_to := hr_api.g_eot ;
4331: Else
4332: l_cad_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val1,
4333: p_abs_date => p_effective_date,

Line 4330: l_cad_date_to := hr_api.g_eot ;

4326: hr_utility.set_location(' called from benxthrd 1 '|| l_cad_val1 ,514);
4327: end if;
4328: if l_cad_val1 in ('CHAD','CHED') then
4329: l_cad_date_from := hr_api.g_sot ;
4330: l_cad_date_to := hr_api.g_eot ;
4331: Else
4332: l_cad_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val1,
4333: p_abs_date => p_effective_date,
4334: p_ext_dfn_id => p_ext_dfn_id);

Line 4344: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS')||

4340: if l_dynamic_BEN_sql is not null then
4341:
4342: if l_cad_exclude = 'N' then
4343: l_dynamic_BEN_sql := l_dynamic_BEN_sql || ' and xcl.chg_actl_dt between to_date(''' ||
4344: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS')||
4345: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4346: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-RRRR HH24:MI:SS') || ''',''DD-MM-RRRR HH24:MI:SS'') ';
4347: else
4348: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||

Line 4346: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-RRRR HH24:MI:SS') || ''',''DD-MM-RRRR HH24:MI:SS'') ';

4342: if l_cad_exclude = 'N' then
4343: l_dynamic_BEN_sql := l_dynamic_BEN_sql || ' and xcl.chg_actl_dt between to_date(''' ||
4344: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS')||
4345: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4346: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-RRRR HH24:MI:SS') || ''',''DD-MM-RRRR HH24:MI:SS'') ';
4347: else
4348: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||
4349: ' and xcl.chg_actl_dt not between to_date(''' ||
4350: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||

Line 4350: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||

4346: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-RRRR HH24:MI:SS') || ''',''DD-MM-RRRR HH24:MI:SS'') ';
4347: else
4348: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||
4349: ' and xcl.chg_actl_dt not between to_date(''' ||
4350: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4351: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4352: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-RRRR HH24:MI:SS') ||''',''DD-MM-RRRR HH24:MI:SS'') ';
4353: end if;
4354: end if ;

Line 4352: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-RRRR HH24:MI:SS') ||''',''DD-MM-RRRR HH24:MI:SS'') ';

4348: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||
4349: ' and xcl.chg_actl_dt not between to_date(''' ||
4350: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4351: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4352: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-RRRR HH24:MI:SS') ||''',''DD-MM-RRRR HH24:MI:SS'') ';
4353: end if;
4354: end if ;
4355:
4356: if l_dynamic_PAY_sql is not null then

Line 4360: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||

4356: if l_dynamic_PAY_sql is not null then
4357: if nvl(l_pay_evt_non_asg,'N') = 'N' then
4358: if l_cad_exclude = 'N' then
4359: l_dynamic_PAY_sql := l_dynamic_PAY_sql || ' and xcl.CREATION_DATE between to_date(''' ||
4360: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4361: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4362: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-RRRR HH24:MI:SS')||''',''DD-MM-RRRR HH24:MI:SS'')';
4363: else
4364: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||

Line 4362: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-RRRR HH24:MI:SS')||''',''DD-MM-RRRR HH24:MI:SS'')';

4358: if l_cad_exclude = 'N' then
4359: l_dynamic_PAY_sql := l_dynamic_PAY_sql || ' and xcl.CREATION_DATE between to_date(''' ||
4360: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4361: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4362: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-RRRR HH24:MI:SS')||''',''DD-MM-RRRR HH24:MI:SS'')';
4363: else
4364: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4365: ' and xcl.CREATION_DATE not between to_date(''' ||
4366: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||

Line 4366: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||

4362: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-RRRR HH24:MI:SS')||''',''DD-MM-RRRR HH24:MI:SS'')';
4363: else
4364: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4365: ' and xcl.CREATION_DATE not between to_date(''' ||
4366: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4367: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4368: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-YYYY HH24:MI:SS')||''',''DD-MM-RRRR HH24:MI:SS'') ';
4369: end if;
4370: end if ;

Line 4368: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-YYYY HH24:MI:SS')||''',''DD-MM-RRRR HH24:MI:SS'') ';

4364: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4365: ' and xcl.CREATION_DATE not between to_date(''' ||
4366: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4367: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4368: to_char(nvl(l_cad_date_to+0.99999,hr_api.g_eot),'DD-MM-YYYY HH24:MI:SS')||''',''DD-MM-RRRR HH24:MI:SS'') ';
4369: end if;
4370: end if ;
4371: end if ;
4372: end if; -- CAD

Line 4379: l_cad_date_from := hr_api.g_sot ;

4375: if g_debug then
4376: hr_utility.set_location(' called from benxthrd 2 '|| l_ced_val1 ,514);
4377: end if;
4378: if l_ced_val1 in ('CHAD','CHED') then
4379: l_cad_date_from := hr_api.g_sot ;
4380: l_cad_date_to := hr_api.g_eot ;
4381: Else
4382: l_ced_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val1,
4383: p_abs_date => p_effective_date,

Line 4380: l_cad_date_to := hr_api.g_eot ;

4376: hr_utility.set_location(' called from benxthrd 2 '|| l_ced_val1 ,514);
4377: end if;
4378: if l_ced_val1 in ('CHAD','CHED') then
4379: l_cad_date_from := hr_api.g_sot ;
4380: l_cad_date_to := hr_api.g_eot ;
4381: Else
4382: l_ced_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val1,
4383: p_abs_date => p_effective_date,
4384: p_ext_dfn_id => p_ext_dfn_id);

Line 4395: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4391: if l_dynamic_BEN_sql is not null then
4392:
4393: if l_ced_exclude = 'N' then
4394: l_dynamic_BEN_sql := l_dynamic_BEN_sql || ' and xcl.chg_eff_dt between to_date(''' ||
4395: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4396: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4397: else
4398: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||
4399: ' and xcl.chg_eff_dt not between to_date(''' ||

Line 4396: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';

4392:
4393: if l_ced_exclude = 'N' then
4394: l_dynamic_BEN_sql := l_dynamic_BEN_sql || ' and xcl.chg_eff_dt between to_date(''' ||
4395: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4396: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4397: else
4398: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||
4399: ' and xcl.chg_eff_dt not between to_date(''' ||
4400: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

Line 4400: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4396: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4397: else
4398: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||
4399: ' and xcl.chg_eff_dt not between to_date(''' ||
4400: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4401: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4402: end if;
4403: end if ;
4404:

Line 4401: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';

4397: else
4398: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||
4399: ' and xcl.chg_eff_dt not between to_date(''' ||
4400: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4401: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4402: end if;
4403: end if ;
4404:
4405: /*

Line 4410: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4406: if l_dynamic_PAY_sql is not null then
4407: if nvl(l_pay_evt_non_asg,'N') = 'N' then
4408: if l_ced_exclude = 'N' then
4409: l_dynamic_PAY_sql := l_dynamic_PAY_sql || ' and xcl.EFFECTIVE_DATE between to_date(''' ||
4410: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4411: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4412: else
4413: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4414: ' and xcl.EFFECTIVE_DATE not between to_date(''' ||

Line 4411: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';

4407: if nvl(l_pay_evt_non_asg,'N') = 'N' then
4408: if l_ced_exclude = 'N' then
4409: l_dynamic_PAY_sql := l_dynamic_PAY_sql || ' and xcl.EFFECTIVE_DATE between to_date(''' ||
4410: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4411: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4412: else
4413: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4414: ' and xcl.EFFECTIVE_DATE not between to_date(''' ||
4415: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

Line 4415: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4411: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4412: else
4413: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4414: ' and xcl.EFFECTIVE_DATE not between to_date(''' ||
4415: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4416: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4417: end if;
4418: end if ;
4419: end if ;

Line 4416: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';

4412: else
4413: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4414: ' and xcl.EFFECTIVE_DATE not between to_date(''' ||
4415: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4416: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4417: end if;
4418: end if ;
4419: end if ;
4420: end if;

Line 4430: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4426: if(p_penserv_date is not null)
4427: then
4428:
4429: l_dynamic_PAY_sql := l_dynamic_PAY_sql || ' and ( ( xcl.EFFECTIVE_DATE between to_date(''' ||
4430: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4431: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '
4432: || ' and xcl.CREATION_DATE between to_date(''' ||
4433: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4434: to_char(nvl(l_ced_date_to + 1,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') )'

Line 4431: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '

4427: then
4428:
4429: l_dynamic_PAY_sql := l_dynamic_PAY_sql || ' and ( ( xcl.EFFECTIVE_DATE between to_date(''' ||
4430: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4431: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '
4432: || ' and xcl.CREATION_DATE between to_date(''' ||
4433: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4434: to_char(nvl(l_ced_date_to + 1,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') )'
4435: || ' or ( xcl.CREATION_DATE between to_date(''' ||

Line 4433: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4429: l_dynamic_PAY_sql := l_dynamic_PAY_sql || ' and ( ( xcl.EFFECTIVE_DATE between to_date(''' ||
4430: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4431: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '
4432: || ' and xcl.CREATION_DATE between to_date(''' ||
4433: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4434: to_char(nvl(l_ced_date_to + 1,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') )'
4435: || ' or ( xcl.CREATION_DATE between to_date(''' ||
4436: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4437: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '

Line 4434: to_char(nvl(l_ced_date_to + 1,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') )'

4430: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4431: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '
4432: || ' and xcl.CREATION_DATE between to_date(''' ||
4433: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4434: to_char(nvl(l_ced_date_to + 1,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') )'
4435: || ' or ( xcl.CREATION_DATE between to_date(''' ||
4436: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4437: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '
4438: || ' and xcl.EFFECTIVE_DATE between to_date(''' ||

Line 4436: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4432: || ' and xcl.CREATION_DATE between to_date(''' ||
4433: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4434: to_char(nvl(l_ced_date_to + 1,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') )'
4435: || ' or ( xcl.CREATION_DATE between to_date(''' ||
4436: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4437: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '
4438: || ' and xcl.EFFECTIVE_DATE between to_date(''' ||
4439: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4440: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ))';

Line 4437: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '

4433: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4434: to_char(nvl(l_ced_date_to + 1,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') )'
4435: || ' or ( xcl.CREATION_DATE between to_date(''' ||
4436: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4437: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '
4438: || ' and xcl.EFFECTIVE_DATE between to_date(''' ||
4439: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4440: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ))';
4441:

Line 4439: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4435: || ' or ( xcl.CREATION_DATE between to_date(''' ||
4436: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4437: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '
4438: || ' and xcl.EFFECTIVE_DATE between to_date(''' ||
4439: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4440: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ))';
4441:
4442: -- For pensrv, Attribute check.Bug# 7341530
4443:

Line 4440: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ))';

4436: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4437: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') '
4438: || ' and xcl.EFFECTIVE_DATE between to_date(''' ||
4439: to_char(nvl(p_penserv_date,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4440: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ))';
4441:
4442: -- For pensrv, Attribute check.Bug# 7341530
4443:
4444: PQP_UTILITIES.get_config_type_values(

Line 4473: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4469: END IF;
4470:
4471: else ----- vkodedal
4472: l_dynamic_PAY_sql := l_dynamic_PAY_sql || ' and xcl.EFFECTIVE_DATE between to_date(''' ||
4473: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4474: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4475: end if;
4476: else
4477: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||

Line 4474: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';

4470:
4471: else ----- vkodedal
4472: l_dynamic_PAY_sql := l_dynamic_PAY_sql || ' and xcl.EFFECTIVE_DATE between to_date(''' ||
4473: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4474: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4475: end if;
4476: else
4477: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4478: ' and xcl.EFFECTIVE_DATE not between to_date(''' ||

Line 4479: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4475: end if;
4476: else
4477: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4478: ' and xcl.EFFECTIVE_DATE not between to_date(''' ||
4479: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4480: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4481: end if;
4482: end if ;
4483: end if ;

Line 4480: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';

4476: else
4477: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4478: ' and xcl.EFFECTIVE_DATE not between to_date(''' ||
4479: to_char(nvl(l_ced_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4480: to_char(nvl(l_ced_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4481: end if;
4482: end if ;
4483: end if ;
4484: end if;

Line 4546: to_char(nvl(l_mtbsdt_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4542: p_abs_date => p_effective_date,
4543: p_ext_dfn_id => p_ext_dfn_id);
4544: if l_mtbsdt_exclude = 'N' then
4545: l_dynamic_sql := l_dynamic_sql || ' and pcp.to_be_sent_dt between to_date(''' ||
4546: to_char(nvl(l_mtbsdt_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4547: to_char(nvl(l_mtbsdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4548: else
4549: l_dynamic_sql := l_dynamic_sql ||
4550: ' and (pcp.to_be_sent_dt is null or pcp.to_be_sent_dt not between to_date(''' ||

Line 4547: to_char(nvl(l_mtbsdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';

4543: p_ext_dfn_id => p_ext_dfn_id);
4544: if l_mtbsdt_exclude = 'N' then
4545: l_dynamic_sql := l_dynamic_sql || ' and pcp.to_be_sent_dt between to_date(''' ||
4546: to_char(nvl(l_mtbsdt_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4547: to_char(nvl(l_mtbsdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4548: else
4549: l_dynamic_sql := l_dynamic_sql ||
4550: ' and (pcp.to_be_sent_dt is null or pcp.to_be_sent_dt not between to_date(''' ||
4551: to_char(nvl(l_mtbsdt_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

Line 4551: to_char(nvl(l_mtbsdt_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4547: to_char(nvl(l_mtbsdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') ';
4548: else
4549: l_dynamic_sql := l_dynamic_sql ||
4550: ' and (pcp.to_be_sent_dt is null or pcp.to_be_sent_dt not between to_date(''' ||
4551: to_char(nvl(l_mtbsdt_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4552: to_char(nvl(l_mtbsdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'')) ';
4553: end if;
4554: end if;
4555: -- communication send date

Line 4552: to_char(nvl(l_mtbsdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'')) ';

4548: else
4549: l_dynamic_sql := l_dynamic_sql ||
4550: ' and (pcp.to_be_sent_dt is null or pcp.to_be_sent_dt not between to_date(''' ||
4551: to_char(nvl(l_mtbsdt_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4552: to_char(nvl(l_mtbsdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'')) ';
4553: end if;
4554: end if;
4555: -- communication send date
4556: if l_msdt_exists = 'Y' and p_data_typ_cd in ('CM') then

Line 4565: to_char(nvl(l_msdt_date_from,hr_api.g_sot),'DD-MM-YYYY') || ''',''DD-MM-RRRR'') and to_date(''' ||

4561: p_abs_date => p_effective_date,
4562: p_ext_dfn_id => p_ext_dfn_id);
4563: if l_msdt_exclude = 'N' then
4564: l_dynamic_sql := l_dynamic_sql || ' and pcp.sent_dt between to_date(''' ||
4565: to_char(nvl(l_msdt_date_from,hr_api.g_sot),'DD-MM-YYYY') || ''',''DD-MM-RRRR'') and to_date(''' ||
4566: to_char(nvl(l_msdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'')';
4567: else
4568: l_dynamic_sql := l_dynamic_sql ||
4569: ' and (pcp.sent_dt is null or pcp.sent_dt not between to_date(''' ||

Line 4566: to_char(nvl(l_msdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'')';

4562: p_ext_dfn_id => p_ext_dfn_id);
4563: if l_msdt_exclude = 'N' then
4564: l_dynamic_sql := l_dynamic_sql || ' and pcp.sent_dt between to_date(''' ||
4565: to_char(nvl(l_msdt_date_from,hr_api.g_sot),'DD-MM-YYYY') || ''',''DD-MM-RRRR'') and to_date(''' ||
4566: to_char(nvl(l_msdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'')';
4567: else
4568: l_dynamic_sql := l_dynamic_sql ||
4569: ' and (pcp.sent_dt is null or pcp.sent_dt not between to_date(''' ||
4570: to_char(nvl(l_msdt_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

Line 4570: to_char(nvl(l_msdt_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||

4566: to_char(nvl(l_msdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'')';
4567: else
4568: l_dynamic_sql := l_dynamic_sql ||
4569: ' and (pcp.sent_dt is null or pcp.sent_dt not between to_date(''' ||
4570: to_char(nvl(l_msdt_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4571: to_char(nvl(l_msdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'')) ';
4572: end if;
4573: end if;
4574:

Line 4571: to_char(nvl(l_msdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'')) ';

4567: else
4568: l_dynamic_sql := l_dynamic_sql ||
4569: ' and (pcp.sent_dt is null or pcp.sent_dt not between to_date(''' ||
4570: to_char(nvl(l_msdt_date_from,hr_api.g_sot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'') and to_date(''' ||
4571: to_char(nvl(l_msdt_date_to,hr_api.g_eot),'DD-MM-RRRR') || ''',''DD-MM-RRRR'')) ';
4572: end if;
4573: end if;
4574:
4575:

Line 5644: hr_api.mandatory_arg_error(p_api_name => l_proc

5640: p_commit => l_commit);
5641: --
5642: if p_ext_dfn_id is null then
5643: --
5644: hr_api.mandatory_arg_error(p_api_name => l_proc
5645: ,p_argument => 'p_ext_dfn_id'
5646: ,p_argument_value => p_ext_dfn_id);
5647: --
5648: elsif p_effective_date is null then

Line 5650: hr_api.mandatory_arg_error(p_api_name => l_proc

5646: ,p_argument_value => p_ext_dfn_id);
5647: --
5648: elsif p_effective_date is null then
5649: --
5650: hr_api.mandatory_arg_error(p_api_name => l_proc
5651: ,p_argument => 'p_effective_date'
5652: ,p_argument_value => p_effective_date);
5653: --
5654: elsif p_business_group_id is null then

Line 5656: hr_api.mandatory_arg_error(p_api_name => l_proc

5652: ,p_argument_value => p_effective_date);
5653: --
5654: elsif p_business_group_id is null then
5655: --
5656: hr_api.mandatory_arg_error(p_api_name => l_proc
5657: ,p_argument => 'p_business_group_id'
5658: ,p_argument_value => p_business_group_id);
5659: --
5660: end if;