[Home] [Help]
14: FUNCTION msite_default_lang_exists(p_msite_id IN NUMBER )
15: RETURN BOOLEAN
16: IS
17: CURSOR valid_msite_lang_cur(p_msite_id IN NUMBER) IS
18: select 1 from dual where exists (
19: select msite_id
20: from ibe_msites_b
21: where msite_id = p_msite_id
22: and default_language_code is not null );
43: FUNCTION msite_default_currency_exists(p_msite_id IN NUMBER )
44: RETURN BOOLEAN
45: IS
46: CURSOR valid_msite_currency_cur(p_msite_id IN NUMBER) IS
47: select 1 from dual where exists (
48: select msite_id from ibe_msites_b where
49: msite_id = p_msite_id and default_currency_code is not null );
50:
51: l_exists NUMBER;
76: FUNCTION msite_default_org_exists(p_msite_id IN NUMBER )
77: RETURN BOOLEAN
78: IS
79: CURSOR valid_msite_org_cur(p_msite_id IN NUMBER) IS
80: select 1 from dual where exists (
81: select msite_id from ibe_msites_b where
82: msite_id = p_msite_id and default_org_id is not null );
83:
84: l_exists NUMBER;
109: FUNCTION valid_language(p_language VARCHAR2)
110: RETURN BOOLEAN
111: IS
112: CURSOR valid_language_cur(p_language varchar2) IS
113: select 1 from dual where exists (
114: select language_code from fnd_languages_vl where
115: language_code = p_language);
116: l_exists NUMBER;
117: l_return_status Boolean := true;
151: FUNCTION valid_orgid(p_orgid NUMBER)
152: RETURN BOOLEAN
153: IS
154: CURSOR valid_orgid_cur(p_orgid varchar2) IS
155: select 1 from dual where exists (
156: select organization_id from hr_all_organization_units where
157: organization_id = p_orgid);
158: l_exists NUMBER;
159: l_return_status Boolean := true;
190: FUNCTION valid_currency(p_currency VARCHAR2)
191: RETURN BOOLEAN
192: IS
193: CURSOR valid_currency_cur(p_currency varchar2) IS
194: select 1 from dual where exists (
195: select currency_code from fnd_currencies_vl where
196: currency_code = p_currency);
197: l_exists NUMBER;
198: l_return_status Boolean := true;
239: p_registered_prclstid number,
240: p_bizpartner_prclstid NUMBER,
241: p_partner_prclstid NUMBER)
242: IS
243: select 1 from dual where exists (
244: select list_header_id from qp_list_headers_v where
245: currency_code = p_currency and
246: list_header_id in (p_walkin_prclstid,p_registered_prclstid,p_bizpartner_prclstid,p_partner_prclstid));
247:
331: l_debug VARCHAR2(1);
332:
333: CURSOR msite_id_seq IS
334: SELECT ibe_msites_b_s1.NEXTVAL
335: FROM DUAL;
336:
337: /*CURSOR store_id_cur IS
338: select store_id from ibe_stores_b
339: where rownum < 2 ;*/
338: select store_id from ibe_stores_b
339: where rownum < 2 ;*/
340:
341: CURSOR master_msite_any_cur IS
342: select 1 from dual where exists (
343: select msite_id from ibe_msites_b
344: where master_msite_flag = 'Y') ;
345:
346: CURSOR master_msite_cur(p_msite_id IN NUMBER) IS
343: select msite_id from ibe_msites_b
344: where master_msite_flag = 'Y') ;
345:
346: CURSOR master_msite_cur(p_msite_id IN NUMBER) IS
347: select 1 from dual
348: where exists (
349: select msite_id
350: from ibe_msites_b
351: where master_msite_flag = 'Y'
351: where master_msite_flag = 'Y'
352: AND msite_id <> p_msite_id);
353:
354: CURSOR yes_no_cur (p_code in varchar2) IS
355: select 1 from dual where exists (
356: select lookup_code
357: from fnd_lookup_values_vl
358: where lookup_type='YES_NO'
359: and lookup_code=p_code);
1535: default_index NUMBER := 0;
1536:
1537: CURSOR msite_languages_id_seq IS
1538: SELECT ibe_msite_languages_s1.NEXTVAL
1539: FROM DUAL;
1540:
1541: l_msite_languages_id NUMBER;
1542: l_insert_row NUMBER := 0;
1543: l_debug VARCHAR2(1);
1743: l_msite_id NUMBER;
1744: l_exists NUMBER;
1745: CURSOR msite_currencies_id_seq IS
1746: SELECT ibe_msite_currencies_s1.NEXTVAL
1747: FROM DUAL;
1748: l_msite_currencies_id NUMBER;
1749: l_payment_threshold NUMBER;
1750: l_insert_row NUMBER := 0;
1751: default_index NUMBER := 0;
2012: l_insert_row NUMBER := 0;
2013:
2014: CURSOR msite_oprorg_id_seq IS
2015: SELECT ibe_msite_orgs_s1.NEXTVAL
2016: FROM DUAL;
2017:
2018: l_msite_org_id NUMBER;
2019: default_index NUMBER := 0;
2020: l_debug VARCHAR2(1);