APPS.IBY_BEPKEYS_PKG dependencies on IBY_BEPINFO

Line 27: function bepKeyExists(i_bepid in iby_bepinfo.bepid%type,

23: ** The output parameters 'o_ownerid, o_bepname' are for error message
24: ** only.
25: */
26:
27: function bepKeyExists(i_bepid in iby_bepinfo.bepid%type,
28: i_ownertype in iby_bepkeys.ownertype%type,
29: i_bepkey in iby_bepkeys.key%type,
30: o_ownerid out nocopy iby_bepkeys.ownerid%type,
31: o_bepname out nocopy iby_bepinfo.name%type)

Line 31: o_bepname out nocopy iby_bepinfo.name%type)

27: function bepKeyExists(i_bepid in iby_bepinfo.bepid%type,
28: i_ownertype in iby_bepkeys.ownertype%type,
29: i_bepkey in iby_bepkeys.key%type,
30: o_ownerid out nocopy iby_bepkeys.ownerid%type,
31: o_bepname out nocopy iby_bepinfo.name%type)
32:
33: return boolean
34:
35: IS

Line 46: from iby_bepkeys a, iby_bepinfo b

42: ci_ownertype iby_bepkeys.ownertype%type,
43: ci_bepkey iby_bepkeys.key%type)
44: is
45: select ownerid, name
46: from iby_bepkeys a, iby_bepinfo b
47: where a.key = ci_bepkey
48: and a.ownertype = ci_ownertype
49: and a.bepid = ci_bepid
50: AND a.bepid = b.bepid;

Line 92: procedure createBEPKey(i_bepid in iby_bepinfo.bepid%type,

88: ** Purpose: creates a SINGLE bep key entry in iby_bepkeys table
89: ** parameters: i_ownerid, i_ownertype identifies the owner of the key.
90: ** i_bepid, id of the back end payment systems.
91: */
92: procedure createBEPKey(i_bepid in iby_bepinfo.bepid%type,
93: i_ownertype in iby_bepkeys.ownertype%type,
94: i_ownerid in iby_bepkeys.ownerid%type,
95: i_key in iby_bepkeys.key%type,
96: i_default in iby_bepkeys.defaults%type)

Line 100: l_bepname iby_bepinfo.name%type;

96: i_default in iby_bepkeys.defaults%type)
97: is
98: l_bepid iby_bepkeys.bepid%type;
99: l_ownerid iby_bepkeys.ownerid%type;
100: l_bepname iby_bepinfo.name%type;
101: l_bep_account_id iby_bepkeys.bep_account_id%TYPE;
102:
103: begin
104: