1 package iby_instrholder_pkg AUTHID CURRENT_USER as
2 /*$Header: ibyhdiss.pls 115.6 2003/05/30 10:59:09 nmukerje ship $*/
3 /*
4 ** Procedure: createHolderInstr.
5 ** Purpose: create a row in holder instrument table. This table keeps
6 ** track of the instrument and its holder information.
7 ** In Parameters: i_hld_type, type of the holder. (payee, user, etc..
8 ** i_hld_id, id of the holder.
9 ** i_ecappid, ec application id through which the holder is
10 ** created. instr_type and instr_id are type of instrument
11 ** BANKACCT or CREDITCARD, and it's id respectively.
12 */
13 procedure createHolderInstr( i_ecappid in iby_ecapp.ecappid%type,
14 i_hld_type in iby_instrholder.ownertype%type,
15 i_hld_id in iby_instrholder.ownerid%type,
16 i_hld_address_id in iby_instrholder.owneraddressid%type,
17 i_instr_type in iby_instrholder.instrtype%type,
18 i_instr_id in iby_instrholder.instrid%type);
19 /*
20 ** Procedure: deleteHolderInstr.
21 ** Purpose: marks the record identified by the ownerid, ownertype and
22 ** instrid and instrtype as in inactivated.
23 */
24 procedure deleteHolderInstr( i_ecappid in iby_ecapp.ecappid%type,
25 i_ownertype in iby_instrholder.ownertype%type,
26 i_ownerid in iby_instrholder.ownerid%type,
27 i_instrtype in iby_instrholder.instrtype%type,
28 i_instrid in iby_instrholder.instrid%type);
29 /*
30 ** Procedure: holderInstrExists
31 ** Purpose: checks whether the corresponding id of the holder holds the
32 ** isntrument or not.
33 */
34 function instrholderExists(i_ecappid in iby_ecapp.ecappid%type,
35 i_hld_type in iby_instrholder.ownertype%type,
36 i_hld_id in iby_instrholder.ownerid%type,
37 i_instr_type in iby_instrholder.instrtype%type,
38 i_instr_id in iby_instrholder.instrid%type)
39 return boolean;
40 procedure getHolderinstr( i_ecappid in iby_ecapp.ecappid%type,
41 i_hld_type in iby_instrholder.ownertype%type,
42 i_hld_id in iby_instrholder.ownerid%type,
43 o_instr_type out nocopy iby_instrholder.instrtype%type,
44 o_instr_id out nocopy iby_instrholder.instrid%type);
45 /*
46 ** Function: payeeAcctExists
47 ** Purpose: checks whether the corresponding id of the holder holds the
48 ** isntrument or not.
49 */
50 function payeeAcctExists(i_ecappid in iby_ecapp.ecappid%type,
51 i_hld_id in iby_instrholder.ownerId%type)
52 return boolean;
53 /*
54 ** Procedure: deleteInstr.
55 ** Purpose: marks the record identified by the ownerid, ownertype and
56 ** instrid as inactivated.
57 */
58 procedure deleteInstr( i_ecappid in iby_ecapp.ecappid%type,
59 i_ownertype in iby_instrholder.ownertype%type,
60 i_ownerid in iby_instrholder.ownerid%type,
61 i_instrid in iby_instrholder.instrid%type);
62 end iby_instrholder_pkg;