DBA Data[Home] [Help]

PACKAGE: APPS.PAY_PAYJPMAG_XMLP_PKG

Source


1 PACKAGE PAY_PAYJPMAG_XMLP_PKG AS
2 /* $Header: PAYJPMAGS.pls 120.0 2007/12/13 12:01:54 amakrish noship $ */
3 	P_PAYROLL_ACTION_ID	number;
4 	P_CHARACTER_SET_CODE	varchar2(1);
5 	P_TRANSACTION_TYPE	varchar2(2);
6 	P_DIRECT_DEPOSIT_FILE_NAME	 varchar2(255);
7 	P_DIRECT_DEPOSIT_FILE_NAME_1 varchar2(255);
8 	P_CONC_REQUEST_ID	number;
9 	CP_EFFECTIVE_DATE	date;
10 	CP_ORG_PAYMENT_METHOD_NAME	varchar2(80);
11 	CP_D_TRANSACTION_TYPE	varchar2(80);
12 	CP_CHARACTER_SET_NAME	varchar2(80);
13 	CP_COMPANY_CODE	varchar2(32767);
14 	CP_COMPANY_NAME	varchar2(120);
15 	CP_DIRECT_DEPOSIT_DATE	date;
16 	CP_BANK_CODE	varchar2(4);
17 	CP_BANK_NAME	varchar2(30);
18 	CP_BANK_NAME_KANA	varchar2(60);
19 	CP_BRANCH_CODE	varchar2(3);
20 	CP_BRANCH_NAME	varchar2(45);
21 	CP_BRANCH_NAME_KANA	varchar2(90);
22 	CP_ACCOUNT_TYPE	varchar2(2);
23 	CP_ACCOUNT_NUMBER	varchar2(7);
24 	CP_ACCOUNT_NAME	varchar2(90);
25 	CP_ORG_PAYMENT_METHOD_ID	number;
26 	CP_EXTERNAL_ACCOUNT_ID	number;
27 	CP_DESCRIPTION1	varchar2(60);
28 	CP_DESCRIPTION2	varchar2(60);
29 	CP_CURRENCY_CODE	varchar2(15);
30 	CP_CURRENCY_FORMAT_MASK	varchar2(30);
31 	function BeforeReport return boolean  ;
32 	function AfterReport (CS_COUNT_PER_REPORT in number,CS_SUM_PER_REPORT in number)return boolean ;
33 	function CF_PAYMENTFormula (BANK_NAME_KANA in varchar2,EMPLOYEE_NUMBER in varchar2,PERSON_ID in number,DESCRIPTION2 in varchar2,
34 	DESCRIPTION1 in varchar2,ACCOUNT_NUMBER in varchar2,PAYMENT in number,ACCOUNT_TYPE in varchar2,ACCOUNT_NAME in varchar2,BANK_CODE in varchar2,
35 	EXTERNAL_ACCOUNT_ID in number,BRANCH_CODE in varchar2,BRANCH_NAME_KANA in varchar2)return Number ;
36 	procedure magtape_init(p_package_name in varchar2)  ;
37 	PROCEDURE magtape_header_record  ;
38 	procedure magtape_data_record(PERSON_ID number,EMPLOYEE_NUMBER varchar2,EXTERNAL_ACCOUNT_ID number,BANK_CODE varchar2,BANK_NAME_KANA varchar2,
39 	BRANCH_CODE varchar2,BRANCH_NAME_KANA varchar2,ACCOUNT_TYPE varchar2,ACCOUNT_NUMBER varchar2,ACCOUNT_NAME varchar2,DESCRIPTION1 varchar2,
40 	DESCRIPTION2 varchar2,PAYMENT number)  ;
41 	procedure magtape_trailer_record(CS_COUNT_PER_REPORT number,CS_SUM_PER_REPORT number)  ;
42 	PROCEDURE magtape_end_record  ;
43 	function AfterPForm return boolean  ;
44 	Function CP_EFFECTIVE_DATE_p return date;
45 	Function CP_ORG_PAYMENT_METHOD_NAME_p return varchar2;
46 	Function CP_D_TRANSACTION_TYPE_p return varchar2;
47 	Function CP_CHARACTER_SET_NAME_p return varchar2;
48 	Function CP_COMPANY_CODE_p return varchar2;
49 	Function CP_COMPANY_NAME_p return varchar2;
50 	Function CP_DIRECT_DEPOSIT_DATE_p return date;
51 	Function CP_BANK_CODE_p return varchar2;
52 	Function CP_BANK_NAME_p return varchar2;
53 	Function CP_BANK_NAME_KANA_p return varchar2;
54 	Function CP_BRANCH_CODE_p return varchar2;
55 	Function CP_BRANCH_NAME_p return varchar2;
56 	Function CP_BRANCH_NAME_KANA_p return varchar2;
57 	Function CP_ACCOUNT_TYPE_p return varchar2;
58 	Function CP_ACCOUNT_NUMBER_p return varchar2;
59 	Function CP_ACCOUNT_NAME_p return varchar2;
60 	Function CP_ORG_PAYMENT_METHOD_ID_p return number;
61 	Function CP_EXTERNAL_ACCOUNT_ID_p return number;
62 	Function CP_DESCRIPTION1_p return varchar2;
63 	Function CP_DESCRIPTION2_p return varchar2;
64 	Function CP_CURRENCY_CODE_p return varchar2;
65 	Function CP_CURRENCY_FORMAT_MASK_p return varchar2;
66 END PAY_PAYJPMAG_XMLP_PKG;