APPS.PAY_JP_ITAX_REPORT_PKG dependencies on STANDARD

Line 151: -- l_temp_tbl hr_jp_standard_pkg.t_varchar2_tbl;

147: l_order_by_clause varchar2(255);
148: l_formula_id number;
149: l_amendment_type varchar2(1);
150: l_valid boolean;
151: -- l_temp_tbl hr_jp_standard_pkg.t_varchar2_tbl;
152: --
153: -- Private procedures
154: --
155: procedure append_action_information_id(p_action_information_id in number)

Line 194: , hr_jp_standard_pkg.to_jp_char(PERSON.EFFECTIVE_DATE, ''EE'') D2

190: append_select_clause(
191: 'select person.assignment_id
192: , person.effective_date
193: , to_char(PERSON.EFFECTIVE_DATE, ''YYYY'') D1
194: , hr_jp_standard_pkg.to_jp_char(PERSON.EFFECTIVE_DATE, ''EE'') D2
195: , to_number(hr_jp_standard_pkg.to_jp_char(PERSON.EFFECTIVE_DATE, ''YY'')) D3
196: , ADDRESS_KANJI D4
197: , ltrim(rtrim(LAST_NAME_KANA || '' '' || FIRST_NAME_KANA)) D5
198: , LAST_NAME_KANA D70

Line 195: , to_number(hr_jp_standard_pkg.to_jp_char(PERSON.EFFECTIVE_DATE, ''YY'')) D3

191: 'select person.assignment_id
192: , person.effective_date
193: , to_char(PERSON.EFFECTIVE_DATE, ''YYYY'') D1
194: , hr_jp_standard_pkg.to_jp_char(PERSON.EFFECTIVE_DATE, ''EE'') D2
195: , to_number(hr_jp_standard_pkg.to_jp_char(PERSON.EFFECTIVE_DATE, ''YY'')) D3
196: , ADDRESS_KANJI D4
197: , ltrim(rtrim(LAST_NAME_KANA || '' '' || FIRST_NAME_KANA)) D5
198: , LAST_NAME_KANA D70
199: , FIRST_NAME_KANA D71

Line 392: hr_jp_standard_pkg.to_table(l_select_clause || l_from_clause || l_where_clause || l_order_by_clause, 255, l_temp_tbl);

388: l_order_by_clause := null;
389: end if;
390: --
391: /*
392: hr_jp_standard_pkg.to_table(l_select_clause || l_from_clause || l_where_clause || l_order_by_clause, 255, l_temp_tbl);
393: for i in 1..l_temp_tbl.count loop
394: dbms_output.put_line(l_temp_tbl(i));
395: end loop;
396: */

Line 569: l_jp_date := hr_jp_standard_pkg.to_jp_char(g_tbl(g_index).hire_date, 'YYMMDD');

565: -- so ACTION_INFORMATION21/22/23 of JP_ITAX_PERSON context are obsolete.
566: --
567: if g_tbl(g_index).hire_date is not null
568: and g_tbl(g_index).actual_termination_date is not null then
569: l_jp_date := hr_jp_standard_pkg.to_jp_char(g_tbl(g_index).hire_date, 'YYMMDD');
570: append_item('D52_U', to_number(substr(l_jp_date, 1, 2)));
571: append_item('D53_U', to_number(substr(l_jp_date, 3, 2)));
572: append_item('D54_U', to_number(substr(l_jp_date, 5, 2)));
573: --

Line 574: l_jp_date := hr_jp_standard_pkg.to_jp_char(g_tbl(g_index).actual_termination_date, 'YYMMDD');

570: append_item('D52_U', to_number(substr(l_jp_date, 1, 2)));
571: append_item('D53_U', to_number(substr(l_jp_date, 3, 2)));
572: append_item('D54_U', to_number(substr(l_jp_date, 5, 2)));
573: --
574: l_jp_date := hr_jp_standard_pkg.to_jp_char(g_tbl(g_index).actual_termination_date, 'YYMMDD');
575: append_item('D52_L', to_number(substr(l_jp_date, 1, 2)));
576: append_item('D53_L', to_number(substr(l_jp_date, 3, 2)));
577: append_item('D54_L', to_number(substr(l_jp_date, 5, 2)));
578: elsif g_tbl(g_index).hire_date is not null

Line 580: l_jp_date := hr_jp_standard_pkg.to_jp_char(

576: append_item('D53_L', to_number(substr(l_jp_date, 3, 2)));
577: append_item('D54_L', to_number(substr(l_jp_date, 5, 2)));
578: elsif g_tbl(g_index).hire_date is not null
579: or g_tbl(g_index).actual_termination_date is not null then
580: l_jp_date := hr_jp_standard_pkg.to_jp_char(
581: nvl(g_tbl(g_index).hire_date,
582: g_tbl(g_index).actual_termination_date), 'YYMMDD');
583: append_item('D52_C', to_number(substr(l_jp_date, 1, 2)));
584: append_item('D53_C', to_number(substr(l_jp_date, 3, 2)));

Line 592: l_jp_date := hr_jp_standard_pkg.to_jp_char(

588: -- Backward Compatibility
589: --
590: if g_tbl(g_index).hire_date is not null
591: or g_tbl(g_index).actual_termination_date is not null then
592: l_jp_date := hr_jp_standard_pkg.to_jp_char(
593: nvl(g_tbl(g_index).actual_termination_date,
594: g_tbl(g_index).hire_date), 'YYMMDD');
595: append_item('D52', to_number(substr(l_jp_date, 1, 2)));
596: append_item('D53', to_number(substr(l_jp_date, 3, 2)));