PACKAGE: APPS.IBY_ACCPPMTMTHD_PKG

Source

1 package iby_accppmtmthd_pkg as
2 /*$Header: ibyacpms.pls 120.2 2005/10/30 05:49:28 appldev ship $*/
3 
4 /*
5 ** Name : iby_accppmtmthd_pkg
6 **
7 ** Purpose:
8 **
9 ** This package creates accepted payment methods for a payee and
10 ** deletes accepted payment methods.
11 **
12 */
13 
14 
15 /*
16 ** Procedure: getMPayeeId
17 ** Purpose: retrieve mpayeeid from iby_payee table based on payeeid
18 */
19 Procedure getMPayeeId(i_payeeid in iby_payee.payeeid%type,
20 			o_mpayeeid out NOCOPY iby_payee.mpayeeid%type);
21 
22 
23 /*
24 ** Function: pmtMthdExists.
25 ** Purpose: Check if the specified payeeid and pmtmethod  exists or not.
26 */
27 
28 function pmtMthdExists(i_ecappid in iby_accppmtmthd.ecappid%type,
29 		     i_payeeid in iby_accppmtmthd.payeeid%type,
30 		     i_instrtype in iby_accttype.instrtype%type,
31                      i_accttype  in iby_accttype.accttype%type,
32 		     o_status out nocopy iby_accppmtmthd.status%type)
33 
34 return boolean;
35 
36 /*
37 ** Procedure Name: createAccpPmtMthd
38 ** Purpose : To create an accepted payment method for a payee.
39 ** Parameters:
40 **     In : i_ecappid, i_payeetype, i_payeeid, i_instrtype, and i_accttype.
41 **     Out: None.
42 **
43 */
44 procedure createAccpPmtMthd(i_ecappid   in iby_accppmtmthd.ecappid%type,
45                             i_payeeid   in iby_accppmtmthd.payeeid%type,
46                             i_instrtype in iby_accttype.instrtype%type,
47                             i_accttype  in iby_accttype.accttype%type
48 					DEFAULT 'ALL');
49 
50 /*
51 ** Procedure Name: deleteAccpPmtMthd
52 ** Purpose : To delete an accepted payment method for a payee.
53 ** Parameters:
54 **     In : i_ecappid, i_payeetype, i_payeeid, i_intrtype, and i_accttype.
55 **     Out: None.
56 **
57 */
58 procedure deleteAccpPmtMthd(i_ecappid   in iby_accppmtmthd.ecappid%type,
59                             i_payeeid   in iby_accppmtmthd.payeeid%type,
60                             i_instrtype in iby_accttype.instrtype%type,
61                             i_accttype  in iby_accttype.accttype%type);
62 
63 end iby_accppmtmthd_pkg;