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

Line 242: between nvl(fnd_date.canonical_to_date(hoi.org_information5),hr_api.g_sot) and nvl(fnd_date.canonical_to_date(hoi.org_information6),g_effective_date);

238: and hoi.org_information1 = 'JPEMPLDETAILSREPORT'
239: and hoi.org_information3 = 'ADDINFO'
240: and hoi.org_information4 is not null
241: and g_effective_date
242: between nvl(fnd_date.canonical_to_date(hoi.org_information5),hr_api.g_sot) and nvl(fnd_date.canonical_to_date(hoi.org_information6),g_effective_date);
243: --
244: l_csr_action csr_action%rowtype;
245: --
246: begin

Line 281: g_term_date_from := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TEDF',l_csr_action.legislative_parameters));

277: g_inc_org_hier_flag := pay_core_utils.get_parameter('IOH',l_csr_action.legislative_parameters);
278: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORG',l_csr_action.legislative_parameters));
279: g_location_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('LOC',l_csr_action.legislative_parameters));
280: g_inc_term_flag := pay_core_utils.get_parameter('ITE',l_csr_action.legislative_parameters);
281: g_term_date_from := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TEDF',l_csr_action.legislative_parameters));
282: g_term_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TEDT',l_csr_action.legislative_parameters));
283: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSSET',l_csr_action.legislative_parameters));
284: --
285: g_ass_set_formula_id := null;

Line 282: g_term_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TEDT',l_csr_action.legislative_parameters));

278: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORG',l_csr_action.legislative_parameters));
279: g_location_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('LOC',l_csr_action.legislative_parameters));
280: g_inc_term_flag := pay_core_utils.get_parameter('ITE',l_csr_action.legislative_parameters);
281: g_term_date_from := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TEDF',l_csr_action.legislative_parameters));
282: g_term_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TEDT',l_csr_action.legislative_parameters));
283: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSSET',l_csr_action.legislative_parameters));
284: --
285: g_ass_set_formula_id := null;
286: g_ass_set_amendment_type := null;

Line 440: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_date'')

436: where ppa.payroll_action_id = :payroll_action_id
437: and pp.business_group_id = ppa.business_group_id + 0
438: and ppos.person_id = pp.person_id
439: and ppos.business_group_id + 0 = pp.business_group_id
440: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_date'')
441: order by
442: ppos.person_id';
443: --
444: p_sqlstr := replace(p_sqlstr,'i_effective_date',fnd_date.date_to_canonical(g_effective_date));

Line 444: p_sqlstr := replace(p_sqlstr,'i_effective_date',fnd_date.date_to_canonical(g_effective_date));

440: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_date'')
441: order by
442: ppos.person_id';
443: --
444: p_sqlstr := replace(p_sqlstr,'i_effective_date',fnd_date.date_to_canonical(g_effective_date));
445: --
446: if g_debug then
447: hr_utility.set_location(l_proc,1000);
448: end if;

Line 2032: p_action_information3 => fnd_date.date_to_canonical(l_csr_emp.date_of_birth),

2028: p_effective_date => g_effective_date,
2029: p_assignment_id => p_assignment_id,
2030: p_action_information1 => substr(l_csr_emp.last_name_kana||' '||l_csr_emp.first_name_kana,1,c_pai_max),
2031: p_action_information2 => substr(l_csr_emp.last_name_kanji||' '||l_csr_emp.first_name_kanji,1,c_pai_max),
2032: p_action_information3 => fnd_date.date_to_canonical(l_csr_emp.date_of_birth),
2033: p_action_information4 => l_csr_emp.sex, /* hr_general.decode_lookup('SEX',l_csr_emp.sex), */
2034: p_action_information5 => l_csr_emp.address1,
2035: p_action_information6 => l_csr_emp.address2,
2036: p_action_information7 => l_csr_emp.address3,

Line 2043: p_action_information14 => fnd_date.date_to_canonical(l_csr_emp.hire_date),

2039: p_action_information10 => l_csr_emp.address_kana3,
2040: p_action_information11 => l_csr_emp.district_code,
2041: p_action_information12 => l_csr_emp.country, /* maybe not required.. */
2042: p_action_information13 => l_csr_emp.postal_code,
2043: p_action_information14 => fnd_date.date_to_canonical(l_csr_emp.hire_date),
2044: p_action_information15 => l_csr_emp.job_name,
2045: p_action_information16 => fnd_date.date_to_canonical(l_term_date),
2046: p_action_information17 => l_term_reason, /* not sure why this only is code, should convert to decode LEAV_REAS here */
2047: p_action_information18 => fnd_date.date_to_canonical(l_csr_emp.death_date),

Line 2045: p_action_information16 => fnd_date.date_to_canonical(l_term_date),

2041: p_action_information12 => l_csr_emp.country, /* maybe not required.. */
2042: p_action_information13 => l_csr_emp.postal_code,
2043: p_action_information14 => fnd_date.date_to_canonical(l_csr_emp.hire_date),
2044: p_action_information15 => l_csr_emp.job_name,
2045: p_action_information16 => fnd_date.date_to_canonical(l_term_date),
2046: p_action_information17 => l_term_reason, /* not sure why this only is code, should convert to decode LEAV_REAS here */
2047: p_action_information18 => fnd_date.date_to_canonical(l_csr_emp.death_date),
2048: p_action_information19 => l_emp_hi_num,
2049: p_action_information20 => l_emp_wp_num,

Line 2047: p_action_information18 => fnd_date.date_to_canonical(l_csr_emp.death_date),

2043: p_action_information14 => fnd_date.date_to_canonical(l_csr_emp.hire_date),
2044: p_action_information15 => l_csr_emp.job_name,
2045: p_action_information16 => fnd_date.date_to_canonical(l_term_date),
2046: p_action_information17 => l_term_reason, /* not sure why this only is code, should convert to decode LEAV_REAS here */
2047: p_action_information18 => fnd_date.date_to_canonical(l_csr_emp.death_date),
2048: p_action_information19 => l_emp_hi_num,
2049: p_action_information20 => l_emp_wp_num,
2050: p_action_information21 => l_emp_wpf_num,
2051: p_action_information22 => l_emp_ei_num,

Line 2053: p_action_information24 => fnd_date.date_to_canonical(l_trm_effective_date),

2049: p_action_information20 => l_emp_wp_num,
2050: p_action_information21 => l_emp_wpf_num,
2051: p_action_information22 => l_emp_ei_num,
2052: p_action_information23 => fnd_number.number_to_canonical(l_trm_amt),
2053: p_action_information24 => fnd_date.date_to_canonical(l_trm_effective_date),
2054: p_action_information25 => fnd_date.date_to_canonical(l_emp_hi_qd),
2055: p_action_information26 => fnd_date.date_to_canonical(l_emp_wp_qd),
2056: p_action_information27 => fnd_date.date_to_canonical(l_emp_wpf_qd),
2057: p_action_information28 => fnd_date.date_to_canonical(l_emp_ei_qd),

Line 2054: p_action_information25 => fnd_date.date_to_canonical(l_emp_hi_qd),

2050: p_action_information21 => l_emp_wpf_num,
2051: p_action_information22 => l_emp_ei_num,
2052: p_action_information23 => fnd_number.number_to_canonical(l_trm_amt),
2053: p_action_information24 => fnd_date.date_to_canonical(l_trm_effective_date),
2054: p_action_information25 => fnd_date.date_to_canonical(l_emp_hi_qd),
2055: p_action_information26 => fnd_date.date_to_canonical(l_emp_wp_qd),
2056: p_action_information27 => fnd_date.date_to_canonical(l_emp_wpf_qd),
2057: p_action_information28 => fnd_date.date_to_canonical(l_emp_ei_qd),
2058: p_action_information29 => l_term_type,

Line 2055: p_action_information26 => fnd_date.date_to_canonical(l_emp_wp_qd),

2051: p_action_information22 => l_emp_ei_num,
2052: p_action_information23 => fnd_number.number_to_canonical(l_trm_amt),
2053: p_action_information24 => fnd_date.date_to_canonical(l_trm_effective_date),
2054: p_action_information25 => fnd_date.date_to_canonical(l_emp_hi_qd),
2055: p_action_information26 => fnd_date.date_to_canonical(l_emp_wp_qd),
2056: p_action_information27 => fnd_date.date_to_canonical(l_emp_wpf_qd),
2057: p_action_information28 => fnd_date.date_to_canonical(l_emp_ei_qd),
2058: p_action_information29 => l_term_type,
2059: p_action_information30 => l_csr_emp.employee_number,

Line 2056: p_action_information27 => fnd_date.date_to_canonical(l_emp_wpf_qd),

2052: p_action_information23 => fnd_number.number_to_canonical(l_trm_amt),
2053: p_action_information24 => fnd_date.date_to_canonical(l_trm_effective_date),
2054: p_action_information25 => fnd_date.date_to_canonical(l_emp_hi_qd),
2055: p_action_information26 => fnd_date.date_to_canonical(l_emp_wp_qd),
2056: p_action_information27 => fnd_date.date_to_canonical(l_emp_wpf_qd),
2057: p_action_information28 => fnd_date.date_to_canonical(l_emp_ei_qd),
2058: p_action_information29 => l_term_type,
2059: p_action_information30 => l_csr_emp.employee_number,
2060: p_action_information_id => o_action_information_id,

Line 2057: p_action_information28 => fnd_date.date_to_canonical(l_emp_ei_qd),

2053: p_action_information24 => fnd_date.date_to_canonical(l_trm_effective_date),
2054: p_action_information25 => fnd_date.date_to_canonical(l_emp_hi_qd),
2055: p_action_information26 => fnd_date.date_to_canonical(l_emp_wp_qd),
2056: p_action_information27 => fnd_date.date_to_canonical(l_emp_wpf_qd),
2057: p_action_information28 => fnd_date.date_to_canonical(l_emp_ei_qd),
2058: p_action_information29 => l_term_type,
2059: p_action_information30 => l_csr_emp.employee_number,
2060: p_action_information_id => o_action_information_id,
2061: p_object_version_number => o_object_version_number);

Line 2137: p_action_information7 => fnd_date.date_to_canonical(l_csr_emp_qua.start_date),

2133: p_action_information3 => hr_general.decode_lookup('PER_SUBJECT_STATUSES',l_csr_emp_qua.status), /* l_csr_emp_qua.status, not sure why this only is meaning.. */
2134: p_action_information4 => l_csr_emp_qua.grade_attained,
2135: p_action_information5 => l_csr_emp_qua.establishment,
2136: p_action_information6 => l_csr_emp_qua.license_number, /* no number formant */
2137: p_action_information7 => fnd_date.date_to_canonical(l_csr_emp_qua.start_date),
2138: p_action_information8 => fnd_date.date_to_canonical(l_csr_emp_qua.end_date),
2139: p_action_information_id => o_action_information_id,
2140: p_object_version_number => o_object_version_number);
2141: --

Line 2138: p_action_information8 => fnd_date.date_to_canonical(l_csr_emp_qua.end_date),

2134: p_action_information4 => l_csr_emp_qua.grade_attained,
2135: p_action_information5 => l_csr_emp_qua.establishment,
2136: p_action_information6 => l_csr_emp_qua.license_number, /* no number formant */
2137: p_action_information7 => fnd_date.date_to_canonical(l_csr_emp_qua.start_date),
2138: p_action_information8 => fnd_date.date_to_canonical(l_csr_emp_qua.end_date),
2139: p_action_information_id => o_action_information_id,
2140: p_object_version_number => o_object_version_number);
2141: --
2142: end loop;

Line 2172: p_action_information5 => fnd_date.date_to_canonical(l_csr_emp_ass_ed.effective_start_date),

2168: p_action_information1 => l_csr_emp_ass_ed.organization_name,
2169: p_action_information2 => l_csr_emp_ass_ed.job_name,
2170: p_action_information3 => l_csr_emp_ass_ed.position_name,
2171: p_action_information4 => l_csr_emp_ass_ed.grade_name,
2172: p_action_information5 => fnd_date.date_to_canonical(l_csr_emp_ass_ed.effective_start_date),
2173: p_action_information6 => fnd_date.date_to_canonical(l_csr_emp_ass_ed.effective_end_date_d), /* sync with old pkg, looks report also convert to display date.. */
2174: p_action_information7 => l_csr_emp_ass_ed.assignment_number,
2175: p_action_information_id => o_action_information_id,
2176: p_object_version_number => o_object_version_number);

Line 2173: p_action_information6 => fnd_date.date_to_canonical(l_csr_emp_ass_ed.effective_end_date_d), /* sync with old pkg, looks report also convert to display date.. */

2169: p_action_information2 => l_csr_emp_ass_ed.job_name,
2170: p_action_information3 => l_csr_emp_ass_ed.position_name,
2171: p_action_information4 => l_csr_emp_ass_ed.grade_name,
2172: p_action_information5 => fnd_date.date_to_canonical(l_csr_emp_ass_ed.effective_start_date),
2173: p_action_information6 => fnd_date.date_to_canonical(l_csr_emp_ass_ed.effective_end_date_d), /* sync with old pkg, looks report also convert to display date.. */
2174: p_action_information7 => l_csr_emp_ass_ed.assignment_number,
2175: p_action_information_id => o_action_information_id,
2176: p_object_version_number => o_object_version_number);
2177: --

Line 2203: p_action_information3 => fnd_date.date_to_canonical(l_csr_emp_ass_wr.effective_start_date),

2199: p_effective_date => g_effective_date,
2200: p_assignment_id => p_assignment_id,
2201: p_action_information1 => l_csr_emp_ass_wr.position_name,
2202: p_action_information2 => l_csr_emp_ass_wr.job_name,
2203: p_action_information3 => fnd_date.date_to_canonical(l_csr_emp_ass_wr.effective_start_date),
2204: p_action_information4 => fnd_date.date_to_canonical(l_csr_emp_ass_wr.effective_end_date_d),
2205: p_action_information5 => l_csr_emp_ass_wr.organization_name,
2206: p_action_information_id => o_action_information_id,
2207: p_object_version_number => o_object_version_number);

Line 2204: p_action_information4 => fnd_date.date_to_canonical(l_csr_emp_ass_wr.effective_end_date_d),

2200: p_assignment_id => p_assignment_id,
2201: p_action_information1 => l_csr_emp_ass_wr.position_name,
2202: p_action_information2 => l_csr_emp_ass_wr.job_name,
2203: p_action_information3 => fnd_date.date_to_canonical(l_csr_emp_ass_wr.effective_start_date),
2204: p_action_information4 => fnd_date.date_to_canonical(l_csr_emp_ass_wr.effective_end_date_d),
2205: p_action_information5 => l_csr_emp_ass_wr.organization_name,
2206: p_action_information_id => o_action_information_id,
2207: p_object_version_number => o_object_version_number);
2208: --

Line 2235: p_action_information2 => fnd_date.date_to_canonical(l_csr_emp_pj_rh.effective_start_date),

2231: p_action_information_category => 'JP_EMPDET_PREV_JOB',
2232: p_effective_date => g_effective_date,
2233: p_assignment_id => p_assignment_id,
2234: p_action_information1 => l_csr_emp_pj_rh.organization_name,
2235: p_action_information2 => fnd_date.date_to_canonical(l_csr_emp_pj_rh.effective_start_date),
2236: p_action_information3 => fnd_date.date_to_canonical(l_csr_emp_pj_rh.effective_end_date_d),
2237: p_action_information4 => l_csr_emp_pj_rh.job_name,
2238: p_action_information5 => 'REHIRE',
2239: p_action_information_id => o_action_information_id,

Line 2236: p_action_information3 => fnd_date.date_to_canonical(l_csr_emp_pj_rh.effective_end_date_d),

2232: p_effective_date => g_effective_date,
2233: p_assignment_id => p_assignment_id,
2234: p_action_information1 => l_csr_emp_pj_rh.organization_name,
2235: p_action_information2 => fnd_date.date_to_canonical(l_csr_emp_pj_rh.effective_start_date),
2236: p_action_information3 => fnd_date.date_to_canonical(l_csr_emp_pj_rh.effective_end_date_d),
2237: p_action_information4 => l_csr_emp_pj_rh.job_name,
2238: p_action_information5 => 'REHIRE',
2239: p_action_information_id => o_action_information_id,
2240: p_object_version_number => o_object_version_number);

Line 2269: p_action_information2 => fnd_date.date_to_canonical(l_csr_emp_pj.start_date),

2265: p_action_information_category => 'JP_EMPDET_PREV_JOB',
2266: p_effective_date => g_effective_date,
2267: p_assignment_id => p_assignment_id,
2268: p_action_information1 => l_csr_emp_pj.employer_name,
2269: p_action_information2 => fnd_date.date_to_canonical(l_csr_emp_pj.start_date),
2270: p_action_information3 => fnd_date.date_to_canonical(l_csr_emp_pj.end_date),
2271: p_action_information4 => l_csr_emp_pj.job_name,
2272: p_action_information5 => l_csr_emp_pj.employment_category,
2273: p_action_information_id => o_action_information_id,

Line 2270: p_action_information3 => fnd_date.date_to_canonical(l_csr_emp_pj.end_date),

2266: p_effective_date => g_effective_date,
2267: p_assignment_id => p_assignment_id,
2268: p_action_information1 => l_csr_emp_pj.employer_name,
2269: p_action_information2 => fnd_date.date_to_canonical(l_csr_emp_pj.start_date),
2270: p_action_information3 => fnd_date.date_to_canonical(l_csr_emp_pj.end_date),
2271: p_action_information4 => l_csr_emp_pj.job_name,
2272: p_action_information5 => l_csr_emp_pj.employment_category,
2273: p_action_information_id => o_action_information_id,
2274: p_object_version_number => o_object_version_number);

Line 2305: p_action_information5 => fnd_date.date_to_canonical(l_csr_con.date_of_birth),

2301: p_action_information1 => substr(l_csr_con.last_name_kana||' '||l_csr_con.first_name_kana,1,c_pai_max),
2302: p_action_information2 => substr(l_csr_con.last_name_kanji||' '||l_csr_con.first_name_kanji,1,c_pai_max),
2303: p_action_information3 => l_csr_con.contact_type, /* hr_general.decode_lookup('CONTACT',l_csr_con.contact_type), */
2304: p_action_information4 => l_csr_con.sex, /* hr_general.decode_lookup('SEX',l_csr_con.sex), */
2305: p_action_information5 => fnd_date.date_to_canonical(l_csr_con.date_of_birth),
2306: p_action_information6 => fnd_number.number_to_canonical(l_csr_con.age), /* unknown requirement, why age for archive date is stored.. */
2307: p_action_information7 => l_csr_con.primary_contact_flag, /* hr_general.decode_lookup('YES_NO',l_csr_con.primary_contact_flag), */
2308: p_action_information8 => l_csr_con.dependent_flag, /* hr_general.decode_lookup('YES_NO',l_csr_con.dependent_flag), */
2309: p_action_information9 => l_csr_con.rltd_per_rsds_w_dsgntr_flag, /* hr_general.decode_lookup('YES_NO',l_csr_con.rltd_per_rsds_w_dsgntr_flag), */