[Home] [Help]
13: FUNCTION msite_enabled_for_store(p_msite_id IN NUMBER )
14: RETURN BOOLEAN
15: IS
16: CURSOR valid_store_msite_cur(p_msite_id IN NUMBER) IS
17: select 1 from dual where exists (
18: select msite_id
19: from jtf_msites_b a ,
20: jtf_stores_b b
21: WHERE a.msite_id = p_msite_id
41: FUNCTION msite_default_lang_exists(p_msite_id IN NUMBER )
42: RETURN BOOLEAN
43: IS
44: CURSOR valid_msite_lang_cur(p_msite_id IN NUMBER) IS
45: select 1 from dual where exists (
46: select msite_id
47: from jtf_msites_b
48: where msite_id = p_msite_id
49: and default_language_code is not null );
70: FUNCTION msite_default_currency_exists(p_msite_id IN NUMBER )
71: RETURN BOOLEAN
72: IS
73: CURSOR valid_msite_currency_cur(p_msite_id IN NUMBER) IS
74: select 1 from dual where exists (
75: select msite_id from jtf_msites_b where
76: msite_id = p_msite_id and default_currency_code is not null );
77:
78: l_exists NUMBER;
103: FUNCTION msite_default_org_exists(p_msite_id IN NUMBER )
104: RETURN BOOLEAN
105: IS
106: CURSOR valid_msite_org_cur(p_msite_id IN NUMBER) IS
107: select 1 from dual where exists (
108: select msite_id from jtf_msites_b where
109: msite_id = p_msite_id and default_org_id is not null );
110:
111: l_exists NUMBER;
136: FUNCTION valid_language(p_language VARCHAR2)
137: RETURN BOOLEAN
138: IS
139: CURSOR valid_language_cur(p_language varchar2) IS
140: select 1 from dual where exists (
141: select language_code from fnd_languages_vl where
142: language_code = p_language);
143: l_exists NUMBER;
144: l_return_status Boolean := true;
178: FUNCTION valid_orgid(p_orgid NUMBER)
179: RETURN BOOLEAN
180: IS
181: CURSOR valid_orgid_cur(p_orgid varchar2) IS
182: select 1 from dual where exists (
183: select organization_id from hr_operating_units where
184: organization_id = p_orgid);
185: l_exists NUMBER;
186: l_return_status Boolean := true;
217: FUNCTION valid_currency(p_currency VARCHAR2)
218: RETURN BOOLEAN
219: IS
220: CURSOR valid_currency_cur(p_currency varchar2) IS
221: select 1 from dual where exists (
222: select currency_code from fnd_currencies_vl where
223: currency_code = p_currency);
224: l_exists NUMBER;
225: l_return_status Boolean := true;
264: p_walkin_prclstid number,
265: p_registered_prclstid number,
266: p_bizpartner_prclstid NUMBER)
267: IS
268: select 1 from dual where exists (
269: select list_header_id from qp_list_headers_v where
270: currency_code = p_currency and
271: list_header_id in (p_walkin_prclstid,p_registered_prclstid,p_bizpartner_prclstid));
272:
343: l_party_access_code VARCHAR2(1);
344:
345: CURSOR msite_id_seq IS
346: SELECT jtf_msites_b_s1.NEXTVAL
347: FROM DUAL;
348:
349: CURSOR store_id_cur IS
350: select store_id from jtf_stores_b
351: where rownum < 2 ;
350: select store_id from jtf_stores_b
351: where rownum < 2 ;
352:
353: CURSOR master_msite_any_cur IS
354: select 1 from dual where exists (
355: select msite_id from jtf_msites_b
356: where master_msite_flag = 'Y') ;
357:
358: CURSOR master_msite_cur(p_msite_id IN NUMBER) IS
355: select msite_id from jtf_msites_b
356: where master_msite_flag = 'Y') ;
357:
358: CURSOR master_msite_cur(p_msite_id IN NUMBER) IS
359: select 1 from dual
360: where exists (
361: select msite_id
362: from jtf_msites_b
363: where master_msite_flag = 'Y'
363: where master_msite_flag = 'Y'
364: AND msite_id <> p_msite_id);
365:
366: CURSOR yes_no_cur (p_code in varchar2) IS
367: select 1 from dual where exists (
368: select lookup_code
369: from fnd_lookup_values_vl
370: where lookup_type='YES_NO'
371: and lookup_code=p_code);
860: default_index NUMBER := 0;
861:
862: CURSOR msite_languages_id_seq IS
863: SELECT jtf_msite_languages_s1.NEXTVAL
864: FROM DUAL;
865:
866: l_msite_languages_id NUMBER;
867: l_insert_row NUMBER := 0;
868:
1062: l_msite_id NUMBER;
1063: l_exists NUMBER;
1064: CURSOR msite_currencies_id_seq IS
1065: SELECT jtf_msite_currencies_s1.NEXTVAL
1066: FROM DUAL;
1067: l_msite_currencies_id NUMBER;
1068: l_insert_row NUMBER := 0;
1069: default_index NUMBER := 0;
1070: BEGIN
1264: l_insert_row NUMBER := 0;
1265:
1266: CURSOR msite_oprorg_id_seq IS
1267: SELECT jtf_msite_orgs_s1.NEXTVAL
1268: FROM DUAL;
1269:
1270: l_msite_org_id NUMBER;
1271: default_index NUMBER := 0;
1272: