[Home] [Help]
PACKAGE: APPS.PAY_PAYJPSMT_XMLP_PKG
Source
1 PACKAGE PAY_PAYJPSMT_XMLP_PKG AS
2 /* $Header: PAYJPSMTS.pls 120.1 2008/04/03 07:31:21 amakrish noship $ */
3 P_BUSINESS_GROUP_ID number;
4 P_DATE_FROM date;
5 LP_DATE_FROM varchar2(60);
6 P_DATE_TO date;
7 LP_DATE_TO varchar2(60);
8 P_ORGANIZATION_ID number;
9 P_PREPARE_DATE date;
10 P_CONC_REQUEST_ID number;
11 P_DISQUALIFIED_CHECK varchar2(3);
12 P_DATE_EARNED date;
13 LP_DATE_EARNED varchar2(60);
14 P_FILE_NAME varchar2(30);
15 P_APPLIED_CATEGORY varchar2(1);
16 CP_EMP_FAILURE_ITEM varchar2(100);
17 CP_RECORD_NUMBER number;
18 CP_BLOCK_SERIAL_NUMBER number;
19 CP_SI_SEX varchar2(80);
20 CP_SI_SEX_CODE varchar2(32767);
21 CP_DISQUALIFIED varchar2(30);
22 CP_GEPPEN_MTH varchar2(20);
23 CP_APPLIED_DATE varchar2(20);
24 CP_PART_TIMER_FLAG varchar2(20);
25 CP_WP_STD_MONTHLY_COMP_NEW varchar2(20);
26 CP_WP_STD_MONTHLY_COMP_OLD varchar2(20);
27 CP_PAYMENT_DAYS_MAY number;
28 CP_PAYMENT_DAYS_JUN number;
29 CP_PAYMENT_DAYS_JUL number;
30 CP_SIMPLE_COMP_MAY number;
31 CP_SIMPLE_COMP_JUN number;
32 CP_SIMPLE_COMP_JUL number;
33 CP_SIMPLE_MTR_COMP_MAY number;
34 CP_SIMPLE_MTR_COMP_JUN number;
35 CP_SIMPLE_MTR_COMP_JUL number;
36 CP_SIMPLE_COMP_TOTAL_MAY number;
37 CP_SIMPLE_COMP_TOTAL_JUN number;
38 CP_SIMPLE_COMP_TOTAL_JUL number;
39 CP_SIMPLE_COMP_TOTAL number;
40 CP_SIMPLE_COMP_AVG number;
41 CP_ADJUSTED_COMP_AVG number;
42 CP_REPORT_TITLE varchar2(40);
43 CP_MAGFILE_NAME varchar2(40);
44 CP_TOTAL_CNT number := 0 ;
45 CP_SANTEI_CNT number := 0 ;
46 CP_GEPPEN_AUG_CNT number := 0 ;
47 CP_GEPPEN_SEP_CNT number := 0 ;
48 CP_GEPPEN_OCT_CNT number := 0 ;
49 CP_DISQUALIFIED_CNT number := 0 ;
50 function BeforeReport return boolean ;
51 function cf_emp_recordformula (ASSIGNMENT_ID in number, EFFECTIVE_DATE in date, ASSIGNMENT_ACTION_ID in number, date_earned in date, WP_NUMBER in varchar2, DATE_OF_BIRTH in date, LAST_NAME_KANA in varchar2, FIRST_NAME_KANA in varchar2) return number ;
52 function AfterReport return boolean ;
53 procedure get_latest_std_mth_comp_info(
54 p_assignment_id in number,
55 p_effective_date in date,
56 p_date_earned in date,
57 p_applied_mth_iv_id in number,
58 p_new_std_mth_comp_iv_id in number,
59 p_old_std_mth_comp_iv_id in number,
60 p_latest_applied_date out nocopy date,
61 p_latest_std_mth_comp out nocopy varchar2)
62 ;
63 function get_global_value(
64 p_global_name in varchar2,
65 p_business_group_id in number,
66 p_legislation_code in varchar2,
67 p_effective_date in date
68 ) return number
69 ;
70 Function CP_EMP_FAILURE_ITEM_p return varchar2;
71 Function CP_RECORD_NUMBER_p return number;
72 Function CP_BLOCK_SERIAL_NUMBER_p return number;
73 Function CP_SI_SEX_p return varchar2;
74 Function CP_SI_SEX_CODE_p return varchar2;
75 Function CP_DISQUALIFIED_p return varchar2;
76 Function CP_GEPPEN_MTH_p return varchar2;
77 Function CP_APPLIED_DATE_p return varchar2;
78 Function CP_PART_TIMER_FLAG_p return varchar2;
79 Function CP_WP_STD_MONTHLY_COMP_NEW_p return varchar2;
80 Function CP_WP_STD_MONTHLY_COMP_OLD_p return varchar2;
81 Function CP_PAYMENT_DAYS_MAY_p return number;
82 Function CP_PAYMENT_DAYS_JUN_p return number;
83 Function CP_PAYMENT_DAYS_JUL_p return number;
84 Function CP_SIMPLE_COMP_MAY_p return number;
85 Function CP_SIMPLE_COMP_JUN_p return number;
86 Function CP_SIMPLE_COMP_JUL_p return number;
87 Function CP_SIMPLE_MTR_COMP_MAY_p return number;
88 Function CP_SIMPLE_MTR_COMP_JUN_p return number;
89 Function CP_SIMPLE_MTR_COMP_JUL_p return number;
90 Function CP_SIMPLE_COMP_TOTAL_MAY_p return number;
91 Function CP_SIMPLE_COMP_TOTAL_JUN_p return number;
92 Function CP_SIMPLE_COMP_TOTAL_JUL_p return number;
93 Function CP_SIMPLE_COMP_TOTAL_p return number;
94 Function CP_SIMPLE_COMP_AVG_p return number;
95 Function CP_ADJUSTED_COMP_AVG_p return number;
96 Function CP_REPORT_TITLE_p return varchar2;
97 Function CP_MAGFILE_NAME_p return varchar2;
98 Function CP_TOTAL_CNT_p return number;
99 Function CP_SANTEI_CNT_p return number;
100 Function CP_GEPPEN_AUG_CNT_p return number;
101 Function CP_GEPPEN_SEP_CNT_p return number;
102 Function CP_GEPPEN_OCT_CNT_p return number;
103 Function CP_DISQUALIFIED_CNT_p return number;
104 --Start of adding packages from 'Global' Spec
105 G_BLOCK_COUNT NUMBER :=0;
106 G_REC_COUNT NUMBER :=0;
107
108 G_ORG_REC VARCHAR2(40);
109
110 G_EMP_REC_1 VARCHAR2(160);
111 G_EMP_REC_2 VARCHAR2(160);
112 G_EMP_REC_3 VARCHAR2(160);
113 G_EMP_REC_4 VARCHAR2(160);
114 G_EMP_REC_5 VARCHAR2(160);
115 G_EMP_REC_6 VARCHAR2(160);
116 G_EMP_REC_7 VARCHAR2(160);
117 G_EMP_REC_8 VARCHAR2(160);
118 G_EMP_REC_9 VARCHAR2(160);
119 G_EMP_REC_10 VARCHAR2(160);
120
121 G_DATE_APPLIED_YYMM VARCHAR2(4);
122 G_SI_SEX_IV_ID NUMBER;
123 G_WP_NEW_COMP_IV_ID NUMBER;
124 G_WP_OLD_COMP_IV_ID NUMBER;
125 G_WP_COMP_APPLIED_DATE_IV_ID NUMBER;
126
127 G_WP_MAX_STD_COMP NUMBER;
128 G_WP_MIN_STD_COMP NUMBER;
129 G_SANTEI_ELM_ID NUMBER;
130 G_PAYMENT_DAYS3_IV_ID NUMBER;
131 G_PAYMENT_DAYS2_IV_ID NUMBER;
132 G_PAYMENT_DAYS1_IV_ID NUMBER;
133 G_SIMPLE_COMP3_IV_ID NUMBER;
134 G_SIMPLE_COMP2_IV_ID NUMBER;
135 G_SIMPLE_COMP1_IV_ID NUMBER;
136 G_SIMPLE_MTR_COMP3_IV_ID NUMBER;
137 G_SIMPLE_MTR_COMP2_IV_ID NUMBER;
138 G_SIMPLE_MTR_COMP1_IV_ID NUMBER;
139 G_SIMPLE_COMP_TOTAL_IV_ID NUMBER;
140 G_SIMPLE_COMP_AVG_IV_ID NUMBER;
141 G_ADJUSTED_COMP_AVG_IV_ID NUMBER;
142 G_SANTEI_BIKOU_ELM_ID NUMBER;
143 G_PART_TIMER_IV_ID NUMBER;
144 g_g_kyou_sangep_pay_day number;
145 g_effective_date date;
146 G_SANTEI_GEPPEN_MTH_ELM_ID NUMBER;
147 G_KOUNEN_MTH_IV_ID NUMBER;
148 --End of addition
149 Function CP_DATE_EARNED_BEFORE return varchar2;
150 END PAY_PAYJPSMT_XMLP_PKG;