[Home] [Help]
PACKAGE: APPS.IBY_ROUTINGINFO_PKG
Source
1 package iby_routinginfo_pkg AUTHID CURRENT_USER as
2 /*$Header: ibyrouts.pls 115.14 2002/05/21 22:48:45 pkm ship $*/
3
4 type t_rulesRec is record(
5 ruleId NUMBER(15),
6 ruleName VARCHAR2(80),
7 bepInstrType VARCHAR2(30),
8 priority NUMBER(15),
9 bepId NUMBER(15),
10 bepSuffix VARCHAR2(10),
11 activeStatus NUMBER(2),
12 payeeId VARCHAR2(80),
13 merchantAccount VARCHAR2(80),
14 hitCounter NUMBER(15),
15 object_version NUMBER
16 );
17 type t_condtRec is record (
18 ruleName VARCHAR2(80),
19 ruleId NUMBER(15),
20 condition_name VARCHAR2(80),
21 parameter VARCHAR2(30),
22 operation VARCHAR2(30),
23 value VARCHAR2(30),
24 is_value_string VARCHAR2(1),
25 entry_seq NUMBER(4),
26 object_version NUMBER
27 );
28
29 type t_condtRecVec is table of t_condtRec index by binary_integer;
30
31 /*-------------------------------------------------------------------+
32 | Function: createRoutingInfo. |
33 | Purpose: To create a Routing information in the database. |
34 +-------------------------------------------------------------------*/
35 procedure createRoutingInfo(i_rules in t_rulesRec,
36 i_conditions in t_condtRecVec);
37
38 /*
39 ** Function: modifyRoutingInfo.
40 ** Purpose: modifies the Routing information in the database.
41 */
42 procedure modifyRoutingInfo(i_rules in t_rulesRec,
43 i_conditions in t_condtRecVec);
44
45 /*
46 ** Function: deleteRoutingInfo.
47 ** Purpose: deletes the Routing information in the database.
48 */
49 procedure deleteRoutingInfo ( i_paymentmethodId in
50 iby_routinginfo.paymentmethodId%type,
51 i_paymentmethodName in
52 iby_routinginfo.paymentmethodName%type,
53 i_version in
54 iby_routinginfo.object_version_number%type);
55
56 /*
57 ** Function: isDuplicateCondNames.
58 ** Purpose: Checks whether the input rule condition names contain
59 ** duplicates. Returns 'true' if there are duplicates, and
60 ** 'false' if not.
61 */
62 function isDuplicateCondNames ( i_conditions in t_condtRecVec )
63 RETURN BOOLEAN;
64
65 end iby_routinginfo_pkg;