DBA Data[Home] [Help]

APPS.PAY_PAYJPFLI_XMLP_PKG dependencies on PAY_JP_REPORT_PKG

Line 11: CP_SALARY_CATEGORY := pay_jp_report_pkg.substrb2(hr_general.decode_lookup('JP_SALARY_CATEGORY',SALARY_CATEGORY),1,8);

7: l_date_year NUMBER;
8: l_date_month NUMBER;
9: l_date_day NUMBER;
10: begin
11: CP_SALARY_CATEGORY := pay_jp_report_pkg.substrb2(hr_general.decode_lookup('JP_SALARY_CATEGORY',SALARY_CATEGORY),1,8);
12:
13: pay_jp_report_pkg.to_era( to_date(TARGET_MONTH || '01','YYYYMMDD'),
14: l_date_era_code,
15: l_date_year,

Line 13: pay_jp_report_pkg.to_era( to_date(TARGET_MONTH || '01','YYYYMMDD'),

9: l_date_day NUMBER;
10: begin
11: CP_SALARY_CATEGORY := pay_jp_report_pkg.substrb2(hr_general.decode_lookup('JP_SALARY_CATEGORY',SALARY_CATEGORY),1,8);
12:
13: pay_jp_report_pkg.to_era( to_date(TARGET_MONTH || '01','YYYYMMDD'),
14: l_date_era_code,
15: l_date_year,
16: l_date_month,
17: l_date_day);

Line 46: pay_jp_report_pkg.to_era( to_date(lpad(to_char(P_FISCAL_YEAR),4,'0') || '-04-01','YYYY-MM-DD'),

42: l_year_suffix varchar2(100);
43: l_title varchar2(100);
44: begin
45: -- hr_standard.event('BEFORE REPORT');
46: pay_jp_report_pkg.to_era( to_date(lpad(to_char(P_FISCAL_YEAR),4,'0') || '-04-01','YYYY-MM-DD'),
47: l_date_era_code,
48: l_date_year,
49: l_date_month,
50: l_date_day);

Line 56: CP_REPORT_TITLE := pay_jp_report_pkg.substrb2(

52: hr_utility.set_message(801,'PAY_JP_PAYJPFLI_REPORT_TITLE');
53: l_title := hr_utility.get_message;
54: hr_utility.set_message(801,'PAY_JP_FISCAL_YEAR');
55: l_year_suffix := hr_utility.get_message;
56: CP_REPORT_TITLE := pay_jp_report_pkg.substrb2(
57: hr_general.decode_lookup('JP_ERA',to_char(l_date_era_code)) ||
58: lpad(nvl(to_char(l_date_year),' '),2,' ') ||l_year_suffix||' '||l_title,1,255);
59: return (TRUE);
60: end;