[Home] [Help]
143: WHERE msite_id = l_msite_id;
144:
145: OPEN x_name_cur FOR SELECT a.language_code,
146: b.msite_name, b.msite_description
147: FROM jtf_msite_languages a, jtf_msites_tl b
148: WHERE a.language_code = b.language
149: AND b.msite_id = a.msite_id
150: AND b.msite_id = l_msite_id;
151:
148: WHERE a.language_code = b.language
149: AND b.msite_id = a.msite_id
150: AND b.msite_id = l_msite_id;
151:
152: OPEN x_lang_cur FOR SELECT language_code from jtf_msite_languages l
153: WHERE l.msite_id = l_msite_id;
154:
155: OPEN x_currency_cur FOR SELECT currency_code, bizpartner_prc_listid,
156: registered_prc_listid, walkin_prc_listid, orderable_limit
222: respt.language,
223: respt.display_name
224: From jtf_msite_resps_b respb ,
225: jtf_msite_resps_tl respt ,
226: jtf_msite_languages lang
227: Where respb.msite_id = l_msite_id
228: And respb.msite_resp_id = respt.msite_resp_id
229: And lang.msite_id = respb.msite_id
230: And lang.language_code = respt.language
455:
456: -- Mini-site name and description for all languages
457: OPEN x_name_cur FOR 'SELECT MM.msite_id, L.language_code, TL.msite_name, '
458: || 'TL.msite_description '
459: || 'FROM jtf_msite_languages L, jtf_msites_tl TL, jtf_msites_b MM WHERE '
460: || 'L.language_code = TL.language AND '
461: || 'L.msite_id = MM.msite_id AND '
462: || 'TL.msite_id = MM.msite_id AND '
463: || l_tmp_str
462: || 'TL.msite_id = MM.msite_id AND '
463: || l_tmp_str
464: || 'ORDER BY MM.msite_id';
465:
466: -- Language assocation(from jtf_msite_languages table)
467: OPEN x_lang_cur FOR 'SELECT MM.msite_id, L.language_code '
468: || 'FROM jtf_msite_languages L, jtf_msites_b MM WHERE '
469: || 'MM.msite_id = L.msite_id AND '
470: || l_tmp_str
464: || 'ORDER BY MM.msite_id';
465:
466: -- Language assocation(from jtf_msite_languages table)
467: OPEN x_lang_cur FOR 'SELECT MM.msite_id, L.language_code '
468: || 'FROM jtf_msite_languages L, jtf_msites_b MM WHERE '
469: || 'MM.msite_id = L.msite_id AND '
470: || l_tmp_str
471: || 'ORDER BY MM.msite_id';
472: