APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_USER_DC_PF_TL

Line 2588: insert into IBY_FNDCPT_USER_DC_PF_TL (

2584: X_LAST_UPDATED_BY,
2585: X_LAST_UPDATE_LOGIN
2586: );
2587:
2588: insert into IBY_FNDCPT_USER_DC_PF_TL (
2589: LAST_UPDATE_DATE,
2590: LAST_UPDATE_LOGIN,
2591: OBJECT_VERSION_NUMBER,
2592: CREATED_BY,

Line 2614: from IBY_FNDCPT_USER_DC_PF_TL T

2610: from FND_LANGUAGES L
2611: where L.INSTALLED_FLAG in ('I', 'B')
2612: and not exists
2613: (select NULL
2614: from IBY_FNDCPT_USER_DC_PF_TL T
2615: where T.USER_DC_PROFILE_CODE = X_USER_DC_PROFILE_CODE
2616: and T.LANGUAGE = L.LANGUAGE_CODE);
2617:
2618: open c;

Line 2660: update IBY_FNDCPT_USER_DC_PF_TL set

2656: if (sql%notfound) then
2657: raise no_data_found;
2658: end if;
2659:
2660: update IBY_FNDCPT_USER_DC_PF_TL set
2661: USER_DC_PROFILE_NAME = X_USER_DC_PROFILE_NAME,
2662: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
2663: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
2664: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 2678: delete from IBY_FNDCPT_USER_DC_PF_TL

2674: procedure USER_DC_PROF_DELETE_ROW (
2675: X_USER_DC_PROFILE_CODE in VARCHAR2
2676: ) is
2677: begin
2678: delete from IBY_FNDCPT_USER_DC_PF_TL
2679: where USER_DC_PROFILE_CODE = X_USER_DC_PROFILE_CODE;
2680:
2681: if (sql%notfound) then
2682: raise no_data_found;

Line 2696: delete from IBY_FNDCPT_USER_DC_PF_TL T

2692:
2693: procedure USER_DC_PROF_ADD_LANGUAGE
2694: is
2695: begin
2696: delete from IBY_FNDCPT_USER_DC_PF_TL T
2697: where not exists
2698: (select NULL
2699: from IBY_FNDCPT_USER_DC_PF_B B
2700: where B.USER_DC_PROFILE_CODE = T.USER_DC_PROFILE_CODE

Line 2703: update IBY_FNDCPT_USER_DC_PF_TL T set (

2699: from IBY_FNDCPT_USER_DC_PF_B B
2700: where B.USER_DC_PROFILE_CODE = T.USER_DC_PROFILE_CODE
2701: );
2702:
2703: update IBY_FNDCPT_USER_DC_PF_TL T set (
2704: USER_DC_PROFILE_NAME
2705: ) = (select
2706: B.USER_DC_PROFILE_NAME
2707: from IBY_FNDCPT_USER_DC_PF_TL B

Line 2707: from IBY_FNDCPT_USER_DC_PF_TL B

2703: update IBY_FNDCPT_USER_DC_PF_TL T set (
2704: USER_DC_PROFILE_NAME
2705: ) = (select
2706: B.USER_DC_PROFILE_NAME
2707: from IBY_FNDCPT_USER_DC_PF_TL B
2708: where B.USER_DC_PROFILE_CODE = T.USER_DC_PROFILE_CODE
2709: and B.LANGUAGE = T.SOURCE_LANG)
2710: where (
2711: T.USER_DC_PROFILE_CODE,

Line 2716: from IBY_FNDCPT_USER_DC_PF_TL SUBB, IBY_FNDCPT_USER_DC_PF_TL SUBT

2712: T.LANGUAGE
2713: ) in (select
2714: SUBT.USER_DC_PROFILE_CODE,
2715: SUBT.LANGUAGE
2716: from IBY_FNDCPT_USER_DC_PF_TL SUBB, IBY_FNDCPT_USER_DC_PF_TL SUBT
2717: where SUBB.USER_DC_PROFILE_CODE = SUBT.USER_DC_PROFILE_CODE
2718: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2719: and (SUBB.USER_DC_PROFILE_NAME <> SUBT.USER_DC_PROFILE_NAME
2720: ));

Line 2722: insert into IBY_FNDCPT_USER_DC_PF_TL (

2718: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2719: and (SUBB.USER_DC_PROFILE_NAME <> SUBT.USER_DC_PROFILE_NAME
2720: ));
2721:
2722: insert into IBY_FNDCPT_USER_DC_PF_TL (
2723: LAST_UPDATE_DATE,
2724: LAST_UPDATE_LOGIN,
2725: OBJECT_VERSION_NUMBER,
2726: CREATED_BY,

Line 2744: from IBY_FNDCPT_USER_DC_PF_TL B, FND_LANGUAGES L

2740: B.USER_DC_PROFILE_CODE,
2741: B.USER_DC_PROFILE_NAME,
2742: L.LANGUAGE_CODE,
2743: B.SOURCE_LANG
2744: from IBY_FNDCPT_USER_DC_PF_TL B, FND_LANGUAGES L
2745: where L.INSTALLED_FLAG in ('I', 'B')
2746: and B.LANGUAGE = userenv('LANG')
2747: and not exists
2748: (select NULL

Line 2749: from IBY_FNDCPT_USER_DC_PF_TL T

2745: where L.INSTALLED_FLAG in ('I', 'B')
2746: and B.LANGUAGE = userenv('LANG')
2747: and not exists
2748: (select NULL
2749: from IBY_FNDCPT_USER_DC_PF_TL T
2750: where T.USER_DC_PROFILE_CODE = B.USER_DC_PROFILE_CODE
2751: and T.LANGUAGE = L.LANGUAGE_CODE);
2752: end USER_DC_PROF_ADD_LANGUAGE;
2753: