1: package iby_bepinfo_pkg AUTHID CURRENT_USER as
2: /*$Header: ibybepis.pls 115.17 2003/12/19 20:32:33 jleybovi ship $*/
3:
4: -- constants for IBY_BEPINFO.BEP_TYPE
5: --
1: package iby_bepinfo_pkg AUTHID CURRENT_USER as
2: /*$Header: ibybepis.pls 115.17 2003/12/19 20:32:33 jleybovi ship $*/
3:
4: -- constants for IBY_BEPINFO.BEP_TYPE
5: --
6: C_BEPTYPE_GATEWAY CONSTANT VARCHAR2(20) := 'GATEWAY';
7: C_BEPTYPE_PROCESSOR CONSTANT VARCHAR2(20) := 'PROCESSOR';
8:
7: C_BEPTYPE_PROCESSOR CONSTANT VARCHAR2(20) := 'PROCESSOR';
8:
9:
10: /*
11: ** Name : iby_bepinfo_pkg.
12: ** Purpose : This package creates or deletes Back end processor entry in
13: ** BEP Table.
14: */
15:
16: /*
17: ** Function: SuffixExists.
18: ** Purpose: Check if suffix with the same name already exists in the system.
19: */
20: function suffixExists (i_bepsuffix in iby_bepinfo.suffix%type,
21: i_bepid in iby_bepinfo.bepid%type)
22: return boolean;
23:
24: /*
17: ** Function: SuffixExists.
18: ** Purpose: Check if suffix with the same name already exists in the system.
19: */
20: function suffixExists (i_bepsuffix in iby_bepinfo.suffix%type,
21: i_bepid in iby_bepinfo.bepid%type)
22: return boolean;
23:
24: /*
25: ** Function: bepNameExists.
24: /*
25: ** Function: bepNameExists.
26: ** Purpose: Check if any bep Name already exists in the system.
27: */
28: function bepNameExists (i_bepname in iby_bepinfo.name%type,
29: i_bepid in iby_bepinfo.bepid%type)
30: return boolean;
31:
32: /*
25: ** Function: bepNameExists.
26: ** Purpose: Check if any bep Name already exists in the system.
27: */
28: function bepNameExists (i_bepname in iby_bepinfo.name%type,
29: i_bepid in iby_bepinfo.bepid%type)
30: return boolean;
31:
32: /*
33: ** Procedure Name : createBEPInfo
42: ** i_cancsupport, io_depid
43: ** Out : io_bepid.
44: **
45: */
46: procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,
47: i_bepurl in iby_bepinfo.baseurl%type,
48: i_bepsuffix in iby_bepinfo.suffix%type,
49: i_bep_type in iby_bepinfo.bep_type%type,
50: i_bepusername in iby_bepinfo.bepusername%type,
43: ** Out : io_bepid.
44: **
45: */
46: procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,
47: i_bepurl in iby_bepinfo.baseurl%type,
48: i_bepsuffix in iby_bepinfo.suffix%type,
49: i_bep_type in iby_bepinfo.bep_type%type,
50: i_bepusername in iby_bepinfo.bepusername%type,
51: i_beppassword in iby_bepinfo.beppassword%type,
44: **
45: */
46: procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,
47: i_bepurl in iby_bepinfo.baseurl%type,
48: i_bepsuffix in iby_bepinfo.suffix%type,
49: i_bep_type in iby_bepinfo.bep_type%type,
50: i_bepusername in iby_bepinfo.bepusername%type,
51: i_beppassword in iby_bepinfo.beppassword%type,
52: i_psusername in iby_bepinfo.psusername%type,
45: */
46: procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,
47: i_bepurl in iby_bepinfo.baseurl%type,
48: i_bepsuffix in iby_bepinfo.suffix%type,
49: i_bep_type in iby_bepinfo.bep_type%type,
50: i_bepusername in iby_bepinfo.bepusername%type,
51: i_beppassword in iby_bepinfo.beppassword%type,
52: i_psusername in iby_bepinfo.psusername%type,
53: i_pspassword in iby_bepinfo.pspassword%type,
46: procedure createBEPInfo(i_bepname in iby_bepinfo.name%type,
47: i_bepurl in iby_bepinfo.baseurl%type,
48: i_bepsuffix in iby_bepinfo.suffix%type,
49: i_bep_type in iby_bepinfo.bep_type%type,
50: i_bepusername in iby_bepinfo.bepusername%type,
51: i_beppassword in iby_bepinfo.beppassword%type,
52: i_psusername in iby_bepinfo.psusername%type,
53: i_pspassword in iby_bepinfo.pspassword%type,
54: i_adminurl in iby_bepinfo.adminurl%type,
47: i_bepurl in iby_bepinfo.baseurl%type,
48: i_bepsuffix in iby_bepinfo.suffix%type,
49: i_bep_type in iby_bepinfo.bep_type%type,
50: i_bepusername in iby_bepinfo.bepusername%type,
51: i_beppassword in iby_bepinfo.beppassword%type,
52: i_psusername in iby_bepinfo.psusername%type,
53: i_pspassword in iby_bepinfo.pspassword%type,
54: i_adminurl in iby_bepinfo.adminurl%type,
55: i_login in iby_bepinfo.loginurl%type,
48: i_bepsuffix in iby_bepinfo.suffix%type,
49: i_bep_type in iby_bepinfo.bep_type%type,
50: i_bepusername in iby_bepinfo.bepusername%type,
51: i_beppassword in iby_bepinfo.beppassword%type,
52: i_psusername in iby_bepinfo.psusername%type,
53: i_pspassword in iby_bepinfo.pspassword%type,
54: i_adminurl in iby_bepinfo.adminurl%type,
55: i_login in iby_bepinfo.loginurl%type,
56: i_logout in iby_bepinfo.logouturl%type,
49: i_bep_type in iby_bepinfo.bep_type%type,
50: i_bepusername in iby_bepinfo.bepusername%type,
51: i_beppassword in iby_bepinfo.beppassword%type,
52: i_psusername in iby_bepinfo.psusername%type,
53: i_pspassword in iby_bepinfo.pspassword%type,
54: i_adminurl in iby_bepinfo.adminurl%type,
55: i_login in iby_bepinfo.loginurl%type,
56: i_logout in iby_bepinfo.logouturl%type,
57: i_supportedop in iby_bepinfo.supportedOp%type,
50: i_bepusername in iby_bepinfo.bepusername%type,
51: i_beppassword in iby_bepinfo.beppassword%type,
52: i_psusername in iby_bepinfo.psusername%type,
53: i_pspassword in iby_bepinfo.pspassword%type,
54: i_adminurl in iby_bepinfo.adminurl%type,
55: i_login in iby_bepinfo.loginurl%type,
56: i_logout in iby_bepinfo.logouturl%type,
57: i_supportedop in iby_bepinfo.supportedOp%type,
58: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
51: i_beppassword in iby_bepinfo.beppassword%type,
52: i_psusername in iby_bepinfo.psusername%type,
53: i_pspassword in iby_bepinfo.pspassword%type,
54: i_adminurl in iby_bepinfo.adminurl%type,
55: i_login in iby_bepinfo.loginurl%type,
56: i_logout in iby_bepinfo.logouturl%type,
57: i_supportedop in iby_bepinfo.supportedOp%type,
58: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
59: i_leadtime in iby_bepinfo.leadtime%type,
52: i_psusername in iby_bepinfo.psusername%type,
53: i_pspassword in iby_bepinfo.pspassword%type,
54: i_adminurl in iby_bepinfo.adminurl%type,
55: i_login in iby_bepinfo.loginurl%type,
56: i_logout in iby_bepinfo.logouturl%type,
57: i_supportedop in iby_bepinfo.supportedOp%type,
58: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
59: i_leadtime in iby_bepinfo.leadtime%type,
60: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
53: i_pspassword in iby_bepinfo.pspassword%type,
54: i_adminurl in iby_bepinfo.adminurl%type,
55: i_login in iby_bepinfo.loginurl%type,
56: i_logout in iby_bepinfo.logouturl%type,
57: i_supportedop in iby_bepinfo.supportedOp%type,
58: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
59: i_leadtime in iby_bepinfo.leadtime%type,
60: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
61: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
55: i_login in iby_bepinfo.loginurl%type,
56: i_logout in iby_bepinfo.logouturl%type,
57: i_supportedop in iby_bepinfo.supportedOp%type,
58: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
59: i_leadtime in iby_bepinfo.leadtime%type,
60: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
61: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
62: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
63: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
56: i_logout in iby_bepinfo.logouturl%type,
57: i_supportedop in iby_bepinfo.supportedOp%type,
58: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
59: i_leadtime in iby_bepinfo.leadtime%type,
60: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
61: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
62: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
63: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
64: i_securityscheme in iby_bepinfo.securityscheme%type,
57: i_supportedop in iby_bepinfo.supportedOp%type,
58: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
59: i_leadtime in iby_bepinfo.leadtime%type,
60: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
61: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
62: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
63: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
64: i_securityscheme in iby_bepinfo.securityscheme%type,
65: i_partyid in NUMBER,
58: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
59: i_leadtime in iby_bepinfo.leadtime%type,
60: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
61: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
62: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
63: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
64: i_securityscheme in iby_bepinfo.securityscheme%type,
65: i_partyid in NUMBER,
66: i_preNLSLang in iby_beplangs.beplang%type,
59: i_leadtime in iby_bepinfo.leadtime%type,
60: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
61: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
62: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
63: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
64: i_securityscheme in iby_bepinfo.securityscheme%type,
65: i_partyid in NUMBER,
66: i_preNLSLang in iby_beplangs.beplang%type,
67: i_opt1NLSLang in iby_beplangs.beplang%type,
60: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
61: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
62: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
63: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
64: i_securityscheme in iby_bepinfo.securityscheme%type,
65: i_partyid in NUMBER,
66: i_preNLSLang in iby_beplangs.beplang%type,
67: i_opt1NLSLang in iby_beplangs.beplang%type,
68: i_opt2NLSLang in iby_beplangs.beplang%type,
65: i_partyid in NUMBER,
66: i_preNLSLang in iby_beplangs.beplang%type,
67: i_opt1NLSLang in iby_beplangs.beplang%type,
68: i_opt2NLSLang in iby_beplangs.beplang%type,
69: io_bepid in out nocopy iby_bepinfo.bepid%type);
70:
71: /*
72: ** Procedure Name : modBEPInfo
73: ** Purpose : modifies an entry in Back end processor information table.
80: ** i_cancsupport, io_depid
81: ** Out : io_bepid.
82: **
83: */
84: procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,
85: i_bepname in iby_bepinfo.name%type,
86: i_bepurl in iby_bepinfo.baseurl%type,
87: i_bepsuffix in iby_bepinfo.suffix%type,
88: i_bep_type in iby_bepinfo.bep_type%type,
81: ** Out : io_bepid.
82: **
83: */
84: procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,
85: i_bepname in iby_bepinfo.name%type,
86: i_bepurl in iby_bepinfo.baseurl%type,
87: i_bepsuffix in iby_bepinfo.suffix%type,
88: i_bep_type in iby_bepinfo.bep_type%type,
89: i_bepusername in iby_bepinfo.bepusername%type,
82: **
83: */
84: procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,
85: i_bepname in iby_bepinfo.name%type,
86: i_bepurl in iby_bepinfo.baseurl%type,
87: i_bepsuffix in iby_bepinfo.suffix%type,
88: i_bep_type in iby_bepinfo.bep_type%type,
89: i_bepusername in iby_bepinfo.bepusername%type,
90: i_beppassword in iby_bepinfo.beppassword%type,
83: */
84: procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,
85: i_bepname in iby_bepinfo.name%type,
86: i_bepurl in iby_bepinfo.baseurl%type,
87: i_bepsuffix in iby_bepinfo.suffix%type,
88: i_bep_type in iby_bepinfo.bep_type%type,
89: i_bepusername in iby_bepinfo.bepusername%type,
90: i_beppassword in iby_bepinfo.beppassword%type,
91: i_psusername in iby_bepinfo.psusername%type,
84: procedure modBEPInfo(i_bepid in iby_bepinfo.bepid%type,
85: i_bepname in iby_bepinfo.name%type,
86: i_bepurl in iby_bepinfo.baseurl%type,
87: i_bepsuffix in iby_bepinfo.suffix%type,
88: i_bep_type in iby_bepinfo.bep_type%type,
89: i_bepusername in iby_bepinfo.bepusername%type,
90: i_beppassword in iby_bepinfo.beppassword%type,
91: i_psusername in iby_bepinfo.psusername%type,
92: i_pspassword in iby_bepinfo.pspassword%type,
85: i_bepname in iby_bepinfo.name%type,
86: i_bepurl in iby_bepinfo.baseurl%type,
87: i_bepsuffix in iby_bepinfo.suffix%type,
88: i_bep_type in iby_bepinfo.bep_type%type,
89: i_bepusername in iby_bepinfo.bepusername%type,
90: i_beppassword in iby_bepinfo.beppassword%type,
91: i_psusername in iby_bepinfo.psusername%type,
92: i_pspassword in iby_bepinfo.pspassword%type,
93: i_adminurl in iby_bepinfo.adminurl%type,
86: i_bepurl in iby_bepinfo.baseurl%type,
87: i_bepsuffix in iby_bepinfo.suffix%type,
88: i_bep_type in iby_bepinfo.bep_type%type,
89: i_bepusername in iby_bepinfo.bepusername%type,
90: i_beppassword in iby_bepinfo.beppassword%type,
91: i_psusername in iby_bepinfo.psusername%type,
92: i_pspassword in iby_bepinfo.pspassword%type,
93: i_adminurl in iby_bepinfo.adminurl%type,
94: i_login in iby_bepinfo.loginurl%type,
87: i_bepsuffix in iby_bepinfo.suffix%type,
88: i_bep_type in iby_bepinfo.bep_type%type,
89: i_bepusername in iby_bepinfo.bepusername%type,
90: i_beppassword in iby_bepinfo.beppassword%type,
91: i_psusername in iby_bepinfo.psusername%type,
92: i_pspassword in iby_bepinfo.pspassword%type,
93: i_adminurl in iby_bepinfo.adminurl%type,
94: i_login in iby_bepinfo.loginurl%type,
95: i_logout in iby_bepinfo.logouturl%type,
88: i_bep_type in iby_bepinfo.bep_type%type,
89: i_bepusername in iby_bepinfo.bepusername%type,
90: i_beppassword in iby_bepinfo.beppassword%type,
91: i_psusername in iby_bepinfo.psusername%type,
92: i_pspassword in iby_bepinfo.pspassword%type,
93: i_adminurl in iby_bepinfo.adminurl%type,
94: i_login in iby_bepinfo.loginurl%type,
95: i_logout in iby_bepinfo.logouturl%type,
96: i_supportedop in iby_bepinfo.supportedOp%type,
89: i_bepusername in iby_bepinfo.bepusername%type,
90: i_beppassword in iby_bepinfo.beppassword%type,
91: i_psusername in iby_bepinfo.psusername%type,
92: i_pspassword in iby_bepinfo.pspassword%type,
93: i_adminurl in iby_bepinfo.adminurl%type,
94: i_login in iby_bepinfo.loginurl%type,
95: i_logout in iby_bepinfo.logouturl%type,
96: i_supportedop in iby_bepinfo.supportedOp%type,
97: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
90: i_beppassword in iby_bepinfo.beppassword%type,
91: i_psusername in iby_bepinfo.psusername%type,
92: i_pspassword in iby_bepinfo.pspassword%type,
93: i_adminurl in iby_bepinfo.adminurl%type,
94: i_login in iby_bepinfo.loginurl%type,
95: i_logout in iby_bepinfo.logouturl%type,
96: i_supportedop in iby_bepinfo.supportedOp%type,
97: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
98: i_leadtime in iby_bepinfo.leadtime%type,
91: i_psusername in iby_bepinfo.psusername%type,
92: i_pspassword in iby_bepinfo.pspassword%type,
93: i_adminurl in iby_bepinfo.adminurl%type,
94: i_login in iby_bepinfo.loginurl%type,
95: i_logout in iby_bepinfo.logouturl%type,
96: i_supportedop in iby_bepinfo.supportedOp%type,
97: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
98: i_leadtime in iby_bepinfo.leadtime%type,
99: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
92: i_pspassword in iby_bepinfo.pspassword%type,
93: i_adminurl in iby_bepinfo.adminurl%type,
94: i_login in iby_bepinfo.loginurl%type,
95: i_logout in iby_bepinfo.logouturl%type,
96: i_supportedop in iby_bepinfo.supportedOp%type,
97: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
98: i_leadtime in iby_bepinfo.leadtime%type,
99: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
100: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
94: i_login in iby_bepinfo.loginurl%type,
95: i_logout in iby_bepinfo.logouturl%type,
96: i_supportedop in iby_bepinfo.supportedOp%type,
97: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
98: i_leadtime in iby_bepinfo.leadtime%type,
99: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
100: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
101: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
102: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
95: i_logout in iby_bepinfo.logouturl%type,
96: i_supportedop in iby_bepinfo.supportedOp%type,
97: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
98: i_leadtime in iby_bepinfo.leadtime%type,
99: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
100: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
101: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
102: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
103: i_securityscheme in iby_bepinfo.securityscheme%type,
96: i_supportedop in iby_bepinfo.supportedOp%type,
97: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
98: i_leadtime in iby_bepinfo.leadtime%type,
99: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
100: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
101: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
102: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
103: i_securityscheme in iby_bepinfo.securityscheme%type,
104: i_partyid in NUMBER,
97: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
98: i_leadtime in iby_bepinfo.leadtime%type,
99: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
100: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
101: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
102: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
103: i_securityscheme in iby_bepinfo.securityscheme%type,
104: i_partyid in NUMBER,
105: i_preNLSLang in iby_beplangs.beplang%type,
98: i_leadtime in iby_bepinfo.leadtime%type,
99: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
100: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
101: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
102: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
103: i_securityscheme in iby_bepinfo.securityscheme%type,
104: i_partyid in NUMBER,
105: i_preNLSLang in iby_beplangs.beplang%type,
106: i_opt1NLSLang in iby_beplangs.beplang%type,
99: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
100: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
101: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
102: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
103: i_securityscheme in iby_bepinfo.securityscheme%type,
104: i_partyid in NUMBER,
105: i_preNLSLang in iby_beplangs.beplang%type,
106: i_opt1NLSLang in iby_beplangs.beplang%type,
107: i_opt2NLSLang in iby_beplangs.beplang%type,
104: i_partyid in NUMBER,
105: i_preNLSLang in iby_beplangs.beplang%type,
106: i_opt1NLSLang in iby_beplangs.beplang%type,
107: i_opt2NLSLang in iby_beplangs.beplang%type,
108: i_object_version in iby_bepinfo.object_version_number%type);
109:
110: /*
111: ** Procedure Name : getBEPInfo
112: ** Purpose : retrieves Back end processor information table.
119: ** o_login, o_logout.
120: ** o_cancsupport, io_depid
121: **
122: */
123: procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,
124: o_bepname out nocopy iby_bepinfo.name%type,
125: o_bepurl out nocopy iby_bepinfo.baseurl%type,
126: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
127: o_bep_type out nocopy iby_bepinfo.bep_type%type,
120: ** o_cancsupport, io_depid
121: **
122: */
123: procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,
124: o_bepname out nocopy iby_bepinfo.name%type,
125: o_bepurl out nocopy iby_bepinfo.baseurl%type,
126: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
127: o_bep_type out nocopy iby_bepinfo.bep_type%type,
128: o_bepusername out nocopy iby_bepinfo.bepusername%type,
121: **
122: */
123: procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,
124: o_bepname out nocopy iby_bepinfo.name%type,
125: o_bepurl out nocopy iby_bepinfo.baseurl%type,
126: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
127: o_bep_type out nocopy iby_bepinfo.bep_type%type,
128: o_bepusername out nocopy iby_bepinfo.bepusername%type,
129: o_beppassword out nocopy iby_bepinfo.beppassword%type,
122: */
123: procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,
124: o_bepname out nocopy iby_bepinfo.name%type,
125: o_bepurl out nocopy iby_bepinfo.baseurl%type,
126: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
127: o_bep_type out nocopy iby_bepinfo.bep_type%type,
128: o_bepusername out nocopy iby_bepinfo.bepusername%type,
129: o_beppassword out nocopy iby_bepinfo.beppassword%type,
130: o_psusername out nocopy iby_bepinfo.psusername%type,
123: procedure getBEPInfo(i_bepid in iby_bepinfo.bepid%type,
124: o_bepname out nocopy iby_bepinfo.name%type,
125: o_bepurl out nocopy iby_bepinfo.baseurl%type,
126: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
127: o_bep_type out nocopy iby_bepinfo.bep_type%type,
128: o_bepusername out nocopy iby_bepinfo.bepusername%type,
129: o_beppassword out nocopy iby_bepinfo.beppassword%type,
130: o_psusername out nocopy iby_bepinfo.psusername%type,
131: o_pspassword out nocopy iby_bepinfo.pspassword%type,
124: o_bepname out nocopy iby_bepinfo.name%type,
125: o_bepurl out nocopy iby_bepinfo.baseurl%type,
126: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
127: o_bep_type out nocopy iby_bepinfo.bep_type%type,
128: o_bepusername out nocopy iby_bepinfo.bepusername%type,
129: o_beppassword out nocopy iby_bepinfo.beppassword%type,
130: o_psusername out nocopy iby_bepinfo.psusername%type,
131: o_pspassword out nocopy iby_bepinfo.pspassword%type,
132: o_adminurl out nocopy iby_bepinfo.adminurl%type,
125: o_bepurl out nocopy iby_bepinfo.baseurl%type,
126: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
127: o_bep_type out nocopy iby_bepinfo.bep_type%type,
128: o_bepusername out nocopy iby_bepinfo.bepusername%type,
129: o_beppassword out nocopy iby_bepinfo.beppassword%type,
130: o_psusername out nocopy iby_bepinfo.psusername%type,
131: o_pspassword out nocopy iby_bepinfo.pspassword%type,
132: o_adminurl out nocopy iby_bepinfo.adminurl%type,
133: o_login out nocopy iby_bepinfo.loginurl%type,
126: o_bepsuffix out nocopy iby_bepinfo.suffix%type,
127: o_bep_type out nocopy iby_bepinfo.bep_type%type,
128: o_bepusername out nocopy iby_bepinfo.bepusername%type,
129: o_beppassword out nocopy iby_bepinfo.beppassword%type,
130: o_psusername out nocopy iby_bepinfo.psusername%type,
131: o_pspassword out nocopy iby_bepinfo.pspassword%type,
132: o_adminurl out nocopy iby_bepinfo.adminurl%type,
133: o_login out nocopy iby_bepinfo.loginurl%type,
134: o_logout out nocopy iby_bepinfo.logouturl%type,
127: o_bep_type out nocopy iby_bepinfo.bep_type%type,
128: o_bepusername out nocopy iby_bepinfo.bepusername%type,
129: o_beppassword out nocopy iby_bepinfo.beppassword%type,
130: o_psusername out nocopy iby_bepinfo.psusername%type,
131: o_pspassword out nocopy iby_bepinfo.pspassword%type,
132: o_adminurl out nocopy iby_bepinfo.adminurl%type,
133: o_login out nocopy iby_bepinfo.loginurl%type,
134: o_logout out nocopy iby_bepinfo.logouturl%type,
135: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
128: o_bepusername out nocopy iby_bepinfo.bepusername%type,
129: o_beppassword out nocopy iby_bepinfo.beppassword%type,
130: o_psusername out nocopy iby_bepinfo.psusername%type,
131: o_pspassword out nocopy iby_bepinfo.pspassword%type,
132: o_adminurl out nocopy iby_bepinfo.adminurl%type,
133: o_login out nocopy iby_bepinfo.loginurl%type,
134: o_logout out nocopy iby_bepinfo.logouturl%type,
135: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
136: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
129: o_beppassword out nocopy iby_bepinfo.beppassword%type,
130: o_psusername out nocopy iby_bepinfo.psusername%type,
131: o_pspassword out nocopy iby_bepinfo.pspassword%type,
132: o_adminurl out nocopy iby_bepinfo.adminurl%type,
133: o_login out nocopy iby_bepinfo.loginurl%type,
134: o_logout out nocopy iby_bepinfo.logouturl%type,
135: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
136: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
137: o_leadtime out nocopy iby_bepinfo.leadtime%type,
130: o_psusername out nocopy iby_bepinfo.psusername%type,
131: o_pspassword out nocopy iby_bepinfo.pspassword%type,
132: o_adminurl out nocopy iby_bepinfo.adminurl%type,
133: o_login out nocopy iby_bepinfo.loginurl%type,
134: o_logout out nocopy iby_bepinfo.logouturl%type,
135: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
136: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
137: o_leadtime out nocopy iby_bepinfo.leadtime%type,
138: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
131: o_pspassword out nocopy iby_bepinfo.pspassword%type,
132: o_adminurl out nocopy iby_bepinfo.adminurl%type,
133: o_login out nocopy iby_bepinfo.loginurl%type,
134: o_logout out nocopy iby_bepinfo.logouturl%type,
135: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
136: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
137: o_leadtime out nocopy iby_bepinfo.leadtime%type,
138: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
139: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
133: o_login out nocopy iby_bepinfo.loginurl%type,
134: o_logout out nocopy iby_bepinfo.logouturl%type,
135: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
136: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
137: o_leadtime out nocopy iby_bepinfo.leadtime%type,
138: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
139: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
140: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
141: o_activestatus out nocopy iby_bepinfo.activestatus%type,
134: o_logout out nocopy iby_bepinfo.logouturl%type,
135: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
136: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
137: o_leadtime out nocopy iby_bepinfo.leadtime%type,
138: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
139: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
140: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
141: o_activestatus out nocopy iby_bepinfo.activestatus%type,
142: o_securityscheme out nocopy iby_bepinfo.securityscheme%type,
135: o_supportedop out nocopy iby_bepinfo.supportedOp%type,
136: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
137: o_leadtime out nocopy iby_bepinfo.leadtime%type,
138: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
139: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
140: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
141: o_activestatus out nocopy iby_bepinfo.activestatus%type,
142: o_securityscheme out nocopy iby_bepinfo.securityscheme%type,
143: o_partyid out nocopy NUMBER,
136: o_pmtschemeName out nocopy JTF_VARCHAR2_TABLE_100,
137: o_leadtime out nocopy iby_bepinfo.leadtime%type,
138: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
139: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
140: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
141: o_activestatus out nocopy iby_bepinfo.activestatus%type,
142: o_securityscheme out nocopy iby_bepinfo.securityscheme%type,
143: o_partyid out nocopy NUMBER,
144: o_preNLSLang out nocopy iby_beplangs.beplang%type,
137: o_leadtime out nocopy iby_bepinfo.leadtime%type,
138: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
139: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
140: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
141: o_activestatus out nocopy iby_bepinfo.activestatus%type,
142: o_securityscheme out nocopy iby_bepinfo.securityscheme%type,
143: o_partyid out nocopy NUMBER,
144: o_preNLSLang out nocopy iby_beplangs.beplang%type,
145: o_opt1NLSLang out nocopy iby_beplangs.beplang%type,
138: o_srvrIdImmed out nocopy iby_bepinfo.srvrIdImmed%type,
139: o_holidayfile out nocopy iby_bepinfo.holidayfile%type,
140: o_fileSupport out nocopy iby_bepinfo.fileSupport%type,
141: o_activestatus out nocopy iby_bepinfo.activestatus%type,
142: o_securityscheme out nocopy iby_bepinfo.securityscheme%type,
143: o_partyid out nocopy NUMBER,
144: o_preNLSLang out nocopy iby_beplangs.beplang%type,
145: o_opt1NLSLang out nocopy iby_beplangs.beplang%type,
146: o_opt2NLSLang out nocopy iby_beplangs.beplang%type,
143: o_partyid out nocopy NUMBER,
144: o_preNLSLang out nocopy iby_beplangs.beplang%type,
145: o_opt1NLSLang out nocopy iby_beplangs.beplang%type,
146: o_opt2NLSLang out nocopy iby_beplangs.beplang%type,
147: o_object_version out nocopy iby_bepinfo.object_version_number%type);
148:
149:
150: /*
151: ** Procedure Name : setBEPStatus
156: ** In : i_bepid, i_status.
157: ** Out : o_flag
158: **
159: */
160: procedure setBEPStatus(i_bepid in iby_bepinfo.bepid%type,
161: i_status in iby_bepinfo.activestatus%type,
162: o_flag out nocopy int);
163:
164:
157: ** Out : o_flag
158: **
159: */
160: procedure setBEPStatus(i_bepid in iby_bepinfo.bepid%type,
161: i_status in iby_bepinfo.activestatus%type,
162: o_flag out nocopy int);
163:
164:
165: /*
166: ** Function: getBepName
167: ** Purpose: return the bep name that matches the id passed
168: */
169:
170: function getBEPName(i_id iby_bepinfo.bepid%type)
171: return varchar;
172:
173: /*
174: ** Function: getBEPId.
173: /*
174: ** Function: getBEPId.
175: ** Purpose: returnt he bep id that matches the name passed.
176: */
177: function getBEPId(i_name iby_bepinfo.name%type)
178: return int;
179:
180:
181:
185: -- We should add more to it later. No validation is done
186: -- in this wrapper.
187: -- FZ 5/20/02
188: procedure create_BEPInfo(
189: i_bepname in iby_bepinfo.name%type,
190: i_bepurl in iby_bepinfo.baseurl%type,
191: i_bepsuffix in iby_bepinfo.suffix%type,
192: i_bep_type in iby_bepinfo.bep_type%type,
193: i_bepusername in iby_bepinfo.bepusername%type,
186: -- in this wrapper.
187: -- FZ 5/20/02
188: procedure create_BEPInfo(
189: i_bepname in iby_bepinfo.name%type,
190: i_bepurl in iby_bepinfo.baseurl%type,
191: i_bepsuffix in iby_bepinfo.suffix%type,
192: i_bep_type in iby_bepinfo.bep_type%type,
193: i_bepusername in iby_bepinfo.bepusername%type,
194: i_beppassword in iby_bepinfo.beppassword%type,
187: -- FZ 5/20/02
188: procedure create_BEPInfo(
189: i_bepname in iby_bepinfo.name%type,
190: i_bepurl in iby_bepinfo.baseurl%type,
191: i_bepsuffix in iby_bepinfo.suffix%type,
192: i_bep_type in iby_bepinfo.bep_type%type,
193: i_bepusername in iby_bepinfo.bepusername%type,
194: i_beppassword in iby_bepinfo.beppassword%type,
195: i_psusername in iby_bepinfo.psusername%type,
188: procedure create_BEPInfo(
189: i_bepname in iby_bepinfo.name%type,
190: i_bepurl in iby_bepinfo.baseurl%type,
191: i_bepsuffix in iby_bepinfo.suffix%type,
192: i_bep_type in iby_bepinfo.bep_type%type,
193: i_bepusername in iby_bepinfo.bepusername%type,
194: i_beppassword in iby_bepinfo.beppassword%type,
195: i_psusername in iby_bepinfo.psusername%type,
196: i_pspassword in iby_bepinfo.pspassword%type,
189: i_bepname in iby_bepinfo.name%type,
190: i_bepurl in iby_bepinfo.baseurl%type,
191: i_bepsuffix in iby_bepinfo.suffix%type,
192: i_bep_type in iby_bepinfo.bep_type%type,
193: i_bepusername in iby_bepinfo.bepusername%type,
194: i_beppassword in iby_bepinfo.beppassword%type,
195: i_psusername in iby_bepinfo.psusername%type,
196: i_pspassword in iby_bepinfo.pspassword%type,
197: i_adminurl in iby_bepinfo.adminurl%type,
190: i_bepurl in iby_bepinfo.baseurl%type,
191: i_bepsuffix in iby_bepinfo.suffix%type,
192: i_bep_type in iby_bepinfo.bep_type%type,
193: i_bepusername in iby_bepinfo.bepusername%type,
194: i_beppassword in iby_bepinfo.beppassword%type,
195: i_psusername in iby_bepinfo.psusername%type,
196: i_pspassword in iby_bepinfo.pspassword%type,
197: i_adminurl in iby_bepinfo.adminurl%type,
198: i_login in iby_bepinfo.loginurl%type,
191: i_bepsuffix in iby_bepinfo.suffix%type,
192: i_bep_type in iby_bepinfo.bep_type%type,
193: i_bepusername in iby_bepinfo.bepusername%type,
194: i_beppassword in iby_bepinfo.beppassword%type,
195: i_psusername in iby_bepinfo.psusername%type,
196: i_pspassword in iby_bepinfo.pspassword%type,
197: i_adminurl in iby_bepinfo.adminurl%type,
198: i_login in iby_bepinfo.loginurl%type,
199: i_logout in iby_bepinfo.logouturl%type,
192: i_bep_type in iby_bepinfo.bep_type%type,
193: i_bepusername in iby_bepinfo.bepusername%type,
194: i_beppassword in iby_bepinfo.beppassword%type,
195: i_psusername in iby_bepinfo.psusername%type,
196: i_pspassword in iby_bepinfo.pspassword%type,
197: i_adminurl in iby_bepinfo.adminurl%type,
198: i_login in iby_bepinfo.loginurl%type,
199: i_logout in iby_bepinfo.logouturl%type,
200: i_supportedop in iby_bepinfo.supportedOp%type,
193: i_bepusername in iby_bepinfo.bepusername%type,
194: i_beppassword in iby_bepinfo.beppassword%type,
195: i_psusername in iby_bepinfo.psusername%type,
196: i_pspassword in iby_bepinfo.pspassword%type,
197: i_adminurl in iby_bepinfo.adminurl%type,
198: i_login in iby_bepinfo.loginurl%type,
199: i_logout in iby_bepinfo.logouturl%type,
200: i_supportedop in iby_bepinfo.supportedOp%type,
201: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
194: i_beppassword in iby_bepinfo.beppassword%type,
195: i_psusername in iby_bepinfo.psusername%type,
196: i_pspassword in iby_bepinfo.pspassword%type,
197: i_adminurl in iby_bepinfo.adminurl%type,
198: i_login in iby_bepinfo.loginurl%type,
199: i_logout in iby_bepinfo.logouturl%type,
200: i_supportedop in iby_bepinfo.supportedOp%type,
201: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
202: i_leadtime in iby_bepinfo.leadtime%type,
195: i_psusername in iby_bepinfo.psusername%type,
196: i_pspassword in iby_bepinfo.pspassword%type,
197: i_adminurl in iby_bepinfo.adminurl%type,
198: i_login in iby_bepinfo.loginurl%type,
199: i_logout in iby_bepinfo.logouturl%type,
200: i_supportedop in iby_bepinfo.supportedOp%type,
201: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
202: i_leadtime in iby_bepinfo.leadtime%type,
203: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
196: i_pspassword in iby_bepinfo.pspassword%type,
197: i_adminurl in iby_bepinfo.adminurl%type,
198: i_login in iby_bepinfo.loginurl%type,
199: i_logout in iby_bepinfo.logouturl%type,
200: i_supportedop in iby_bepinfo.supportedOp%type,
201: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
202: i_leadtime in iby_bepinfo.leadtime%type,
203: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
204: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
198: i_login in iby_bepinfo.loginurl%type,
199: i_logout in iby_bepinfo.logouturl%type,
200: i_supportedop in iby_bepinfo.supportedOp%type,
201: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
202: i_leadtime in iby_bepinfo.leadtime%type,
203: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
204: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
205: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
206: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
199: i_logout in iby_bepinfo.logouturl%type,
200: i_supportedop in iby_bepinfo.supportedOp%type,
201: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
202: i_leadtime in iby_bepinfo.leadtime%type,
203: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
204: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
205: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
206: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
207: i_securityscheme in iby_bepinfo.securityscheme%type,
200: i_supportedop in iby_bepinfo.supportedOp%type,
201: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
202: i_leadtime in iby_bepinfo.leadtime%type,
203: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
204: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
205: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
206: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
207: i_securityscheme in iby_bepinfo.securityscheme%type,
208: i_partyid in NUMBER,
201: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
202: i_leadtime in iby_bepinfo.leadtime%type,
203: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
204: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
205: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
206: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
207: i_securityscheme in iby_bepinfo.securityscheme%type,
208: i_partyid in NUMBER,
209: i_preNLSLang in iby_beplangs.beplang%type,
202: i_leadtime in iby_bepinfo.leadtime%type,
203: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
204: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
205: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
206: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
207: i_securityscheme in iby_bepinfo.securityscheme%type,
208: i_partyid in NUMBER,
209: i_preNLSLang in iby_beplangs.beplang%type,
210: i_opt1NLSLang in iby_beplangs.beplang%type,
203: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
204: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
205: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
206: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
207: i_securityscheme in iby_bepinfo.securityscheme%type,
208: i_partyid in NUMBER,
209: i_preNLSLang in iby_beplangs.beplang%type,
210: i_opt1NLSLang in iby_beplangs.beplang%type,
211: i_opt2NLSLang in iby_beplangs.beplang%type,
208: i_partyid in NUMBER,
209: i_preNLSLang in iby_beplangs.beplang%type,
210: i_opt1NLSLang in iby_beplangs.beplang%type,
211: i_opt2NLSLang in iby_beplangs.beplang%type,
212: io_bepid in out nocopy iby_bepinfo.bepid%type
213: );
214:
215:
216:
217: -- This is similar to modBEPInfo(), however we add code to
218: -- to handle FND_API.G_MISS_XXX
219: -- FZ 5/20/02
220: procedure update_BEPInfo(
221: i_bepid in iby_bepinfo.bepid%type,
222: i_bepname in iby_bepinfo.name%type,
223: i_bepurl in iby_bepinfo.baseurl%type,
224: i_bepsuffix in iby_bepinfo.suffix%type,
225: i_bep_type in iby_bepinfo.bep_type%type,
218: -- to handle FND_API.G_MISS_XXX
219: -- FZ 5/20/02
220: procedure update_BEPInfo(
221: i_bepid in iby_bepinfo.bepid%type,
222: i_bepname in iby_bepinfo.name%type,
223: i_bepurl in iby_bepinfo.baseurl%type,
224: i_bepsuffix in iby_bepinfo.suffix%type,
225: i_bep_type in iby_bepinfo.bep_type%type,
226: i_bepusername in iby_bepinfo.bepusername%type,
219: -- FZ 5/20/02
220: procedure update_BEPInfo(
221: i_bepid in iby_bepinfo.bepid%type,
222: i_bepname in iby_bepinfo.name%type,
223: i_bepurl in iby_bepinfo.baseurl%type,
224: i_bepsuffix in iby_bepinfo.suffix%type,
225: i_bep_type in iby_bepinfo.bep_type%type,
226: i_bepusername in iby_bepinfo.bepusername%type,
227: i_beppassword in iby_bepinfo.beppassword%type,
220: procedure update_BEPInfo(
221: i_bepid in iby_bepinfo.bepid%type,
222: i_bepname in iby_bepinfo.name%type,
223: i_bepurl in iby_bepinfo.baseurl%type,
224: i_bepsuffix in iby_bepinfo.suffix%type,
225: i_bep_type in iby_bepinfo.bep_type%type,
226: i_bepusername in iby_bepinfo.bepusername%type,
227: i_beppassword in iby_bepinfo.beppassword%type,
228: i_psusername in iby_bepinfo.psusername%type,
221: i_bepid in iby_bepinfo.bepid%type,
222: i_bepname in iby_bepinfo.name%type,
223: i_bepurl in iby_bepinfo.baseurl%type,
224: i_bepsuffix in iby_bepinfo.suffix%type,
225: i_bep_type in iby_bepinfo.bep_type%type,
226: i_bepusername in iby_bepinfo.bepusername%type,
227: i_beppassword in iby_bepinfo.beppassword%type,
228: i_psusername in iby_bepinfo.psusername%type,
229: i_pspassword in iby_bepinfo.pspassword%type,
222: i_bepname in iby_bepinfo.name%type,
223: i_bepurl in iby_bepinfo.baseurl%type,
224: i_bepsuffix in iby_bepinfo.suffix%type,
225: i_bep_type in iby_bepinfo.bep_type%type,
226: i_bepusername in iby_bepinfo.bepusername%type,
227: i_beppassword in iby_bepinfo.beppassword%type,
228: i_psusername in iby_bepinfo.psusername%type,
229: i_pspassword in iby_bepinfo.pspassword%type,
230: i_adminurl in iby_bepinfo.adminurl%type,
223: i_bepurl in iby_bepinfo.baseurl%type,
224: i_bepsuffix in iby_bepinfo.suffix%type,
225: i_bep_type in iby_bepinfo.bep_type%type,
226: i_bepusername in iby_bepinfo.bepusername%type,
227: i_beppassword in iby_bepinfo.beppassword%type,
228: i_psusername in iby_bepinfo.psusername%type,
229: i_pspassword in iby_bepinfo.pspassword%type,
230: i_adminurl in iby_bepinfo.adminurl%type,
231: i_login in iby_bepinfo.loginurl%type,
224: i_bepsuffix in iby_bepinfo.suffix%type,
225: i_bep_type in iby_bepinfo.bep_type%type,
226: i_bepusername in iby_bepinfo.bepusername%type,
227: i_beppassword in iby_bepinfo.beppassword%type,
228: i_psusername in iby_bepinfo.psusername%type,
229: i_pspassword in iby_bepinfo.pspassword%type,
230: i_adminurl in iby_bepinfo.adminurl%type,
231: i_login in iby_bepinfo.loginurl%type,
232: i_logout in iby_bepinfo.logouturl%type,
225: i_bep_type in iby_bepinfo.bep_type%type,
226: i_bepusername in iby_bepinfo.bepusername%type,
227: i_beppassword in iby_bepinfo.beppassword%type,
228: i_psusername in iby_bepinfo.psusername%type,
229: i_pspassword in iby_bepinfo.pspassword%type,
230: i_adminurl in iby_bepinfo.adminurl%type,
231: i_login in iby_bepinfo.loginurl%type,
232: i_logout in iby_bepinfo.logouturl%type,
233: i_supportedop in iby_bepinfo.supportedOp%type,
226: i_bepusername in iby_bepinfo.bepusername%type,
227: i_beppassword in iby_bepinfo.beppassword%type,
228: i_psusername in iby_bepinfo.psusername%type,
229: i_pspassword in iby_bepinfo.pspassword%type,
230: i_adminurl in iby_bepinfo.adminurl%type,
231: i_login in iby_bepinfo.loginurl%type,
232: i_logout in iby_bepinfo.logouturl%type,
233: i_supportedop in iby_bepinfo.supportedOp%type,
234: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
227: i_beppassword in iby_bepinfo.beppassword%type,
228: i_psusername in iby_bepinfo.psusername%type,
229: i_pspassword in iby_bepinfo.pspassword%type,
230: i_adminurl in iby_bepinfo.adminurl%type,
231: i_login in iby_bepinfo.loginurl%type,
232: i_logout in iby_bepinfo.logouturl%type,
233: i_supportedop in iby_bepinfo.supportedOp%type,
234: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
235: i_leadtime in iby_bepinfo.leadtime%type,
228: i_psusername in iby_bepinfo.psusername%type,
229: i_pspassword in iby_bepinfo.pspassword%type,
230: i_adminurl in iby_bepinfo.adminurl%type,
231: i_login in iby_bepinfo.loginurl%type,
232: i_logout in iby_bepinfo.logouturl%type,
233: i_supportedop in iby_bepinfo.supportedOp%type,
234: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
235: i_leadtime in iby_bepinfo.leadtime%type,
236: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
229: i_pspassword in iby_bepinfo.pspassword%type,
230: i_adminurl in iby_bepinfo.adminurl%type,
231: i_login in iby_bepinfo.loginurl%type,
232: i_logout in iby_bepinfo.logouturl%type,
233: i_supportedop in iby_bepinfo.supportedOp%type,
234: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
235: i_leadtime in iby_bepinfo.leadtime%type,
236: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
237: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
231: i_login in iby_bepinfo.loginurl%type,
232: i_logout in iby_bepinfo.logouturl%type,
233: i_supportedop in iby_bepinfo.supportedOp%type,
234: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
235: i_leadtime in iby_bepinfo.leadtime%type,
236: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
237: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
238: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
239: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
232: i_logout in iby_bepinfo.logouturl%type,
233: i_supportedop in iby_bepinfo.supportedOp%type,
234: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
235: i_leadtime in iby_bepinfo.leadtime%type,
236: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
237: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
238: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
239: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
240: i_securityscheme in iby_bepinfo.securityscheme%type,
233: i_supportedop in iby_bepinfo.supportedOp%type,
234: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
235: i_leadtime in iby_bepinfo.leadtime%type,
236: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
237: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
238: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
239: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
240: i_securityscheme in iby_bepinfo.securityscheme%type,
241: i_partyid in NUMBER,
234: i_pmtschemeName in JTF_VARCHAR2_TABLE_100,
235: i_leadtime in iby_bepinfo.leadtime%type,
236: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
237: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
238: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
239: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
240: i_securityscheme in iby_bepinfo.securityscheme%type,
241: i_partyid in NUMBER,
242: i_preNLSLang in iby_beplangs.beplang%type,
235: i_leadtime in iby_bepinfo.leadtime%type,
236: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
237: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
238: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
239: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
240: i_securityscheme in iby_bepinfo.securityscheme%type,
241: i_partyid in NUMBER,
242: i_preNLSLang in iby_beplangs.beplang%type,
243: i_opt1NLSLang in iby_beplangs.beplang%type,
236: i_srvrIdImmed in iby_bepinfo.srvrIdImmed%type DEFAULT 'Y',
237: i_holidayfile in iby_bepinfo.holidayfile%type DEFAULT 'N',
238: i_fileSupport in iby_bepinfo.fileSupport%type DEFAULT 'N',
239: i_activestatus in iby_bepinfo.activestatus%type DEFAULT 'Y',
240: i_securityscheme in iby_bepinfo.securityscheme%type,
241: i_partyid in NUMBER,
242: i_preNLSLang in iby_beplangs.beplang%type,
243: i_opt1NLSLang in iby_beplangs.beplang%type,
244: i_opt2NLSLang in iby_beplangs.beplang%type,
241: i_partyid in NUMBER,
242: i_preNLSLang in iby_beplangs.beplang%type,
243: i_opt1NLSLang in iby_beplangs.beplang%type,
244: i_opt2NLSLang in iby_beplangs.beplang%type,
245: i_object_version in iby_bepinfo.object_version_number%type
246: );
247:
248:
249: end iby_bepinfo_pkg;
245: i_object_version in iby_bepinfo.object_version_number%type
246: );
247:
248:
249: end iby_bepinfo_pkg;