[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;