APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on IBY_BEPLANGS

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

1070: /* Procedure: getBEPLang
1071: * Function: fetch valid nlslang based on input lang
1072: */
1073: procedure getBEPLang(i_bepid IN iby_bepinfo.bepid%type,
1074: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type)
1075: IS
1076: CURSOR c_getPreferred(ci_bepid iby_bepinfo.bepid%type) IS
1077: SELECT beplang
1078: FROM iby_BEPlangs

Line 1078: FROM iby_BEPlangs

1074: io_beplang IN OUT NOCOPY iby_beplangs.beplang%type)
1075: IS
1076: CURSOR c_getPreferred(ci_bepid iby_bepinfo.bepid%type) IS
1077: SELECT beplang
1078: FROM iby_BEPlangs
1079: WHERE BEPID = ci_bepid
1080: AND Preferred = 0
1081: AND BEPLang <> '' AND BEPLang IS NOT NULL; -- reject anything trivial
1082:

Line 1099: FROM iby_BEPlangs

1095: -- otherwise gives preferred, if preferred missing,
1096: -- give empty string (actually ' ', as plsql doesn't treat '' as NULL)
1097: SELECT count(*)
1098: INTO l_bep_lang_count
1099: FROM iby_BEPlangs
1100: WHERE BEPID = i_bepid
1101: AND UPPER(BEPlang) = UPPER(io_beplang);
1102:
1103: IF (l_bep_lang_count = 0) THEN

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

1123: */
1124: /* comment out for now */
1125: /*
1126: FUNCTION getNLSLang(i_bepid IN iby_bepinfo.bepid%type,
1127: i_beplang IN iby_beplangs.beplang%type) RETURN VARCHAR2 IS
1128: v_Lang iby_beplangs.beplang%type;
1129: BEGIN
1130: v_Lang := i_beplang;
1131: iby_paymentmanagerdb_pkg.getBEPLang(i_bepid, v_Lang);

Line 1128: v_Lang iby_beplangs.beplang%type;

1124: /* comment out for now */
1125: /*
1126: FUNCTION getNLSLang(i_bepid IN iby_bepinfo.bepid%type,
1127: i_beplang IN iby_beplangs.beplang%type) RETURN VARCHAR2 IS
1128: v_Lang iby_beplangs.beplang%type;
1129: BEGIN
1130: v_Lang := i_beplang;
1131: iby_paymentmanagerdb_pkg.getBEPLang(i_bepid, v_Lang);
1132: RETURN v_Lang;