eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYJPSDD_XMLP_PKG dependencies on PAY_JP_BALANCE_PKG

Line 37: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);

33: l_date_year := l_date_year - trunc(l_date_year,-2);
34: G_PREPARE_DATE_YEAR := lpad(to_char(l_date_year),2,'0');
35: G_PREPARE_DATE_MONTH := lpad(to_char(l_date_month),2,'0');
36: G_PREPARE_DATE_DAY := lpad(to_char(l_date_day),2,'0');
37: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
38: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
39: G_BASIC_PENSION_NUMBER_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'BASIC_PENSION_NUM');
40: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
41: G_DISQUALIFIED_STATUS_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_CAUSE');

Line 38: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

34: G_PREPARE_DATE_YEAR := lpad(to_char(l_date_year),2,'0');
35: G_PREPARE_DATE_MONTH := lpad(to_char(l_date_month),2,'0');
36: G_PREPARE_DATE_DAY := lpad(to_char(l_date_day),2,'0');
37: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
38: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
39: G_BASIC_PENSION_NUMBER_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'BASIC_PENSION_NUM');
40: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
41: G_DISQUALIFIED_STATUS_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_CAUSE');
42: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

Line 39: G_BASIC_PENSION_NUMBER_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'BASIC_PENSION_NUM');

35: G_PREPARE_DATE_MONTH := lpad(to_char(l_date_month),2,'0');
36: G_PREPARE_DATE_DAY := lpad(to_char(l_date_day),2,'0');
37: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
38: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
39: G_BASIC_PENSION_NUMBER_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'BASIC_PENSION_NUM');
40: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
41: G_DISQUALIFIED_STATUS_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_CAUSE');
42: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');

Line 40: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

36: G_PREPARE_DATE_DAY := lpad(to_char(l_date_day),2,'0');
37: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
38: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
39: G_BASIC_PENSION_NUMBER_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'BASIC_PENSION_NUM');
40: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
41: G_DISQUALIFIED_STATUS_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_CAUSE');
42: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
44: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');

Line 41: G_DISQUALIFIED_STATUS_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_CAUSE');

37: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(P_BUSINESS_GROUP_ID);
38: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
39: G_BASIC_PENSION_NUMBER_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'BASIC_PENSION_NUM');
40: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
41: G_DISQUALIFIED_STATUS_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_CAUSE');
42: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
44: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
45: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');

Line 42: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

38: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
39: G_BASIC_PENSION_NUMBER_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'BASIC_PENSION_NUM');
40: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
41: G_DISQUALIFIED_STATUS_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_CAUSE');
42: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
44: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
45: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
46: G_WP_NEW_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_MR');

Line 43: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');

39: G_BASIC_PENSION_NUMBER_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'BASIC_PENSION_NUM');
40: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
41: G_DISQUALIFIED_STATUS_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_CAUSE');
42: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
44: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
45: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
46: G_WP_NEW_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_MR');
47: G_WP_OLD_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_MR');

Line 44: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');

40: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
41: G_DISQUALIFIED_STATUS_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_CAUSE');
42: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
44: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
45: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
46: G_WP_NEW_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_MR');
47: G_WP_OLD_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_MR');
48: return (TRUE);

Line 45: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');

41: G_DISQUALIFIED_STATUS_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_CAUSE');
42: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
44: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
45: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
46: G_WP_NEW_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_MR');
47: G_WP_OLD_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_MR');
48: return (TRUE);
49: end;

Line 46: G_WP_NEW_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_MR');

42: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
43: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
44: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
45: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
46: G_WP_NEW_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_MR');
47: G_WP_OLD_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_MR');
48: return (TRUE);
49: end;
50:

Line 47: G_WP_OLD_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_MR');

43: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
44: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
45: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
46: G_WP_NEW_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_MR');
47: G_WP_OLD_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_MR');
48: return (TRUE);
49: end;
50:
51: function cf_emp_recordformula (TOTAL_REC in number, ASSIGNMENT_ID in number, EFFECTIVE_DATE in date, WP_NUMBER in varchar2, DATE_OF_BIRTH in date) return number is

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 89: CP_DISQUALIFIED_STATUS_CODE := pay_jp_balance_pkg.get_entry_value_char(g_disqualified_status_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);

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:
92: CP_WP_STD_MONTHLY_COMP := NULL;
93: CP_WP_SALARY := NULL;

Line 95: l_date_applied := nvl(pay_jp_balance_pkg.get_entry_value_char(g_wp_comp_date_applied_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),'000101');

91:
92: CP_WP_STD_MONTHLY_COMP := NULL;
93: CP_WP_SALARY := NULL;
94:
95: l_date_applied := nvl(pay_jp_balance_pkg.get_entry_value_char(g_wp_comp_date_applied_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),'000101');
96: if to_number(to_char(EFFECTIVE_DATE,'YYYYMM')) - to_number(l_date_applied) < 0 then
97: l_iv_id := G_WP_OLD_COMP_IV_ID;
98: l_sal_iv_id := G_WP_OLD_SALARY_IV_ID;
99: else

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);

Line 107: CP_WP_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(l_sal_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);

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);
108:
109: l_emp_failure_item := ' ';
110:
111: if nvl(WP_NUMBER,' ') = ' ' then