APPS.PAY_PAYJPBON_XMLP_PKG dependencies on PAY_JP_REPORT_PKG

Line 19: pay_jp_report_pkg.to_era(p_payment_date,

15:
16: g_rec_cnt := 0;
17:
18:
19: pay_jp_report_pkg.to_era(p_payment_date,
20: l_date_era_code,
21: l_date_yyyy,
22: l_date_mm,
23: l_date_dd);

Line 31: pay_jp_report_pkg.to_era(l_date,

27: cp_payment_date_dd := lpad(to_char(l_date_dd),2,'0');
28: cp_payment_date_yymmdd := cp_payment_date_yy||'.'||cp_payment_date_mm||'.'||cp_payment_date_dd;
29:
30: l_date := to_date(p_scheduled_payment_yyyymm||'01','YYYYMMDD');
31: pay_jp_report_pkg.to_era(l_date,
32: l_date_era_code,
33: l_date_yyyy,
34: l_date_mm,
35: l_date_dd);

Line 41: pay_jp_report_pkg.to_era(p_reported_date,

37: cp_scheduled_payment_yy := lpad(to_char(l_date_yy),2,'0');
38: cp_scheduled_payment_mm := lpad(to_char(l_date_mm),2,'0');
39: cp_scheduled_payment_yymm := cp_scheduled_payment_yy||'.'||cp_scheduled_payment_mm;
40:
41: pay_jp_report_pkg.to_era(p_reported_date,
42: l_date_era_code,
43: l_date_yyyy,
44: l_date_mm,
45: l_date_dd);

Line 110: pay_jp_report_pkg.to_era(date_of_birth,

106: else
107: cp_exclude := '';
108: end if;
109:
110: pay_jp_report_pkg.to_era(date_of_birth,
111: l_date_era_code,
112: l_date_yyyy,
113: l_date_mm,
114: l_date_dd);

Line 123: pay_jp_report_pkg.to_era(effective_date,

119: cp_birth_date_dd := lpad(to_char(l_date_dd),2,'0');
120: cp_birth_date_erayymmdd := cp_birth_date_era||'.'||cp_birth_date_yy||'.'||cp_birth_date_mm||'.'||cp_birth_date_dd;
121:
122: if trunc(effective_date,'DD') <> trunc(p_payment_date,'DD') then
123: pay_jp_report_pkg.to_era(effective_date,
124: l_date_era_code,
125: l_date_yyyy,
126: l_date_mm,
127: l_date_dd);

Line 174: l_where_clause_for_assid := pay_jp_report_pkg.get_concatenated_numbers(

170: l_legislation_code per_business_groups_perf.legislation_code%type;
171: begin
172: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(p_business_group_id);
173:
174: l_where_clause_for_assid := pay_jp_report_pkg.get_concatenated_numbers(
175: to_number(p_assignment_id1),
176: to_number(p_assignment_id2),
177: to_number(p_assignment_id3),
178: to_number(p_assignment_id4),