eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_INSTRHOLDER_PKG dependencies on IBY_INSTRHOLDER

Line 1: package iby_instrholder_pkg AUTHID CURRENT_USER as

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

Line 14: i_hld_type in iby_instrholder.ownertype%type,

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);

Line 15: i_hld_id in iby_instrholder.ownerid%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: /*

Line 16: i_hld_address_id in iby_instrholder.owneraddressid%type,

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.

Line 17: i_instr_type in iby_instrholder.instrtype%type,

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

Line 18: i_instr_id in iby_instrholder.instrid%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.

Line 25: i_ownertype in iby_instrholder.ownertype%type,

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: /*

Line 26: i_ownerid in iby_instrholder.ownerid%type,

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

Line 27: i_instrtype in iby_instrholder.instrtype%type,

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

Line 28: i_instrid in iby_instrholder.instrid%type);

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.

Line 35: i_hld_type in iby_instrholder.ownertype%type,

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;

Line 36: i_hld_id in iby_instrholder.ownerid%type,

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,

Line 37: i_instr_type in iby_instrholder.instrtype%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,

Line 38: i_instr_id in iby_instrholder.instrid%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,

Line 41: i_hld_type in iby_instrholder.ownertype%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: /*

Line 42: i_hld_id in iby_instrholder.ownerid%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

Line 43: o_instr_type out nocopy iby_instrholder.instrtype%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

Line 44: o_instr_id out nocopy iby_instrholder.instrid%type);

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.

Line 51: i_hld_id in iby_instrholder.ownerId%type)

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

Line 59: i_ownertype in iby_instrholder.ownertype%type,

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;

Line 60: i_ownerid in iby_instrholder.ownerid%type,

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;

Line 61: i_instrid in iby_instrholder.instrid%type);

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;

Line 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;