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_PAYEE_PKG dependencies on IBY_PAYEE

Line 1: package body iby_payee_pkg as

1: package body iby_payee_pkg as
2: /*$Header: ibypyeeb.pls 120.1 2005/07/26 17:26:59 rameshsh ship $*/
3:
4:
5: /*

Line 9: function payeeNameExists (i_name in iby_payee.name%type,

5: /*
6: ** Function: payeeNameExists.
7: ** Purpose: Check if any payee Name already exists in the system.
8: */
9: function payeeNameExists (i_name in iby_payee.name%type,
10: i_payeeid in iby_payee.payeeid%type )
11: -- when payeeid is '', we are adding a new one
12: -- otherwise it's update for an existing one
13: return boolean

Line 10: i_payeeid in iby_payee.payeeid%type )

6: ** Function: payeeNameExists.
7: ** Purpose: Check if any payee Name already exists in the system.
8: */
9: function payeeNameExists (i_name in iby_payee.name%type,
10: i_payeeid in iby_payee.payeeid%type )
11: -- when payeeid is '', we are adding a new one
12: -- otherwise it's update for an existing one
13: return boolean
14: is

Line 16: l_name iby_payee.name%type;

12: -- otherwise it's update for an existing one
13: return boolean
14: is
15: l_flag boolean := false;
16: l_name iby_payee.name%type;
17:
18: -- for modify
19: cursor c_payee(ci_name in iby_payee.name%type,
20: ci_payeeid in iby_payee.payeeid%type) is

Line 19: cursor c_payee(ci_name in iby_payee.name%type,

15: l_flag boolean := false;
16: l_name iby_payee.name%type;
17:
18: -- for modify
19: cursor c_payee(ci_name in iby_payee.name%type,
20: ci_payeeid in iby_payee.payeeid%type) is
21: SELECT name
22: FROM iby_payee
23: WHERE name = ci_name AND

Line 20: ci_payeeid in iby_payee.payeeid%type) is

16: l_name iby_payee.name%type;
17:
18: -- for modify
19: cursor c_payee(ci_name in iby_payee.name%type,
20: ci_payeeid in iby_payee.payeeid%type) is
21: SELECT name
22: FROM iby_payee
23: WHERE name = ci_name AND
24: payeeid <> ci_payeeid;

Line 22: FROM iby_payee

18: -- for modify
19: cursor c_payee(ci_name in iby_payee.name%type,
20: ci_payeeid in iby_payee.payeeid%type) is
21: SELECT name
22: FROM iby_payee
23: WHERE name = ci_name AND
24: payeeid <> ci_payeeid;
25:
26: -- for create

Line 27: cursor c_payee2(ci_name in iby_payee.name%type) is

23: WHERE name = ci_name AND
24: payeeid <> ci_payeeid;
25:
26: -- for create
27: cursor c_payee2(ci_name in iby_payee.name%type) is
28:
29: SELECT name
30: FROM iby_payee
31: WHERE name = ci_name;

Line 30: FROM iby_payee

26: -- for create
27: cursor c_payee2(ci_name in iby_payee.name%type) is
28:
29: SELECT name
30: FROM iby_payee
31: WHERE name = ci_name;
32:
33: begin
34: if ( c_payee%isopen) then

Line 68: function payeeExists(i_ecappid in iby_payee.ecappid%type,

64: /*
65: ** Function: payeeExists.
66: ** Purpose: Check if the specified payeeid and ecappid exists or not.
67: */
68: function payeeExists(i_ecappid in iby_payee.ecappid%type,
69: i_payeeid in iby_payee.payeeid%type)
70: return boolean
71: is
72: l_payeeid iby_payee.payeeid%type;

Line 69: i_payeeid in iby_payee.payeeid%type)

65: ** Function: payeeExists.
66: ** Purpose: Check if the specified payeeid and ecappid exists or not.
67: */
68: function payeeExists(i_ecappid in iby_payee.ecappid%type,
69: i_payeeid in iby_payee.payeeid%type)
70: return boolean
71: is
72: l_payeeid iby_payee.payeeid%type;
73: l_flag boolean := false;

Line 72: l_payeeid iby_payee.payeeid%type;

68: function payeeExists(i_ecappid in iby_payee.ecappid%type,
69: i_payeeid in iby_payee.payeeid%type)
70: return boolean
71: is
72: l_payeeid iby_payee.payeeid%type;
73: l_flag boolean := false;
74: cursor c_payeeid
75: (ci_payeeid iby_payee.payeeid%type)
76: is

Line 75: (ci_payeeid iby_payee.payeeid%type)

71: is
72: l_payeeid iby_payee.payeeid%type;
73: l_flag boolean := false;
74: cursor c_payeeid
75: (ci_payeeid iby_payee.payeeid%type)
76: is
77: SELECT payeeid
78: FROM iby_payee
79: WHERE payeeid = ci_payeeid; -- no longer touches ecappid

Line 78: FROM iby_payee

74: cursor c_payeeid
75: (ci_payeeid iby_payee.payeeid%type)
76: is
77: SELECT payeeid
78: FROM iby_payee
79: WHERE payeeid = ci_payeeid; -- no longer touches ecappid
80: begin
81: if ( c_payeeid%isopen) then
82: close c_payeeid;

Line 104: function payeeActive(i_ecappid in iby_payee.ecappid%type,

100: /*
101: ** Function: payeeActive.
102: ** Purpose: Check if the specified payeeid and ecappid is active or not.
103: */
104: function payeeActive(i_ecappid in iby_payee.ecappid%type,
105: i_payeeid in iby_payee.payeeid%type)
106: return boolean
107: is
108: l_payeeid iby_payee.payeeid%type;

Line 105: i_payeeid in iby_payee.payeeid%type)

101: ** Function: payeeActive.
102: ** Purpose: Check if the specified payeeid and ecappid is active or not.
103: */
104: function payeeActive(i_ecappid in iby_payee.ecappid%type,
105: i_payeeid in iby_payee.payeeid%type)
106: return boolean
107: is
108: l_payeeid iby_payee.payeeid%type;
109: l_flag boolean := false;

Line 108: l_payeeid iby_payee.payeeid%type;

104: function payeeActive(i_ecappid in iby_payee.ecappid%type,
105: i_payeeid in iby_payee.payeeid%type)
106: return boolean
107: is
108: l_payeeid iby_payee.payeeid%type;
109: l_flag boolean := false;
110: cursor c_payeeid (
111: ci_payeeid iby_payee.payeeid%type)
112: is

Line 111: ci_payeeid iby_payee.payeeid%type)

107: is
108: l_payeeid iby_payee.payeeid%type;
109: l_flag boolean := false;
110: cursor c_payeeid (
111: ci_payeeid iby_payee.payeeid%type)
112: is
113: select payeeid from iby_payee
114: where payeeid = ci_payeeid
115: and upper(activestatus) = 'Y';

Line 113: select payeeid from iby_payee

109: l_flag boolean := false;
110: cursor c_payeeid (
111: ci_payeeid iby_payee.payeeid%type)
112: is
113: select payeeid from iby_payee
114: where payeeid = ci_payeeid
115: and upper(activestatus) = 'Y';
116: begin
117: if ( c_payeeid%isopen) then

Line 138: ** Purpose: creates a payee object in iby_payee.

134:
135:
136: /*
137: ** Procedure: createPayee.
138: ** Purpose: creates a payee object in iby_payee.
139: ** parameters: i_payeeid, id of the payee that is passed by ec application.
140: ** ecappid, id of the ecapplication.
141: */
142: procedure createPayee(i_ecappid in iby_ecapp.ecappid%type,

Line 143: i_payeeid in iby_payee.payeeid%type,

139: ** parameters: i_payeeid, id of the payee that is passed by ec application.
140: ** ecappid, id of the ecapplication.
141: */
142: procedure createPayee(i_ecappid in iby_ecapp.ecappid%type,
143: i_payeeid in iby_payee.payeeid%type,
144: i_payeename in iby_payee.name%type,
145: i_supportedOp in iby_payee.supportedOp%type,
146: i_username in iby_payee.username%type,
147: i_password in iby_payee.password%type,

Line 144: i_payeename in iby_payee.name%type,

140: ** ecappid, id of the ecapplication.
141: */
142: procedure createPayee(i_ecappid in iby_ecapp.ecappid%type,
143: i_payeeid in iby_payee.payeeid%type,
144: i_payeename in iby_payee.name%type,
145: i_supportedOp in iby_payee.supportedOp%type,
146: i_username in iby_payee.username%type,
147: i_password in iby_payee.password%type,
148: i_activestatus in iby_payee.activeStatus%type,

Line 145: i_supportedOp in iby_payee.supportedOp%type,

141: */
142: procedure createPayee(i_ecappid in iby_ecapp.ecappid%type,
143: i_payeeid in iby_payee.payeeid%type,
144: i_payeename in iby_payee.name%type,
145: i_supportedOp in iby_payee.supportedOp%type,
146: i_username in iby_payee.username%type,
147: i_password in iby_payee.password%type,
148: i_activestatus in iby_payee.activeStatus%type,
149: i_threshold in iby_payee.threshold%type,

Line 146: i_username in iby_payee.username%type,

142: procedure createPayee(i_ecappid in iby_ecapp.ecappid%type,
143: i_payeeid in iby_payee.payeeid%type,
144: i_payeename in iby_payee.name%type,
145: i_supportedOp in iby_payee.supportedOp%type,
146: i_username in iby_payee.username%type,
147: i_password in iby_payee.password%type,
148: i_activestatus in iby_payee.activeStatus%type,
149: i_threshold in iby_payee.threshold%type,
150: i_risk_enabled in iby_payee.risk_enabled%type,

Line 147: i_password in iby_payee.password%type,

143: i_payeeid in iby_payee.payeeid%type,
144: i_payeename in iby_payee.name%type,
145: i_supportedOp in iby_payee.supportedOp%type,
146: i_username in iby_payee.username%type,
147: i_password in iby_payee.password%type,
148: i_activestatus in iby_payee.activeStatus%type,
149: i_threshold in iby_payee.threshold%type,
150: i_risk_enabled in iby_payee.risk_enabled%type,
151: i_bepids in JTF_NUMBER_TABLE,

Line 148: i_activestatus in iby_payee.activeStatus%type,

144: i_payeename in iby_payee.name%type,
145: i_supportedOp in iby_payee.supportedOp%type,
146: i_username in iby_payee.username%type,
147: i_password in iby_payee.password%type,
148: i_activestatus in iby_payee.activeStatus%type,
149: i_threshold in iby_payee.threshold%type,
150: i_risk_enabled in iby_payee.risk_enabled%type,
151: i_bepids in JTF_NUMBER_TABLE,
152: i_bepkeys in varchar2,

Line 149: i_threshold in iby_payee.threshold%type,

145: i_supportedOp in iby_payee.supportedOp%type,
146: i_username in iby_payee.username%type,
147: i_password in iby_payee.password%type,
148: i_activestatus in iby_payee.activeStatus%type,
149: i_threshold in iby_payee.threshold%type,
150: i_risk_enabled in iby_payee.risk_enabled%type,
151: i_bepids in JTF_NUMBER_TABLE,
152: i_bepkeys in varchar2,
153: i_bepdefaults in varchar2,

Line 150: i_risk_enabled in iby_payee.risk_enabled%type,

146: i_username in iby_payee.username%type,
147: i_password in iby_payee.password%type,
148: i_activestatus in iby_payee.activeStatus%type,
149: i_threshold in iby_payee.threshold%type,
150: i_risk_enabled in iby_payee.risk_enabled%type,
151: i_bepids in JTF_NUMBER_TABLE,
152: i_bepkeys in varchar2,
153: i_bepdefaults in varchar2,
154: i_mcc in number,

Line 155: i_secenable IN iby_payee.security_enabled%TYPE

151: i_bepids in JTF_NUMBER_TABLE,
152: i_bepkeys in varchar2,
153: i_bepdefaults in varchar2,
154: i_mcc in number,
155: i_secenable IN iby_payee.security_enabled%TYPE
156: )
157:
158: is
159: l_bepid_tab number_tab;

Line 182: ** make an entry into iby_payee table.

178: END IF;
179:
180: /*
181: ** call payeeExists to verfify if payee already exists or not. if not
182: ** make an entry into iby_payee table.
183: */
184:
185: if (not payeeExists( i_ecappid,i_payeeid) ) then
186:

Line 187: select iby_payee_s.NEXTVAL

183: */
184:
185: if (not payeeExists( i_ecappid,i_payeeid) ) then
186:
187: select iby_payee_s.NEXTVAL
188: into mpayeeid
189: from dual;
190:
191: INSERT INTO iby_payee ( mpayeeid,ecappid, payeeid, name, supportedop,

Line 191: INSERT INTO iby_payee ( mpayeeid,ecappid, payeeid, name, supportedop,

187: select iby_payee_s.NEXTVAL
188: into mpayeeid
189: from dual;
190:
191: INSERT INTO iby_payee ( mpayeeid,ecappid, payeeid, name, supportedop,
192: username, password, activestatus,
193: threshold, risk_enabled, mcc_code, security_enabled,
194: last_update_date, last_updated_by,
195: creation_date, created_by,

Line 229: procedure setPayeeStatus(i_ecappid in iby_payee.ecappid%type,

225: ** Change the active status of the payee
226: **
227: ** ecappid is no longer used
228: */
229: procedure setPayeeStatus(i_ecappid in iby_payee.ecappid%type,
230: i_payeeid in iby_payee.payeeid%type,
231: i_activestatus in iby_payee.activeStatus%type)
232: is
233:

Line 230: i_payeeid in iby_payee.payeeid%type,

226: **
227: ** ecappid is no longer used
228: */
229: procedure setPayeeStatus(i_ecappid in iby_payee.ecappid%type,
230: i_payeeid in iby_payee.payeeid%type,
231: i_activestatus in iby_payee.activeStatus%type)
232: is
233:
234: begin

Line 231: i_activestatus in iby_payee.activeStatus%type)

227: ** ecappid is no longer used
228: */
229: procedure setPayeeStatus(i_ecappid in iby_payee.ecappid%type,
230: i_payeeid in iby_payee.payeeid%type,
231: i_activestatus in iby_payee.activeStatus%type)
232: is
233:
234: begin
235: if (payeeExists(i_ecappid, i_payeeid) ) then

Line 236: UPDATE iby_payee

232: is
233:
234: begin
235: if (payeeExists(i_ecappid, i_payeeid) ) then
236: UPDATE iby_payee
237: SET activestatus = i_activestatus,
238: last_update_date = sysdate,
239: last_updated_by = fnd_global.user_id,
240: last_update_login = fnd_global.login_id

Line 253: ** Purpose: creates a payee object in iby_payee.

249:
250:
251: /*
252: ** Procedure: modifyPayee.
253: ** Purpose: creates a payee object in iby_payee.
254: ** parameters: i_payeeid, id of the payee that is passed by ec application.
255: ** ecappid, id of the ecapplication.
256: ** ecappid is no longer used
257: */

Line 259: i_payeeid in iby_payee.payeeid%type,

255: ** ecappid, id of the ecapplication.
256: ** ecappid is no longer used
257: */
258: procedure modifyPayee(i_ecappid in iby_ecapp.ecappid%type,
259: i_payeeid in iby_payee.payeeid%type,
260: i_payeename in iby_payee.name%type,
261: i_supportedOp in iby_payee.supportedOp%type,
262: i_username in iby_payee.username%type,
263: i_password in iby_payee.password%type,

Line 260: i_payeename in iby_payee.name%type,

256: ** ecappid is no longer used
257: */
258: procedure modifyPayee(i_ecappid in iby_ecapp.ecappid%type,
259: i_payeeid in iby_payee.payeeid%type,
260: i_payeename in iby_payee.name%type,
261: i_supportedOp in iby_payee.supportedOp%type,
262: i_username in iby_payee.username%type,
263: i_password in iby_payee.password%type,
264: i_activestatus in iby_payee.activeStatus%type,

Line 261: i_supportedOp in iby_payee.supportedOp%type,

257: */
258: procedure modifyPayee(i_ecappid in iby_ecapp.ecappid%type,
259: i_payeeid in iby_payee.payeeid%type,
260: i_payeename in iby_payee.name%type,
261: i_supportedOp in iby_payee.supportedOp%type,
262: i_username in iby_payee.username%type,
263: i_password in iby_payee.password%type,
264: i_activestatus in iby_payee.activeStatus%type,
265: i_threshold in iby_payee.threshold%type,

Line 262: i_username in iby_payee.username%type,

258: procedure modifyPayee(i_ecappid in iby_ecapp.ecappid%type,
259: i_payeeid in iby_payee.payeeid%type,
260: i_payeename in iby_payee.name%type,
261: i_supportedOp in iby_payee.supportedOp%type,
262: i_username in iby_payee.username%type,
263: i_password in iby_payee.password%type,
264: i_activestatus in iby_payee.activeStatus%type,
265: i_threshold in iby_payee.threshold%type,
266: i_risk_enabled in iby_payee.risk_enabled%type,

Line 263: i_password in iby_payee.password%type,

259: i_payeeid in iby_payee.payeeid%type,
260: i_payeename in iby_payee.name%type,
261: i_supportedOp in iby_payee.supportedOp%type,
262: i_username in iby_payee.username%type,
263: i_password in iby_payee.password%type,
264: i_activestatus in iby_payee.activeStatus%type,
265: i_threshold in iby_payee.threshold%type,
266: i_risk_enabled in iby_payee.risk_enabled%type,
267: i_bepids in JTF_NUMBER_TABLE,

Line 264: i_activestatus in iby_payee.activeStatus%type,

260: i_payeename in iby_payee.name%type,
261: i_supportedOp in iby_payee.supportedOp%type,
262: i_username in iby_payee.username%type,
263: i_password in iby_payee.password%type,
264: i_activestatus in iby_payee.activeStatus%type,
265: i_threshold in iby_payee.threshold%type,
266: i_risk_enabled in iby_payee.risk_enabled%type,
267: i_bepids in JTF_NUMBER_TABLE,
268: i_bepkeys in varchar2,

Line 265: i_threshold in iby_payee.threshold%type,

261: i_supportedOp in iby_payee.supportedOp%type,
262: i_username in iby_payee.username%type,
263: i_password in iby_payee.password%type,
264: i_activestatus in iby_payee.activeStatus%type,
265: i_threshold in iby_payee.threshold%type,
266: i_risk_enabled in iby_payee.risk_enabled%type,
267: i_bepids in JTF_NUMBER_TABLE,
268: i_bepkeys in varchar2,
269: i_bepdefaults in varchar2,

Line 266: i_risk_enabled in iby_payee.risk_enabled%type,

262: i_username in iby_payee.username%type,
263: i_password in iby_payee.password%type,
264: i_activestatus in iby_payee.activeStatus%type,
265: i_threshold in iby_payee.threshold%type,
266: i_risk_enabled in iby_payee.risk_enabled%type,
267: i_bepids in JTF_NUMBER_TABLE,
268: i_bepkeys in varchar2,
269: i_bepdefaults in varchar2,
270: i_mcc in number,

Line 271: i_secenable IN iby_payee.security_enabled%TYPE,

267: i_bepids in JTF_NUMBER_TABLE,
268: i_bepkeys in varchar2,
269: i_bepdefaults in varchar2,
270: i_mcc in number,
271: i_secenable IN iby_payee.security_enabled%TYPE,
272: i_object_version in iby_payee.object_version_number%type
273: )
274: is
275: l_bepid_tab number_tab;

Line 272: i_object_version in iby_payee.object_version_number%type

268: i_bepkeys in varchar2,
269: i_bepdefaults in varchar2,
270: i_mcc in number,
271: i_secenable IN iby_payee.security_enabled%TYPE,
272: i_object_version in iby_payee.object_version_number%type
273: )
274: is
275: l_bepid_tab number_tab;
276: l_bepkey_tab varchar_tab;

Line 294: UPDATE iby_payee

290: IF (payeeNameExists(i_payeename, i_payeeid)) THEN
291: raise_application_error(-20000, 'IBY_20514#', FALSE);
292: END IF;
293:
294: UPDATE iby_payee
295: SET name= i_payeename,
296: supportedOp = i_supportedOp,
297: username = i_username,
298: password = i_password,

Line 390: end iby_payee_pkg;

386: counter := ddindx;
387:
388: end getNumberTables;
389:
390: end iby_payee_pkg;