DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on FND_DATE

Line 122: g_termination_date_from := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', l_legislative_parameters));

118: g_eoy := add_months(g_soy, 12) - 1;
119: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID', l_legislative_parameters));
120: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID', l_legislative_parameters));
121: g_include_terminated_flag := nvl(pay_core_utils.get_parameter('INCLUDE_TERMINATED_FLAG', l_legislative_parameters), 'Y');
122: g_termination_date_from := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', l_legislative_parameters));
123: g_termination_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO', l_legislative_parameters));
124: g_inherit_archive_flag := nvl(pay_core_utils.get_parameter('INHERIT_ARCHIVE_FLAG', l_legislative_parameters), 'Y');
125: g_rearchive_flag := nvl(pay_core_utils.get_parameter('REARCHIVE_FLAG', l_legislative_parameters), 'N');
126: g_publication_period_status := nvl(pay_core_utils.get_parameter('PUBLICATION_PERIOD_STATUS', l_legislative_parameters), 'C');

Line 123: g_termination_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO', l_legislative_parameters));

119: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID', l_legislative_parameters));
120: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID', l_legislative_parameters));
121: g_include_terminated_flag := nvl(pay_core_utils.get_parameter('INCLUDE_TERMINATED_FLAG', l_legislative_parameters), 'Y');
122: g_termination_date_from := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', l_legislative_parameters));
123: g_termination_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO', l_legislative_parameters));
124: g_inherit_archive_flag := nvl(pay_core_utils.get_parameter('INHERIT_ARCHIVE_FLAG', l_legislative_parameters), 'Y');
125: g_rearchive_flag := nvl(pay_core_utils.get_parameter('REARCHIVE_FLAG', l_legislative_parameters), 'N');
126: g_publication_period_status := nvl(pay_core_utils.get_parameter('PUBLICATION_PERIOD_STATUS', l_legislative_parameters), 'C');
127: g_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('PUBLICATION_START_DATE', l_legislative_parameters));

Line 127: g_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('PUBLICATION_START_DATE', l_legislative_parameters));

123: g_termination_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO', l_legislative_parameters));
124: g_inherit_archive_flag := nvl(pay_core_utils.get_parameter('INHERIT_ARCHIVE_FLAG', l_legislative_parameters), 'Y');
125: g_rearchive_flag := nvl(pay_core_utils.get_parameter('REARCHIVE_FLAG', l_legislative_parameters), 'N');
126: g_publication_period_status := nvl(pay_core_utils.get_parameter('PUBLICATION_PERIOD_STATUS', l_legislative_parameters), 'C');
127: g_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('PUBLICATION_START_DATE', l_legislative_parameters));
128: g_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('PUBLICATION_END_DATE', l_legislative_parameters));
129: g_bg_dpnt_ref_type := per_jp_ctr_utility_pkg.bg_itax_dpnt_ref_type(g_business_group_id);
130: --
131: g_payroll_action_id := p_payroll_action_id;

Line 128: g_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('PUBLICATION_END_DATE', l_legislative_parameters));

124: g_inherit_archive_flag := nvl(pay_core_utils.get_parameter('INHERIT_ARCHIVE_FLAG', l_legislative_parameters), 'Y');
125: g_rearchive_flag := nvl(pay_core_utils.get_parameter('REARCHIVE_FLAG', l_legislative_parameters), 'N');
126: g_publication_period_status := nvl(pay_core_utils.get_parameter('PUBLICATION_PERIOD_STATUS', l_legislative_parameters), 'C');
127: g_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('PUBLICATION_START_DATE', l_legislative_parameters));
128: g_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('PUBLICATION_END_DATE', l_legislative_parameters));
129: g_bg_dpnt_ref_type := per_jp_ctr_utility_pkg.bg_itax_dpnt_ref_type(g_business_group_id);
130: --
131: g_payroll_action_id := p_payroll_action_id;
132: end if;

Line 382: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE', wic.legislative_parameters)),

378: select wic.assignment_action_id,
379: wic.action_sequence,
380: wic.payroll_id,
381: nvl(pay.prl_information1, g_bg_dpnt_ref_type) dpnt_ref_type,
382: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE', wic.legislative_parameters)),
383: wic.effective_date) dpnt_effective_date,
384: wic.effective_date,
385: wic.date_earned,
386: wic.itax_organization_id,

Line 816: l_person_rec.action_information11 := fnd_date.date_to_canonical(l_wic_rec.date_start);

812: l_person_rec.action_information7 := fnd_number.number_to_canonical(l_per_rec.address_id);
813: l_person_rec.action_information8 := l_per_rec.address_kana;
814: l_person_rec.action_information9 := l_per_rec.address_kanji;
815: l_person_rec.action_information10 := l_per_rec.country;
816: l_person_rec.action_information11 := fnd_date.date_to_canonical(l_wic_rec.date_start);
817: l_person_rec.action_information12 := l_wic_rec.leaving_reason;
818: l_person_rec.action_information13 := fnd_date.date_to_canonical(l_per_rec.date_of_birth);
819: jp_date(
820: p_date => l_per_rec.date_of_birth,

Line 818: l_person_rec.action_information13 := fnd_date.date_to_canonical(l_per_rec.date_of_birth);

814: l_person_rec.action_information9 := l_per_rec.address_kanji;
815: l_person_rec.action_information10 := l_per_rec.country;
816: l_person_rec.action_information11 := fnd_date.date_to_canonical(l_wic_rec.date_start);
817: l_person_rec.action_information12 := l_wic_rec.leaving_reason;
818: l_person_rec.action_information13 := fnd_date.date_to_canonical(l_per_rec.date_of_birth);
819: jp_date(
820: p_date => l_per_rec.date_of_birth,
821: p_meiji => l_person_rec.action_information14,
822: p_taishou => l_person_rec.action_information15,

Line 840: l_person_rec.action_information25 := fnd_date.date_to_canonical(l_wic_rec.actual_termination_date);

836: p_month => l_person_rec.action_information22,
837: p_day => l_person_rec.action_information23);
838: */
839: l_person_rec.action_information24 := fnd_number.number_to_canonical(l_wic_rec.itax_organization_id);
840: l_person_rec.action_information25 := fnd_date.date_to_canonical(l_wic_rec.actual_termination_date);
841: l_person_rec.action_information26 := fnd_number.number_to_canonical(l_per_rec.organization_id);
842: l_person_rec.action_information28 := l_per_rec.district_code;
843: --
844: -- JP_ITAX_ARCH

Line 862: l_arch_rec.action_information12 := fnd_date.date_to_canonical(l_wic_rec.date_earned);

858: l_arch_rec.action_information8 := l_swot_rec.salary_payer_address_kanji;
859: l_arch_rec.action_information9 := l_swot_rec.salary_payer_name_kanji;
860: l_arch_rec.action_information10 := l_swot_rec.salary_payer_telephone_number;
861: l_arch_rec.action_information11 := l_swot_rec.tax_office_number;
862: l_arch_rec.action_information12 := fnd_date.date_to_canonical(l_wic_rec.date_earned);
863: l_arch_rec.action_information13 := l_wic_rec.employment_category;
864: l_arch_rec.action_information14 := l_wic_rec.itax_category;
865: l_arch_rec.action_information15 := l_wic_rec.itax_yea_category;
866: l_arch_rec.action_information30 := l_submission_required_flag;

Line 1162: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);

1158: l_pact_rec.effective_date := g_effective_date;
1159: l_pact_rec.action_information1 := fnd_number.number_to_canonical(g_payroll_id);
1160: l_pact_rec.action_information2 := fnd_number.number_to_canonical(g_itax_organization_id);
1161: l_pact_rec.action_information3 := g_include_terminated_flag;
1162: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1163: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);
1164: l_pact_rec.action_information6 := g_publication_period_status;
1165: l_pact_rec.action_information7 := fnd_date.date_to_canonical(g_publication_start_date);
1166: l_pact_rec.action_information8 := fnd_date.date_to_canonical(g_publication_end_date);

Line 1163: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);

1159: l_pact_rec.action_information1 := fnd_number.number_to_canonical(g_payroll_id);
1160: l_pact_rec.action_information2 := fnd_number.number_to_canonical(g_itax_organization_id);
1161: l_pact_rec.action_information3 := g_include_terminated_flag;
1162: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1163: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);
1164: l_pact_rec.action_information6 := g_publication_period_status;
1165: l_pact_rec.action_information7 := fnd_date.date_to_canonical(g_publication_start_date);
1166: l_pact_rec.action_information8 := fnd_date.date_to_canonical(g_publication_end_date);
1167: --

Line 1165: l_pact_rec.action_information7 := fnd_date.date_to_canonical(g_publication_start_date);

1161: l_pact_rec.action_information3 := g_include_terminated_flag;
1162: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1163: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);
1164: l_pact_rec.action_information6 := g_publication_period_status;
1165: l_pact_rec.action_information7 := fnd_date.date_to_canonical(g_publication_start_date);
1166: l_pact_rec.action_information8 := fnd_date.date_to_canonical(g_publication_end_date);
1167: --
1168: create_action_information(l_pact_rec);
1169: end if;

Line 1166: l_pact_rec.action_information8 := fnd_date.date_to_canonical(g_publication_end_date);

1162: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1163: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);
1164: l_pact_rec.action_information6 := g_publication_period_status;
1165: l_pact_rec.action_information7 := fnd_date.date_to_canonical(g_publication_start_date);
1166: l_pact_rec.action_information8 := fnd_date.date_to_canonical(g_publication_end_date);
1167: --
1168: create_action_information(l_pact_rec);
1169: end if;
1170: --