APPS.IBY_PAYEE_PKG dependencies on IBY_PAYEE

Line 1: package iby_payee_pkg AUTHID CURRENT_USER as

1: package iby_payee_pkg AUTHID CURRENT_USER as
2: /*$Header: ibypyees.pls 120.1 2005/07/26 17:26:52 rameshsh ship $*/
3:
4: /*
5: ** Procedure: createPayee.

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

2: /*$Header: ibypyees.pls 120.1 2005/07/26 17:26:52 rameshsh ship $*/
3:
4: /*
5: ** Procedure: createPayee.
6: ** Purpose: creates a payee object in iby_payee.
7: ** parameters: i_payeeid, id of the payee that is passed by ec application.
8: ** ecappid, id of the ecapplication.
9: */
10: procedure createPayee(i_ecappid in iby_ecapp.ecappid%type,

Line 11: i_payeeid in iby_payee.payeeid%type,

7: ** parameters: i_payeeid, id of the payee that is passed by ec application.
8: ** ecappid, id of the ecapplication.
9: */
10: procedure createPayee(i_ecappid in iby_ecapp.ecappid%type,
11: i_payeeid in iby_payee.payeeid%type,
12: i_payeename in iby_payee.name%type,
13: i_supportedOp in iby_payee.supportedOp%type,
14: i_username in iby_payee.username%type,
15: i_password in iby_payee.password%type,

Line 12: i_payeename in iby_payee.name%type,

8: ** ecappid, id of the ecapplication.
9: */
10: procedure createPayee(i_ecappid in iby_ecapp.ecappid%type,
11: i_payeeid in iby_payee.payeeid%type,
12: i_payeename in iby_payee.name%type,
13: i_supportedOp in iby_payee.supportedOp%type,
14: i_username in iby_payee.username%type,
15: i_password in iby_payee.password%type,
16: i_activestatus in iby_payee.activeStatus%type,

Line 13: i_supportedOp in iby_payee.supportedOp%type,

9: */
10: procedure createPayee(i_ecappid in iby_ecapp.ecappid%type,
11: i_payeeid in iby_payee.payeeid%type,
12: i_payeename in iby_payee.name%type,
13: i_supportedOp in iby_payee.supportedOp%type,
14: i_username in iby_payee.username%type,
15: i_password in iby_payee.password%type,
16: i_activestatus in iby_payee.activeStatus%type,
17: i_threshold in iby_payee.threshold%type,

Line 14: i_username in iby_payee.username%type,

10: procedure createPayee(i_ecappid in iby_ecapp.ecappid%type,
11: i_payeeid in iby_payee.payeeid%type,
12: i_payeename in iby_payee.name%type,
13: i_supportedOp in iby_payee.supportedOp%type,
14: i_username in iby_payee.username%type,
15: i_password in iby_payee.password%type,
16: i_activestatus in iby_payee.activeStatus%type,
17: i_threshold in iby_payee.threshold%type,
18: i_risk_enabled in iby_payee.risk_enabled%type,

Line 15: i_password in iby_payee.password%type,

11: i_payeeid in iby_payee.payeeid%type,
12: i_payeename in iby_payee.name%type,
13: i_supportedOp in iby_payee.supportedOp%type,
14: i_username in iby_payee.username%type,
15: i_password in iby_payee.password%type,
16: i_activestatus in iby_payee.activeStatus%type,
17: i_threshold in iby_payee.threshold%type,
18: i_risk_enabled in iby_payee.risk_enabled%type,
19: i_bepids in JTF_NUMBER_TABLE,

Line 16: i_activestatus in iby_payee.activeStatus%type,

12: i_payeename in iby_payee.name%type,
13: i_supportedOp in iby_payee.supportedOp%type,
14: i_username in iby_payee.username%type,
15: i_password in iby_payee.password%type,
16: i_activestatus in iby_payee.activeStatus%type,
17: i_threshold in iby_payee.threshold%type,
18: i_risk_enabled in iby_payee.risk_enabled%type,
19: i_bepids in JTF_NUMBER_TABLE,
20: i_bepkeys in varchar2,

Line 17: i_threshold in iby_payee.threshold%type,

13: i_supportedOp in iby_payee.supportedOp%type,
14: i_username in iby_payee.username%type,
15: i_password in iby_payee.password%type,
16: i_activestatus in iby_payee.activeStatus%type,
17: i_threshold in iby_payee.threshold%type,
18: i_risk_enabled in iby_payee.risk_enabled%type,
19: i_bepids in JTF_NUMBER_TABLE,
20: i_bepkeys in varchar2,
21: i_bepdefaults in varchar2,

Line 18: i_risk_enabled in iby_payee.risk_enabled%type,

14: i_username in iby_payee.username%type,
15: i_password in iby_payee.password%type,
16: i_activestatus in iby_payee.activeStatus%type,
17: i_threshold in iby_payee.threshold%type,
18: i_risk_enabled in iby_payee.risk_enabled%type,
19: i_bepids in JTF_NUMBER_TABLE,
20: i_bepkeys in varchar2,
21: i_bepdefaults in varchar2,
22: i_mcc in number,

Line 23: i_secenable IN iby_payee.security_enabled%TYPE

19: i_bepids in JTF_NUMBER_TABLE,
20: i_bepkeys in varchar2,
21: i_bepdefaults in varchar2,
22: i_mcc in number,
23: i_secenable IN iby_payee.security_enabled%TYPE
24: );
25:
26:
27: /*

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

27: /*
28: ** Procedure activatePayee
29: ** Set the active status of the payee
30: */
31: procedure setPayeeStatus(i_ecappid in iby_payee.ecappid%type,
32: i_payeeid in iby_payee.payeeid%type,
33: i_activestatus in iby_payee.activeStatus%type);
34:
35:

Line 32: i_payeeid in iby_payee.payeeid%type,

28: ** Procedure activatePayee
29: ** Set the active status of the payee
30: */
31: procedure setPayeeStatus(i_ecappid in iby_payee.ecappid%type,
32: i_payeeid in iby_payee.payeeid%type,
33: i_activestatus in iby_payee.activeStatus%type);
34:
35:
36: /*

Line 33: i_activestatus in iby_payee.activeStatus%type);

29: ** Set the active status of the payee
30: */
31: procedure setPayeeStatus(i_ecappid in iby_payee.ecappid%type,
32: i_payeeid in iby_payee.payeeid%type,
33: i_activestatus in iby_payee.activeStatus%type);
34:
35:
36: /*
37: ** Procedure: modifyPayee.

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

34:
35:
36: /*
37: ** Procedure: modifyPayee.
38: ** Purpose: creates a payee object in iby_payee.
39: ** parameters: i_payeeid, id of the payee that is passed by ec application.
40: ** ecappid, id of the ecapplication.
41: */
42: procedure modifyPayee(i_ecappid in iby_ecapp.ecappid%type,

Line 43: i_payeeid in iby_payee.payeeid%type,

39: ** parameters: i_payeeid, id of the payee that is passed by ec application.
40: ** ecappid, id of the ecapplication.
41: */
42: procedure modifyPayee(i_ecappid in iby_ecapp.ecappid%type,
43: i_payeeid in iby_payee.payeeid%type,
44: i_payeename in iby_payee.name%type,
45: i_supportedOp in iby_payee.supportedOp%type,
46: i_username in iby_payee.username%type,
47: i_password in iby_payee.password%type,

Line 44: i_payeename in iby_payee.name%type,

40: ** ecappid, id of the ecapplication.
41: */
42: procedure modifyPayee(i_ecappid in iby_ecapp.ecappid%type,
43: i_payeeid in iby_payee.payeeid%type,
44: i_payeename in iby_payee.name%type,
45: i_supportedOp in iby_payee.supportedOp%type,
46: i_username in iby_payee.username%type,
47: i_password in iby_payee.password%type,
48: i_activestatus in iby_payee.activeStatus%type,

Line 45: i_supportedOp in iby_payee.supportedOp%type,

41: */
42: procedure modifyPayee(i_ecappid in iby_ecapp.ecappid%type,
43: i_payeeid in iby_payee.payeeid%type,
44: i_payeename in iby_payee.name%type,
45: i_supportedOp in iby_payee.supportedOp%type,
46: i_username in iby_payee.username%type,
47: i_password in iby_payee.password%type,
48: i_activestatus in iby_payee.activeStatus%type,
49: i_threshold in iby_payee.threshold%type,

Line 46: i_username in iby_payee.username%type,

42: procedure modifyPayee(i_ecappid in iby_ecapp.ecappid%type,
43: i_payeeid in iby_payee.payeeid%type,
44: i_payeename in iby_payee.name%type,
45: i_supportedOp in iby_payee.supportedOp%type,
46: i_username in iby_payee.username%type,
47: i_password in iby_payee.password%type,
48: i_activestatus in iby_payee.activeStatus%type,
49: i_threshold in iby_payee.threshold%type,
50: i_risk_enabled in iby_payee.risk_enabled%type,

Line 47: i_password in iby_payee.password%type,

43: i_payeeid in iby_payee.payeeid%type,
44: i_payeename in iby_payee.name%type,
45: i_supportedOp in iby_payee.supportedOp%type,
46: i_username in iby_payee.username%type,
47: i_password in iby_payee.password%type,
48: i_activestatus in iby_payee.activeStatus%type,
49: i_threshold in iby_payee.threshold%type,
50: i_risk_enabled in iby_payee.risk_enabled%type,
51: i_bepids in JTF_NUMBER_TABLE,

Line 48: i_activestatus in iby_payee.activeStatus%type,

44: i_payeename in iby_payee.name%type,
45: i_supportedOp in iby_payee.supportedOp%type,
46: i_username in iby_payee.username%type,
47: i_password in iby_payee.password%type,
48: i_activestatus in iby_payee.activeStatus%type,
49: i_threshold in iby_payee.threshold%type,
50: i_risk_enabled in iby_payee.risk_enabled%type,
51: i_bepids in JTF_NUMBER_TABLE,
52: i_bepkeys in varchar2,

Line 49: i_threshold in iby_payee.threshold%type,

45: i_supportedOp in iby_payee.supportedOp%type,
46: i_username in iby_payee.username%type,
47: i_password in iby_payee.password%type,
48: i_activestatus in iby_payee.activeStatus%type,
49: i_threshold in iby_payee.threshold%type,
50: i_risk_enabled in iby_payee.risk_enabled%type,
51: i_bepids in JTF_NUMBER_TABLE,
52: i_bepkeys in varchar2,
53: i_bepdefaults in varchar2,

Line 50: i_risk_enabled in iby_payee.risk_enabled%type,

46: i_username in iby_payee.username%type,
47: i_password in iby_payee.password%type,
48: i_activestatus in iby_payee.activeStatus%type,
49: i_threshold in iby_payee.threshold%type,
50: i_risk_enabled in iby_payee.risk_enabled%type,
51: i_bepids in JTF_NUMBER_TABLE,
52: i_bepkeys in varchar2,
53: i_bepdefaults in varchar2,
54: i_mcc in number,

Line 55: i_secenable IN iby_payee.security_enabled%TYPE,

51: i_bepids in JTF_NUMBER_TABLE,
52: i_bepkeys in varchar2,
53: i_bepdefaults in varchar2,
54: i_mcc in number,
55: i_secenable IN iby_payee.security_enabled%TYPE,
56: i_object_version in iby_payee.object_version_number%type);
57:
58:
59: /*

Line 56: i_object_version in iby_payee.object_version_number%type);

52: i_bepkeys in varchar2,
53: i_bepdefaults in varchar2,
54: i_mcc in number,
55: i_secenable IN iby_payee.security_enabled%TYPE,
56: i_object_version in iby_payee.object_version_number%type);
57:
58:
59: /*
60: ** Function: payeeExists.

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

59: /*
60: ** Function: payeeExists.
61: ** Purpose: Check if the specified payeeid and ecappid exists or not.
62: */
63: function payeeExists(i_ecappid in iby_payee.ecappid%type,
64: i_payeeid in iby_payee.payeeid%type)
65: return boolean;
66:
67: /*

Line 64: i_payeeid in iby_payee.payeeid%type)

60: ** Function: payeeExists.
61: ** Purpose: Check if the specified payeeid and ecappid exists or not.
62: */
63: function payeeExists(i_ecappid in iby_payee.ecappid%type,
64: i_payeeid in iby_payee.payeeid%type)
65: return boolean;
66:
67: /*
68: ** Following procedures are used for BEP keys parsing.

Line 76: end iby_payee_pkg;

72:
73: procedure getTables(tableString varchar2, pltable out NOCOPY varchar_tab, counter out NOCOPY integer);
74: procedure getNumberTables(tableNumber JTF_NUMBER_TABLE, pltable out NOCOPY number_tab, counter out NOCOPY integer);
75:
76: end iby_payee_pkg;