PACKAGE: APPS.PAY_PAYJPCAD_XMLP_PKG

Source

1 PACKAGE PAY_PAYJPCAD_XMLP_PKG AS
2 /* $Header: PAYJPCADS.pls 120.0 2007/12/13 11:59:37 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_FD_SERIAL_NUMBER	varchar2(32767);
12 	CP_COUNT_OF_RECORD	number;
13 	CP_RECORD_NUMBER	number;
14 	CP_BASIC_PENSION_NUMBER	varchar2(20);
15 	CP_NEW_ADDRESS	varchar2(240);
16 	CP_NEW_ADDRESS_KANA	varchar2(240);
17 	CP_PREV_ADDRESS	varchar2(240);
18 	CP_PREV_ADDRESS_KANA	varchar2(240);
19 	CP_FD_COUNT	number;
20 	CP_EMP_FAILURE_ITEM	varchar2(100);
21 	CP_REPORT_TITLE	varchar2(40);
22 	CP_MAGFILE_NAME	varchar2(40);
23 	function BeforeReport  return boolean  ;
24 	function cf_emp_recordformula (TOTAL_REC in number, ASSIGNMENT_ID in number, EFFECTIVE_DATE in date,
25 NEW_ADDRESS_KANA1 in varchar2, NEW_DISTRICT_NAME_KANA in varchar2,
26 NEW_ADDRESS_KANA2_3 in varchar2, NEW_ADDRESS1 in varchar2, PREV_ADDRESS2_3 in varchar2,
27 WP_NUMBER in varchar2, DATE_OF_BIRTH in date, NEW_ADDRESS_COUNTRY in varchar2,
28 NEW_POSTAL_CODE in varchar2, PREV_ADDRESS_COUNTRY in varchar2,NEW_ADDRESS2_3 IN VARCHAR2,
29 PREV_ADDRESS_KANA1 IN VARCHAR2,PREV_ADDRESS1 IN VARCHAR2,PREV_DISTRICT_NAME_KANA IN VARCHAR2,
30 PREV_ADDRESS_KANA2_3 IN VARCHAR2) RETURN NUMBER ;
31 	function AfterReport  return boolean  ;
32 	Function CP_FD_SERIAL_NUMBER_p return varchar2;
33 	Function CP_COUNT_OF_RECORD_p return number;
34 	Function CP_RECORD_NUMBER_p return number;
35 	Function CP_BASIC_PENSION_NUMBER_p return varchar2;
36 	Function CP_NEW_ADDRESS_p return varchar2;
37 	Function CP_NEW_ADDRESS_KANA_p return varchar2;
38 	Function CP_PREV_ADDRESS_p return varchar2;
39 	Function CP_PREV_ADDRESS_KANA_p return varchar2;
40 	Function CP_FD_COUNT_p return number;
41 	Function CP_EMP_FAILURE_ITEM_p return varchar2;
42 	Function CP_REPORT_TITLE_p return varchar2;
43 	Function CP_MAGFILE_NAME_p return varchar2;
44 	--added
45 	G_REC_COUNT		NUMBER	:=0;
46 	G_COUNT_OF_RECORD	NUMBER	:=0;
47 	G_FD_COUNT		NUMBER	:=0;
48 G_FD_SERIAL_NUMBER	NUMBER	:=0;
49 G_HEADER_OUT		NUMBER	:=0;
50 G_MAGFILE_NAME		VARCHAR2(255);
51 G_PREPARE_DATE_YEAR	VARCHAR2(2);
52 G_PREPARE_DATE_MONTH	VARCHAR2(2);
53 G_PREPARE_DATE_DAY	VARCHAR2(2);
54 G_BASIC_PENSION_NUMBER_IV_ID	NUMBER;
55 END PAY_PAYJPCAD_XMLP_PKG;