1 PACKAGE PAY_US_PPM_HOOK AUTHID CURRENT_USER AS
2 /* $Header: payusppmhook.pkh 120.1 2010/01/20 07:01:06 mikarthi noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : PAY_US_PPM_HOOK
21 File Name : payusppmhook.pkh
22
23 Description : This package is called from the BEFORE INSERT/UPDATE
24 User Hooks. The following are the functionalities present
25 in User Hook
26
27 1. Validates the Bank Account Number in the Bank Details KFF
28
29 2. Validates the IAT Transit Code in the Further Information DFF
30
31 3. Validates the Tranks Code in the Bank Details KFF
32
33 Change List
34 -----------
35 Name Date Version Bug Text
36 -------------- ----------- ------- ------- -----------------------------
37 mikarthi 05-Dec-2008 115.0 8806003 Initial Version
38 mikarthi 20-Jan-2010 115.4 8904560 Included validation for DFI
39 Qualifier and Country Code.
40 ******************************************************************************/
41
42
43 procedure VALIDATE_BANK_DETAILS(P_ORG_PAYMENT_METHOD_ID in NUMBER
44 ,P_SEGMENT3 in VARCHAR2
45 ,P_SEGMENT4 in VARCHAR2
46 ,p_ppm_information1 in VARCHAR2
47 ,p_ppm_information2 in VARCHAR2
48 ,p_ppm_information3 in VARCHAR2
49 ,p_effective_date in date);
50
51 procedure UPDATE_BANK_DETAILS(P_PERSONAL_PAYMENT_METHOD_ID in NUMBER
52 ,P_SEGMENT3 in VARCHAR2
53 ,P_SEGMENT4 in VARCHAR2
54 ,p_ppm_information1 in VARCHAR2
55 ,p_ppm_information2 in VARCHAR2
56 ,p_ppm_information3 in VARCHAR2
57 ,p_effective_date in date);
58
59 end PAY_US_PPM_HOOK;