APPS.BIS_FUNCTIONAL_AREA_PVT dependencies on BIS_FUNCTIONAL_AREAS

Line 65: INSERT INTO BIS_FUNCTIONAL_AREAS

61: l_Func_Area_Rec.Creation_Date := l_Func_Area_Rec.Last_Update_Date;
62: END IF;
63:
64: -- INSERT THE ACTUAL VALUES INTO BASE TABLES
65: INSERT INTO BIS_FUNCTIONAL_AREAS
66: (
67: FUNCTIONAL_AREA_ID
68: , SHORT_NAME
69: , CREATED_BY

Line 87: INSERT INTO BIS_FUNCTIONAL_AREAS_TL

83: , l_Func_Area_Rec.Last_Update_Login
84: );
85:
86: -- INSERT THE ACTUAL VALUES INTO TRANSLATABLE TABLES
87: INSERT INTO BIS_FUNCTIONAL_AREAS_TL
88: (
89: FUNCTIONAL_AREA_ID
90: , NAME
91: , DESCRIPTION

Line 116: FROM BIS_FUNCTIONAL_AREAS_TL T

112: WHERE L.INSTALLED_FLAG IN ('I', 'B')
113: AND NOT EXISTS
114: (
115: SELECT NULL
116: FROM BIS_FUNCTIONAL_AREAS_TL T
117: WHERE T.FUNCTIONAL_AREA_ID = l_Func_Area_Rec.Functional_Area_Id
118: AND T.LANGUAGE = L.LANGUAGE_CODE
119: );
120:

Line 225: UPDATE BIS_FUNCTIONAL_AREAS

221: l_Func_Area_Rec.Last_Update_Login := p_Func_Area_Rec.Last_Update_Login;
222: END IF;
223:
224: -- Update the base table
225: UPDATE BIS_FUNCTIONAL_AREAS
226: SET
227: LAST_UPDATED_BY = l_Func_Area_Rec.Last_Updated_By
228: , LAST_UPDATE_DATE = l_Func_Area_Rec.Last_Update_Date
229: , LAST_UPDATE_LOGIN = l_Func_Area_Rec.Last_Update_Login

Line 354: UPDATE BIS_FUNCTIONAL_AREAS_TL

350: --DBMS_OUTPUT.PUT_LINE ('T p_Func_Area_Rec.Last_Updated_By - ' || p_Func_Area_Rec.Last_Updated_By);
351: --DBMS_OUTPUT.PUT_LINE ('T l_Func_Area_Rec.Last_Update_Date - ' || l_Func_Area_Rec.Last_Update_Date);
352:
353: -- Update the base table
354: UPDATE BIS_FUNCTIONAL_AREAS_TL
355: SET
356: NAME = l_Func_Area_Rec.Name
357: , DESCRIPTION = l_Func_Area_Rec.Description
358: , LAST_UPDATED_BY = l_Func_Area_Rec.Last_Updated_By

Line 432: FROM BIS_FUNCTIONAL_AREAS_VL F

428: , F.CREATION_DATE
429: , F.LAST_UPDATED_BY
430: , F.LAST_UPDATE_DATE
431: , F.LAST_UPDATE_LOGIN
432: FROM BIS_FUNCTIONAL_AREAS_VL F
433: WHERE F.SHORT_NAME = p_Func_Area_Rec.Short_Name;
434:
435: BEGIN
436: FND_MSG_PUB.Initialize;

Line 678: DELETE BIS_FUNCTIONAL_AREAS

674: END IF;
675:
676: END LOOP;
677:
678: DELETE BIS_FUNCTIONAL_AREAS
679: WHERE FUNCTIONAL_AREA_ID = l_Func_Area_Rec.Functional_Area_Id
680: AND SHORT_NAME = l_Func_Area_Rec.Short_Name;
681:
682: DELETE BIS_FUNCTIONAL_AREAS_TL

Line 682: DELETE BIS_FUNCTIONAL_AREAS_TL

678: DELETE BIS_FUNCTIONAL_AREAS
679: WHERE FUNCTIONAL_AREA_ID = l_Func_Area_Rec.Functional_Area_Id
680: AND SHORT_NAME = l_Func_Area_Rec.Short_Name;
681:
682: DELETE BIS_FUNCTIONAL_AREAS_TL
683: WHERE FUNCTIONAL_AREA_ID = l_Func_Area_Rec.Functional_Area_Id;
684: -- Commit if required
685: IF (p_Commit = FND_API.G_TRUE) THEN
686: COMMIT;

Line 798: DELETE FROM BIS_FUNCTIONAL_AREAS_TL T

794: -- procedure to add a language.
795: PROCEDURE Add_Language IS
796: BEGIN
797:
798: DELETE FROM BIS_FUNCTIONAL_AREAS_TL T
799: WHERE NOT EXISTS
800: (
801: SELECT NULL
802: FROM BIS_FUNCTIONAL_AREAS B

Line 802: FROM BIS_FUNCTIONAL_AREAS B

798: DELETE FROM BIS_FUNCTIONAL_AREAS_TL T
799: WHERE NOT EXISTS
800: (
801: SELECT NULL
802: FROM BIS_FUNCTIONAL_AREAS B
803: WHERE B.FUNCTIONAL_AREA_ID = T.FUNCTIONAL_AREA_ID
804: );
805:
806: UPDATE BIS_FUNCTIONAL_AREAS_TL T SET (

Line 806: UPDATE BIS_FUNCTIONAL_AREAS_TL T SET (

802: FROM BIS_FUNCTIONAL_AREAS B
803: WHERE B.FUNCTIONAL_AREA_ID = T.FUNCTIONAL_AREA_ID
804: );
805:
806: UPDATE BIS_FUNCTIONAL_AREAS_TL T SET (
807: NAME,
808: DESCRIPTION
809: ) = (SELECT
810: B.NAME,

Line 812: FROM BIS_FUNCTIONAL_AREAS_TL B

808: DESCRIPTION
809: ) = (SELECT
810: B.NAME,
811: B.DESCRIPTION
812: FROM BIS_FUNCTIONAL_AREAS_TL B
813: WHERE B.FUNCTIONAL_AREA_ID = T.FUNCTIONAL_AREA_ID
814: AND B.LANGUAGE = T.SOURCE_LANG)
815: WHERE (
816: T.FUNCTIONAL_AREA_ID,

Line 821: FROM BIS_FUNCTIONAL_AREAS_TL SUBB, BIS_FUNCTIONAL_AREAS_TL SUBT

817: T.LANGUAGE
818: ) IN (SELECT
819: SUBT.FUNCTIONAL_AREA_ID,
820: SUBT.LANGUAGE
821: FROM BIS_FUNCTIONAL_AREAS_TL SUBB, BIS_FUNCTIONAL_AREAS_TL SUBT
822: WHERE SUBB.FUNCTIONAL_AREA_ID = SUBT.FUNCTIONAL_AREA_ID
823: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
824: AND (
825: SUBB.NAME <> SUBT.NAME

Line 830: INSERT INTO BIS_FUNCTIONAL_AREAS_TL

826: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
827: )
828: );
829:
830: INSERT INTO BIS_FUNCTIONAL_AREAS_TL
831: (
832: FUNCTIONAL_AREA_ID
833: , NAME
834: , DESCRIPTION

Line 854: FROM BIS_FUNCTIONAL_AREAS_TL B, FND_LANGUAGES L

850: , B.CREATION_DATE
851: , B.LAST_UPDATED_BY
852: , B.LAST_UPDATE_DATE
853: , B.LAST_UPDATE_LOGIN
854: FROM BIS_FUNCTIONAL_AREAS_TL B, FND_LANGUAGES L
855: WHERE L.INSTALLED_FLAG IN ('I', 'B')
856: AND B.LANGUAGE = USERENV('LANG')
857: AND NOT EXISTS
858: (

Line 860: FROM BIS_FUNCTIONAL_AREAS_TL T

856: AND B.LANGUAGE = USERENV('LANG')
857: AND NOT EXISTS
858: (
859: SELECT NULL
860: FROM BIS_FUNCTIONAL_AREAS_TL T
861: WHERE T.FUNCTIONAL_AREA_ID = B.FUNCTIONAL_AREA_ID
862: AND T.LANGUAGE = L.LANGUAGE_CODE
863: );
864: