PACKAGE: APPS.PAY_PAYJPSQD_XMLP_PKG

Source

1 PACKAGE PAY_PAYJPSQD_XMLP_PKG AS
2 /* $Header: PAYJPSQDS.pls 120.0 2007/12/13 12:08:52 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_CONC_REQUEST_ID	number;
10 	P_FILE_NAME	varchar2(30);
11 	CP_WP_STD_MONTHLY_COMP	varchar2(30);
12 	CP_SALARY	number;
13 	CP_MATERIAL_SALARY	number;
14 	CP_SALARY_SUM	number;
15 	CP_SI_SEX	varchar2(80);
16 	CP_SI_SEX_CODE	varchar2(1);
17 	CP_BASIC_PENSION_NUMBER	varchar2(20);
18 	CP_KOUSEI_NENKIN_NUMBER1	varchar2(30);
19 	CP_KOUSEI_NENKIN_NUMBER2	varchar2(30);
20 	CP_KOKUMIN_NENKIN_NUMBER1	varchar2(30);
21 	CP_KOKUMIN_NENKIN_NUMBER2	varchar2(30);
22 	CP_SENIN_HOKEN_NUMBER1	varchar2(30);
23 	CP_SENIN_HOKEN_NUMBER2	varchar2(30);
24 	CP_EMP_FAILURE_ITEM	varchar2(100);
25 	CP_ADDRESS	varchar2(240);
26 	CP_FD_SERIAL_NUMBER	varchar2(20);
27 	CP_COUNT_OF_RECORD	number;
28 	CP_RECORD_NUMBER	number;
29 	CP_FD_COUNT	number;
30 	CP_ADDRESS_KANA	varchar2(240);
31 	CP_REPORT_TITLE	varchar2(40);
32 	CP_MAGFILE_NAME	varchar2(40);
33 	function BeforeReport  return boolean  ;
34 	--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) return number  ;
35 	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
36 ,ADDRESS2_3 in varchar2,DATE_QUALIFIED in date,WP_NUMBER in varchar2,DATE_OF_BIRTH in date,ADDRESS_COUNTRY in varchar2,POSTAL_CODE in varchar2) return number ;
37 	function AfterReport  return boolean  ;
38 	Function CP_WP_STD_MONTHLY_COMP_p return varchar2;
39 	Function CP_SALARY_p return number;
40 	Function CP_MATERIAL_SALARY_p return number;
41 	Function CP_SALARY_SUM_p return number;
42 	Function CP_SI_SEX_p return varchar2;
43 	Function CP_SI_SEX_CODE_p return varchar2;
44 	Function CP_BASIC_PENSION_NUMBER_p return varchar2;
45 	Function CP_KOUSEI_NENKIN_NUMBER1_p return varchar2;
46 	Function CP_KOUSEI_NENKIN_NUMBER2_p return varchar2;
47 	Function CP_KOKUMIN_NENKIN_NUMBER1_p return varchar2;
48 	Function CP_KOKUMIN_NENKIN_NUMBER2_p return varchar2;
49 	Function CP_SENIN_HOKEN_NUMBER1_p return varchar2;
50 	Function CP_SENIN_HOKEN_NUMBER2_p return varchar2;
51 	Function CP_EMP_FAILURE_ITEM_p return varchar2;
52 	Function CP_ADDRESS_p return varchar2;
53 	Function CP_FD_SERIAL_NUMBER_p return varchar2;
54 	Function CP_COUNT_OF_RECORD_p return number;
55 	Function CP_RECORD_NUMBER_p return number;
56 	Function CP_FD_COUNT_p return number;
57 	Function CP_ADDRESS_KANA_p return varchar2;
58 	Function CP_REPORT_TITLE_p return varchar2;
59 	Function CP_MAGFILE_NAME_p return varchar2;
60 	-- added
61 	G_REC_COUNT						NUMBER	:=0;		G_COUNT_OF_RECORD			NUMBER	:=0;  	G_FD_COUNT						NUMBER	:=0;
62 	G_FD_SERIAL_NUMBER		NUMBER	:=0;
63 	G_HEADER_OUT					NUMBER	:=0;
64 	G_MAGFILE_NAME				VARCHAR2(255);
65 	G_PREPARE_DATE_YEAR						VARCHAR2(2);
66 	G_PREPARE_DATE_MONTH					VARCHAR2(2);
67 	G_PREPARE_DATE_DAY						VARCHAR2(2);
68 	G_BASIC_PENSION_NUMBER_IV_ID	NUMBER;
69 	G_SI_SEX_IV_ID								NUMBER;
70 	G_SALARY_IV_ID								NUMBER;
71 	G_MATERIAL_SALARY_IV_ID				NUMBER;
72 	G_WP_COMP_DATE_APPLIED_IV_ID	NUMBER;
73 	G_WP_NEW_COMP_IV_ID						NUMBER;
74 	G_WP_OLD_COMP_IV_ID						NUMBER;
75 	G_KOUSEI_NUMBER_1_IV_ID				NUMBER;
76 	G_KOUSEI_NUMBER_2_IV_ID				NUMBER;
77 	G_KOKUMIN_NUMBER_1_IV_ID			NUMBER;
78 	G_KOKUMIN_NUMBER_2_IV_ID			NUMBER;
79 	G_SENIN_NUMBER_1_IV_ID				NUMBER;
80 	G_SENIN_NUMBER_2_IV_ID				NUMBER;
81 
82 
83 	g_telephone_number						VARCHAR2(20);
84 	g_postal_code									VARCHAR2(7);
85 	g_header_failure_item					VARCHAR2(100);
86 END PAY_PAYJPSQD_XMLP_PKG;