APPS.IBY_INSTRHOLDER_PKG dependencies on IBY_ECAPP

Line 9: function instrholderExists(i_ecappid in iby_ecapp.ecappid%type,

5: ** Function: holderInstrExists
6: ** Purpose: checks whether the corresponding id of the holder holds the
7: ** instrument or not.
8: */
9: function instrholderExists(i_ecappid in iby_ecapp.ecappid%type,
10: i_hld_type in iby_instrholder.ownerType%type,
11: i_hld_id in iby_instrholder.ownerId%type,
12: i_instr_type in iby_instrholder.instrtype%type,
13: i_instr_id in iby_instrholder.instrid%type)

Line 61: function payeeAcctExists(i_ecappid in iby_ecapp.ecappid%type,

57: ** Function: payeeAcctExists
58: ** Purpose: checks whether the corresponding id of the holder holds the
59: ** isntrument or not.
60: */
61: function payeeAcctExists(i_ecappid in iby_ecapp.ecappid%type,
62: i_hld_id in iby_instrholder.ownerId%type)
63: return boolean
64: is
65: l_flag boolean := false;

Line 110: procedure createHolderInstr(i_ecappid in iby_ecapp.ecappid%type,

106: ** i_ecappid, ec application id through which the holder is
107: ** created. instr_type and instr_id are type of instrument
108: ** BANKACCT or CREDITCARD, and it's id respectively.
109: */
110: procedure createHolderInstr(i_ecappid in iby_ecapp.ecappid%type,
111: i_hld_type in iby_instrholder.ownertype%type,
112: i_hld_id in iby_instrholder.ownerid%type,
113: i_hld_address_id in iby_instrholder.owneraddressid%type,
114: i_instr_type in iby_instrholder.instrtype%type,

Line 137: procedure deleteHolderInstr(i_ecappid in iby_ecapp.ecappid%type,

133: ** Procedure: deleteHolderInstr.
134: ** Purpose: marks the record identified by the ownerid, ownertype and
135: ** instrid and instrtype as in inactivated.
136: */
137: procedure deleteHolderInstr(i_ecappid in iby_ecapp.ecappid%type,
138: i_ownertype in iby_instrholder.ownertype%type,
139: i_ownerid in iby_instrholder.ownerid%type,
140: i_instrtype in iby_instrholder.instrtype%type,
141: i_instrid in iby_instrholder.instrid%type)

Line 223: procedure getHolderinstr( i_ecappid in iby_ecapp.ecappid%type,

219: end if;
220: commit;
221: end deleteHolderInstr;
222:
223: procedure getHolderinstr( i_ecappid in iby_ecapp.ecappid%type,
224: i_hld_type in iby_instrholder.ownertype%type,
225: i_hld_id in iby_instrholder.ownerid%type,
226: o_instr_type out nocopy iby_instrholder.instrtype%type,
227: o_instr_id out nocopy iby_instrholder.instrid%type)

Line 264: procedure deleteInstr( i_ecappid in iby_ecapp.ecappid%type,

260: ** Procedure: deleteInstr.
261: ** Purpose: marks the record identified by the ownerid, ownertype and
262: ** instrid as inactivated.
263: */
264: procedure deleteInstr( i_ecappid in iby_ecapp.ecappid%type,
265: i_ownertype in iby_instrholder.ownertype%type,
266: i_ownerid in iby_instrholder.ownerid%type,
267: i_instrid in iby_instrholder.instrid%type)
268: is