DBA Data[Home] [Help]

APPS.IBY_BEPINFO_PKG dependencies on IBY_BEPLANGS

Line 121: i_preNLSLang in iby_beplangs.beplang%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,
124: io_bepid in out nocopy iby_bepinfo.bepid%type)
125: is

Line 122: i_opt1NLSLang in iby_beplangs.beplang%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,
124: io_bepid in out nocopy iby_bepinfo.bepid%type)
125: is
126: l_instrtype iby_bepinfo.instrtype%type;

Line 123: i_opt2NLSLang in iby_beplangs.beplang%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,
124: io_bepid in out nocopy iby_bepinfo.bepid%type)
125: is
126: l_instrtype iby_bepinfo.instrtype%type;
127:

Line 197: iby_beplangs_pkg.createBEPLangs(io_bepid, i_preNLSLang,

193: iby_pmtschemes_pkg.createPmtScheme(io_bepid, i_pmtschemename);
194: END IF;
195:
196: --create NLS Languages.
197: iby_beplangs_pkg.createBEPLangs(io_bepid, i_preNLSLang,
198: i_opt1NLSLang, i_opt2NLSLang);
199:
200: commit;
201:

Line 233: i_preNLSLang in iby_beplangs.beplang%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,
236: io_bepid in out nocopy iby_bepinfo.bepid%type)
237:

Line 234: i_opt1NLSLang in iby_beplangs.beplang%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,
236: io_bepid in out nocopy iby_bepinfo.bepid%type)
237:
238: is

Line 235: i_opt2NLSLang in iby_beplangs.beplang%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,
236: io_bepid in out nocopy iby_bepinfo.bepid%type)
237:
238: is
239:

Line 259: l_preNLSLang iby_beplangs.beplang%type;

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;
262:
263: begin

Line 260: l_opt1NLSLang iby_beplangs.beplang%type;

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;
262:
263: begin
264:

Line 261: l_opt2NLSLang iby_beplangs.beplang%type;

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;
262:
263: begin
264:
265: l_bepname := i_bepname;

Line 449: i_preNLSLang in iby_beplangs.beplang%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,
452: i_object_version in iby_bepinfo.object_version_number%type)
453: is

Line 450: i_opt1NLSLang in iby_beplangs.beplang%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,
452: i_object_version in iby_bepinfo.object_version_number%type)
453: is
454:

Line 451: i_opt2NLSLang in iby_beplangs.beplang%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,
452: i_object_version in iby_bepinfo.object_version_number%type)
453: is
454:
455: l_instrtype iby_bepinfo.instrtype%type;

Line 517: iby_beplangs_pkg.createBEPLangs(i_bepid, i_preNLSLang,

513: -- replace pmt scheme info
514: iby_pmtschemes_pkg.createPmtScheme(i_bepid, i_pmtschemename);
515:
516: -- replace NLS Languages.
517: iby_beplangs_pkg.createBEPLangs(i_bepid, i_preNLSLang,
518: i_opt1NLSLang, i_opt2NLSLang);
519: commit;
520: end modbepinfo;
521:

Line 553: i_preNLSLang in iby_beplangs.beplang%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,
556: i_object_version in iby_bepinfo.object_version_number%type)
557:

Line 554: i_opt1NLSLang in iby_beplangs.beplang%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,
556: i_object_version in iby_bepinfo.object_version_number%type)
557:
558: is

Line 555: i_opt2NLSLang in iby_beplangs.beplang%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,
556: i_object_version in iby_bepinfo.object_version_number%type)
557:
558: is
559: l_api_name CONSTANT VARCHAR2(30) := 'update_BEPInfo';

Line 683: iby_beplangs_pkg.createBEPLangs(i_bepid, i_preNLSLang,

679: -- and BEP langs update, as there are no business requirement
680: -- at this point.
681:
682: -- replace NLS Languages.
683: iby_beplangs_pkg.createBEPLangs(i_bepid, i_preNLSLang,
684: i_opt1NLSLang, i_opt2NLSLang);
685: commit;
686:
687: end update_BEPInfo;

Line 726: o_preNLSLang out nocopy iby_beplangs.beplang%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,
729: o_object_version out nocopy iby_bepinfo.object_version_number%type)
730: is

Line 727: o_opt1NLSLang out nocopy iby_beplangs.beplang%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,
729: o_object_version out nocopy iby_bepinfo.object_version_number%type)
730: is
731:

Line 728: o_opt2NLSLang out nocopy iby_beplangs.beplang%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,
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

Line 743: FROM iby_beplangs

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;
746:
747: cursor c_opt1NLSLang(ci_bepid in iby_bepinfo.bepid%type) is

Line 749: FROM iby_beplangs

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;
752:
753: cursor c_opt2NLSLang(ci_bepid in iby_bepinfo.bepid%type) is

Line 755: FROM iby_beplangs

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;
758:
759: begin