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.

[Home] [Help]

APPS.PAY_PAYJPSQD_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: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
41: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_MR_AT_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

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: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
41: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_MR_AT_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
42: G_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_MONEY');

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: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
41: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_MR_AT_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
42: G_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_MONEY');
43: G_MATERIAL_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_KIND');

Line 40: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');

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: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
41: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_MR_AT_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
42: G_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_MONEY');
43: G_MATERIAL_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_KIND');
44: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

Line 41: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_MR_AT_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

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: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
41: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_MR_AT_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
42: G_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_MONEY');
43: G_MATERIAL_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_KIND');
44: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
45: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');

Line 42: G_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_MONEY');

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: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
41: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_MR_AT_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
42: G_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_MONEY');
43: G_MATERIAL_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_KIND');
44: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
45: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
46: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');

Line 43: G_MATERIAL_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_KIND');

39: G_BASIC_PENSION_NUMBER_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'BASIC_PENSION_NUM');
40: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
41: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_MR_AT_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
42: G_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_MONEY');
43: G_MATERIAL_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_KIND');
44: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
45: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
46: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
47: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');

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

40: G_SI_SEX_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
41: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_MR_AT_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
42: G_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_MONEY');
43: G_MATERIAL_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_KIND');
44: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
45: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
46: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
47: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
48: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_PENSION_BOOK_NUM_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

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

41: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_MR_AT_QUALIFY_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
42: G_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_MONEY');
43: G_MATERIAL_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_KIND');
44: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
45: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
46: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
47: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
48: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_PENSION_BOOK_NUM_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
49: G_KOUSEI_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_OFFICE_NUM');

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

42: G_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_MONEY');
43: G_MATERIAL_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_KIND');
44: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
45: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
46: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
47: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
48: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_PENSION_BOOK_NUM_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
49: G_KOUSEI_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_OFFICE_NUM');
50: G_KOUSEI_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_NUM');

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

43: G_MATERIAL_SALARY_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'ERN_KIND');
44: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
45: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
46: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
47: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
48: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_PENSION_BOOK_NUM_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
49: G_KOUSEI_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_OFFICE_NUM');
50: G_KOUSEI_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_NUM');
51: G_KOKUMIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_OFFICE_NUM');

Line 48: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_PENSION_BOOK_NUM_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);

44: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_SMR_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
45: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
46: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
47: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
48: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_PENSION_BOOK_NUM_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
49: G_KOUSEI_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_OFFICE_NUM');
50: G_KOUSEI_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_NUM');
51: G_KOKUMIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_OFFICE_NUM');
52: G_KOKUMIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_NUM');

Line 49: G_KOUSEI_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_OFFICE_NUM');

45: G_WP_COMP_DATE_APPLIED_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'APPLY_MTH');
46: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
47: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
48: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_PENSION_BOOK_NUM_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
49: G_KOUSEI_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_OFFICE_NUM');
50: G_KOUSEI_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_NUM');
51: G_KOKUMIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_OFFICE_NUM');
52: G_KOKUMIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_NUM');
53: G_SENIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_OFFICE_NUM');

Line 50: G_KOUSEI_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_NUM');

46: G_WP_NEW_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'REVISED_SMR');
47: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
48: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_PENSION_BOOK_NUM_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
49: G_KOUSEI_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_OFFICE_NUM');
50: G_KOUSEI_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_NUM');
51: G_KOKUMIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_OFFICE_NUM');
52: G_KOKUMIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_NUM');
53: G_SENIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_OFFICE_NUM');
54: G_SENIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_NUM');

Line 51: G_KOKUMIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_OFFICE_NUM');

47: G_WP_OLD_COMP_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'PRIOR_SMR');
48: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_PENSION_BOOK_NUM_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
49: G_KOUSEI_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_OFFICE_NUM');
50: G_KOUSEI_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_NUM');
51: G_KOKUMIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_OFFICE_NUM');
52: G_KOKUMIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_NUM');
53: G_SENIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_OFFICE_NUM');
54: G_SENIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_NUM');
55: return (TRUE);

Line 52: G_KOKUMIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_NUM');

48: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_PENSION_BOOK_NUM_INFO',P_BUSINESS_GROUP_ID,l_legislation_code);
49: G_KOUSEI_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_OFFICE_NUM');
50: G_KOUSEI_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_NUM');
51: G_KOKUMIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_OFFICE_NUM');
52: G_KOKUMIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_NUM');
53: G_SENIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_OFFICE_NUM');
54: G_SENIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_NUM');
55: return (TRUE);
56: end;

Line 53: G_SENIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_OFFICE_NUM');

49: G_KOUSEI_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_OFFICE_NUM');
50: G_KOUSEI_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_NUM');
51: G_KOKUMIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_OFFICE_NUM');
52: G_KOKUMIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_NUM');
53: G_SENIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_OFFICE_NUM');
54: G_SENIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_NUM');
55: return (TRUE);
56: end;
57:

Line 54: G_SENIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_NUM');

50: G_KOUSEI_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'WP_BOOK_NUM');
51: G_KOKUMIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_OFFICE_NUM');
52: G_KOKUMIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'NP_BOOK_NUM');
53: G_SENIN_NUMBER_1_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_OFFICE_NUM');
54: G_SENIN_NUMBER_2_IV_ID := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SAILOR_INS_BOOK_NUM');
55: return (TRUE);
56: end;
57:
58: function cf_emp_recordformula (TOTAL_REC in number, ASSIGNMENT_ID in number, EFFECTIVE_DATE in date, ADDRESS_KANA1 in varchar2, DISTRICT_NAME_KANA in varchar2, ADDRESS_KANA2_3 in varchar2, ADDRESS1 in varchar2

Line 95: 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);

91: CP_RECORD_NUMBER := G_REC_COUNT - (G_FD_COUNT -1)*2500;
92: CP_COUNT_OF_RECORD := G_COUNT_OF_RECORD;
93: CP_FD_SERIAL_NUMBER := lpad(to_char(G_FD_SERIAL_NUMBER),3,'0');
94: CP_FD_COUNT := G_FD_COUNT;
95: 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);
96:
97: CP_SI_SEX_CODE := pay_jp_balance_pkg.get_entry_value_char(g_si_sex_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
98: CP_SI_SEX := hr_general.decode_lookup('JP_SI_SEX',CP_SI_SEX_CODE);
99:

Line 97: CP_SI_SEX_CODE := pay_jp_balance_pkg.get_entry_value_char(g_si_sex_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);

93: CP_FD_SERIAL_NUMBER := lpad(to_char(G_FD_SERIAL_NUMBER),3,'0');
94: CP_FD_COUNT := G_FD_COUNT;
95: 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);
96:
97: CP_SI_SEX_CODE := pay_jp_balance_pkg.get_entry_value_char(g_si_sex_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
98: CP_SI_SEX := hr_general.decode_lookup('JP_SI_SEX',CP_SI_SEX_CODE);
99:
100: l_address_kana := pay_jp_report_pkg.substrb2((pay_jp_report_pkg.set_space_on_address(ADDRESS_KANA1,DISTRICT_NAME_KANA,1)||' '||ADDRESS_KANA2_3),1,240);
101: l_address_kana := replace(replace(l_address_kana,hr_jp_standard_pkg.sjhextochar('8140'),' '),' ',' ');

Line 113: CP_KOUSEI_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);

109: CP_KOKUMIN_NENKIN_NUMBER2 := NULL;
110: CP_SENIN_HOKEN_NUMBER1 := NULL;
111: CP_SENIN_HOKEN_NUMBER2 := NULL;
112:
113: CP_KOUSEI_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
114: CP_KOUSEI_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
115: CP_KOKUMIN_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
116: CP_KOKUMIN_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
117: CP_SENIN_HOKEN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);

Line 114: CP_KOUSEI_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);

110: CP_SENIN_HOKEN_NUMBER1 := NULL;
111: CP_SENIN_HOKEN_NUMBER2 := NULL;
112:
113: CP_KOUSEI_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
114: CP_KOUSEI_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
115: CP_KOKUMIN_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
116: CP_KOKUMIN_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
117: CP_SENIN_HOKEN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
118: CP_SENIN_HOKEN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);

Line 115: CP_KOKUMIN_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);

111: CP_SENIN_HOKEN_NUMBER2 := NULL;
112:
113: CP_KOUSEI_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
114: CP_KOUSEI_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
115: CP_KOKUMIN_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
116: CP_KOKUMIN_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
117: CP_SENIN_HOKEN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
118: CP_SENIN_HOKEN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
119:

Line 116: CP_KOKUMIN_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);

112:
113: CP_KOUSEI_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
114: CP_KOUSEI_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
115: CP_KOKUMIN_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
116: CP_KOKUMIN_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
117: CP_SENIN_HOKEN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
118: CP_SENIN_HOKEN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
119:
120: CP_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(g_salary_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);

Line 117: CP_SENIN_HOKEN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);

113: CP_KOUSEI_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
114: CP_KOUSEI_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
115: CP_KOKUMIN_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
116: CP_KOKUMIN_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
117: CP_SENIN_HOKEN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
118: CP_SENIN_HOKEN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
119:
120: CP_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(g_salary_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);
121: CP_MATERIAL_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(g_material_salary_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);

Line 118: CP_SENIN_HOKEN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);

114: CP_KOUSEI_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kousei_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
115: CP_KOKUMIN_NENKIN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
116: CP_KOKUMIN_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
117: CP_SENIN_HOKEN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
118: CP_SENIN_HOKEN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
119:
120: CP_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(g_salary_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);
121: CP_MATERIAL_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(g_material_salary_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);
122: CP_SALARY_SUM := CP_SALARY + CP_MATERIAL_SALARY;

Line 120: CP_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(g_salary_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);

116: CP_KOKUMIN_NENKIN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_kokumin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
117: CP_SENIN_HOKEN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
118: CP_SENIN_HOKEN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
119:
120: CP_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(g_salary_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);
121: CP_MATERIAL_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(g_material_salary_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);
122: CP_SALARY_SUM := CP_SALARY + CP_MATERIAL_SALARY;
123:
124: CP_WP_STD_MONTHLY_COMP := NULL;

Line 121: CP_MATERIAL_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(g_material_salary_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);

117: CP_SENIN_HOKEN_NUMBER1 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_1_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
118: CP_SENIN_HOKEN_NUMBER2 := pay_jp_balance_pkg.get_entry_value_char(g_senin_number_2_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
119:
120: CP_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(g_salary_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);
121: CP_MATERIAL_SALARY := nvl(pay_jp_balance_pkg.get_entry_value_number(g_material_salary_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),0);
122: CP_SALARY_SUM := CP_SALARY + CP_MATERIAL_SALARY;
123:
124: CP_WP_STD_MONTHLY_COMP := NULL;
125:

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

122: CP_SALARY_SUM := CP_SALARY + CP_MATERIAL_SALARY;
123:
124: CP_WP_STD_MONTHLY_COMP := NULL;
125:
126: l_date_applied := nvl(pay_jp_balance_pkg.get_entry_value_char(g_wp_comp_date_applied_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),'000101');
127: if to_number(to_char(DATE_QUALIFIED,'YYYYMM')) - to_number(l_date_applied) < 0 then
128: l_iv_id := g_wp_old_comp_iv_id;
129: else
130: l_iv_id := g_wp_new_comp_iv_id;

Line 132: 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);

128: l_iv_id := g_wp_old_comp_iv_id;
129: else
130: l_iv_id := g_wp_new_comp_iv_id;
131: end if;
132: 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);
133: if nvl(l_wp_std_monthly_comp,' ') <> ' ' then
134: CP_WP_STD_MONTHLY_COMP := lpad(to_char(floor(to_number(l_wp_std_monthly_comp)/1000)),4,'0');
135: end if;
136: l_emp_failure_item := ' ';