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_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 388: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE', wic.legislative_parameters)),wic.effective_date) dpnt_effective_date,

384: select wic.assignment_action_id,
385: wic.action_sequence,
386: wic.payroll_id,
387: nvl(pay.prl_information1, g_bg_dpnt_ref_type) dpnt_ref_type,
388: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE', wic.legislative_parameters)),wic.effective_date) dpnt_effective_date,
389: wic.effective_date,
390: wic.date_earned,
391: wic.itax_organization_id,
392: wic.itax_category,

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

838: l_person_rec.action_information7 := fnd_number.number_to_canonical(l_per_rec.address_id);
839: l_person_rec.action_information8 := l_per_rec.address_kana;
840: l_person_rec.action_information9 := l_per_rec.address_kanji;
841: l_person_rec.action_information10 := l_per_rec.country;
842: l_person_rec.action_information11 := fnd_date.date_to_canonical(l_wic_rec.date_start);
843: l_person_rec.action_information12 := l_wic_rec.leaving_reason;
844: l_person_rec.action_information13 := fnd_date.date_to_canonical(l_per_rec.date_of_birth);
845: --
846: jp_date(

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

840: l_person_rec.action_information9 := l_per_rec.address_kanji;
841: l_person_rec.action_information10 := l_per_rec.country;
842: l_person_rec.action_information11 := fnd_date.date_to_canonical(l_wic_rec.date_start);
843: l_person_rec.action_information12 := l_wic_rec.leaving_reason;
844: l_person_rec.action_information13 := fnd_date.date_to_canonical(l_per_rec.date_of_birth);
845: --
846: jp_date(
847: p_date => l_per_rec.date_of_birth,
848: p_meiji => l_person_rec.action_information14,

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

867: --
868: */
869: --
870: l_person_rec.action_information24 := fnd_number.number_to_canonical(l_wic_rec.itax_organization_id);
871: l_person_rec.action_information25 := fnd_date.date_to_canonical(l_wic_rec.actual_termination_date);
872: l_person_rec.action_information26 := fnd_number.number_to_canonical(l_per_rec.organization_id);
873: l_person_rec.action_information28 := l_per_rec.district_code;
874: --
875: -- JP_ITAX_ARCH

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

889: l_arch_rec.action_information8 := l_swot_rec.salary_payer_address_kanji;
890: l_arch_rec.action_information9 := l_swot_rec.salary_payer_name_kanji;
891: l_arch_rec.action_information10 := l_swot_rec.salary_payer_telephone_number;
892: l_arch_rec.action_information11 := l_swot_rec.tax_office_number;
893: l_arch_rec.action_information12 := fnd_date.date_to_canonical(l_wic_rec.date_earned);
894: l_arch_rec.action_information13 := l_wic_rec.employment_category;
895: l_arch_rec.action_information14 := l_wic_rec.itax_category;
896: l_arch_rec.action_information15 := l_wic_rec.itax_yea_category;
897: l_arch_rec.action_information30 := l_submission_required_flag;

Line 1171: l_housing_rec.action_information3 := fnd_date.date_to_canonical(l_housing_info.residence_date_1);

1167: l_housing_rec.effective_date := l_wic_rec.effective_date;
1168: l_housing_rec.action_information_category := 'JP_ITAX_HOUSING';
1169: l_housing_rec.action_information1 := fnd_number.number_to_canonical(l_housing_info.payable_loan);
1170: l_housing_rec.action_information2 := fnd_number.number_to_canonical(l_housing_info.loan_count);
1171: l_housing_rec.action_information3 := fnd_date.date_to_canonical(l_housing_info.residence_date_1);
1172: l_housing_rec.action_information4 := l_housing_info.loan_type_1;
1173: l_housing_rec.action_information5 := fnd_number.number_to_canonical(l_housing_info.loan_balance_1);
1174: l_housing_rec.action_information6 := fnd_date.date_to_canonical(l_housing_info.residence_date_2);
1175: l_housing_rec.action_information7 := l_housing_info.loan_type_2;

Line 1174: l_housing_rec.action_information6 := fnd_date.date_to_canonical(l_housing_info.residence_date_2);

1170: l_housing_rec.action_information2 := fnd_number.number_to_canonical(l_housing_info.loan_count);
1171: l_housing_rec.action_information3 := fnd_date.date_to_canonical(l_housing_info.residence_date_1);
1172: l_housing_rec.action_information4 := l_housing_info.loan_type_1;
1173: l_housing_rec.action_information5 := fnd_number.number_to_canonical(l_housing_info.loan_balance_1);
1174: l_housing_rec.action_information6 := fnd_date.date_to_canonical(l_housing_info.residence_date_2);
1175: l_housing_rec.action_information7 := l_housing_info.loan_type_2;
1176: l_housing_rec.action_information8 := fnd_number.number_to_canonical(l_housing_info.loan_balance_2);
1177: --
1178: -- Create the data

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

1253: l_pact_rec.effective_date := g_effective_date;
1254: l_pact_rec.action_information1 := fnd_number.number_to_canonical(g_payroll_id);
1255: l_pact_rec.action_information2 := fnd_number.number_to_canonical(g_itax_organization_id);
1256: l_pact_rec.action_information3 := g_include_terminated_flag;
1257: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1258: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);
1259: l_pact_rec.action_information6 := g_publication_period_status;
1260: l_pact_rec.action_information7 := fnd_date.date_to_canonical(g_publication_start_date);
1261: l_pact_rec.action_information8 := fnd_date.date_to_canonical(g_publication_end_date);

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

1254: l_pact_rec.action_information1 := fnd_number.number_to_canonical(g_payroll_id);
1255: l_pact_rec.action_information2 := fnd_number.number_to_canonical(g_itax_organization_id);
1256: l_pact_rec.action_information3 := g_include_terminated_flag;
1257: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1258: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);
1259: l_pact_rec.action_information6 := g_publication_period_status;
1260: l_pact_rec.action_information7 := fnd_date.date_to_canonical(g_publication_start_date);
1261: l_pact_rec.action_information8 := fnd_date.date_to_canonical(g_publication_end_date);
1262: --

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

1256: l_pact_rec.action_information3 := g_include_terminated_flag;
1257: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1258: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);
1259: l_pact_rec.action_information6 := g_publication_period_status;
1260: l_pact_rec.action_information7 := fnd_date.date_to_canonical(g_publication_start_date);
1261: l_pact_rec.action_information8 := fnd_date.date_to_canonical(g_publication_end_date);
1262: --
1263: create_action_information(l_pact_rec);
1264: end if;

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

1257: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1258: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);
1259: l_pact_rec.action_information6 := g_publication_period_status;
1260: l_pact_rec.action_information7 := fnd_date.date_to_canonical(g_publication_start_date);
1261: l_pact_rec.action_information8 := fnd_date.date_to_canonical(g_publication_end_date);
1262: --
1263: create_action_information(l_pact_rec);
1264: end if;
1265: --