APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on IBY_BEPLANGS

Line 1004: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type)

1000: /* Procedure: getBEPLang
1001: * Function: fetch valid nlslang based on input lang
1002: */
1003: procedure getBEPLang(i_bepid IN iby_bepinfo.bepid%type,
1004: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type)
1005: IS
1006: CURSOR c_getPreferred(ci_bepid iby_bepinfo.bepid%type) IS
1007: SELECT beplang
1008: FROM iby_BEPlangs

Line 1008: FROM iby_BEPlangs

1004: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type)
1005: IS
1006: CURSOR c_getPreferred(ci_bepid iby_bepinfo.bepid%type) IS
1007: SELECT beplang
1008: FROM iby_BEPlangs
1009: WHERE BEPID = ci_bepid
1010: AND Preferred = 0
1011: AND BEPLang <> '' AND BEPLang IS NOT NULL; -- reject anything trivial
1012:

Line 1029: FROM iby_BEPlangs

1025: -- otherwise gives preferred, if preferred missing,
1026: -- give empty string (actually ' ', as plsql doesn't treat '' as NULL)
1027: SELECT count(*)
1028: INTO l_bep_lang_count
1029: FROM iby_BEPlangs
1030: WHERE BEPID = i_bepid
1031: AND UPPER(BEPlang) = UPPER(io_beplang);
1032:
1033: IF (l_bep_lang_count = 0) THEN

Line 1057: i_beplang IN iby_beplangs.beplang%type) RETURN VARCHAR2 IS

1053: */
1054: /* comment out for now */
1055: /*
1056: FUNCTION getNLSLang(i_bepid IN iby_bepinfo.bepid%type,
1057: i_beplang IN iby_beplangs.beplang%type) RETURN VARCHAR2 IS
1058: v_Lang iby_beplangs.beplang%type;
1059: BEGIN
1060: v_Lang := i_beplang;
1061: iby_paymentmanagerdb_pkg.getBEPLang(i_bepid, v_Lang);

Line 1058: v_Lang iby_beplangs.beplang%type;

1054: /* comment out for now */
1055: /*
1056: FUNCTION getNLSLang(i_bepid IN iby_bepinfo.bepid%type,
1057: i_beplang IN iby_beplangs.beplang%type) RETURN VARCHAR2 IS
1058: v_Lang iby_beplangs.beplang%type;
1059: BEGIN
1060: v_Lang := i_beplang;
1061: iby_paymentmanagerdb_pkg.getBEPLang(i_bepid, v_Lang);
1062: RETURN v_Lang;