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
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);
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: /*
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.
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
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.
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: /*
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
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
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.
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;
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,
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,
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,
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: /*
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
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
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.
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
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;
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;
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;
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;