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.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on FND_DATE

Line 241: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year

237: is
238: select assignment_extra_info_id,object_version_number
239: from per_assignment_extra_info
240: where assignment_id = p_assignment_id
241: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year
242: And information_type in ('KR_YEA_SP_TAX_EXEM_INFO'
243: ,'KR_YEA_SP_TAX_EXEM_INFO2'
244: ,'KR_YEA_SP_TAX_EXEM_INFO3' /* Bug 9393732 */
245: ,'KR_YEA_DONATION_TOTALS' /* Bug 9393732 */

Line 273: And to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year

269: Is
270: Select 'Y'
271: From per_assignment_extra_info
272: Where assignment_id = p_assignment_id
273: And to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year
274: And information_type in ('KR_YEA_SP_TAX_EXEM_INFO'
275: ,'KR_YEA_SP_TAX_EXEM_INFO2'
276: ,'KR_YEA_SP_TAX_EXEM_INFO3' /* Bug 9393732 */
277: ,'KR_YEA_DONATION_TOTALS' /* Bug 9393732 */

Line 531: And to_char(fnd_date.canonical_to_date(aei_information1), 'yyyy') = p_target_year

527: aei_information2,
528: object_version_number
529: From per_assignment_extra_info
530: Where assignment_id = p_assignment_id
531: And to_char(fnd_date.canonical_to_date(aei_information1), 'yyyy') = p_target_year
532: And information_type = 'KR_YEA_TAX_EXEM_INFO2';
533:
534: Cursor csr_kr_assignment_yea_info6
535: Is

Line 590: l_effective_date := fnd_date.canonical_to_date(p_effective_date);

586: --
587: if p_effective_date is null then
588: l_effective_date := to_date('31/12/'||to_char(p_target_year), 'DD/MM/YYYY');
589: else
590: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
591: end if;
592: --
593: -- Bug 4915940: Setting profiles PER_PERSON_ID and PER_ASSIGNMENT_ID
594:

Line 1224: select min(fnd_date.canonical_to_date(hoi.org_information2)),

1220: -- cursor fetches the entry periods of the organizations defined in the hierarchy
1221: -- in bottom to top order starting from the Employee's Organization.
1222: cursor csr_hierarchy_entry_period(p_version in number,
1223: p_emp_org_id in number) is
1224: select min(fnd_date.canonical_to_date(hoi.org_information2)),
1225: max(fnd_date.canonical_to_date(hoi.org_information3)),
1226: max(fnd_date.canonical_to_date(hoi.org_information4))
1227: from (select pose.organization_id_parent,
1228: level hierarchy_level,

Line 1225: max(fnd_date.canonical_to_date(hoi.org_information3)),

1221: -- in bottom to top order starting from the Employee's Organization.
1222: cursor csr_hierarchy_entry_period(p_version in number,
1223: p_emp_org_id in number) is
1224: select min(fnd_date.canonical_to_date(hoi.org_information2)),
1225: max(fnd_date.canonical_to_date(hoi.org_information3)),
1226: max(fnd_date.canonical_to_date(hoi.org_information4))
1227: from (select pose.organization_id_parent,
1228: level hierarchy_level,
1229: pose.organization_id_child

Line 1226: max(fnd_date.canonical_to_date(hoi.org_information4))

1222: cursor csr_hierarchy_entry_period(p_version in number,
1223: p_emp_org_id in number) is
1224: select min(fnd_date.canonical_to_date(hoi.org_information2)),
1225: max(fnd_date.canonical_to_date(hoi.org_information3)),
1226: max(fnd_date.canonical_to_date(hoi.org_information4))
1227: from (select pose.organization_id_parent,
1228: level hierarchy_level,
1229: pose.organization_id_child
1230: from per_org_structure_elements pose

Line 1244: select min(fnd_date.canonical_to_date(hoi.org_information2)),

1240: order by org.hierarchy_level asc;
1241:
1242: -- cursor fetches the Entry Period defined in BG level
1243: cursor csr_bg_entry_period is
1244: select min(fnd_date.canonical_to_date(hoi.org_information2)),
1245: max(fnd_date.canonical_to_date(hoi.org_information3)),
1246: max(fnd_date.canonical_to_date(hoi.org_information4))
1247: from hr_organization_information hoi
1248: where hoi.organization_id = p_business_group_id

Line 1245: max(fnd_date.canonical_to_date(hoi.org_information3)),

1241:
1242: -- cursor fetches the Entry Period defined in BG level
1243: cursor csr_bg_entry_period is
1244: select min(fnd_date.canonical_to_date(hoi.org_information2)),
1245: max(fnd_date.canonical_to_date(hoi.org_information3)),
1246: max(fnd_date.canonical_to_date(hoi.org_information4))
1247: from hr_organization_information hoi
1248: where hoi.organization_id = p_business_group_id
1249: and hoi.org_information1 = p_target_year

Line 1246: max(fnd_date.canonical_to_date(hoi.org_information4))

1242: -- cursor fetches the Entry Period defined in BG level
1243: cursor csr_bg_entry_period is
1244: select min(fnd_date.canonical_to_date(hoi.org_information2)),
1245: max(fnd_date.canonical_to_date(hoi.org_information3)),
1246: max(fnd_date.canonical_to_date(hoi.org_information4))
1247: from hr_organization_information hoi
1248: where hoi.organization_id = p_business_group_id
1249: and hoi.org_information1 = p_target_year
1250: and hoi.org_information_context ='KR_YEA_ENTRY_PERIOD_BG';

Line 1254: select min(fnd_date.canonical_to_date(hoi.org_information2)),

1250: and hoi.org_information_context ='KR_YEA_ENTRY_PERIOD_BG';
1251:
1252: -- cursor fetches the Entry Period defined in Employee's Org level
1253: cursor csr_emp_org_entry_period (p_emp_org number) is
1254: select min(fnd_date.canonical_to_date(hoi.org_information2)),
1255: max(fnd_date.canonical_to_date(hoi.org_information3)),
1256: max(fnd_date.canonical_to_date(hoi.org_information4))
1257: from hr_organization_information hoi
1258: where hoi.organization_id = p_emp_org

Line 1255: max(fnd_date.canonical_to_date(hoi.org_information3)),

1251:
1252: -- cursor fetches the Entry Period defined in Employee's Org level
1253: cursor csr_emp_org_entry_period (p_emp_org number) is
1254: select min(fnd_date.canonical_to_date(hoi.org_information2)),
1255: max(fnd_date.canonical_to_date(hoi.org_information3)),
1256: max(fnd_date.canonical_to_date(hoi.org_information4))
1257: from hr_organization_information hoi
1258: where hoi.organization_id = p_emp_org
1259: and hoi.org_information1 = p_target_year

Line 1256: max(fnd_date.canonical_to_date(hoi.org_information4))

1252: -- cursor fetches the Entry Period defined in Employee's Org level
1253: cursor csr_emp_org_entry_period (p_emp_org number) is
1254: select min(fnd_date.canonical_to_date(hoi.org_information2)),
1255: max(fnd_date.canonical_to_date(hoi.org_information3)),
1256: max(fnd_date.canonical_to_date(hoi.org_information4))
1257: from hr_organization_information hoi
1258: where hoi.organization_id = p_emp_org
1259: and hoi.org_information1 = p_target_year
1260: and hoi.org_information_context ='KR_YEA_ENTRY_PERIOD_ORG';

Line 1551: l_effective_date := fnd_date.canonical_to_date(p_effective_date);

1547: begin
1548: P_RETURN_STATUS := 'E';
1549: P_FF_RETURN_STATUS := 'INVALID';
1550:
1551: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1552: l_year := to_char(l_effective_date,'yyyy');
1553: l_assignment_id := p_assignment_id;
1554:
1555: OPEN csr_formula_exists('VALIDATE_YEA_DATA',l_effective_date); -- 4644132

Line 1879: eff_date := fnd_date.canonical_to_date(P_EFFECTIVE_DATE);

1875: eff_date date ;
1876: l_def_bal_id pay_defined_balances.defined_balance_id%type ;
1877: --
1878: begin
1879: eff_date := fnd_date.canonical_to_date(P_EFFECTIVE_DATE);
1880: --
1881: P_ITAX := get_total_itax(P_ASSIGNMENT_ID, eff_date);
1882: P_STAX := get_total_stax(P_ASSIGNMENT_ID, eff_date);
1883: P_RTAX := get_total_rtax(P_ASSIGNMENT_ID, eff_date);

Line 1891: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1887: open csr_get_def_bal_id_ytd('HI_PREM_EE') ;
1888: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1889: if csr_get_def_bal_id_ytd%found then
1890: p_hi_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1891: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1892: end if ;
1893: close csr_get_def_bal_id_ytd ;
1894: --
1895: -- Bug 7260606

Line 1900: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1896: open csr_get_def_bal_id_ytd('LTCI_PREM_EE') ;
1897: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1898: if csr_get_def_bal_id_ytd%found then
1899: p_ltci_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1900: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1901: end if ;
1902: close csr_get_def_bal_id_ytd ;
1903: -- End of Bug 7260606
1904: --

Line 1909: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1905: open csr_get_def_bal_id_ytd('EI_PREM') ;
1906: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1907: if csr_get_def_bal_id_ytd%found then
1908: p_ei_prem := pay_balance_pkg.get_value(l_def_bal_id,
1909: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1910: end if ;
1911: close csr_get_def_bal_id_ytd ;
1912: --
1913: open csr_get_def_bal_id_ytd('NP_PREM_EE') ;

Line 1917: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1913: open csr_get_def_bal_id_ytd('NP_PREM_EE') ;
1914: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1915: if csr_get_def_bal_id_ytd%found then
1916: p_np_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1917: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1918: end if ;
1919: close csr_get_def_bal_id_ytd ;
1920: --
1921: -- Bug 6024342

Line 1926: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1922: open csr_get_def_bal_id_ytd('Pension Premium') ;
1923: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1924: if csr_get_def_bal_id_ytd%found then
1925: p_pen_prem_bal := pay_balance_pkg.get_value(l_def_bal_id,
1926: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1927: end if ;
1928: close csr_get_def_bal_id_ytd ;
1929: --
1930: -- Bug 9737699

Line 1935: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1931: open csr_get_def_bal_id_ytd('Post Office Pension') ;
1932: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1933: if csr_get_def_bal_id_ytd%found then
1934: p_post_office_pen_prem := pay_balance_pkg.get_value(l_def_bal_id,
1935: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1936: end if ;
1937: close csr_get_def_bal_id_ytd ;
1938: --
1939: -- Bug 9737699

Line 1944: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1940: open csr_get_def_bal_id_ytd('Private School Pension') ;
1941: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1942: if csr_get_def_bal_id_ytd%found then
1943: p_pvt_school_pen_prem := pay_balance_pkg.get_value(l_def_bal_id,
1944: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1945: end if ;
1946: close csr_get_def_bal_id_ytd ;
1947: --
1948: -- Bug 9737699

Line 1953: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1949: open csr_get_def_bal_id_ytd('Military Pension Premium') ;
1950: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1951: if csr_get_def_bal_id_ytd%found then
1952: p_military_pen_prem := pay_balance_pkg.get_value(l_def_bal_id,
1953: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1954: end if ;
1955: close csr_get_def_bal_id_ytd ;
1956: --
1957: --

Line 1974: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year

1970: is
1971: select assignment_extra_info_id,object_version_number
1972: from per_assignment_extra_info
1973: where assignment_id = p_assignment_id
1974: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year
1975: And information_type in ('KR_YEA_SP_TAX_EXEM_INFO'
1976: ,'KR_YEA_SP_TAX_EXEM_INFO2'
1977: ,'KR_YEA_SP_TAX_EXEM_INFO3' /* Bug 9393732 */
1978: ,'KR_YEA_DONATION_TOTALS' /* Bug 9393732 */

Line 2097: open csr_get_eff_date(p_assignment_id, fnd_date.canonical_to_date(p_effective_date));

2093:
2094: l_final_eff_date := null;
2095: final_eff_date := null;
2096:
2097: open csr_get_eff_date(p_assignment_id, fnd_date.canonical_to_date(p_effective_date));
2098: fetch csr_get_eff_date into l_final_eff_date;
2099: close csr_get_eff_date;
2100:
2101: if to_char(l_final_eff_date,'YYYY') = to_char(fnd_date.canonical_to_date(p_effective_date),'YYYY') then

Line 2101: if to_char(l_final_eff_date,'YYYY') = to_char(fnd_date.canonical_to_date(p_effective_date),'YYYY') then

2097: open csr_get_eff_date(p_assignment_id, fnd_date.canonical_to_date(p_effective_date));
2098: fetch csr_get_eff_date into l_final_eff_date;
2099: close csr_get_eff_date;
2100:
2101: if to_char(l_final_eff_date,'YYYY') = to_char(fnd_date.canonical_to_date(p_effective_date),'YYYY') then
2102: final_eff_date := l_final_eff_date;
2103: else
2104: final_eff_date := fnd_date.canonical_to_date(p_effective_date);
2105: end if;

Line 2104: final_eff_date := fnd_date.canonical_to_date(p_effective_date);

2100:
2101: if to_char(l_final_eff_date,'YYYY') = to_char(fnd_date.canonical_to_date(p_effective_date),'YYYY') then
2102: final_eff_date := l_final_eff_date;
2103: else
2104: final_eff_date := fnd_date.canonical_to_date(p_effective_date);
2105: end if;
2106: -- End of bug 9246066
2107:
2108: OPEN csr_get_non_resident_flag(to_number(P_ASSIGNMENT_ID),final_eff_date); -- Bug 9246066

Line 2342: select pay_kr_ff_functions_pkg.aged_flag(p_national_identifier,fnd_date.canonical_to_date(p_effective_date))

2338: p_result out nocopy varchar2)
2339: is
2340:
2341: cursor csr is
2342: select pay_kr_ff_functions_pkg.aged_flag(p_national_identifier,fnd_date.canonical_to_date(p_effective_date))
2343: from dual;
2344:
2345: begin
2346:

Line 2369: values (userenv('sessionid'),fnd_date.canonical_to_date(p_effective_date));

2365: open csr_get_session_id;
2366: fetch csr_get_session_id into l_session_id;
2367: if csr_get_session_id%notfound then
2368: insert into fnd_sessions(session_id,effective_date)
2369: values (userenv('sessionid'),fnd_date.canonical_to_date(p_effective_date));
2370: end if;
2371: close csr_get_session_id;
2372:
2373: end insert_fnd_sessions;

Line 2410: p_result := pay_kr_ff_functions_pkg.get_globalvalue(p_glbvar,fnd_date.canonical_to_date(p_process_date));

2406: p_process_date in varchar2,
2407: p_result out nocopy varchar2)
2408: is
2409: begin
2410: p_result := pay_kr_ff_functions_pkg.get_globalvalue(p_glbvar,fnd_date.canonical_to_date(p_process_date));
2411:
2412: end;
2413: --------------------------------------------------------------------------------------
2414: --

Line 2441: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = to_number(p_target_year);

2437: aei_information11
2438: from per_assignment_extra_info
2439: where assignment_id = p_assignment_id
2440: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2441: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = to_number(p_target_year);
2442: --
2443: cursor csr_get_temp_tbl_data(l_donation_year in varchar2, l_donation_code in varchar2) is
2444: select assignment_yea_info_id,
2445: object_version_number

Line 2509: fnd_date.canonical_to_date(i.aei_information1)) = 'Y')) then

2505: end if;
2506: else
2507: if((i.aei_information2 = p_target_year)
2508: and (pay_kr_ff_functions_pkg.display_yea_info(p_assignment_id,
2509: fnd_date.canonical_to_date(i.aei_information1)) = 'Y')) then
2510: update per_kr_assignment_yea_info
2511: set ayi_information4 = i.aei_information4,
2512: ayi_information11 = i.aei_information11,
2513: ayi_information5 = i.aei_information5

Line 2611: fnd_date.date_to_canonical(to_date('31-12-'||p_target_year,'DD-MM-YYYY')),

2607: p_assignment_id,
2608: 'KR_YEA_DONATION_TYPE_DETAIL',
2609: p_target_year,
2610: 'KR_YEA_DONATION_TYPE_DETAIL',
2611: fnd_date.date_to_canonical(to_date('31-12-'||p_target_year,'DD-MM-YYYY')),
2612: p_target_year,
2613: '0',
2614: '0',
2615: '0',

Line 2865: fnd_date.date_to_canonical(to_date('31-12-'||p_target_year,'DD-MM-YYYY')),

2861: p_assignment_id,
2862: 'KR_YEA_DONATION_TOTALS1',
2863: p_target_year,
2864: 'KR_YEA_DONATION_TOTALS1',
2865: fnd_date.date_to_canonical(to_date('31-12-'||p_target_year,'DD-MM-YYYY')),
2866: p_stat_parent,
2867: p_tax_parent,
2868: p_pledt_parent,
2869: p_spec_parent,

Line 2972: fnd_date.date_to_canonical(to_date('31-12-'||p_target_year,'DD-MM-YYYY')),

2968: p_assignment_id,
2969: 'KR_YEA_DONATION_TOTALS',
2970: p_target_year,
2971: 'KR_YEA_DONATION_TOTALS',
2972: fnd_date.date_to_canonical(to_date('31-12-'||p_target_year,'DD-MM-YYYY')),
2973: p_stat_self,
2974: p_stat_spouse,
2975: p_stat_child,
2976: p_pol_self ,

Line 3021: fnd_date.date_to_canonical(to_date('31-12-'||p_target_year,'DD-MM-YYYY')),

3017: p_assignment_id,
3018: 'KR_YEA_DONATION_TOTALS1',
3019: p_target_year,
3020: 'KR_YEA_DONATION_TOTALS1',
3021: fnd_date.date_to_canonical(to_date('31-12-'||p_target_year,'DD-MM-YYYY')),
3022: p_stat_parent,
3023: p_tax_parent,
3024: p_pledt_parent,
3025: p_spec_parent,

Line 3064: l_contract_st_date := fnd_date.canonical_to_date(p_contract_st_date);

3060: l_total_days number;
3061: --
3062: begin
3063: --
3064: l_contract_st_date := fnd_date.canonical_to_date(p_contract_st_date);
3065: l_contract_end_date := fnd_date.canonical_to_date(p_contract_end_date);
3066: l_start_date := to_date('01-01-'||p_target_year,'DD-MM-YYYY');
3067: l_end_date := to_date('31-12-'||p_target_year,'DD-MM-YYYY');
3068: l_total_days := (l_contract_end_date - l_contract_st_date) + 1;

Line 3065: l_contract_end_date := fnd_date.canonical_to_date(p_contract_end_date);

3061: --
3062: begin
3063: --
3064: l_contract_st_date := fnd_date.canonical_to_date(p_contract_st_date);
3065: l_contract_end_date := fnd_date.canonical_to_date(p_contract_end_date);
3066: l_start_date := to_date('01-01-'||p_target_year,'DD-MM-YYYY');
3067: l_end_date := to_date('31-12-'||p_target_year,'DD-MM-YYYY');
3068: l_total_days := (l_contract_end_date - l_contract_st_date) + 1;
3069: --