APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_USER_EFT_PF_TL

Line 2371: insert into IBY_FNDCPT_USER_EFT_PF_TL (

2367: X_LAST_UPDATED_BY,
2368: X_LAST_UPDATE_LOGIN
2369: );
2370:
2371: insert into IBY_FNDCPT_USER_EFT_PF_TL (
2372: USER_EFT_PROFILE_CODE,
2373: USER_EFT_PROFILE_NAME,
2374: CREATED_BY,
2375: CREATION_DATE,

Line 2397: from IBY_FNDCPT_USER_EFT_PF_TL T

2393: from FND_LANGUAGES L
2394: where L.INSTALLED_FLAG in ('I', 'B')
2395: and not exists
2396: (select NULL
2397: from IBY_FNDCPT_USER_EFT_PF_TL T
2398: where T.USER_EFT_PROFILE_CODE = X_USER_EFT_PROFILE_CODE
2399: and T.LANGUAGE = L.LANGUAGE_CODE);
2400:
2401: open c;

Line 2443: update IBY_FNDCPT_USER_EFT_PF_TL set

2439: if (sql%notfound) then
2440: raise no_data_found;
2441: end if;
2442:
2443: update IBY_FNDCPT_USER_EFT_PF_TL set
2444: USER_EFT_PROFILE_NAME = X_USER_EFT_PROFILE_NAME,
2445: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
2446: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
2447: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 2461: delete from IBY_FNDCPT_USER_EFT_PF_TL

2457: procedure USER_EFT_PROF_DELETE_ROW (
2458: X_USER_EFT_PROFILE_CODE in VARCHAR2
2459: ) is
2460: begin
2461: delete from IBY_FNDCPT_USER_EFT_PF_TL
2462: where USER_EFT_PROFILE_CODE = X_USER_EFT_PROFILE_CODE;
2463:
2464: if (sql%notfound) then
2465: raise no_data_found;

Line 2479: delete from IBY_FNDCPT_USER_EFT_PF_TL T

2475:
2476: procedure USER_EFT_PROF_ADD_LANGUAGE
2477: is
2478: begin
2479: delete from IBY_FNDCPT_USER_EFT_PF_TL T
2480: where not exists
2481: (select NULL
2482: from IBY_FNDCPT_USER_EFT_PF_B B
2483: where B.USER_EFT_PROFILE_CODE = T.USER_EFT_PROFILE_CODE

Line 2486: update IBY_FNDCPT_USER_EFT_PF_TL T set (

2482: from IBY_FNDCPT_USER_EFT_PF_B B
2483: where B.USER_EFT_PROFILE_CODE = T.USER_EFT_PROFILE_CODE
2484: );
2485:
2486: update IBY_FNDCPT_USER_EFT_PF_TL T set (
2487: USER_EFT_PROFILE_NAME
2488: ) = (select
2489: B.USER_EFT_PROFILE_NAME
2490: from IBY_FNDCPT_USER_EFT_PF_TL B

Line 2490: from IBY_FNDCPT_USER_EFT_PF_TL B

2486: update IBY_FNDCPT_USER_EFT_PF_TL T set (
2487: USER_EFT_PROFILE_NAME
2488: ) = (select
2489: B.USER_EFT_PROFILE_NAME
2490: from IBY_FNDCPT_USER_EFT_PF_TL B
2491: where B.USER_EFT_PROFILE_CODE = T.USER_EFT_PROFILE_CODE
2492: and B.LANGUAGE = T.SOURCE_LANG)
2493: where (
2494: T.USER_EFT_PROFILE_CODE,

Line 2499: from IBY_FNDCPT_USER_EFT_PF_TL SUBB, IBY_FNDCPT_USER_EFT_PF_TL SUBT

2495: T.LANGUAGE
2496: ) in (select
2497: SUBT.USER_EFT_PROFILE_CODE,
2498: SUBT.LANGUAGE
2499: from IBY_FNDCPT_USER_EFT_PF_TL SUBB, IBY_FNDCPT_USER_EFT_PF_TL SUBT
2500: where SUBB.USER_EFT_PROFILE_CODE = SUBT.USER_EFT_PROFILE_CODE
2501: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2502: and (SUBB.USER_EFT_PROFILE_NAME <> SUBT.USER_EFT_PROFILE_NAME
2503: ));

Line 2505: insert into IBY_FNDCPT_USER_EFT_PF_TL (

2501: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2502: and (SUBB.USER_EFT_PROFILE_NAME <> SUBT.USER_EFT_PROFILE_NAME
2503: ));
2504:
2505: insert into IBY_FNDCPT_USER_EFT_PF_TL (
2506: USER_EFT_PROFILE_CODE,
2507: USER_EFT_PROFILE_NAME,
2508: CREATED_BY,
2509: CREATION_DATE,

Line 2527: from IBY_FNDCPT_USER_EFT_PF_TL B, FND_LANGUAGES L

2523: B.LAST_UPDATE_LOGIN,
2524: B.OBJECT_VERSION_NUMBER,
2525: L.LANGUAGE_CODE,
2526: B.SOURCE_LANG
2527: from IBY_FNDCPT_USER_EFT_PF_TL B, FND_LANGUAGES L
2528: where L.INSTALLED_FLAG in ('I', 'B')
2529: and B.LANGUAGE = userenv('LANG')
2530: and not exists
2531: (select NULL

Line 2532: from IBY_FNDCPT_USER_EFT_PF_TL T

2528: where L.INSTALLED_FLAG in ('I', 'B')
2529: and B.LANGUAGE = userenv('LANG')
2530: and not exists
2531: (select NULL
2532: from IBY_FNDCPT_USER_EFT_PF_TL T
2533: where T.USER_EFT_PROFILE_CODE = B.USER_EFT_PROFILE_CODE
2534: and T.LANGUAGE = L.LANGUAGE_CODE);
2535: end USER_EFT_PROF_ADD_LANGUAGE;
2536: