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 HR_GENERAL

Line 2033: p_action_information4 => l_csr_emp.sex, /* hr_general.decode_lookup('SEX',l_csr_emp.sex), */

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,
2037: p_action_information8 => l_csr_emp.address_kana1,

Line 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.. */

2129: p_effective_date => g_effective_date,
2130: p_assignment_id => p_assignment_id,
2131: p_action_information1 => l_csr_emp_qua.qualification_type,
2132: p_action_information2 => l_csr_emp_qua.title,
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),

Line 2303: p_action_information3 => l_csr_con.contact_type, /* hr_general.decode_lookup('CONTACT',l_csr_con.contact_type), */

2299: p_effective_date => g_effective_date,
2300: p_assignment_id => p_assignment_id,
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), */

Line 2304: p_action_information4 => l_csr_con.sex, /* hr_general.decode_lookup('SEX',l_csr_con.sex), */

2300: p_assignment_id => p_assignment_id,
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), */

Line 2307: p_action_information7 => l_csr_con.primary_contact_flag, /* hr_general.decode_lookup('YES_NO',l_csr_con.primary_contact_flag), */

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), */
2310: p_action_information10 => fnd_number.number_to_canonical(l_csr_con.sequence),
2311: p_action_information11 => l_csr_con.household_head, /* hr_general.decode_lookup('YES_NO',l_csr_con.household_head), */

Line 2308: p_action_information8 => l_csr_con.dependent_flag, /* hr_general.decode_lookup('YES_NO',l_csr_con.dependent_flag), */

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), */
2310: p_action_information10 => fnd_number.number_to_canonical(l_csr_con.sequence),
2311: p_action_information11 => l_csr_con.household_head, /* hr_general.decode_lookup('YES_NO',l_csr_con.household_head), */
2312: p_action_information12 => l_csr_con.si_itax, /* hr_general.decode_lookup('YES_NO',l_csr_con.si_itax), */

Line 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), */

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), */
2310: p_action_information10 => fnd_number.number_to_canonical(l_csr_con.sequence),
2311: p_action_information11 => l_csr_con.household_head, /* hr_general.decode_lookup('YES_NO',l_csr_con.household_head), */
2312: p_action_information12 => l_csr_con.si_itax, /* hr_general.decode_lookup('YES_NO',l_csr_con.si_itax), */
2313: p_action_information_id => o_action_information_id,

Line 2311: p_action_information11 => l_csr_con.household_head, /* hr_general.decode_lookup('YES_NO',l_csr_con.household_head), */

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), */
2310: p_action_information10 => fnd_number.number_to_canonical(l_csr_con.sequence),
2311: p_action_information11 => l_csr_con.household_head, /* hr_general.decode_lookup('YES_NO',l_csr_con.household_head), */
2312: p_action_information12 => l_csr_con.si_itax, /* hr_general.decode_lookup('YES_NO',l_csr_con.si_itax), */
2313: p_action_information_id => o_action_information_id,
2314: p_object_version_number => o_object_version_number);
2315: --

Line 2312: p_action_information12 => l_csr_con.si_itax, /* hr_general.decode_lookup('YES_NO',l_csr_con.si_itax), */

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), */
2310: p_action_information10 => fnd_number.number_to_canonical(l_csr_con.sequence),
2311: p_action_information11 => l_csr_con.household_head, /* hr_general.decode_lookup('YES_NO',l_csr_con.household_head), */
2312: p_action_information12 => l_csr_con.si_itax, /* hr_general.decode_lookup('YES_NO',l_csr_con.si_itax), */
2313: p_action_information_id => o_action_information_id,
2314: p_object_version_number => o_object_version_number);
2315: --
2316: end loop;