APPS.BIS_FUNCTIONAL_AREA_PUB dependencies on BIS_FUNCTIONAL_AREAS

Line 12: REM | Module: Wrapper for populating the table BIS_FUNCTIONAL_AREAS_TL |

8: REM | FILENAME |
9: REM | BISPFASS.pls |
10: REM | |
11: REM | DESCRIPTION |
12: REM | Module: Wrapper for populating the table BIS_FUNCTIONAL_AREAS_TL |
13: REM | and relationship with FND_APPLICATIONS table |
14: REM | NOTES |
15: REM | 24-NOV-2004 Aditya Rao Created. |
16: REM +=======================================================================+

Line 29: Functional_Area_Id BIS_FUNCTIONAL_AREAS.FUNCTIONAL_AREA_ID%TYPE

25:
26:
27: TYPE Functional_Area_Rec_Type IS RECORD
28: (
29: Functional_Area_Id BIS_FUNCTIONAL_AREAS.FUNCTIONAL_AREA_ID%TYPE
30: , Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE -- requirement of this field is still under discussion
31: , Name BIS_FUNCTIONAL_AREAS_TL.NAME%TYPE
32: , Description BIS_FUNCTIONAL_AREAS_TL.DESCRIPTION%TYPE
33: , Created_By BIS_FUNCTIONAL_AREAS.CREATED_BY%TYPE

Line 30: , Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE -- requirement of this field is still under discussion

26:
27: TYPE Functional_Area_Rec_Type IS RECORD
28: (
29: Functional_Area_Id BIS_FUNCTIONAL_AREAS.FUNCTIONAL_AREA_ID%TYPE
30: , Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE -- requirement of this field is still under discussion
31: , Name BIS_FUNCTIONAL_AREAS_TL.NAME%TYPE
32: , Description BIS_FUNCTIONAL_AREAS_TL.DESCRIPTION%TYPE
33: , Created_By BIS_FUNCTIONAL_AREAS.CREATED_BY%TYPE
34: , Creation_Date BIS_FUNCTIONAL_AREAS.CREATION_DATE%TYPE

Line 31: , Name BIS_FUNCTIONAL_AREAS_TL.NAME%TYPE

27: TYPE Functional_Area_Rec_Type IS RECORD
28: (
29: Functional_Area_Id BIS_FUNCTIONAL_AREAS.FUNCTIONAL_AREA_ID%TYPE
30: , Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE -- requirement of this field is still under discussion
31: , Name BIS_FUNCTIONAL_AREAS_TL.NAME%TYPE
32: , Description BIS_FUNCTIONAL_AREAS_TL.DESCRIPTION%TYPE
33: , Created_By BIS_FUNCTIONAL_AREAS.CREATED_BY%TYPE
34: , Creation_Date BIS_FUNCTIONAL_AREAS.CREATION_DATE%TYPE
35: , Last_Updated_By BIS_FUNCTIONAL_AREAS.LAST_UPDATED_BY%TYPE

Line 32: , Description BIS_FUNCTIONAL_AREAS_TL.DESCRIPTION%TYPE

28: (
29: Functional_Area_Id BIS_FUNCTIONAL_AREAS.FUNCTIONAL_AREA_ID%TYPE
30: , Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE -- requirement of this field is still under discussion
31: , Name BIS_FUNCTIONAL_AREAS_TL.NAME%TYPE
32: , Description BIS_FUNCTIONAL_AREAS_TL.DESCRIPTION%TYPE
33: , Created_By BIS_FUNCTIONAL_AREAS.CREATED_BY%TYPE
34: , Creation_Date BIS_FUNCTIONAL_AREAS.CREATION_DATE%TYPE
35: , Last_Updated_By BIS_FUNCTIONAL_AREAS.LAST_UPDATED_BY%TYPE
36: , Last_Update_Date BIS_FUNCTIONAL_AREAS.LAST_UPDATE_DATE%TYPE

Line 33: , Created_By BIS_FUNCTIONAL_AREAS.CREATED_BY%TYPE

29: Functional_Area_Id BIS_FUNCTIONAL_AREAS.FUNCTIONAL_AREA_ID%TYPE
30: , Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE -- requirement of this field is still under discussion
31: , Name BIS_FUNCTIONAL_AREAS_TL.NAME%TYPE
32: , Description BIS_FUNCTIONAL_AREAS_TL.DESCRIPTION%TYPE
33: , Created_By BIS_FUNCTIONAL_AREAS.CREATED_BY%TYPE
34: , Creation_Date BIS_FUNCTIONAL_AREAS.CREATION_DATE%TYPE
35: , Last_Updated_By BIS_FUNCTIONAL_AREAS.LAST_UPDATED_BY%TYPE
36: , Last_Update_Date BIS_FUNCTIONAL_AREAS.LAST_UPDATE_DATE%TYPE
37: , Last_Update_Login BIS_FUNCTIONAL_AREAS.LAST_UPDATE_LOGIN%TYPE

Line 34: , Creation_Date BIS_FUNCTIONAL_AREAS.CREATION_DATE%TYPE

30: , Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE -- requirement of this field is still under discussion
31: , Name BIS_FUNCTIONAL_AREAS_TL.NAME%TYPE
32: , Description BIS_FUNCTIONAL_AREAS_TL.DESCRIPTION%TYPE
33: , Created_By BIS_FUNCTIONAL_AREAS.CREATED_BY%TYPE
34: , Creation_Date BIS_FUNCTIONAL_AREAS.CREATION_DATE%TYPE
35: , Last_Updated_By BIS_FUNCTIONAL_AREAS.LAST_UPDATED_BY%TYPE
36: , Last_Update_Date BIS_FUNCTIONAL_AREAS.LAST_UPDATE_DATE%TYPE
37: , Last_Update_Login BIS_FUNCTIONAL_AREAS.LAST_UPDATE_LOGIN%TYPE
38: );

Line 35: , Last_Updated_By BIS_FUNCTIONAL_AREAS.LAST_UPDATED_BY%TYPE

31: , Name BIS_FUNCTIONAL_AREAS_TL.NAME%TYPE
32: , Description BIS_FUNCTIONAL_AREAS_TL.DESCRIPTION%TYPE
33: , Created_By BIS_FUNCTIONAL_AREAS.CREATED_BY%TYPE
34: , Creation_Date BIS_FUNCTIONAL_AREAS.CREATION_DATE%TYPE
35: , Last_Updated_By BIS_FUNCTIONAL_AREAS.LAST_UPDATED_BY%TYPE
36: , Last_Update_Date BIS_FUNCTIONAL_AREAS.LAST_UPDATE_DATE%TYPE
37: , Last_Update_Login BIS_FUNCTIONAL_AREAS.LAST_UPDATE_LOGIN%TYPE
38: );
39:

Line 36: , Last_Update_Date BIS_FUNCTIONAL_AREAS.LAST_UPDATE_DATE%TYPE

32: , Description BIS_FUNCTIONAL_AREAS_TL.DESCRIPTION%TYPE
33: , Created_By BIS_FUNCTIONAL_AREAS.CREATED_BY%TYPE
34: , Creation_Date BIS_FUNCTIONAL_AREAS.CREATION_DATE%TYPE
35: , Last_Updated_By BIS_FUNCTIONAL_AREAS.LAST_UPDATED_BY%TYPE
36: , Last_Update_Date BIS_FUNCTIONAL_AREAS.LAST_UPDATE_DATE%TYPE
37: , Last_Update_Login BIS_FUNCTIONAL_AREAS.LAST_UPDATE_LOGIN%TYPE
38: );
39:
40: TYPE Func_Area_Apps_Depend_Rec_Type IS RECORD

Line 37: , Last_Update_Login BIS_FUNCTIONAL_AREAS.LAST_UPDATE_LOGIN%TYPE

33: , Created_By BIS_FUNCTIONAL_AREAS.CREATED_BY%TYPE
34: , Creation_Date BIS_FUNCTIONAL_AREAS.CREATION_DATE%TYPE
35: , Last_Updated_By BIS_FUNCTIONAL_AREAS.LAST_UPDATED_BY%TYPE
36: , Last_Update_Date BIS_FUNCTIONAL_AREAS.LAST_UPDATE_DATE%TYPE
37: , Last_Update_Login BIS_FUNCTIONAL_AREAS.LAST_UPDATE_LOGIN%TYPE
38: );
39:
40: TYPE Func_Area_Apps_Depend_Rec_Type IS RECORD
41: (

Line 43: , Func_Area_Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE

39:
40: TYPE Func_Area_Apps_Depend_Rec_Type IS RECORD
41: (
42: Functional_Area_Id BIS_FUNC_AREA_APP_DEPENDENCY.FUNCTIONAL_AREA_ID%TYPE
43: , Func_Area_Short_Name BIS_FUNCTIONAL_AREAS.SHORT_NAME%TYPE
44: , Application_Id BIS_FUNC_AREA_APP_DEPENDENCY.APPLICATION_ID%TYPE
45: , Apps_Short_Name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
46: );
47: