PACKAGE: APPS.PAY_PAYJPSDD_XMLP_PKG

Source

1 PACKAGE PAY_PAYJPSDD_XMLP_PKG AS
2 /* $Header: PAYJPSDDS.pls 120.0 2007/12/13 12:07:30 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_FD_SERIAL_NUMBER	number;
8 	P_PREPARE_DATE	date;
9 	P_PREPARE_DATE_1	varchar2(10);
10 	P_CONC_REQUEST_ID	number;
11 	P_FILE_NAME	varchar2(30);
12 	CP_BASIC_PENSION_NUMBER	varchar2(20);
13 	CP_DISQUALIFIED_STATUS	varchar2(40);
14 	CP_DISQUALIFIED_STATUS_CODE	varchar2(1);
15 	CP_WP_STD_MONTHLY_COMP	varchar2(20);
16 	CP_WP_SALARY	number;
17 	CP_EMP_FAILURE_ITEM	varchar2(100);
18 	CP_RECORD_NUMBER	number;
19 	CP_COUNT_OF_RECORD	number;
20 	CP_FD_COUNT	number;
21 	CP_FD_SERIAL_NUMBER	varchar2(3);
22 	CP_REPORT_TITLE	varchar2(50);
23 	CP_MAGFILE_NAME	varchar2(40);
24 	function BeforeReport  return boolean  ;
25 	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  ;
26 	function AfterReport  return boolean  ;
27 	Function CP_BASIC_PENSION_NUMBER_p return varchar2;
28 	Function CP_DISQUALIFIED_STATUS_p return varchar2;
29 	Function CP_DISQUALIFIED_STATUS_CODE_p return varchar2;
30 	Function CP_WP_STD_MONTHLY_COMP_p return varchar2;
31 	Function CP_WP_SALARY_p return number;
32 	Function CP_EMP_FAILURE_ITEM_p return varchar2;
33 	Function CP_RECORD_NUMBER_p return number;
34 	Function CP_COUNT_OF_RECORD_p return number;
35 	Function CP_FD_COUNT_p return number;
36 	Function CP_FD_SERIAL_NUMBER_p return varchar2;
37 	Function CP_REPORT_TITLE_p return varchar2;
38 	Function CP_MAGFILE_NAME_p return varchar2;
39 	--added
40 	G_REC_COUNT NUMBER:=0;
41 	G_COUNT_OF_RECORD NUMBER:=0;
42 	G_FD_COUNT NUMBER:=0;
43 	G_FD_SERIAL_NUMBER NUMBER:=0;
44 	G_HEADER_OUT NUMBER:=0;
45 	G_MAGFILE_NAME VARCHAR2(255);
46 
47 	G_PREPARE_DATE_YEAR VARCHAR2(2);
48 	G_PREPARE_DATE_MONTH VARCHAR2(2);
49 	G_PREPARE_DATE_DAY VARCHAR2(2);
50 
51 	G_BASIC_PENSION_NUMBER_IV_ID	NUMBER;
52 	G_DISQUALIFIED_STATUS_IV_ID		NUMBER;
53 
54 	G_WP_COMP_DATE_APPLIED_IV_ID	NUMBER;
55 	G_WP_NEW_COMP_IV_ID						NUMBER;
56 	G_WP_OLD_COMP_IV_ID						NUMBER;
57 	G_WP_NEW_SALARY_IV_ID					NUMBER;
58 	G_WP_OLD_SALARY_IV_ID					NUMBER;
59 END PAY_PAYJPSDD_XMLP_PKG;