[Home] [Help]
274: g_effective_date := l_csr_action.effective_date;
275: g_business_group_id := l_csr_action.business_group_id;
276: g_legislation_code := l_csr_action.legislation_code;
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));
275: g_business_group_id := l_csr_action.business_group_id;
276: g_legislation_code := l_csr_action.legislation_code;
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));
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;
287: if g_assignment_set_id is not null then
1885: pp.sex,
1886: pcr.primary_contact_flag,
1887: pcr.dependent_flag,
1888: pcr.rltd_per_rsds_w_dsgntr_flag,
1889: fnd_number.canonical_to_number(pcr.cont_information2) sequence,
1890: pcr.cont_information3 household_head,
1891: pcr.cont_information1 si_itax
1892: from per_contact_relationships pcr,
1893: per_all_people_f pp
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,
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),
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), */
2310: p_action_information10 => fnd_number.number_to_canonical(l_csr_con.sequence),
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,
2314: p_object_version_number => o_object_version_number);