APPS.PAY_JP_ITAX_REPORT_PKG dependencies on HR_JP_STANDARD_PKG

Line 156: -- l_temp_tbl hr_jp_standard_pkg.t_varchar2_tbl;

152: l_order_by_clause varchar2(255);
153: l_formula_id number;
154: l_amendment_type varchar2(1);
155: l_valid boolean;
156: -- l_temp_tbl hr_jp_standard_pkg.t_varchar2_tbl;
157: --
158: -- Private procedures
159: --
160: procedure append_action_information_id(p_action_information_id in number)

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

195: append_select_clause(
196: 'select person.assignment_id
197: , person.effective_date
198: , to_char(PERSON.EFFECTIVE_DATE, ''YYYY'') D1
199: , hr_jp_standard_pkg.to_jp_char(PERSON.EFFECTIVE_DATE, ''EE'') D2
200: , to_number(hr_jp_standard_pkg.to_jp_char(PERSON.EFFECTIVE_DATE, ''YY'')) D3
201: , ADDRESS_KANJI D4
202: , ltrim(rtrim(LAST_NAME_KANA || '' '' || FIRST_NAME_KANA)) D5
203: , LAST_NAME_KANA D70

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

196: 'select person.assignment_id
197: , person.effective_date
198: , to_char(PERSON.EFFECTIVE_DATE, ''YYYY'') D1
199: , hr_jp_standard_pkg.to_jp_char(PERSON.EFFECTIVE_DATE, ''EE'') D2
200: , to_number(hr_jp_standard_pkg.to_jp_char(PERSON.EFFECTIVE_DATE, ''YY'')) D3
201: , ADDRESS_KANJI D4
202: , ltrim(rtrim(LAST_NAME_KANA || '' '' || FIRST_NAME_KANA)) D5
203: , LAST_NAME_KANA D70
204: , FIRST_NAME_KANA D71

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

404: l_order_by_clause := null;
405: end if;
406: --
407: /*
408: hr_jp_standard_pkg.to_table(l_select_clause || l_from_clause || l_where_clause || l_order_by_clause, 255, l_temp_tbl);
409: for i in 1..l_temp_tbl.count loop
410: dbms_output.put_line(l_temp_tbl(i));
411: end loop;
412: */

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

581: -- so ACTION_INFORMATION21/22/23 of JP_ITAX_PERSON context are obsolete.
582: --
583: if g_tbl(g_index).hire_date is not null
584: and g_tbl(g_index).actual_termination_date is not null then
585: l_jp_date := hr_jp_standard_pkg.to_jp_char(g_tbl(g_index).hire_date, 'YYMMDD');
586: append_item('D52_U', to_number(substr(l_jp_date, 1, 2)));
587: append_item('D53_U', to_number(substr(l_jp_date, 3, 2)));
588: append_item('D54_U', to_number(substr(l_jp_date, 5, 2)));
589: --

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

586: append_item('D52_U', to_number(substr(l_jp_date, 1, 2)));
587: append_item('D53_U', to_number(substr(l_jp_date, 3, 2)));
588: append_item('D54_U', to_number(substr(l_jp_date, 5, 2)));
589: --
590: l_jp_date := hr_jp_standard_pkg.to_jp_char(g_tbl(g_index).actual_termination_date, 'YYMMDD');
591: append_item('D52_L', to_number(substr(l_jp_date, 1, 2)));
592: append_item('D53_L', to_number(substr(l_jp_date, 3, 2)));
593: append_item('D54_L', to_number(substr(l_jp_date, 5, 2)));
594: elsif g_tbl(g_index).hire_date is not null

Line 596: l_jp_date := hr_jp_standard_pkg.to_jp_char(

592: append_item('D53_L', to_number(substr(l_jp_date, 3, 2)));
593: append_item('D54_L', to_number(substr(l_jp_date, 5, 2)));
594: elsif g_tbl(g_index).hire_date is not null
595: or g_tbl(g_index).actual_termination_date is not null then
596: l_jp_date := hr_jp_standard_pkg.to_jp_char(
597: nvl(g_tbl(g_index).hire_date,
598: g_tbl(g_index).actual_termination_date), 'YYMMDD');
599: append_item('D52_C', to_number(substr(l_jp_date, 1, 2)));
600: append_item('D53_C', to_number(substr(l_jp_date, 3, 2)));

Line 608: l_jp_date := hr_jp_standard_pkg.to_jp_char(

604: -- Backward Compatibility
605: --
606: if g_tbl(g_index).hire_date is not null
607: or g_tbl(g_index).actual_termination_date is not null then
608: l_jp_date := hr_jp_standard_pkg.to_jp_char(
609: nvl(g_tbl(g_index).actual_termination_date,
610: g_tbl(g_index).hire_date), 'YYMMDD');
611: append_item('D52', to_number(substr(l_jp_date, 1, 2)));
612: append_item('D53', to_number(substr(l_jp_date, 3, 2)));