1 package iby_payee_pkg as
2 /*$Header: ibypyees.pls 120.1 2005/07/26 17:26:52 rameshsh ship $*/
3
4 /*
5 ** Procedure: createPayee.
6 ** Purpose: creates a payee object in iby_payee.
7 ** parameters: i_payeeid, id of the payee that is passed by ec application.
8 ** ecappid, id of the ecapplication.
9 */
10 procedure createPayee(i_ecappid in iby_ecapp.ecappid%type,
11 i_payeeid in iby_payee.payeeid%type,
12 i_payeename in iby_payee.name%type,
13 i_supportedOp in iby_payee.supportedOp%type,
14 i_username in iby_payee.username%type,
15 i_password in iby_payee.password%type,
16 i_activestatus in iby_payee.activeStatus%type,
17 i_threshold in iby_payee.threshold%type,
18 i_risk_enabled in iby_payee.risk_enabled%type,
19 i_bepids in JTF_NUMBER_TABLE,
20 i_bepkeys in varchar2,
21 i_bepdefaults in varchar2,
22 i_mcc in number,
23 i_secenable IN iby_payee.security_enabled%TYPE
24 );
25
26
27 /*
28 ** Procedure activatePayee
29 ** Set the active status of the payee
30 */
31 procedure setPayeeStatus(i_ecappid in iby_payee.ecappid%type,
32 i_payeeid in iby_payee.payeeid%type,
33 i_activestatus in iby_payee.activeStatus%type);
34
35
36 /*
37 ** Procedure: modifyPayee.
38 ** Purpose: creates a payee object in iby_payee.
39 ** parameters: i_payeeid, id of the payee that is passed by ec application.
40 ** ecappid, id of the ecapplication.
41 */
42 procedure modifyPayee(i_ecappid in iby_ecapp.ecappid%type,
43 i_payeeid in iby_payee.payeeid%type,
44 i_payeename in iby_payee.name%type,
45 i_supportedOp in iby_payee.supportedOp%type,
46 i_username in iby_payee.username%type,
47 i_password in iby_payee.password%type,
48 i_activestatus in iby_payee.activeStatus%type,
49 i_threshold in iby_payee.threshold%type,
50 i_risk_enabled in iby_payee.risk_enabled%type,
51 i_bepids in JTF_NUMBER_TABLE,
52 i_bepkeys in varchar2,
53 i_bepdefaults in varchar2,
54 i_mcc in number,
55 i_secenable IN iby_payee.security_enabled%TYPE,
56 i_object_version in iby_payee.object_version_number%type);
57
58
59 /*
60 ** Function: payeeExists.
61 ** Purpose: Check if the specified payeeid and ecappid exists or not.
62 */
63 function payeeExists(i_ecappid in iby_payee.ecappid%type,
64 i_payeeid in iby_payee.payeeid%type)
65 return boolean;
66
67 /*
68 ** Following procedures are used for BEP keys parsing.
69 */
70 Type varchar_tab is table of varchar2(100) index by BINARY_INTEGER;
71 Type number_tab is table of number index by BINARY_INTEGER;
72
73 procedure getTables(tableString varchar2, pltable out NOCOPY varchar_tab, counter out NOCOPY integer);
74 procedure getNumberTables(tableNumber JTF_NUMBER_TABLE, pltable out NOCOPY number_tab, counter out NOCOPY integer);
75
76 end iby_payee_pkg;
[Home] [Help]