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 3713: l_cad_date_from := hr_api.g_sot ;

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

Line 3714: l_cad_date_to := hr_api.g_eot ;

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

Line 3727: l_cad_date_from := hr_api.g_sot ;

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

Line 3728: l_cad_date_to := hr_api.g_eot ;

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

Line 4327: l_cad_date_from := hr_api.g_sot ;

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

Line 4328: l_cad_date_to := hr_api.g_eot ;

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

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

4338: if l_dynamic_BEN_sql is not null then
4339:
4340: if l_cad_exclude = 'N' then
4341: l_dynamic_BEN_sql := l_dynamic_BEN_sql || ' and xcl.chg_actl_dt between to_date(''' ||
4342: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS')||
4343: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4344: 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'') ';
4345: else
4346: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||

Line 4344: 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'') ';

4340: if l_cad_exclude = 'N' then
4341: l_dynamic_BEN_sql := l_dynamic_BEN_sql || ' and xcl.chg_actl_dt between to_date(''' ||
4342: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS')||
4343: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4344: 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'') ';
4345: else
4346: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||
4347: ' and xcl.chg_actl_dt not between to_date(''' ||
4348: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||

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

4344: 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'') ';
4345: else
4346: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||
4347: ' and xcl.chg_actl_dt not between to_date(''' ||
4348: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4349: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4350: 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'') ';
4351: end if;
4352: end if ;

Line 4350: 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'') ';

4346: l_dynamic_BEN_sql := l_dynamic_BEN_sql ||
4347: ' and xcl.chg_actl_dt not between to_date(''' ||
4348: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4349: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4350: 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'') ';
4351: end if;
4352: end if ;
4353:
4354: if l_dynamic_PAY_sql is not null then

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

4354: if l_dynamic_PAY_sql is not null then
4355: if nvl(l_pay_evt_non_asg,'N') = 'N' then
4356: if l_cad_exclude = 'N' then
4357: l_dynamic_PAY_sql := l_dynamic_PAY_sql || ' and xcl.CREATION_DATE between to_date(''' ||
4358: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4359: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4360: 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'')';
4361: else
4362: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||

Line 4360: 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'')';

4356: if l_cad_exclude = 'N' then
4357: l_dynamic_PAY_sql := l_dynamic_PAY_sql || ' and xcl.CREATION_DATE between to_date(''' ||
4358: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4359: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4360: 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'')';
4361: else
4362: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4363: ' and xcl.CREATION_DATE not between to_date(''' ||
4364: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||

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

4360: 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'')';
4361: else
4362: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4363: ' and xcl.CREATION_DATE not between to_date(''' ||
4364: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4365: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4366: 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'') ';
4367: end if;
4368: end if ;

Line 4366: 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'') ';

4362: l_dynamic_PAY_sql := l_dynamic_PAY_sql ||
4363: ' and xcl.CREATION_DATE not between to_date(''' ||
4364: to_char(nvl(l_cad_date_from,hr_api.g_sot),'DD-MM-RRRR HH24:MI:SS') ||
4365: ''',''DD-MM-RRRR HH24:MI:SS'') and to_date(''' ||
4366: 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'') ';
4367: end if;
4368: end if ;
4369: end if ;
4370: end if; -- CAD

Line 4377: l_cad_date_from := hr_api.g_sot ;

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

Line 4378: l_cad_date_to := hr_api.g_eot ;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5638: hr_api.mandatory_arg_error(p_api_name => l_proc

5634: p_commit => l_commit);
5635: --
5636: if p_ext_dfn_id is null then
5637: --
5638: hr_api.mandatory_arg_error(p_api_name => l_proc
5639: ,p_argument => 'p_ext_dfn_id'
5640: ,p_argument_value => p_ext_dfn_id);
5641: --
5642: elsif p_effective_date is null then

Line 5644: hr_api.mandatory_arg_error(p_api_name => l_proc

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

Line 5650: hr_api.mandatory_arg_error(p_api_name => l_proc

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