APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_USER_CC_PF_TL

Line 2154: insert into IBY_FNDCPT_USER_CC_PF_TL (

2150: X_LAST_UPDATED_BY,
2151: X_LAST_UPDATE_LOGIN
2152: );
2153:
2154: insert into IBY_FNDCPT_USER_CC_PF_TL (
2155: CREATION_DATE,
2156: LAST_UPDATED_BY,
2157: LAST_UPDATE_DATE,
2158: LAST_UPDATE_LOGIN,

Line 2180: from IBY_FNDCPT_USER_CC_PF_TL T

2176: from FND_LANGUAGES L
2177: where L.INSTALLED_FLAG in ('I', 'B')
2178: and not exists
2179: (select NULL
2180: from IBY_FNDCPT_USER_CC_PF_TL T
2181: where T.USER_CC_PROFILE_CODE = X_USER_CC_PROFILE_CODE
2182: and T.LANGUAGE = L.LANGUAGE_CODE);
2183:
2184: open c;

Line 2226: update IBY_FNDCPT_USER_CC_PF_TL set

2222: if (sql%notfound) then
2223: raise no_data_found;
2224: end if;
2225:
2226: update IBY_FNDCPT_USER_CC_PF_TL set
2227: USER_CC_PROFILE_NAME = X_USER_CC_PROFILE_NAME,
2228: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
2229: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
2230: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 2244: delete from IBY_FNDCPT_USER_CC_PF_TL

2240: procedure USER_CC_PROF_DELETE_ROW (
2241: X_USER_CC_PROFILE_CODE in VARCHAR2
2242: ) is
2243: begin
2244: delete from IBY_FNDCPT_USER_CC_PF_TL
2245: where USER_CC_PROFILE_CODE = X_USER_CC_PROFILE_CODE;
2246:
2247: if (sql%notfound) then
2248: raise no_data_found;

Line 2262: delete from IBY_FNDCPT_USER_CC_PF_TL T

2258:
2259: procedure USER_CC_PROF_ADD_LANGUAGE
2260: is
2261: begin
2262: delete from IBY_FNDCPT_USER_CC_PF_TL T
2263: where not exists
2264: (select NULL
2265: from IBY_FNDCPT_USER_CC_PF_B B
2266: where B.USER_CC_PROFILE_CODE = T.USER_CC_PROFILE_CODE

Line 2269: update IBY_FNDCPT_USER_CC_PF_TL T set (

2265: from IBY_FNDCPT_USER_CC_PF_B B
2266: where B.USER_CC_PROFILE_CODE = T.USER_CC_PROFILE_CODE
2267: );
2268:
2269: update IBY_FNDCPT_USER_CC_PF_TL T set (
2270: USER_CC_PROFILE_NAME
2271: ) = (select
2272: B.USER_CC_PROFILE_NAME
2273: from IBY_FNDCPT_USER_CC_PF_TL B

Line 2273: from IBY_FNDCPT_USER_CC_PF_TL B

2269: update IBY_FNDCPT_USER_CC_PF_TL T set (
2270: USER_CC_PROFILE_NAME
2271: ) = (select
2272: B.USER_CC_PROFILE_NAME
2273: from IBY_FNDCPT_USER_CC_PF_TL B
2274: where B.USER_CC_PROFILE_CODE = T.USER_CC_PROFILE_CODE
2275: and B.LANGUAGE = T.SOURCE_LANG)
2276: where (
2277: T.USER_CC_PROFILE_CODE,

Line 2282: from IBY_FNDCPT_USER_CC_PF_TL SUBB, IBY_FNDCPT_USER_CC_PF_TL SUBT

2278: T.LANGUAGE
2279: ) in (select
2280: SUBT.USER_CC_PROFILE_CODE,
2281: SUBT.LANGUAGE
2282: from IBY_FNDCPT_USER_CC_PF_TL SUBB, IBY_FNDCPT_USER_CC_PF_TL SUBT
2283: where SUBB.USER_CC_PROFILE_CODE = SUBT.USER_CC_PROFILE_CODE
2284: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2285: and (SUBB.USER_CC_PROFILE_NAME <> SUBT.USER_CC_PROFILE_NAME
2286: ));

Line 2288: insert into IBY_FNDCPT_USER_CC_PF_TL (

2284: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2285: and (SUBB.USER_CC_PROFILE_NAME <> SUBT.USER_CC_PROFILE_NAME
2286: ));
2287:
2288: insert into IBY_FNDCPT_USER_CC_PF_TL (
2289: CREATION_DATE,
2290: LAST_UPDATED_BY,
2291: LAST_UPDATE_DATE,
2292: LAST_UPDATE_LOGIN,

Line 2310: from IBY_FNDCPT_USER_CC_PF_TL B, FND_LANGUAGES L

2306: B.USER_CC_PROFILE_NAME,
2307: B.CREATED_BY,
2308: L.LANGUAGE_CODE,
2309: B.SOURCE_LANG
2310: from IBY_FNDCPT_USER_CC_PF_TL B, FND_LANGUAGES L
2311: where L.INSTALLED_FLAG in ('I', 'B')
2312: and B.LANGUAGE = userenv('LANG')
2313: and not exists
2314: (select NULL

Line 2315: from IBY_FNDCPT_USER_CC_PF_TL T

2311: where L.INSTALLED_FLAG in ('I', 'B')
2312: and B.LANGUAGE = userenv('LANG')
2313: and not exists
2314: (select NULL
2315: from IBY_FNDCPT_USER_CC_PF_TL T
2316: where T.USER_CC_PROFILE_CODE = B.USER_CC_PROFILE_CODE
2317: and T.LANGUAGE = L.LANGUAGE_CODE);
2318: end USER_CC_PROF_ADD_LANGUAGE;
2319: