[Home] [Help]
PACKAGE: APPS.PAY_PAYJPGMT_XMLP_PKG
Source
1 PACKAGE PAY_PAYJPGMT_XMLP_PKG AS
2 /* $Header: PAYJPGMTS.pls 120.0 2007/12/13 11:59:59 amakrish noship $ */
3 P_BUSINESS_GROUP_ID number;
4 P_DATE_FROM date;
5 P_DATE_TO date;
6 P_ORGANIZATION_ID number;
7 P_PREPARE_DATE date;
8 P_CONC_REQUEST_ID number;
9 P_SANTEI_INCLUDE varchar2(3);
10 P_DATE_EARNED date;
11 P_FILE_NAME varchar2(30);
12 P_APPLIED_CATEGORY varchar2(1);
13 CP_EMP_FAILURE_ITEM varchar2(100);
14 CP_RECORD_NUMBER number;
15 CP_BLOCK_SERIAL_NUMBER number;
16 CP_SI_SEX varchar2(60);
17 CP_SI_SEX_CODE varchar2(32767);
18 CP_APPLIED_DATE varchar2(20);
19 CP_APPLIED_CATEGORY varchar2(20);
20 CP_PART_TIMER_FLAG varchar2(20);
21 CP_WP_STD_MONTHLY_COMP_NEW varchar2(20);
22 CP_WP_STD_MONTHLY_COMP_OLD varchar2(20);
23 CP_3MTH_AGO number;
24 CP_2MTH_AGO number;
25 CP_1MTH_AGO number;
26 CP_PAYMENT_DAYS_3MTH_AGO number;
27 CP_PAYMENT_DAYS_2MTH_AGO number;
28 CP_PAYMENT_DAYS_1MTH_AGO number;
29 CP_SIMPLE_COMP_3MTH_AGO number;
30 CP_SIMPLE_COMP_2MTH_AGO number;
31 CP_SIMPLE_COMP_1MTH_AGO number;
32 CP_SIMPLE_MTR_COMP_3MTH_AGO number;
33 CP_SIMPLE_MTR_COMP_2MTH_AGO number;
34 CP_SIMPLE_MTR_COMP_1MTH_AGO number;
35 CP_SIMPLE_COMP_TOTAL_3MTH_AGO number;
36 CP_SIMPLE_COMP_TOTAL_2MTH_AGO number;
37 CP_SIMPLE_COMP_TOTAL_1MTH_AGO number;
38 CP_SIMPLE_COMP_TOTAL number;
39 CP_SIMPLE_COMP_AVG number;
40 CP_ADJUSTED_COMP_AVG number;
41 CP_REPORT_TITLE varchar2(40);
42 CP_MAGFILE_NAME varchar2(40);
43 CP_TOTAL_CNT number := 0 ;
44 CP_SANTEI_CNT number := 0 ;
45 CP_GEPPEN_CNT number := 0 ;
46 function BeforeReport return boolean ;
47 function cf_emp_recordformula (ASSIGNMENT_ID in number, EFFECTIVE_DATE in date, date_earned in date, APPLIED_CATEGORY in varchar2, ASSIGNMENT_ACTION_ID in number, WP_NUMBER in varchar2,
48 DATE_OF_BIRTH in date, LAST_NAME_KANA in varchar2, FIRST_NAME_KANA in varchar2) return number ;
49 function AfterReport return boolean ;
50 procedure get_latest_std_mth_comp_info(
51 p_assignment_id in number,
52 p_effective_date in date,
53 p_date_earned in date,
54 p_applied_mth_iv_id in number,
55 p_new_std_mth_comp_iv_id in number,
56 p_old_std_mth_comp_iv_id in number,
57 p_latest_applied_date out nocopy date,
58 p_latest_std_mth_comp out nocopy varchar2)
59 ;
60 Function CP_EMP_FAILURE_ITEM_p return varchar2;
61 Function CP_RECORD_NUMBER_p return number;
62 Function CP_BLOCK_SERIAL_NUMBER_p return number;
63 Function CP_SI_SEX_p return varchar2;
64 Function CP_SI_SEX_CODE_p return varchar2;
65 Function CP_APPLIED_DATE_p return varchar2;
66 Function CP_APPLIED_CATEGORY_p return varchar2;
67 Function CP_PART_TIMER_FLAG_p return varchar2;
68 Function CP_WP_STD_MONTHLY_COMP_NEW_p return varchar2;
69 Function CP_WP_STD_MONTHLY_COMP_OLD_p return varchar2;
70 Function CP_3MTH_AGO_p return number;
71 Function CP_2MTH_AGO_p return number;
72 Function CP_1MTH_AGO_p return number;
73 Function CP_PAYMENT_DAYS_3MTH_AGO_p return number;
74 Function CP_PAYMENT_DAYS_2MTH_AGO_p return number;
75 Function CP_PAYMENT_DAYS_1MTH_AGO_p return number;
76 Function CP_SIMPLE_COMP_3MTH_AGO_p return number;
77 Function CP_SIMPLE_COMP_2MTH_AGO_p return number;
78 Function CP_SIMPLE_COMP_1MTH_AGO_p return number;
79 Function CP_SIMPLE_MTR_COMP_3MTH_AGO_p return number;
80 Function CP_SIMPLE_MTR_COMP_2MTH_AGO_p return number;
81 Function CP_SIMPLE_MTR_COMP_1MTH_AGO_p return number;
82 Function CP_SIMPLE_COMP_TOTAL_3MTH_AGO_ return number;
83 Function CP_SIMPLE_COMP_TOTAL_2MTH_AGO_ return number;
84 Function CP_SIMPLE_COMP_TOTAL_1MTH_AGO_ return number;
85 Function CP_SIMPLE_COMP_TOTAL_p return number;
86 Function CP_SIMPLE_COMP_AVG_p return number;
87 Function CP_ADJUSTED_COMP_AVG_p return number;
88 Function CP_REPORT_TITLE_p return varchar2;
89 Function CP_MAGFILE_NAME_p return varchar2;
90 Function CP_TOTAL_CNT_p return number;
91 Function CP_SANTEI_CNT_p return number;
92 Function CP_GEPPEN_CNT_p return number;
93
94 /*added from GLOBAL PACKAGE*/
95
96 G_BLOCK_COUNT NUMBER :=1;
97 G_REC_COUNT NUMBER :=0;
98
99 G_ORG_REC VARCHAR2(40);
100
101 G_EMP_REC_1 VARCHAR2(160);
102 G_EMP_REC_2 VARCHAR2(160);
103 G_EMP_REC_3 VARCHAR2(160);
104 G_EMP_REC_4 VARCHAR2(160);
105 G_EMP_REC_5 VARCHAR2(160);
106 G_EMP_REC_6 VARCHAR2(160);
107 G_EMP_REC_7 VARCHAR2(160);
108 G_EMP_REC_8 VARCHAR2(160);
109 G_EMP_REC_9 VARCHAR2(160);
110 G_EMP_REC_10 VARCHAR2(160);
111
112 G_SANTEI_DATE_APPLIED_YYMM VARCHAR2(4);
113 G_GEPPEN_DATE_APPLIED_YYMM VARCHAR2(4);
114 G_SI_SEX_IV_ID NUMBER;
115 G_WP_NEW_COMP_IV_ID NUMBER;
116 G_WP_OLD_COMP_IV_ID NUMBER;
117 G_WP_COMP_APPLIED_DATE_IV_ID NUMBER;
118
119 G_SANTEI_ELM_ID NUMBER;
120 G_SAN_PAYMENT_DAYS3_IV_ID NUMBER;
121 G_SAN_PAYMENT_DAYS2_IV_ID NUMBER;
122 G_SAN_PAYMENT_DAYS1_IV_ID NUMBER;
123 G_SAN_SIMPLE_COMP3_IV_ID NUMBER;
124 G_SAN_SIMPLE_COMP2_IV_ID NUMBER;
125 G_SAN_SIMPLE_COMP1_IV_ID NUMBER;
126 G_SAN_SIMPLE_MTR_COMP3_IV_ID NUMBER;
127 G_SAN_SIMPLE_MTR_COMP2_IV_ID NUMBER;
128 G_SAN_SIMPLE_MTR_COMP1_IV_ID NUMBER;
129 G_SAN_SIMPLE_COMP_TOTAL_IV_ID NUMBER;
130 G_SAN_SIMPLE_COMP_AVG_IV_ID NUMBER;
131 G_SAN_ADJUSTED_COMP_AVG_IV_ID NUMBER;
132 G_SANTEI_BIKOU_ELM_ID NUMBER;
133 G_PART_TIMER_IV_ID NUMBER;
134
135 G_GEPPEN_ELM_ID NUMBER;
136 G_GEP_PAYMENT_DAYS3_IV_ID NUMBER;
137 G_GEP_PAYMENT_DAYS2_IV_ID NUMBER;
138 G_GEP_PAYMENT_DAYS1_IV_ID NUMBER;
139 G_GEP_SIMPLE_COMP3_IV_ID NUMBER;
140 G_GEP_SIMPLE_COMP2_IV_ID NUMBER;
141 G_GEP_SIMPLE_COMP1_IV_ID NUMBER;
142 G_GEP_SIMPLE_MTR_COMP3_IV_ID NUMBER;
143 G_GEP_SIMPLE_MTR_COMP2_IV_ID NUMBER;
144 G_GEP_SIMPLE_MTR_COMP1_IV_ID NUMBER;
145 G_GEP_SIMPLE_COMP_TOTAL_IV_ID NUMBER;
146 G_GEP_SIMPLE_COMP_AVG_IV_ID NUMBER;
147 G_GEP_ADJUSTED_COMP_AVG_IV_ID NUMBER;
148 g_san_message varchar2(100);
149 g_gep_message varchar2(100);
150 g_wp_num_message varchar2(100);
151 g_birth_date_message varchar2(100);
152 g_full_name_message varchar2(100);
153 g_si_sex_message varchar2(100);
154 /*FIX ENDS*/
155 END PAY_PAYJPGMT_XMLP_PKG;