APPS.PAY_PAYJPSDD_XMLP_PKG dependencies on PAY_JP_REPORT_PKG

Line 28: pay_jp_report_pkg.to_era( P_PREPARE_DATE,

24: else
25: g_magfile_name := P_FILE_NAME;
26: end if;
27:
28: pay_jp_report_pkg.to_era( P_PREPARE_DATE,
29: l_date_era_code,
30: l_date_year,
31: l_date_month,
32: l_date_day);

Line 87: CP_BASIC_PENSION_NUMBER := pay_jp_report_pkg.substrb2(pay_jp_balance_pkg.get_entry_value_char(g_basic_pension_number_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),1,10);

83: CP_COUNT_OF_RECORD := G_COUNT_OF_RECORD;
84: CP_FD_SERIAL_NUMBER := lpad(to_char(G_FD_SERIAL_NUMBER ),3,'0');
85: CP_FD_COUNT := G_FD_COUNT;
86:
87: CP_BASIC_PENSION_NUMBER := pay_jp_report_pkg.substrb2(pay_jp_balance_pkg.get_entry_value_char(g_basic_pension_number_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),1,10);
88:
89: CP_DISQUALIFIED_STATUS_CODE := pay_jp_balance_pkg.get_entry_value_char(g_disqualified_status_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
90: CP_DISQUALIFIED_STATUS := hr_general.decode_lookup('JP_WP_DISQUALIFIED_STATUS',CP_DISQUALIFIED_STATUS_CODE);
91:

Line 103: l_wp_std_monthly_comp := pay_jp_report_pkg.substrb2(to_char(pay_jp_balance_pkg.get_entry_value_number(l_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE)),1,38);

99: else
100: l_iv_id := G_WP_NEW_COMP_IV_ID;
101: l_sal_iv_id := G_WP_NEW_SALARY_IV_ID;
102: end if;
103: l_wp_std_monthly_comp := pay_jp_report_pkg.substrb2(to_char(pay_jp_balance_pkg.get_entry_value_number(l_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE)),1,38);
104: if nvl(l_wp_std_monthly_comp,' ') <> ' ' then
105: CP_WP_STD_MONTHLY_COMP := lpad(to_char(floor(to_number(l_wp_std_monthly_comp)/1000)),4,'0');
106: end if;
107: CP_WP_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(l_sal_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);