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_BEPINFO_PKG dependencies on IBY_BEPINFO

Line 1: package body iby_bepinfo_pkg as

1: package body iby_bepinfo_pkg as
2: /*$Header: ibybepib.pls 115.18 2002/11/16 00:40:23 jleybovi ship $*/
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30) := 'IBY_BEPINFO_PKG';

Line 5: g_pkg_name CONSTANT VARCHAR2(30) := 'IBY_BEPINFO_PKG';

1: package body iby_bepinfo_pkg as
2: /*$Header: ibybepib.pls 115.18 2002/11/16 00:40:23 jleybovi ship $*/
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30) := 'IBY_BEPINFO_PKG';
6:
7: /*
8: ** Function:suffixExists.
9: ** Purpose: Check if suffix already exists

Line 12: function suffixExists (i_bepsuffix in iby_bepinfo.suffix%type,

8: ** Function:suffixExists.
9: ** Purpose: Check if suffix already exists
10: **
11: */
12: function suffixExists (i_bepsuffix in iby_bepinfo.suffix%type,
13: i_bepid in iby_bepinfo.bepid%type )
14: -- when bepid is -1, we are adding a new one
15: -- otherwise it's update for an existing one
16: return boolean

Line 13: i_bepid in iby_bepinfo.bepid%type )

9: ** Purpose: Check if suffix already exists
10: **
11: */
12: function suffixExists (i_bepsuffix in iby_bepinfo.suffix%type,
13: i_bepid in iby_bepinfo.bepid%type )
14: -- when bepid is -1, we are adding a new one
15: -- otherwise it's update for an existing one
16: return boolean
17:

Line 20: l_bepsuffix iby_bepinfo.suffix%type;

16: return boolean
17:
18: is
19: l_flag boolean := false;
20: l_bepsuffix iby_bepinfo.suffix%type;
21:
22: cursor c_bep(ci_bepsuffix in iby_bepinfo.suffix%type,
23: ci_bepid in iby_bepinfo.bepid%type) is
24: SELECT suffix

Line 22: cursor c_bep(ci_bepsuffix in iby_bepinfo.suffix%type,

18: is
19: l_flag boolean := false;
20: l_bepsuffix iby_bepinfo.suffix%type;
21:
22: cursor c_bep(ci_bepsuffix in iby_bepinfo.suffix%type,
23: ci_bepid in iby_bepinfo.bepid%type) is
24: SELECT suffix
25: FROM iby_bepinfo
26: WHERE suffix = ci_bepsuffix AND

Line 23: ci_bepid in iby_bepinfo.bepid%type) is

19: l_flag boolean := false;
20: l_bepsuffix iby_bepinfo.suffix%type;
21:
22: cursor c_bep(ci_bepsuffix in iby_bepinfo.suffix%type,
23: ci_bepid in iby_bepinfo.bepid%type) is
24: SELECT suffix
25: FROM iby_bepinfo
26: WHERE suffix = ci_bepsuffix AND
27: bepid <> ci_bepid;

Line 25: FROM iby_bepinfo

21:
22: cursor c_bep(ci_bepsuffix in iby_bepinfo.suffix%type,
23: ci_bepid in iby_bepinfo.bepid%type) is
24: SELECT suffix
25: FROM iby_bepinfo
26: WHERE suffix = ci_bepsuffix AND
27: bepid <> ci_bepid;
28: begin
29: if ( c_bep%isopen) then

Line 52: function bepNameExists (i_bepname in iby_bepinfo.name%type,

48: /*
49: ** Function: bepNameExists.
50: ** Purpose: Check if any bep Name already exists in the system.
51: */
52: function bepNameExists (i_bepname in iby_bepinfo.name%type,
53: i_bepid in iby_bepinfo.bepid%type )
54: -- when bepid is -1, we are adding a new one
55: -- otherwise it's update for an existing one
56: return boolean

Line 53: i_bepid in iby_bepinfo.bepid%type )

49: ** Function: bepNameExists.
50: ** Purpose: Check if any bep Name already exists in the system.
51: */
52: function bepNameExists (i_bepname in iby_bepinfo.name%type,
53: i_bepid in iby_bepinfo.bepid%type )
54: -- when bepid is -1, we are adding a new one
55: -- otherwise it's update for an existing one
56: return boolean
57: is

Line 59: l_bepname iby_bepinfo.name%type;

55: -- otherwise it's update for an existing one
56: return boolean
57: is
58: l_flag boolean := false;
59: l_bepname iby_bepinfo.name%type;
60: cursor c_bep(ci_bepname in iby_bepinfo.name%type,
61: ci_bepid in iby_bepinfo.bepid%type) is
62: SELECT name
63: FROM iby_bepinfo

Line 60: cursor c_bep(ci_bepname in iby_bepinfo.name%type,

56: return boolean
57: is
58: l_flag boolean := false;
59: l_bepname iby_bepinfo.name%type;
60: cursor c_bep(ci_bepname in iby_bepinfo.name%type,
61: ci_bepid in iby_bepinfo.bepid%type) is
62: SELECT name
63: FROM iby_bepinfo
64: WHERE name = ci_bepname AND

Line 61: ci_bepid in iby_bepinfo.bepid%type) is

57: is
58: l_flag boolean := false;
59: l_bepname iby_bepinfo.name%type;
60: cursor c_bep(ci_bepname in iby_bepinfo.name%type,
61: ci_bepid in iby_bepinfo.bepid%type) is
62: SELECT name
63: FROM iby_bepinfo
64: WHERE name = ci_bepname AND
65: bepid <> ci_bepid;

Line 63: FROM iby_bepinfo

59: l_bepname iby_bepinfo.name%type;
60: cursor c_bep(ci_bepname in iby_bepinfo.name%type,
61: ci_bepid in iby_bepinfo.bepid%type) is
62: SELECT name
63: FROM iby_bepinfo
64: WHERE name = ci_bepname AND
65: bepid <> ci_bepid;
66:
67: begin

Line 87: ** Purpose: Creates an entry in the iby_bepinfo table and assigns an id

83: end bepNameExists;
84:
85: /*
86: ** Procedure: createBEPInfo
87: ** Purpose: Creates an entry in the iby_bepinfo table and assigns an id
88: ** to identify it.
89: ** Parameters: bepname, name of the bep, bepurl, url of the bep
90: ** bepusername, username to be used to logon to bep,
91: ** beppassword, password for bepusername,

Line 101: procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,

97: ** or not. srvridimmed, whether a server id is returned
98: ** immediately for a payment or not.
99: ** leadtime is the time that a payment should be scheduled.
100: */
101: procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,
102: i_bepurl in iby_bepinfo.baseurl%type,
103: i_bepsuffix in iby_bepinfo.suffix%type,
104: i_bep_type in iby_bepinfo.bep_type%type,
105: i_bepusername in iby_bepinfo.bepusername%type,

Line 102: i_bepurl in iby_bepinfo.baseurl%type,

98: ** immediately for a payment or not.
99: ** leadtime is the time that a payment should be scheduled.
100: */
101: procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,
102: i_bepurl in iby_bepinfo.baseurl%type,
103: i_bepsuffix in iby_bepinfo.suffix%type,
104: i_bep_type in iby_bepinfo.bep_type%type,
105: i_bepusername in iby_bepinfo.bepusername%type,
106: i_beppassword in iby_bepinfo.beppassword%type,

Line 103: i_bepsuffix in iby_bepinfo.suffix%type,

99: ** leadtime is the time that a payment should be scheduled.
100: */
101: procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,
102: i_bepurl in iby_bepinfo.baseurl%type,
103: i_bepsuffix in iby_bepinfo.suffix%type,
104: i_bep_type in iby_bepinfo.bep_type%type,
105: i_bepusername in iby_bepinfo.bepusername%type,
106: i_beppassword in iby_bepinfo.beppassword%type,
107: i_psusername in iby_bepinfo.psusername%type,

Line 104: i_bep_type in iby_bepinfo.bep_type%type,

100: */
101: procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,
102: i_bepurl in iby_bepinfo.baseurl%type,
103: i_bepsuffix in iby_bepinfo.suffix%type,
104: i_bep_type in iby_bepinfo.bep_type%type,
105: i_bepusername in iby_bepinfo.bepusername%type,
106: i_beppassword in iby_bepinfo.beppassword%type,
107: i_psusername in iby_bepinfo.psusername%type,
108: i_pspassword in iby_bepinfo.pspassword%type,

Line 105: i_bepusername in iby_bepinfo.bepusername%type,

101: procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,
102: i_bepurl in iby_bepinfo.baseurl%type,
103: i_bepsuffix in iby_bepinfo.suffix%type,
104: i_bep_type in iby_bepinfo.bep_type%type,
105: i_bepusername in iby_bepinfo.bepusername%type,
106: i_beppassword in iby_bepinfo.beppassword%type,
107: i_psusername in iby_bepinfo.psusername%type,
108: i_pspassword in iby_bepinfo.pspassword%type,
109: i_adminurl in iby_bepinfo.adminurl%type,

Line 106: i_beppassword in iby_bepinfo.beppassword%type,

102: i_bepurl in iby_bepinfo.baseurl%type,
103: i_bepsuffix in iby_bepinfo.suffix%type,
104: i_bep_type in iby_bepinfo.bep_type%type,
105: i_bepusername in iby_bepinfo.bepusername%type,
106: i_beppassword in iby_bepinfo.beppassword%type,
107: i_psusername in iby_bepinfo.psusername%type,
108: i_pspassword in iby_bepinfo.pspassword%type,
109: i_adminurl in iby_bepinfo.adminurl%type,
110: i_login in iby_bepinfo.loginurl%type,

Line 107: i_psusername in iby_bepinfo.psusername%type,

103: i_bepsuffix in iby_bepinfo.suffix%type,
104: i_bep_type in iby_bepinfo.bep_type%type,
105: i_bepusername in iby_bepinfo.bepusername%type,
106: i_beppassword in iby_bepinfo.beppassword%type,
107: i_psusername in iby_bepinfo.psusername%type,
108: i_pspassword in iby_bepinfo.pspassword%type,
109: i_adminurl in iby_bepinfo.adminurl%type,
110: i_login in iby_bepinfo.loginurl%type,
111: i_logout in iby_bepinfo.logouturl%type,

Line 108: i_pspassword in iby_bepinfo.pspassword%type,

104: i_bep_type in iby_bepinfo.bep_type%type,
105: i_bepusername in iby_bepinfo.bepusername%type,
106: i_beppassword in iby_bepinfo.beppassword%type,
107: i_psusername in iby_bepinfo.psusername%type,
108: i_pspassword in iby_bepinfo.pspassword%type,
109: i_adminurl in iby_bepinfo.adminurl%type,
110: i_login in iby_bepinfo.loginurl%type,
111: i_logout in iby_bepinfo.logouturl%type,
112: i_supportedop in iby_bepinfo.supportedOp%type,

Line 109: i_adminurl in iby_bepinfo.adminurl%type,

105: i_bepusername in iby_bepinfo.bepusername%type,
106: i_beppassword in iby_bepinfo.beppassword%type,
107: i_psusername in iby_bepinfo.psusername%type,
108: i_pspassword in iby_bepinfo.pspassword%type,
109: i_adminurl in iby_bepinfo.adminurl%type,
110: i_login in iby_bepinfo.loginurl%type,
111: i_logout in iby_bepinfo.logouturl%type,
112: i_supportedop in iby_bepinfo.supportedOp%type,
113: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,

Line 110: i_login in iby_bepinfo.loginurl%type,

106: i_beppassword in iby_bepinfo.beppassword%type,
107: i_psusername in iby_bepinfo.psusername%type,
108: i_pspassword in iby_bepinfo.pspassword%type,
109: i_adminurl in iby_bepinfo.adminurl%type,
110: i_login in iby_bepinfo.loginurl%type,
111: i_logout in iby_bepinfo.logouturl%type,
112: i_supportedop in iby_bepinfo.supportedOp%type,
113: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
114: i_leadtime in iby_bepinfo.leadtime%type,

Line 111: i_logout in iby_bepinfo.logouturl%type,

107: i_psusername in iby_bepinfo.psusername%type,
108: i_pspassword in iby_bepinfo.pspassword%type,
109: i_adminurl in iby_bepinfo.adminurl%type,
110: i_login in iby_bepinfo.loginurl%type,
111: i_logout in iby_bepinfo.logouturl%type,
112: i_supportedop in iby_bepinfo.supportedOp%type,
113: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
114: i_leadtime in iby_bepinfo.leadtime%type,
115: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,

Line 112: i_supportedop in iby_bepinfo.supportedOp%type,

108: i_pspassword in iby_bepinfo.pspassword%type,
109: i_adminurl in iby_bepinfo.adminurl%type,
110: i_login in iby_bepinfo.loginurl%type,
111: i_logout in iby_bepinfo.logouturl%type,
112: i_supportedop in iby_bepinfo.supportedOp%type,
113: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
114: i_leadtime in iby_bepinfo.leadtime%type,
115: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
116: i_holidayfile in iby_bepinfo.holidayfile%type,

Line 114: i_leadtime in iby_bepinfo.leadtime%type,

110: i_login in iby_bepinfo.loginurl%type,
111: i_logout in iby_bepinfo.logouturl%type,
112: i_supportedop in iby_bepinfo.supportedOp%type,
113: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
114: i_leadtime in iby_bepinfo.leadtime%type,
115: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
116: i_holidayfile in iby_bepinfo.holidayfile%type,
117: i_fileSupport in iby_bepinfo.fileSupport%type,
118: i_activestatus in iby_bepinfo.activestatus%type,

Line 115: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,

111: i_logout in iby_bepinfo.logouturl%type,
112: i_supportedop in iby_bepinfo.supportedOp%type,
113: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
114: i_leadtime in iby_bepinfo.leadtime%type,
115: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
116: i_holidayfile in iby_bepinfo.holidayfile%type,
117: i_fileSupport in iby_bepinfo.fileSupport%type,
118: i_activestatus in iby_bepinfo.activestatus%type,
119: i_securityscheme in iby_bepinfo.securityscheme%type,

Line 116: i_holidayfile in iby_bepinfo.holidayfile%type,

112: i_supportedop in iby_bepinfo.supportedOp%type,
113: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
114: i_leadtime in iby_bepinfo.leadtime%type,
115: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
116: i_holidayfile in iby_bepinfo.holidayfile%type,
117: i_fileSupport in iby_bepinfo.fileSupport%type,
118: i_activestatus in iby_bepinfo.activestatus%type,
119: i_securityscheme in iby_bepinfo.securityscheme%type,
120: i_partyid in NUMBER,

Line 117: i_fileSupport in iby_bepinfo.fileSupport%type,

113: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
114: i_leadtime in iby_bepinfo.leadtime%type,
115: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
116: i_holidayfile in iby_bepinfo.holidayfile%type,
117: i_fileSupport in iby_bepinfo.fileSupport%type,
118: i_activestatus in iby_bepinfo.activestatus%type,
119: i_securityscheme in iby_bepinfo.securityscheme%type,
120: i_partyid in NUMBER,
121: i_preNLSLang in iby_beplangs.beplang%type,

Line 118: i_activestatus in iby_bepinfo.activestatus%type,

114: i_leadtime in iby_bepinfo.leadtime%type,
115: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
116: i_holidayfile in iby_bepinfo.holidayfile%type,
117: i_fileSupport in iby_bepinfo.fileSupport%type,
118: i_activestatus in iby_bepinfo.activestatus%type,
119: i_securityscheme in iby_bepinfo.securityscheme%type,
120: i_partyid in NUMBER,
121: i_preNLSLang in iby_beplangs.beplang%type,
122: i_opt1NLSLang in iby_beplangs.beplang%type,

Line 119: i_securityscheme in iby_bepinfo.securityscheme%type,

115: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
116: i_holidayfile in iby_bepinfo.holidayfile%type,
117: i_fileSupport in iby_bepinfo.fileSupport%type,
118: i_activestatus in iby_bepinfo.activestatus%type,
119: i_securityscheme in iby_bepinfo.securityscheme%type,
120: i_partyid in NUMBER,
121: i_preNLSLang in iby_beplangs.beplang%type,
122: i_opt1NLSLang in iby_beplangs.beplang%type,
123: i_opt2NLSLang in iby_beplangs.beplang%type,

Line 124: io_bepid in out nocopy iby_bepinfo.bepid%type)

120: i_partyid in NUMBER,
121: i_preNLSLang in iby_beplangs.beplang%type,
122: i_opt1NLSLang in iby_beplangs.beplang%type,
123: i_opt2NLSLang in iby_beplangs.beplang%type,
124: io_bepid in out nocopy iby_bepinfo.bepid%type)
125: is
126: l_instrtype iby_bepinfo.instrtype%type;
127:
128: cursor c_bepid is

Line 126: l_instrtype iby_bepinfo.instrtype%type;

122: i_opt1NLSLang in iby_beplangs.beplang%type,
123: i_opt2NLSLang in iby_beplangs.beplang%type,
124: io_bepid in out nocopy iby_bepinfo.bepid%type)
125: is
126: l_instrtype iby_bepinfo.instrtype%type;
127:
128: cursor c_bepid is
129: SELECT to_char(iby_bep_s.nextval) FROM dual;
130:

Line 166: ** It's a new BEP, insert information into iby_bepinfo.

162: open c_bepid;
163: fetch c_bepid into io_bepid;
164:
165: /*
166: ** It's a new BEP, insert information into iby_bepinfo.
167: */
168: INSERT INTO iby_bepinfo ( bepid, name, bepusername, beppassword, psusername,
169: pspassword, baseurl, suffix, bep_type,
170: supportedop, adminurl, loginurl, logouturl,

Line 168: INSERT INTO iby_bepinfo ( bepid, name, bepusername, beppassword, psusername,

164:
165: /*
166: ** It's a new BEP, insert information into iby_bepinfo.
167: */
168: INSERT INTO iby_bepinfo ( bepid, name, bepusername, beppassword, psusername,
169: pspassword, baseurl, suffix, bep_type,
170: supportedop, adminurl, loginurl, logouturl,
171: leadtime, srvrIdImmed, holidayfile,
172: filesupport, activestatus,

Line 213: i_bepname in iby_bepinfo.name%type,

209: -- We should add more to it later. No validation is done
210: -- in this wrapper.
211: -- FZ 5/20/02
212: procedure create_BEPInfo(
213: i_bepname in iby_bepinfo.name%type,
214: i_bepurl in iby_bepinfo.baseurl%type,
215: i_bepsuffix in iby_bepinfo.suffix%type,
216: i_bep_type in iby_bepinfo.bep_type%type,
217: i_bepusername in iby_bepinfo.bepusername%type,

Line 214: i_bepurl in iby_bepinfo.baseurl%type,

210: -- in this wrapper.
211: -- FZ 5/20/02
212: procedure create_BEPInfo(
213: i_bepname in iby_bepinfo.name%type,
214: i_bepurl in iby_bepinfo.baseurl%type,
215: i_bepsuffix in iby_bepinfo.suffix%type,
216: i_bep_type in iby_bepinfo.bep_type%type,
217: i_bepusername in iby_bepinfo.bepusername%type,
218: i_beppassword in iby_bepinfo.beppassword%type,

Line 215: i_bepsuffix in iby_bepinfo.suffix%type,

211: -- FZ 5/20/02
212: procedure create_BEPInfo(
213: i_bepname in iby_bepinfo.name%type,
214: i_bepurl in iby_bepinfo.baseurl%type,
215: i_bepsuffix in iby_bepinfo.suffix%type,
216: i_bep_type in iby_bepinfo.bep_type%type,
217: i_bepusername in iby_bepinfo.bepusername%type,
218: i_beppassword in iby_bepinfo.beppassword%type,
219: i_psusername in iby_bepinfo.psusername%type,

Line 216: i_bep_type in iby_bepinfo.bep_type%type,

212: procedure create_BEPInfo(
213: i_bepname in iby_bepinfo.name%type,
214: i_bepurl in iby_bepinfo.baseurl%type,
215: i_bepsuffix in iby_bepinfo.suffix%type,
216: i_bep_type in iby_bepinfo.bep_type%type,
217: i_bepusername in iby_bepinfo.bepusername%type,
218: i_beppassword in iby_bepinfo.beppassword%type,
219: i_psusername in iby_bepinfo.psusername%type,
220: i_pspassword in iby_bepinfo.pspassword%type,

Line 217: i_bepusername in iby_bepinfo.bepusername%type,

213: i_bepname in iby_bepinfo.name%type,
214: i_bepurl in iby_bepinfo.baseurl%type,
215: i_bepsuffix in iby_bepinfo.suffix%type,
216: i_bep_type in iby_bepinfo.bep_type%type,
217: i_bepusername in iby_bepinfo.bepusername%type,
218: i_beppassword in iby_bepinfo.beppassword%type,
219: i_psusername in iby_bepinfo.psusername%type,
220: i_pspassword in iby_bepinfo.pspassword%type,
221: i_adminurl in iby_bepinfo.adminurl%type,

Line 218: i_beppassword in iby_bepinfo.beppassword%type,

214: i_bepurl in iby_bepinfo.baseurl%type,
215: i_bepsuffix in iby_bepinfo.suffix%type,
216: i_bep_type in iby_bepinfo.bep_type%type,
217: i_bepusername in iby_bepinfo.bepusername%type,
218: i_beppassword in iby_bepinfo.beppassword%type,
219: i_psusername in iby_bepinfo.psusername%type,
220: i_pspassword in iby_bepinfo.pspassword%type,
221: i_adminurl in iby_bepinfo.adminurl%type,
222: i_login in iby_bepinfo.loginurl%type,

Line 219: i_psusername in iby_bepinfo.psusername%type,

215: i_bepsuffix in iby_bepinfo.suffix%type,
216: i_bep_type in iby_bepinfo.bep_type%type,
217: i_bepusername in iby_bepinfo.bepusername%type,
218: i_beppassword in iby_bepinfo.beppassword%type,
219: i_psusername in iby_bepinfo.psusername%type,
220: i_pspassword in iby_bepinfo.pspassword%type,
221: i_adminurl in iby_bepinfo.adminurl%type,
222: i_login in iby_bepinfo.loginurl%type,
223: i_logout in iby_bepinfo.logouturl%type,

Line 220: i_pspassword in iby_bepinfo.pspassword%type,

216: i_bep_type in iby_bepinfo.bep_type%type,
217: i_bepusername in iby_bepinfo.bepusername%type,
218: i_beppassword in iby_bepinfo.beppassword%type,
219: i_psusername in iby_bepinfo.psusername%type,
220: i_pspassword in iby_bepinfo.pspassword%type,
221: i_adminurl in iby_bepinfo.adminurl%type,
222: i_login in iby_bepinfo.loginurl%type,
223: i_logout in iby_bepinfo.logouturl%type,
224: i_supportedop in iby_bepinfo.supportedOp%type,

Line 221: i_adminurl in iby_bepinfo.adminurl%type,

217: i_bepusername in iby_bepinfo.bepusername%type,
218: i_beppassword in iby_bepinfo.beppassword%type,
219: i_psusername in iby_bepinfo.psusername%type,
220: i_pspassword in iby_bepinfo.pspassword%type,
221: i_adminurl in iby_bepinfo.adminurl%type,
222: i_login in iby_bepinfo.loginurl%type,
223: i_logout in iby_bepinfo.logouturl%type,
224: i_supportedop in iby_bepinfo.supportedOp%type,
225: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,

Line 222: i_login in iby_bepinfo.loginurl%type,

218: i_beppassword in iby_bepinfo.beppassword%type,
219: i_psusername in iby_bepinfo.psusername%type,
220: i_pspassword in iby_bepinfo.pspassword%type,
221: i_adminurl in iby_bepinfo.adminurl%type,
222: i_login in iby_bepinfo.loginurl%type,
223: i_logout in iby_bepinfo.logouturl%type,
224: i_supportedop in iby_bepinfo.supportedOp%type,
225: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
226: i_leadtime in iby_bepinfo.leadtime%type,

Line 223: i_logout in iby_bepinfo.logouturl%type,

219: i_psusername in iby_bepinfo.psusername%type,
220: i_pspassword in iby_bepinfo.pspassword%type,
221: i_adminurl in iby_bepinfo.adminurl%type,
222: i_login in iby_bepinfo.loginurl%type,
223: i_logout in iby_bepinfo.logouturl%type,
224: i_supportedop in iby_bepinfo.supportedOp%type,
225: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
226: i_leadtime in iby_bepinfo.leadtime%type,
227: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,

Line 224: i_supportedop in iby_bepinfo.supportedOp%type,

220: i_pspassword in iby_bepinfo.pspassword%type,
221: i_adminurl in iby_bepinfo.adminurl%type,
222: i_login in iby_bepinfo.loginurl%type,
223: i_logout in iby_bepinfo.logouturl%type,
224: i_supportedop in iby_bepinfo.supportedOp%type,
225: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
226: i_leadtime in iby_bepinfo.leadtime%type,
227: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
228: i_holidayfile in iby_bepinfo.holidayfile%type,

Line 226: i_leadtime in iby_bepinfo.leadtime%type,

222: i_login in iby_bepinfo.loginurl%type,
223: i_logout in iby_bepinfo.logouturl%type,
224: i_supportedop in iby_bepinfo.supportedOp%type,
225: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
226: i_leadtime in iby_bepinfo.leadtime%type,
227: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
228: i_holidayfile in iby_bepinfo.holidayfile%type,
229: i_fileSupport in iby_bepinfo.fileSupport%type,
230: i_activestatus in iby_bepinfo.activestatus%type,

Line 227: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,

223: i_logout in iby_bepinfo.logouturl%type,
224: i_supportedop in iby_bepinfo.supportedOp%type,
225: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
226: i_leadtime in iby_bepinfo.leadtime%type,
227: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
228: i_holidayfile in iby_bepinfo.holidayfile%type,
229: i_fileSupport in iby_bepinfo.fileSupport%type,
230: i_activestatus in iby_bepinfo.activestatus%type,
231: i_securityscheme in iby_bepinfo.securityscheme%type,

Line 228: i_holidayfile in iby_bepinfo.holidayfile%type,

224: i_supportedop in iby_bepinfo.supportedOp%type,
225: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
226: i_leadtime in iby_bepinfo.leadtime%type,
227: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
228: i_holidayfile in iby_bepinfo.holidayfile%type,
229: i_fileSupport in iby_bepinfo.fileSupport%type,
230: i_activestatus in iby_bepinfo.activestatus%type,
231: i_securityscheme in iby_bepinfo.securityscheme%type,
232: i_partyid in NUMBER,

Line 229: i_fileSupport in iby_bepinfo.fileSupport%type,

225: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
226: i_leadtime in iby_bepinfo.leadtime%type,
227: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
228: i_holidayfile in iby_bepinfo.holidayfile%type,
229: i_fileSupport in iby_bepinfo.fileSupport%type,
230: i_activestatus in iby_bepinfo.activestatus%type,
231: i_securityscheme in iby_bepinfo.securityscheme%type,
232: i_partyid in NUMBER,
233: i_preNLSLang in iby_beplangs.beplang%type,

Line 230: i_activestatus in iby_bepinfo.activestatus%type,

226: i_leadtime in iby_bepinfo.leadtime%type,
227: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
228: i_holidayfile in iby_bepinfo.holidayfile%type,
229: i_fileSupport in iby_bepinfo.fileSupport%type,
230: i_activestatus in iby_bepinfo.activestatus%type,
231: i_securityscheme in iby_bepinfo.securityscheme%type,
232: i_partyid in NUMBER,
233: i_preNLSLang in iby_beplangs.beplang%type,
234: i_opt1NLSLang in iby_beplangs.beplang%type,

Line 231: i_securityscheme in iby_bepinfo.securityscheme%type,

227: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
228: i_holidayfile in iby_bepinfo.holidayfile%type,
229: i_fileSupport in iby_bepinfo.fileSupport%type,
230: i_activestatus in iby_bepinfo.activestatus%type,
231: i_securityscheme in iby_bepinfo.securityscheme%type,
232: i_partyid in NUMBER,
233: i_preNLSLang in iby_beplangs.beplang%type,
234: i_opt1NLSLang in iby_beplangs.beplang%type,
235: i_opt2NLSLang in iby_beplangs.beplang%type,

Line 236: io_bepid in out nocopy iby_bepinfo.bepid%type)

232: i_partyid in NUMBER,
233: i_preNLSLang in iby_beplangs.beplang%type,
234: i_opt1NLSLang in iby_beplangs.beplang%type,
235: i_opt2NLSLang in iby_beplangs.beplang%type,
236: io_bepid in out nocopy iby_bepinfo.bepid%type)
237:
238: is
239:
240: l_bepname iby_bepinfo.name%type;

Line 240: l_bepname iby_bepinfo.name%type;

236: io_bepid in out nocopy iby_bepinfo.bepid%type)
237:
238: is
239:
240: l_bepname iby_bepinfo.name%type;
241: l_bepurl iby_bepinfo.baseurl%type;
242: l_bepsuffix iby_bepinfo.suffix%type;
243: l_bep_type iby_bepinfo.bep_type%type;
244: l_bepusername iby_bepinfo.bepusername%type;

Line 241: l_bepurl iby_bepinfo.baseurl%type;

237:
238: is
239:
240: l_bepname iby_bepinfo.name%type;
241: l_bepurl iby_bepinfo.baseurl%type;
242: l_bepsuffix iby_bepinfo.suffix%type;
243: l_bep_type iby_bepinfo.bep_type%type;
244: l_bepusername iby_bepinfo.bepusername%type;
245: l_beppassword iby_bepinfo.beppassword%type;

Line 242: l_bepsuffix iby_bepinfo.suffix%type;

238: is
239:
240: l_bepname iby_bepinfo.name%type;
241: l_bepurl iby_bepinfo.baseurl%type;
242: l_bepsuffix iby_bepinfo.suffix%type;
243: l_bep_type iby_bepinfo.bep_type%type;
244: l_bepusername iby_bepinfo.bepusername%type;
245: l_beppassword iby_bepinfo.beppassword%type;
246: l_psusername iby_bepinfo.psusername%type;

Line 243: l_bep_type iby_bepinfo.bep_type%type;

239:
240: l_bepname iby_bepinfo.name%type;
241: l_bepurl iby_bepinfo.baseurl%type;
242: l_bepsuffix iby_bepinfo.suffix%type;
243: l_bep_type iby_bepinfo.bep_type%type;
244: l_bepusername iby_bepinfo.bepusername%type;
245: l_beppassword iby_bepinfo.beppassword%type;
246: l_psusername iby_bepinfo.psusername%type;
247: l_pspassword iby_bepinfo.pspassword%type;

Line 244: l_bepusername iby_bepinfo.bepusername%type;

240: l_bepname iby_bepinfo.name%type;
241: l_bepurl iby_bepinfo.baseurl%type;
242: l_bepsuffix iby_bepinfo.suffix%type;
243: l_bep_type iby_bepinfo.bep_type%type;
244: l_bepusername iby_bepinfo.bepusername%type;
245: l_beppassword iby_bepinfo.beppassword%type;
246: l_psusername iby_bepinfo.psusername%type;
247: l_pspassword iby_bepinfo.pspassword%type;
248: l_adminurl iby_bepinfo.adminurl%type;

Line 245: l_beppassword iby_bepinfo.beppassword%type;

241: l_bepurl iby_bepinfo.baseurl%type;
242: l_bepsuffix iby_bepinfo.suffix%type;
243: l_bep_type iby_bepinfo.bep_type%type;
244: l_bepusername iby_bepinfo.bepusername%type;
245: l_beppassword iby_bepinfo.beppassword%type;
246: l_psusername iby_bepinfo.psusername%type;
247: l_pspassword iby_bepinfo.pspassword%type;
248: l_adminurl iby_bepinfo.adminurl%type;
249: l_login iby_bepinfo.loginurl%type;

Line 246: l_psusername iby_bepinfo.psusername%type;

242: l_bepsuffix iby_bepinfo.suffix%type;
243: l_bep_type iby_bepinfo.bep_type%type;
244: l_bepusername iby_bepinfo.bepusername%type;
245: l_beppassword iby_bepinfo.beppassword%type;
246: l_psusername iby_bepinfo.psusername%type;
247: l_pspassword iby_bepinfo.pspassword%type;
248: l_adminurl iby_bepinfo.adminurl%type;
249: l_login iby_bepinfo.loginurl%type;
250: l_logout iby_bepinfo.logouturl%type;

Line 247: l_pspassword iby_bepinfo.pspassword%type;

243: l_bep_type iby_bepinfo.bep_type%type;
244: l_bepusername iby_bepinfo.bepusername%type;
245: l_beppassword iby_bepinfo.beppassword%type;
246: l_psusername iby_bepinfo.psusername%type;
247: l_pspassword iby_bepinfo.pspassword%type;
248: l_adminurl iby_bepinfo.adminurl%type;
249: l_login iby_bepinfo.loginurl%type;
250: l_logout iby_bepinfo.logouturl%type;
251: l_supportedop iby_bepinfo.supportedOp%type;

Line 248: l_adminurl iby_bepinfo.adminurl%type;

244: l_bepusername iby_bepinfo.bepusername%type;
245: l_beppassword iby_bepinfo.beppassword%type;
246: l_psusername iby_bepinfo.psusername%type;
247: l_pspassword iby_bepinfo.pspassword%type;
248: l_adminurl iby_bepinfo.adminurl%type;
249: l_login iby_bepinfo.loginurl%type;
250: l_logout iby_bepinfo.logouturl%type;
251: l_supportedop iby_bepinfo.supportedOp%type;
252: l_leadtime iby_bepinfo.leadtime%type;

Line 249: l_login iby_bepinfo.loginurl%type;

245: l_beppassword iby_bepinfo.beppassword%type;
246: l_psusername iby_bepinfo.psusername%type;
247: l_pspassword iby_bepinfo.pspassword%type;
248: l_adminurl iby_bepinfo.adminurl%type;
249: l_login iby_bepinfo.loginurl%type;
250: l_logout iby_bepinfo.logouturl%type;
251: l_supportedop iby_bepinfo.supportedOp%type;
252: l_leadtime iby_bepinfo.leadtime%type;
253: l_srvrIdImmed iby_bepinfo.srvrIdImmed%type DEFAULT 'Y';

Line 250: l_logout iby_bepinfo.logouturl%type;

246: l_psusername iby_bepinfo.psusername%type;
247: l_pspassword iby_bepinfo.pspassword%type;
248: l_adminurl iby_bepinfo.adminurl%type;
249: l_login iby_bepinfo.loginurl%type;
250: l_logout iby_bepinfo.logouturl%type;
251: l_supportedop iby_bepinfo.supportedOp%type;
252: l_leadtime iby_bepinfo.leadtime%type;
253: l_srvrIdImmed iby_bepinfo.srvrIdImmed%type DEFAULT 'Y';
254: l_holidayfile iby_bepinfo.holidayfile%type DEFAULT 'N';

Line 251: l_supportedop iby_bepinfo.supportedOp%type;

247: l_pspassword iby_bepinfo.pspassword%type;
248: l_adminurl iby_bepinfo.adminurl%type;
249: l_login iby_bepinfo.loginurl%type;
250: l_logout iby_bepinfo.logouturl%type;
251: l_supportedop iby_bepinfo.supportedOp%type;
252: l_leadtime iby_bepinfo.leadtime%type;
253: l_srvrIdImmed iby_bepinfo.srvrIdImmed%type DEFAULT 'Y';
254: l_holidayfile iby_bepinfo.holidayfile%type DEFAULT 'N';
255: l_fileSupport iby_bepinfo.fileSupport%type DEFAULT 'N';

Line 252: l_leadtime iby_bepinfo.leadtime%type;

248: l_adminurl iby_bepinfo.adminurl%type;
249: l_login iby_bepinfo.loginurl%type;
250: l_logout iby_bepinfo.logouturl%type;
251: l_supportedop iby_bepinfo.supportedOp%type;
252: l_leadtime iby_bepinfo.leadtime%type;
253: l_srvrIdImmed iby_bepinfo.srvrIdImmed%type DEFAULT 'Y';
254: l_holidayfile iby_bepinfo.holidayfile%type DEFAULT 'N';
255: l_fileSupport iby_bepinfo.fileSupport%type DEFAULT 'N';
256: l_activestatus iby_bepinfo.activestatus%type DEFAULT 'Y';

Line 253: l_srvrIdImmed iby_bepinfo.srvrIdImmed%type DEFAULT 'Y';

249: l_login iby_bepinfo.loginurl%type;
250: l_logout iby_bepinfo.logouturl%type;
251: l_supportedop iby_bepinfo.supportedOp%type;
252: l_leadtime iby_bepinfo.leadtime%type;
253: l_srvrIdImmed iby_bepinfo.srvrIdImmed%type DEFAULT 'Y';
254: l_holidayfile iby_bepinfo.holidayfile%type DEFAULT 'N';
255: l_fileSupport iby_bepinfo.fileSupport%type DEFAULT 'N';
256: l_activestatus iby_bepinfo.activestatus%type DEFAULT 'Y';
257: l_securityscheme iby_bepinfo.securityscheme%type;

Line 254: l_holidayfile iby_bepinfo.holidayfile%type DEFAULT 'N';

250: l_logout iby_bepinfo.logouturl%type;
251: l_supportedop iby_bepinfo.supportedOp%type;
252: l_leadtime iby_bepinfo.leadtime%type;
253: l_srvrIdImmed iby_bepinfo.srvrIdImmed%type DEFAULT 'Y';
254: l_holidayfile iby_bepinfo.holidayfile%type DEFAULT 'N';
255: l_fileSupport iby_bepinfo.fileSupport%type DEFAULT 'N';
256: l_activestatus iby_bepinfo.activestatus%type DEFAULT 'Y';
257: l_securityscheme iby_bepinfo.securityscheme%type;
258: l_partyid NUMBER;

Line 255: l_fileSupport iby_bepinfo.fileSupport%type DEFAULT 'N';

251: l_supportedop iby_bepinfo.supportedOp%type;
252: l_leadtime iby_bepinfo.leadtime%type;
253: l_srvrIdImmed iby_bepinfo.srvrIdImmed%type DEFAULT 'Y';
254: l_holidayfile iby_bepinfo.holidayfile%type DEFAULT 'N';
255: l_fileSupport iby_bepinfo.fileSupport%type DEFAULT 'N';
256: l_activestatus iby_bepinfo.activestatus%type DEFAULT 'Y';
257: l_securityscheme iby_bepinfo.securityscheme%type;
258: l_partyid NUMBER;
259: l_preNLSLang iby_beplangs.beplang%type;

Line 256: l_activestatus iby_bepinfo.activestatus%type DEFAULT 'Y';

252: l_leadtime iby_bepinfo.leadtime%type;
253: l_srvrIdImmed iby_bepinfo.srvrIdImmed%type DEFAULT 'Y';
254: l_holidayfile iby_bepinfo.holidayfile%type DEFAULT 'N';
255: l_fileSupport iby_bepinfo.fileSupport%type DEFAULT 'N';
256: l_activestatus iby_bepinfo.activestatus%type DEFAULT 'Y';
257: l_securityscheme iby_bepinfo.securityscheme%type;
258: l_partyid NUMBER;
259: l_preNLSLang iby_beplangs.beplang%type;
260: l_opt1NLSLang iby_beplangs.beplang%type;

Line 257: l_securityscheme iby_bepinfo.securityscheme%type;

253: l_srvrIdImmed iby_bepinfo.srvrIdImmed%type DEFAULT 'Y';
254: l_holidayfile iby_bepinfo.holidayfile%type DEFAULT 'N';
255: l_fileSupport iby_bepinfo.fileSupport%type DEFAULT 'N';
256: l_activestatus iby_bepinfo.activestatus%type DEFAULT 'Y';
257: l_securityscheme iby_bepinfo.securityscheme%type;
258: l_partyid NUMBER;
259: l_preNLSLang iby_beplangs.beplang%type;
260: l_opt1NLSLang iby_beplangs.beplang%type;
261: l_opt2NLSLang iby_beplangs.beplang%type;

Line 414: ** Purpose: modifies the entry in the iby_bepinfo table that matches bepid

410:
411:
412: /*
413: ** Function: modBEPInfo
414: ** Purpose: modifies the entry in the iby_bepinfo table that matches bepid
415: ** passed with the values specified.
416: ** Parameters: bepid, id of the bep, bepname, name of the bep,
417: ** bepurl, url of the bep
418: ** bepusername, username to be used to logon to bep,

Line 428: procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,

424: ** or not. srvridimmed, whether a server id is returned
425: ** immediately for a payment or not.
426: ** leadtime is the time that a payment should be scheduled.
427: */
428: procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,
429: i_bepname in iby_bepinfo.name%type,
430: i_bepurl in iby_bepinfo.baseurl%type,
431: i_bepsuffix in iby_bepinfo.suffix%type,
432: i_bep_type in iby_bepinfo.bep_type%type,

Line 429: i_bepname in iby_bepinfo.name%type,

425: ** immediately for a payment or not.
426: ** leadtime is the time that a payment should be scheduled.
427: */
428: procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,
429: i_bepname in iby_bepinfo.name%type,
430: i_bepurl in iby_bepinfo.baseurl%type,
431: i_bepsuffix in iby_bepinfo.suffix%type,
432: i_bep_type in iby_bepinfo.bep_type%type,
433: i_bepusername in iby_bepinfo.bepusername%type,

Line 430: i_bepurl in iby_bepinfo.baseurl%type,

426: ** leadtime is the time that a payment should be scheduled.
427: */
428: procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,
429: i_bepname in iby_bepinfo.name%type,
430: i_bepurl in iby_bepinfo.baseurl%type,
431: i_bepsuffix in iby_bepinfo.suffix%type,
432: i_bep_type in iby_bepinfo.bep_type%type,
433: i_bepusername in iby_bepinfo.bepusername%type,
434: i_beppassword in iby_bepinfo.beppassword%type,

Line 431: i_bepsuffix in iby_bepinfo.suffix%type,

427: */
428: procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,
429: i_bepname in iby_bepinfo.name%type,
430: i_bepurl in iby_bepinfo.baseurl%type,
431: i_bepsuffix in iby_bepinfo.suffix%type,
432: i_bep_type in iby_bepinfo.bep_type%type,
433: i_bepusername in iby_bepinfo.bepusername%type,
434: i_beppassword in iby_bepinfo.beppassword%type,
435: i_psusername in iby_bepinfo.psusername%type,

Line 432: i_bep_type in iby_bepinfo.bep_type%type,

428: procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,
429: i_bepname in iby_bepinfo.name%type,
430: i_bepurl in iby_bepinfo.baseurl%type,
431: i_bepsuffix in iby_bepinfo.suffix%type,
432: i_bep_type in iby_bepinfo.bep_type%type,
433: i_bepusername in iby_bepinfo.bepusername%type,
434: i_beppassword in iby_bepinfo.beppassword%type,
435: i_psusername in iby_bepinfo.psusername%type,
436: i_pspassword in iby_bepinfo.pspassword%type,

Line 433: i_bepusername in iby_bepinfo.bepusername%type,

429: i_bepname in iby_bepinfo.name%type,
430: i_bepurl in iby_bepinfo.baseurl%type,
431: i_bepsuffix in iby_bepinfo.suffix%type,
432: i_bep_type in iby_bepinfo.bep_type%type,
433: i_bepusername in iby_bepinfo.bepusername%type,
434: i_beppassword in iby_bepinfo.beppassword%type,
435: i_psusername in iby_bepinfo.psusername%type,
436: i_pspassword in iby_bepinfo.pspassword%type,
437: i_adminurl in iby_bepinfo.adminurl%type,

Line 434: i_beppassword in iby_bepinfo.beppassword%type,

430: i_bepurl in iby_bepinfo.baseurl%type,
431: i_bepsuffix in iby_bepinfo.suffix%type,
432: i_bep_type in iby_bepinfo.bep_type%type,
433: i_bepusername in iby_bepinfo.bepusername%type,
434: i_beppassword in iby_bepinfo.beppassword%type,
435: i_psusername in iby_bepinfo.psusername%type,
436: i_pspassword in iby_bepinfo.pspassword%type,
437: i_adminurl in iby_bepinfo.adminurl%type,
438: i_login in iby_bepinfo.loginurl%type,

Line 435: i_psusername in iby_bepinfo.psusername%type,

431: i_bepsuffix in iby_bepinfo.suffix%type,
432: i_bep_type in iby_bepinfo.bep_type%type,
433: i_bepusername in iby_bepinfo.bepusername%type,
434: i_beppassword in iby_bepinfo.beppassword%type,
435: i_psusername in iby_bepinfo.psusername%type,
436: i_pspassword in iby_bepinfo.pspassword%type,
437: i_adminurl in iby_bepinfo.adminurl%type,
438: i_login in iby_bepinfo.loginurl%type,
439: i_logout in iby_bepinfo.logouturl%type,

Line 436: i_pspassword in iby_bepinfo.pspassword%type,

432: i_bep_type in iby_bepinfo.bep_type%type,
433: i_bepusername in iby_bepinfo.bepusername%type,
434: i_beppassword in iby_bepinfo.beppassword%type,
435: i_psusername in iby_bepinfo.psusername%type,
436: i_pspassword in iby_bepinfo.pspassword%type,
437: i_adminurl in iby_bepinfo.adminurl%type,
438: i_login in iby_bepinfo.loginurl%type,
439: i_logout in iby_bepinfo.logouturl%type,
440: i_supportedop in iby_bepinfo.supportedOp%type,

Line 437: i_adminurl in iby_bepinfo.adminurl%type,

433: i_bepusername in iby_bepinfo.bepusername%type,
434: i_beppassword in iby_bepinfo.beppassword%type,
435: i_psusername in iby_bepinfo.psusername%type,
436: i_pspassword in iby_bepinfo.pspassword%type,
437: i_adminurl in iby_bepinfo.adminurl%type,
438: i_login in iby_bepinfo.loginurl%type,
439: i_logout in iby_bepinfo.logouturl%type,
440: i_supportedop in iby_bepinfo.supportedOp%type,
441: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,

Line 438: i_login in iby_bepinfo.loginurl%type,

434: i_beppassword in iby_bepinfo.beppassword%type,
435: i_psusername in iby_bepinfo.psusername%type,
436: i_pspassword in iby_bepinfo.pspassword%type,
437: i_adminurl in iby_bepinfo.adminurl%type,
438: i_login in iby_bepinfo.loginurl%type,
439: i_logout in iby_bepinfo.logouturl%type,
440: i_supportedop in iby_bepinfo.supportedOp%type,
441: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
442: i_leadtime in iby_bepinfo.leadtime%type,

Line 439: i_logout in iby_bepinfo.logouturl%type,

435: i_psusername in iby_bepinfo.psusername%type,
436: i_pspassword in iby_bepinfo.pspassword%type,
437: i_adminurl in iby_bepinfo.adminurl%type,
438: i_login in iby_bepinfo.loginurl%type,
439: i_logout in iby_bepinfo.logouturl%type,
440: i_supportedop in iby_bepinfo.supportedOp%type,
441: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
442: i_leadtime in iby_bepinfo.leadtime%type,
443: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,

Line 440: i_supportedop in iby_bepinfo.supportedOp%type,

436: i_pspassword in iby_bepinfo.pspassword%type,
437: i_adminurl in iby_bepinfo.adminurl%type,
438: i_login in iby_bepinfo.loginurl%type,
439: i_logout in iby_bepinfo.logouturl%type,
440: i_supportedop in iby_bepinfo.supportedOp%type,
441: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
442: i_leadtime in iby_bepinfo.leadtime%type,
443: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
444: i_holidayfile in iby_bepinfo.holidayfile%type,

Line 442: i_leadtime in iby_bepinfo.leadtime%type,

438: i_login in iby_bepinfo.loginurl%type,
439: i_logout in iby_bepinfo.logouturl%type,
440: i_supportedop in iby_bepinfo.supportedOp%type,
441: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
442: i_leadtime in iby_bepinfo.leadtime%type,
443: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
444: i_holidayfile in iby_bepinfo.holidayfile%type,
445: i_fileSupport in iby_bepinfo.fileSupport%type,
446: i_activestatus in iby_bepinfo.activestatus%type,

Line 443: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,

439: i_logout in iby_bepinfo.logouturl%type,
440: i_supportedop in iby_bepinfo.supportedOp%type,
441: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
442: i_leadtime in iby_bepinfo.leadtime%type,
443: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
444: i_holidayfile in iby_bepinfo.holidayfile%type,
445: i_fileSupport in iby_bepinfo.fileSupport%type,
446: i_activestatus in iby_bepinfo.activestatus%type,
447: i_securityscheme in iby_bepinfo.securityscheme%type,

Line 444: i_holidayfile in iby_bepinfo.holidayfile%type,

440: i_supportedop in iby_bepinfo.supportedOp%type,
441: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
442: i_leadtime in iby_bepinfo.leadtime%type,
443: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
444: i_holidayfile in iby_bepinfo.holidayfile%type,
445: i_fileSupport in iby_bepinfo.fileSupport%type,
446: i_activestatus in iby_bepinfo.activestatus%type,
447: i_securityscheme in iby_bepinfo.securityscheme%type,
448: i_partyid in NUMBER,

Line 445: i_fileSupport in iby_bepinfo.fileSupport%type,

441: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
442: i_leadtime in iby_bepinfo.leadtime%type,
443: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
444: i_holidayfile in iby_bepinfo.holidayfile%type,
445: i_fileSupport in iby_bepinfo.fileSupport%type,
446: i_activestatus in iby_bepinfo.activestatus%type,
447: i_securityscheme in iby_bepinfo.securityscheme%type,
448: i_partyid in NUMBER,
449: i_preNLSLang in iby_beplangs.beplang%type,

Line 446: i_activestatus in iby_bepinfo.activestatus%type,

442: i_leadtime in iby_bepinfo.leadtime%type,
443: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
444: i_holidayfile in iby_bepinfo.holidayfile%type,
445: i_fileSupport in iby_bepinfo.fileSupport%type,
446: i_activestatus in iby_bepinfo.activestatus%type,
447: i_securityscheme in iby_bepinfo.securityscheme%type,
448: i_partyid in NUMBER,
449: i_preNLSLang in iby_beplangs.beplang%type,
450: i_opt1NLSLang in iby_beplangs.beplang%type,

Line 447: i_securityscheme in iby_bepinfo.securityscheme%type,

443: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
444: i_holidayfile in iby_bepinfo.holidayfile%type,
445: i_fileSupport in iby_bepinfo.fileSupport%type,
446: i_activestatus in iby_bepinfo.activestatus%type,
447: i_securityscheme in iby_bepinfo.securityscheme%type,
448: i_partyid in NUMBER,
449: i_preNLSLang in iby_beplangs.beplang%type,
450: i_opt1NLSLang in iby_beplangs.beplang%type,
451: i_opt2NLSLang in iby_beplangs.beplang%type,

Line 452: i_object_version in iby_bepinfo.object_version_number%type)

448: i_partyid in NUMBER,
449: i_preNLSLang in iby_beplangs.beplang%type,
450: i_opt1NLSLang in iby_beplangs.beplang%type,
451: i_opt2NLSLang in iby_beplangs.beplang%type,
452: i_object_version in iby_bepinfo.object_version_number%type)
453: is
454:
455: l_instrtype iby_bepinfo.instrtype%type;
456:

Line 455: l_instrtype iby_bepinfo.instrtype%type;

451: i_opt2NLSLang in iby_beplangs.beplang%type,
452: i_object_version in iby_bepinfo.object_version_number%type)
453: is
454:
455: l_instrtype iby_bepinfo.instrtype%type;
456:
457: begin
458:
459: -- check for the bep name/suffix uniqueness before update

Line 478: UPDATE iby_bepinfo

474:
475: /*
476: ** update the row that matches the bepid;
477: */
478: UPDATE iby_bepinfo
479: SET name = i_bepname,
480: bepusername = i_bepusername,
481: beppassword = i_beppassword,
482: psusername = i_psusername,

Line 529: -- missing param for IBY_BEPINFO.INSTRTYPE

525:
526: -- This is similar to modBEPInfo(), however we add code to
527: -- to handle FND_API.G_MISS_XXX
528: -- As we add this as a new independent API, we also add the
529: -- missing param for IBY_BEPINFO.INSTRTYPE
530: -- FZ 5/20/02
531: procedure update_BEPInfo(
532: i_bepid in iby_bepinfo.bepid%type,
533: i_bepname in iby_bepinfo.name%type,

Line 532: i_bepid in iby_bepinfo.bepid%type,

528: -- As we add this as a new independent API, we also add the
529: -- missing param for IBY_BEPINFO.INSTRTYPE
530: -- FZ 5/20/02
531: procedure update_BEPInfo(
532: i_bepid in iby_bepinfo.bepid%type,
533: i_bepname in iby_bepinfo.name%type,
534: i_bepurl in iby_bepinfo.baseurl%type,
535: i_bepsuffix in iby_bepinfo.suffix%type,
536: i_bep_type in iby_bepinfo.bep_type%type,

Line 533: i_bepname in iby_bepinfo.name%type,

529: -- missing param for IBY_BEPINFO.INSTRTYPE
530: -- FZ 5/20/02
531: procedure update_BEPInfo(
532: i_bepid in iby_bepinfo.bepid%type,
533: i_bepname in iby_bepinfo.name%type,
534: i_bepurl in iby_bepinfo.baseurl%type,
535: i_bepsuffix in iby_bepinfo.suffix%type,
536: i_bep_type in iby_bepinfo.bep_type%type,
537: i_bepusername in iby_bepinfo.bepusername%type,

Line 534: i_bepurl in iby_bepinfo.baseurl%type,

530: -- FZ 5/20/02
531: procedure update_BEPInfo(
532: i_bepid in iby_bepinfo.bepid%type,
533: i_bepname in iby_bepinfo.name%type,
534: i_bepurl in iby_bepinfo.baseurl%type,
535: i_bepsuffix in iby_bepinfo.suffix%type,
536: i_bep_type in iby_bepinfo.bep_type%type,
537: i_bepusername in iby_bepinfo.bepusername%type,
538: i_beppassword in iby_bepinfo.beppassword%type,

Line 535: i_bepsuffix in iby_bepinfo.suffix%type,

531: procedure update_BEPInfo(
532: i_bepid in iby_bepinfo.bepid%type,
533: i_bepname in iby_bepinfo.name%type,
534: i_bepurl in iby_bepinfo.baseurl%type,
535: i_bepsuffix in iby_bepinfo.suffix%type,
536: i_bep_type in iby_bepinfo.bep_type%type,
537: i_bepusername in iby_bepinfo.bepusername%type,
538: i_beppassword in iby_bepinfo.beppassword%type,
539: i_psusername in iby_bepinfo.psusername%type,

Line 536: i_bep_type in iby_bepinfo.bep_type%type,

532: i_bepid in iby_bepinfo.bepid%type,
533: i_bepname in iby_bepinfo.name%type,
534: i_bepurl in iby_bepinfo.baseurl%type,
535: i_bepsuffix in iby_bepinfo.suffix%type,
536: i_bep_type in iby_bepinfo.bep_type%type,
537: i_bepusername in iby_bepinfo.bepusername%type,
538: i_beppassword in iby_bepinfo.beppassword%type,
539: i_psusername in iby_bepinfo.psusername%type,
540: i_pspassword in iby_bepinfo.pspassword%type,

Line 537: i_bepusername in iby_bepinfo.bepusername%type,

533: i_bepname in iby_bepinfo.name%type,
534: i_bepurl in iby_bepinfo.baseurl%type,
535: i_bepsuffix in iby_bepinfo.suffix%type,
536: i_bep_type in iby_bepinfo.bep_type%type,
537: i_bepusername in iby_bepinfo.bepusername%type,
538: i_beppassword in iby_bepinfo.beppassword%type,
539: i_psusername in iby_bepinfo.psusername%type,
540: i_pspassword in iby_bepinfo.pspassword%type,
541: i_adminurl in iby_bepinfo.adminurl%type,

Line 538: i_beppassword in iby_bepinfo.beppassword%type,

534: i_bepurl in iby_bepinfo.baseurl%type,
535: i_bepsuffix in iby_bepinfo.suffix%type,
536: i_bep_type in iby_bepinfo.bep_type%type,
537: i_bepusername in iby_bepinfo.bepusername%type,
538: i_beppassword in iby_bepinfo.beppassword%type,
539: i_psusername in iby_bepinfo.psusername%type,
540: i_pspassword in iby_bepinfo.pspassword%type,
541: i_adminurl in iby_bepinfo.adminurl%type,
542: i_login in iby_bepinfo.loginurl%type,

Line 539: i_psusername in iby_bepinfo.psusername%type,

535: i_bepsuffix in iby_bepinfo.suffix%type,
536: i_bep_type in iby_bepinfo.bep_type%type,
537: i_bepusername in iby_bepinfo.bepusername%type,
538: i_beppassword in iby_bepinfo.beppassword%type,
539: i_psusername in iby_bepinfo.psusername%type,
540: i_pspassword in iby_bepinfo.pspassword%type,
541: i_adminurl in iby_bepinfo.adminurl%type,
542: i_login in iby_bepinfo.loginurl%type,
543: i_logout in iby_bepinfo.logouturl%type,

Line 540: i_pspassword in iby_bepinfo.pspassword%type,

536: i_bep_type in iby_bepinfo.bep_type%type,
537: i_bepusername in iby_bepinfo.bepusername%type,
538: i_beppassword in iby_bepinfo.beppassword%type,
539: i_psusername in iby_bepinfo.psusername%type,
540: i_pspassword in iby_bepinfo.pspassword%type,
541: i_adminurl in iby_bepinfo.adminurl%type,
542: i_login in iby_bepinfo.loginurl%type,
543: i_logout in iby_bepinfo.logouturl%type,
544: i_supportedop in iby_bepinfo.supportedOp%type,

Line 541: i_adminurl in iby_bepinfo.adminurl%type,

537: i_bepusername in iby_bepinfo.bepusername%type,
538: i_beppassword in iby_bepinfo.beppassword%type,
539: i_psusername in iby_bepinfo.psusername%type,
540: i_pspassword in iby_bepinfo.pspassword%type,
541: i_adminurl in iby_bepinfo.adminurl%type,
542: i_login in iby_bepinfo.loginurl%type,
543: i_logout in iby_bepinfo.logouturl%type,
544: i_supportedop in iby_bepinfo.supportedOp%type,
545: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,

Line 542: i_login in iby_bepinfo.loginurl%type,

538: i_beppassword in iby_bepinfo.beppassword%type,
539: i_psusername in iby_bepinfo.psusername%type,
540: i_pspassword in iby_bepinfo.pspassword%type,
541: i_adminurl in iby_bepinfo.adminurl%type,
542: i_login in iby_bepinfo.loginurl%type,
543: i_logout in iby_bepinfo.logouturl%type,
544: i_supportedop in iby_bepinfo.supportedOp%type,
545: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
546: i_leadtime in iby_bepinfo.leadtime%type,

Line 543: i_logout in iby_bepinfo.logouturl%type,

539: i_psusername in iby_bepinfo.psusername%type,
540: i_pspassword in iby_bepinfo.pspassword%type,
541: i_adminurl in iby_bepinfo.adminurl%type,
542: i_login in iby_bepinfo.loginurl%type,
543: i_logout in iby_bepinfo.logouturl%type,
544: i_supportedop in iby_bepinfo.supportedOp%type,
545: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
546: i_leadtime in iby_bepinfo.leadtime%type,
547: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,

Line 544: i_supportedop in iby_bepinfo.supportedOp%type,

540: i_pspassword in iby_bepinfo.pspassword%type,
541: i_adminurl in iby_bepinfo.adminurl%type,
542: i_login in iby_bepinfo.loginurl%type,
543: i_logout in iby_bepinfo.logouturl%type,
544: i_supportedop in iby_bepinfo.supportedOp%type,
545: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
546: i_leadtime in iby_bepinfo.leadtime%type,
547: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
548: i_holidayfile in iby_bepinfo.holidayfile%type,

Line 546: i_leadtime in iby_bepinfo.leadtime%type,

542: i_login in iby_bepinfo.loginurl%type,
543: i_logout in iby_bepinfo.logouturl%type,
544: i_supportedop in iby_bepinfo.supportedOp%type,
545: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
546: i_leadtime in iby_bepinfo.leadtime%type,
547: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
548: i_holidayfile in iby_bepinfo.holidayfile%type,
549: i_fileSupport in iby_bepinfo.fileSupport%type,
550: i_activestatus in iby_bepinfo.activestatus%type,

Line 547: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,

543: i_logout in iby_bepinfo.logouturl%type,
544: i_supportedop in iby_bepinfo.supportedOp%type,
545: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
546: i_leadtime in iby_bepinfo.leadtime%type,
547: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
548: i_holidayfile in iby_bepinfo.holidayfile%type,
549: i_fileSupport in iby_bepinfo.fileSupport%type,
550: i_activestatus in iby_bepinfo.activestatus%type,
551: i_securityscheme in iby_bepinfo.securityscheme%type,

Line 548: i_holidayfile in iby_bepinfo.holidayfile%type,

544: i_supportedop in iby_bepinfo.supportedOp%type,
545: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
546: i_leadtime in iby_bepinfo.leadtime%type,
547: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
548: i_holidayfile in iby_bepinfo.holidayfile%type,
549: i_fileSupport in iby_bepinfo.fileSupport%type,
550: i_activestatus in iby_bepinfo.activestatus%type,
551: i_securityscheme in iby_bepinfo.securityscheme%type,
552: i_partyid in NUMBER,

Line 549: i_fileSupport in iby_bepinfo.fileSupport%type,

545: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
546: i_leadtime in iby_bepinfo.leadtime%type,
547: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
548: i_holidayfile in iby_bepinfo.holidayfile%type,
549: i_fileSupport in iby_bepinfo.fileSupport%type,
550: i_activestatus in iby_bepinfo.activestatus%type,
551: i_securityscheme in iby_bepinfo.securityscheme%type,
552: i_partyid in NUMBER,
553: i_preNLSLang in iby_beplangs.beplang%type,

Line 550: i_activestatus in iby_bepinfo.activestatus%type,

546: i_leadtime in iby_bepinfo.leadtime%type,
547: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
548: i_holidayfile in iby_bepinfo.holidayfile%type,
549: i_fileSupport in iby_bepinfo.fileSupport%type,
550: i_activestatus in iby_bepinfo.activestatus%type,
551: i_securityscheme in iby_bepinfo.securityscheme%type,
552: i_partyid in NUMBER,
553: i_preNLSLang in iby_beplangs.beplang%type,
554: i_opt1NLSLang in iby_beplangs.beplang%type,

Line 551: i_securityscheme in iby_bepinfo.securityscheme%type,

547: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type,
548: i_holidayfile in iby_bepinfo.holidayfile%type,
549: i_fileSupport in iby_bepinfo.fileSupport%type,
550: i_activestatus in iby_bepinfo.activestatus%type,
551: i_securityscheme in iby_bepinfo.securityscheme%type,
552: i_partyid in NUMBER,
553: i_preNLSLang in iby_beplangs.beplang%type,
554: i_opt1NLSLang in iby_beplangs.beplang%type,
555: i_opt2NLSLang in iby_beplangs.beplang%type,

Line 556: i_object_version in iby_bepinfo.object_version_number%type)

552: i_partyid in NUMBER,
553: i_preNLSLang in iby_beplangs.beplang%type,
554: i_opt1NLSLang in iby_beplangs.beplang%type,
555: i_opt2NLSLang in iby_beplangs.beplang%type,
556: i_object_version in iby_bepinfo.object_version_number%type)
557:
558: is
559: l_api_name CONSTANT VARCHAR2(30) := 'update_BEPInfo';
560:

Line 610: -- to null. However IBY_BEPINFO.NAME is a not null column

606:
607:
608: -- by the new App standard, if input is FND_API.G_MISS_CHAR
609: -- in update API, it means the caller wants to set the field
610: -- to null. However IBY_BEPINFO.NAME is a not null column
611: -- note it's ok for the input param to be null. In that case
612: -- the existing value in db is retained
613: IF i_bepname = FND_API.G_MISS_CHAR THEN
614: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');

Line 625: -- to null. However IBY_BEPINFO.SUFFIX is a not null column

621: END IF;
622:
623: -- by the new App standard, if input is FND_API.G_MISS_CHAR
624: -- in update API, it means the caller wants to set the field
625: -- to null. However IBY_BEPINFO.SUFFIX is a not null column
626: -- note it's ok for the input param to be null. In that case
627: -- the existing value in db is retained
628: IF i_bepsuffix = FND_API.G_MISS_CHAR THEN
629: fnd_message.set_name('IBY', 'IBY_G_INVALID_PARAM_ERR');

Line 641: UPDATE IBY_BEPINFO SET

637:
638:
639: -- update the row that matches the bepid;
640: -- should use OVN based locking
641: UPDATE IBY_BEPINFO SET
642: name = DECODE(i_bepname, NULL, name, i_bepname),
643: suffix = DECODE(i_bepsuffix, NULL, suffix, i_bepsuffix),
644: bepusername = DECODE(i_bepusername, NULL, bepusername, FND_API.G_MISS_CHAR, NULL, i_bepusername),
645: beppassword = DECODE(i_beppassword, NULL, beppassword, FND_API.G_MISS_CHAR, NULL, i_beppassword),

Line 705: procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,

701: ** o_login, o_logout.
702: ** o_cancsupport, io_depid
703: **
704: */
705: procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,
706: o_bepname out nocopy iby_bepinfo.name%type,
707: o_bepurl out nocopy iby_bepinfo.baseurl%type,
708: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
709: o_bep_type out nocopy iby_bepinfo.bep_type%type,

Line 706: o_bepname out nocopy iby_bepinfo.name%type,

702: ** o_cancsupport, io_depid
703: **
704: */
705: procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,
706: o_bepname out nocopy iby_bepinfo.name%type,
707: o_bepurl out nocopy iby_bepinfo.baseurl%type,
708: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
709: o_bep_type out nocopy iby_bepinfo.bep_type%type,
710: o_bepusername out nocopy iby_bepinfo.bepusername%type,

Line 707: o_bepurl out nocopy iby_bepinfo.baseurl%type,

703: **
704: */
705: procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,
706: o_bepname out nocopy iby_bepinfo.name%type,
707: o_bepurl out nocopy iby_bepinfo.baseurl%type,
708: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
709: o_bep_type out nocopy iby_bepinfo.bep_type%type,
710: o_bepusername out nocopy iby_bepinfo.bepusername%type,
711: o_beppassword out nocopy iby_bepinfo.beppassword%type,

Line 708: o_bepsuffix out nocopy iby_bepinfo.suffix%type,

704: */
705: procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,
706: o_bepname out nocopy iby_bepinfo.name%type,
707: o_bepurl out nocopy iby_bepinfo.baseurl%type,
708: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
709: o_bep_type out nocopy iby_bepinfo.bep_type%type,
710: o_bepusername out nocopy iby_bepinfo.bepusername%type,
711: o_beppassword out nocopy iby_bepinfo.beppassword%type,
712: o_psusername out nocopy iby_bepinfo.psusername%type,

Line 709: o_bep_type out nocopy iby_bepinfo.bep_type%type,

705: procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,
706: o_bepname out nocopy iby_bepinfo.name%type,
707: o_bepurl out nocopy iby_bepinfo.baseurl%type,
708: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
709: o_bep_type out nocopy iby_bepinfo.bep_type%type,
710: o_bepusername out nocopy iby_bepinfo.bepusername%type,
711: o_beppassword out nocopy iby_bepinfo.beppassword%type,
712: o_psusername out nocopy iby_bepinfo.psusername%type,
713: o_pspassword out nocopy iby_bepinfo.pspassword%type,

Line 710: o_bepusername out nocopy iby_bepinfo.bepusername%type,

706: o_bepname out nocopy iby_bepinfo.name%type,
707: o_bepurl out nocopy iby_bepinfo.baseurl%type,
708: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
709: o_bep_type out nocopy iby_bepinfo.bep_type%type,
710: o_bepusername out nocopy iby_bepinfo.bepusername%type,
711: o_beppassword out nocopy iby_bepinfo.beppassword%type,
712: o_psusername out nocopy iby_bepinfo.psusername%type,
713: o_pspassword out nocopy iby_bepinfo.pspassword%type,
714: o_adminurl out nocopy iby_bepinfo.adminurl%type,

Line 711: o_beppassword out nocopy iby_bepinfo.beppassword%type,

707: o_bepurl out nocopy iby_bepinfo.baseurl%type,
708: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
709: o_bep_type out nocopy iby_bepinfo.bep_type%type,
710: o_bepusername out nocopy iby_bepinfo.bepusername%type,
711: o_beppassword out nocopy iby_bepinfo.beppassword%type,
712: o_psusername out nocopy iby_bepinfo.psusername%type,
713: o_pspassword out nocopy iby_bepinfo.pspassword%type,
714: o_adminurl out nocopy iby_bepinfo.adminurl%type,
715: o_login out nocopy iby_bepinfo.loginurl%type,

Line 712: o_psusername out nocopy iby_bepinfo.psusername%type,

708: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
709: o_bep_type out nocopy iby_bepinfo.bep_type%type,
710: o_bepusername out nocopy iby_bepinfo.bepusername%type,
711: o_beppassword out nocopy iby_bepinfo.beppassword%type,
712: o_psusername out nocopy iby_bepinfo.psusername%type,
713: o_pspassword out nocopy iby_bepinfo.pspassword%type,
714: o_adminurl out nocopy iby_bepinfo.adminurl%type,
715: o_login out nocopy iby_bepinfo.loginurl%type,
716: o_logout out nocopy iby_bepinfo.logouturl%type,

Line 713: o_pspassword out nocopy iby_bepinfo.pspassword%type,

709: o_bep_type out nocopy iby_bepinfo.bep_type%type,
710: o_bepusername out nocopy iby_bepinfo.bepusername%type,
711: o_beppassword out nocopy iby_bepinfo.beppassword%type,
712: o_psusername out nocopy iby_bepinfo.psusername%type,
713: o_pspassword out nocopy iby_bepinfo.pspassword%type,
714: o_adminurl out nocopy iby_bepinfo.adminurl%type,
715: o_login out nocopy iby_bepinfo.loginurl%type,
716: o_logout out nocopy iby_bepinfo.logouturl%type,
717: o_supportedop out nocopy iby_bepinfo.supportedOp%type,

Line 714: o_adminurl out nocopy iby_bepinfo.adminurl%type,

710: o_bepusername out nocopy iby_bepinfo.bepusername%type,
711: o_beppassword out nocopy iby_bepinfo.beppassword%type,
712: o_psusername out nocopy iby_bepinfo.psusername%type,
713: o_pspassword out nocopy iby_bepinfo.pspassword%type,
714: o_adminurl out nocopy iby_bepinfo.adminurl%type,
715: o_login out nocopy iby_bepinfo.loginurl%type,
716: o_logout out nocopy iby_bepinfo.logouturl%type,
717: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
718: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,

Line 715: o_login out nocopy iby_bepinfo.loginurl%type,

711: o_beppassword out nocopy iby_bepinfo.beppassword%type,
712: o_psusername out nocopy iby_bepinfo.psusername%type,
713: o_pspassword out nocopy iby_bepinfo.pspassword%type,
714: o_adminurl out nocopy iby_bepinfo.adminurl%type,
715: o_login out nocopy iby_bepinfo.loginurl%type,
716: o_logout out nocopy iby_bepinfo.logouturl%type,
717: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
718: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
719: o_leadtime out nocopy iby_bepinfo.leadtime%type,

Line 716: o_logout out nocopy iby_bepinfo.logouturl%type,

712: o_psusername out nocopy iby_bepinfo.psusername%type,
713: o_pspassword out nocopy iby_bepinfo.pspassword%type,
714: o_adminurl out nocopy iby_bepinfo.adminurl%type,
715: o_login out nocopy iby_bepinfo.loginurl%type,
716: o_logout out nocopy iby_bepinfo.logouturl%type,
717: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
718: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
719: o_leadtime out nocopy iby_bepinfo.leadtime%type,
720: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,

Line 717: o_supportedop out nocopy iby_bepinfo.supportedOp%type,

713: o_pspassword out nocopy iby_bepinfo.pspassword%type,
714: o_adminurl out nocopy iby_bepinfo.adminurl%type,
715: o_login out nocopy iby_bepinfo.loginurl%type,
716: o_logout out nocopy iby_bepinfo.logouturl%type,
717: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
718: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
719: o_leadtime out nocopy iby_bepinfo.leadtime%type,
720: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
721: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,

Line 719: o_leadtime out nocopy iby_bepinfo.leadtime%type,

715: o_login out nocopy iby_bepinfo.loginurl%type,
716: o_logout out nocopy iby_bepinfo.logouturl%type,
717: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
718: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
719: o_leadtime out nocopy iby_bepinfo.leadtime%type,
720: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
721: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
722: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
723: o_activestatus out nocopy iby_bepinfo.activestatus%type,

Line 720: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,

716: o_logout out nocopy iby_bepinfo.logouturl%type,
717: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
718: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
719: o_leadtime out nocopy iby_bepinfo.leadtime%type,
720: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
721: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
722: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
723: o_activestatus out nocopy iby_bepinfo.activestatus%type,
724: o_securityscheme out nocopy iby_bepinfo.securityscheme%type,

Line 721: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,

717: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
718: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
719: o_leadtime out nocopy iby_bepinfo.leadtime%type,
720: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
721: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
722: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
723: o_activestatus out nocopy iby_bepinfo.activestatus%type,
724: o_securityscheme out nocopy iby_bepinfo.securityscheme%type,
725: o_partyid out nocopy NUMBER,

Line 722: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,

718: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
719: o_leadtime out nocopy iby_bepinfo.leadtime%type,
720: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
721: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
722: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
723: o_activestatus out nocopy iby_bepinfo.activestatus%type,
724: o_securityscheme out nocopy iby_bepinfo.securityscheme%type,
725: o_partyid out nocopy NUMBER,
726: o_preNLSLang out nocopy iby_beplangs.beplang%type,

Line 723: o_activestatus out nocopy iby_bepinfo.activestatus%type,

719: o_leadtime out nocopy iby_bepinfo.leadtime%type,
720: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
721: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
722: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
723: o_activestatus out nocopy iby_bepinfo.activestatus%type,
724: o_securityscheme out nocopy iby_bepinfo.securityscheme%type,
725: o_partyid out nocopy NUMBER,
726: o_preNLSLang out nocopy iby_beplangs.beplang%type,
727: o_opt1NLSLang out nocopy iby_beplangs.beplang%type,

Line 724: o_securityscheme out nocopy iby_bepinfo.securityscheme%type,

720: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
721: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
722: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
723: o_activestatus out nocopy iby_bepinfo.activestatus%type,
724: o_securityscheme out nocopy iby_bepinfo.securityscheme%type,
725: o_partyid out nocopy NUMBER,
726: o_preNLSLang out nocopy iby_beplangs.beplang%type,
727: o_opt1NLSLang out nocopy iby_beplangs.beplang%type,
728: o_opt2NLSLang out nocopy iby_beplangs.beplang%type,

Line 729: o_object_version out nocopy iby_bepinfo.object_version_number%type)

725: o_partyid out nocopy NUMBER,
726: o_preNLSLang out nocopy iby_beplangs.beplang%type,
727: o_opt1NLSLang out nocopy iby_beplangs.beplang%type,
728: o_opt2NLSLang out nocopy iby_beplangs.beplang%type,
729: o_object_version out nocopy iby_bepinfo.object_version_number%type)
730: is
731:
732: cursor c_bepinfo(ci_bepid in iby_bepinfo.bepid%type) is
733: SELECT name, baseurl, suffix, bep_type, bepusername, beppassword,

Line 732: cursor c_bepinfo(ci_bepid in iby_bepinfo.bepid%type) is

728: o_opt2NLSLang out nocopy iby_beplangs.beplang%type,
729: o_object_version out nocopy iby_bepinfo.object_version_number%type)
730: is
731:
732: cursor c_bepinfo(ci_bepid in iby_bepinfo.bepid%type) is
733: SELECT name, baseurl, suffix, bep_type, bepusername, beppassword,
734: supportedop, psusername, pspassword,
735: adminurl, loginurl, logouturl, leadtime, holidayfile,
736: srvridimmed, filesupport, activestatus,

Line 738: FROM iby_bepinfo

734: supportedop, psusername, pspassword,
735: adminurl, loginurl, logouturl, leadtime, holidayfile,
736: srvridimmed, filesupport, activestatus,
737: securityscheme, party_id, object_version_number
738: FROM iby_bepinfo
739: WHERE bepid = ci_bepid;
740:
741: cursor c_preNLSLang(ci_bepid in iby_bepinfo.bepid%type) is
742: SELECT beplang

Line 741: cursor c_preNLSLang(ci_bepid in iby_bepinfo.bepid%type) is

737: securityscheme, party_id, object_version_number
738: FROM iby_bepinfo
739: WHERE bepid = ci_bepid;
740:
741: cursor c_preNLSLang(ci_bepid in iby_bepinfo.bepid%type) is
742: SELECT beplang
743: FROM iby_beplangs
744: WHERE bepid = ci_bepid
745: AND preferred = 0;

Line 747: cursor c_opt1NLSLang(ci_bepid in iby_bepinfo.bepid%type) is

743: FROM iby_beplangs
744: WHERE bepid = ci_bepid
745: AND preferred = 0;
746:
747: cursor c_opt1NLSLang(ci_bepid in iby_bepinfo.bepid%type) is
748: SELECT beplang
749: FROM iby_beplangs
750: WHERE bepid = ci_bepid
751: AND preferred = 1;

Line 753: cursor c_opt2NLSLang(ci_bepid in iby_bepinfo.bepid%type) is

749: FROM iby_beplangs
750: WHERE bepid = ci_bepid
751: AND preferred = 1;
752:
753: cursor c_opt2NLSLang(ci_bepid in iby_bepinfo.bepid%type) is
754: SELECT beplang
755: FROM iby_beplangs
756: WHERE bepid = ci_bepid
757: AND preferred = 2;

Line 818: procedure setBEPStatus(i_bepid in iby_bepinfo.bepid%type,

814: ** In : i_bepid, i_status.
815: ** Out : o_flag
816: **
817: */
818: procedure setBEPStatus(i_bepid in iby_bepinfo.bepid%type,
819: i_status in iby_bepinfo.activestatus%type,
820: o_flag out nocopy int)
821: is
822:

Line 819: i_status in iby_bepinfo.activestatus%type,

815: ** Out : o_flag
816: **
817: */
818: procedure setBEPStatus(i_bepid in iby_bepinfo.bepid%type,
819: i_status in iby_bepinfo.activestatus%type,
820: o_flag out nocopy int)
821: is
822:
823: begin

Line 827: UPDATE iby_bepinfo

823: begin
824:
825: o_flag := 0;
826:
827: UPDATE iby_bepinfo
828: SET activestatus = i_status,
829: last_update_date = sysdate,
830: last_updated_by = fnd_global.user_id,
831: last_update_login = fnd_global.login_id,

Line 853: function getBEPName(i_id iby_bepinfo.bepid%type)

849: ** Function: getBepName
850: ** Purpose: return the bep name that matches the id passed
851: */
852:
853: function getBEPName(i_id iby_bepinfo.bepid%type)
854: return varchar
855: is
856:
857: l_bepname iby_bepinfo.name%type;

Line 857: l_bepname iby_bepinfo.name%type;

853: function getBEPName(i_id iby_bepinfo.bepid%type)
854: return varchar
855: is
856:
857: l_bepname iby_bepinfo.name%type;
858:
859: cursor c_bep(ci_id iby_bepinfo.bepid%type)
860: is
861: SELECT name

Line 859: cursor c_bep(ci_id iby_bepinfo.bepid%type)

855: is
856:
857: l_bepname iby_bepinfo.name%type;
858:
859: cursor c_bep(ci_id iby_bepinfo.bepid%type)
860: is
861: SELECT name
862: FROM iby_bepinfo
863: WHERE bepid = ci_id;

Line 862: FROM iby_bepinfo

858:
859: cursor c_bep(ci_id iby_bepinfo.bepid%type)
860: is
861: SELECT name
862: FROM iby_bepinfo
863: WHERE bepid = ci_id;
864:
865: BEGIN
866: IF (c_bep%isopen) THEN

Line 885: function getBEPId(i_name iby_bepinfo.name%type)

881: /*
882: ** Function: getBEPId.
883: ** Purpose: returnt the bep id that matches the name passed.
884: */
885: function getBEPId(i_name iby_bepinfo.name%type)
886: return int
887: is
888:
889: l_flag boolean := false;

Line 890: l_bepid iby_bepinfo.bepid%type;

886: return int
887: is
888:
889: l_flag boolean := false;
890: l_bepid iby_bepinfo.bepid%type;
891:
892: cursor c_bep(ci_name iby_bepinfo.name%type)
893: is
894: select bepid

Line 892: cursor c_bep(ci_name iby_bepinfo.name%type)

888:
889: l_flag boolean := false;
890: l_bepid iby_bepinfo.bepid%type;
891:
892: cursor c_bep(ci_name iby_bepinfo.name%type)
893: is
894: select bepid
895: from iby_bepinfo
896: where name = ci_name;

Line 895: from iby_bepinfo

891:
892: cursor c_bep(ci_name iby_bepinfo.name%type)
893: is
894: select bepid
895: from iby_bepinfo
896: where name = ci_name;
897:
898: begin
899:

Line 920: end iby_bepinfo_pkg;

916: end getBEPId;
917:
918:
919:
920: end iby_bepinfo_pkg;