DBA Data[Home] [Help]

APPS.BIS_RESPONSIBILITY_PUB dependencies on FND_RESPONSIBILITY

Line 14: REM | insert records in the FND Responsibility table |

10: REM | PACKAGE |
11: REM | BIS_RESPONSIBILITY_PUB |
12: REM | DESCRIPTION |
13: REM | Module: Private package that calls the FND packages to |
14: REM | insert records in the FND Responsibility table |
15: REM | |
16: REM | NOTES |
17: REM | 07-MAR-2005 KRISHNA Created. |
18: REM | 25-MAR-2005 ANKAGARW bug#4392370 - Removed SECURITY_GROUP_ID | |

Line 23: Application_Id FND_RESPONSIBILITY.APPLICATION_ID%TYPE

19: REM +=======================================================================+
20: */
21: TYPE Responsibility_Rec_Type IS RECORD
22: (
23: Application_Id FND_RESPONSIBILITY.APPLICATION_ID%TYPE
24: , Responsibility_Id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE
25: , Responsibility_Key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE
26: , Menu_Id FND_RESPONSIBILITY.MENU_ID%TYPE
27: , Responsibility_Name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE

Line 24: , Responsibility_Id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE

20: */
21: TYPE Responsibility_Rec_Type IS RECORD
22: (
23: Application_Id FND_RESPONSIBILITY.APPLICATION_ID%TYPE
24: , Responsibility_Id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE
25: , Responsibility_Key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE
26: , Menu_Id FND_RESPONSIBILITY.MENU_ID%TYPE
27: , Responsibility_Name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE
28: , Description FND_RESPONSIBILITY_TL.DESCRIPTION%TYPE

Line 25: , Responsibility_Key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE

21: TYPE Responsibility_Rec_Type IS RECORD
22: (
23: Application_Id FND_RESPONSIBILITY.APPLICATION_ID%TYPE
24: , Responsibility_Id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE
25: , Responsibility_Key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE
26: , Menu_Id FND_RESPONSIBILITY.MENU_ID%TYPE
27: , Responsibility_Name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE
28: , Description FND_RESPONSIBILITY_TL.DESCRIPTION%TYPE
29: , Start_Date FND_RESPONSIBILITY.START_DATE%TYPE

Line 26: , Menu_Id FND_RESPONSIBILITY.MENU_ID%TYPE

22: (
23: Application_Id FND_RESPONSIBILITY.APPLICATION_ID%TYPE
24: , Responsibility_Id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE
25: , Responsibility_Key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE
26: , Menu_Id FND_RESPONSIBILITY.MENU_ID%TYPE
27: , Responsibility_Name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE
28: , Description FND_RESPONSIBILITY_TL.DESCRIPTION%TYPE
29: , Start_Date FND_RESPONSIBILITY.START_DATE%TYPE
30: , End_Date FND_RESPONSIBILITY.END_DATE%TYPE

Line 27: , Responsibility_Name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE

23: Application_Id FND_RESPONSIBILITY.APPLICATION_ID%TYPE
24: , Responsibility_Id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE
25: , Responsibility_Key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE
26: , Menu_Id FND_RESPONSIBILITY.MENU_ID%TYPE
27: , Responsibility_Name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE
28: , Description FND_RESPONSIBILITY_TL.DESCRIPTION%TYPE
29: , Start_Date FND_RESPONSIBILITY.START_DATE%TYPE
30: , End_Date FND_RESPONSIBILITY.END_DATE%TYPE
31: , Version FND_RESPONSIBILITY.VERSION%TYPE

Line 28: , Description FND_RESPONSIBILITY_TL.DESCRIPTION%TYPE

24: , Responsibility_Id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE
25: , Responsibility_Key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE
26: , Menu_Id FND_RESPONSIBILITY.MENU_ID%TYPE
27: , Responsibility_Name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE
28: , Description FND_RESPONSIBILITY_TL.DESCRIPTION%TYPE
29: , Start_Date FND_RESPONSIBILITY.START_DATE%TYPE
30: , End_Date FND_RESPONSIBILITY.END_DATE%TYPE
31: , Version FND_RESPONSIBILITY.VERSION%TYPE
32: , Web_Host_Name FND_RESPONSIBILITY.WEB_HOST_NAME%TYPE

Line 29: , Start_Date FND_RESPONSIBILITY.START_DATE%TYPE

25: , Responsibility_Key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE
26: , Menu_Id FND_RESPONSIBILITY.MENU_ID%TYPE
27: , Responsibility_Name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE
28: , Description FND_RESPONSIBILITY_TL.DESCRIPTION%TYPE
29: , Start_Date FND_RESPONSIBILITY.START_DATE%TYPE
30: , End_Date FND_RESPONSIBILITY.END_DATE%TYPE
31: , Version FND_RESPONSIBILITY.VERSION%TYPE
32: , Web_Host_Name FND_RESPONSIBILITY.WEB_HOST_NAME%TYPE
33: , Web_Agent_Name FND_RESPONSIBILITY.WEB_AGENT_NAME%TYPE

Line 30: , End_Date FND_RESPONSIBILITY.END_DATE%TYPE

26: , Menu_Id FND_RESPONSIBILITY.MENU_ID%TYPE
27: , Responsibility_Name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE
28: , Description FND_RESPONSIBILITY_TL.DESCRIPTION%TYPE
29: , Start_Date FND_RESPONSIBILITY.START_DATE%TYPE
30: , End_Date FND_RESPONSIBILITY.END_DATE%TYPE
31: , Version FND_RESPONSIBILITY.VERSION%TYPE
32: , Web_Host_Name FND_RESPONSIBILITY.WEB_HOST_NAME%TYPE
33: , Web_Agent_Name FND_RESPONSIBILITY.WEB_AGENT_NAME%TYPE
34: , Data_Group_Application_Id FND_RESPONSIBILITY.DATA_GROUP_APPLICATION_ID%TYPE

Line 31: , Version FND_RESPONSIBILITY.VERSION%TYPE

27: , Responsibility_Name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE
28: , Description FND_RESPONSIBILITY_TL.DESCRIPTION%TYPE
29: , Start_Date FND_RESPONSIBILITY.START_DATE%TYPE
30: , End_Date FND_RESPONSIBILITY.END_DATE%TYPE
31: , Version FND_RESPONSIBILITY.VERSION%TYPE
32: , Web_Host_Name FND_RESPONSIBILITY.WEB_HOST_NAME%TYPE
33: , Web_Agent_Name FND_RESPONSIBILITY.WEB_AGENT_NAME%TYPE
34: , Data_Group_Application_Id FND_RESPONSIBILITY.DATA_GROUP_APPLICATION_ID%TYPE
35: , Data_Group_Id FND_RESPONSIBILITY.DATA_GROUP_ID%TYPE

Line 32: , Web_Host_Name FND_RESPONSIBILITY.WEB_HOST_NAME%TYPE

28: , Description FND_RESPONSIBILITY_TL.DESCRIPTION%TYPE
29: , Start_Date FND_RESPONSIBILITY.START_DATE%TYPE
30: , End_Date FND_RESPONSIBILITY.END_DATE%TYPE
31: , Version FND_RESPONSIBILITY.VERSION%TYPE
32: , Web_Host_Name FND_RESPONSIBILITY.WEB_HOST_NAME%TYPE
33: , Web_Agent_Name FND_RESPONSIBILITY.WEB_AGENT_NAME%TYPE
34: , Data_Group_Application_Id FND_RESPONSIBILITY.DATA_GROUP_APPLICATION_ID%TYPE
35: , Data_Group_Id FND_RESPONSIBILITY.DATA_GROUP_ID%TYPE
36: , Group_Application_Id FND_RESPONSIBILITY.GROUP_APPLICATION_ID%TYPE

Line 33: , Web_Agent_Name FND_RESPONSIBILITY.WEB_AGENT_NAME%TYPE

29: , Start_Date FND_RESPONSIBILITY.START_DATE%TYPE
30: , End_Date FND_RESPONSIBILITY.END_DATE%TYPE
31: , Version FND_RESPONSIBILITY.VERSION%TYPE
32: , Web_Host_Name FND_RESPONSIBILITY.WEB_HOST_NAME%TYPE
33: , Web_Agent_Name FND_RESPONSIBILITY.WEB_AGENT_NAME%TYPE
34: , Data_Group_Application_Id FND_RESPONSIBILITY.DATA_GROUP_APPLICATION_ID%TYPE
35: , Data_Group_Id FND_RESPONSIBILITY.DATA_GROUP_ID%TYPE
36: , Group_Application_Id FND_RESPONSIBILITY.GROUP_APPLICATION_ID%TYPE
37: , Request_Group_Id FND_RESPONSIBILITY.REQUEST_GROUP_ID%TYPE

Line 34: , Data_Group_Application_Id FND_RESPONSIBILITY.DATA_GROUP_APPLICATION_ID%TYPE

30: , End_Date FND_RESPONSIBILITY.END_DATE%TYPE
31: , Version FND_RESPONSIBILITY.VERSION%TYPE
32: , Web_Host_Name FND_RESPONSIBILITY.WEB_HOST_NAME%TYPE
33: , Web_Agent_Name FND_RESPONSIBILITY.WEB_AGENT_NAME%TYPE
34: , Data_Group_Application_Id FND_RESPONSIBILITY.DATA_GROUP_APPLICATION_ID%TYPE
35: , Data_Group_Id FND_RESPONSIBILITY.DATA_GROUP_ID%TYPE
36: , Group_Application_Id FND_RESPONSIBILITY.GROUP_APPLICATION_ID%TYPE
37: , Request_Group_Id FND_RESPONSIBILITY.REQUEST_GROUP_ID%TYPE
38: , Last_Update_Date FND_RESPONSIBILITY.LAST_UPDATE_DATE%TYPE

Line 35: , Data_Group_Id FND_RESPONSIBILITY.DATA_GROUP_ID%TYPE

31: , Version FND_RESPONSIBILITY.VERSION%TYPE
32: , Web_Host_Name FND_RESPONSIBILITY.WEB_HOST_NAME%TYPE
33: , Web_Agent_Name FND_RESPONSIBILITY.WEB_AGENT_NAME%TYPE
34: , Data_Group_Application_Id FND_RESPONSIBILITY.DATA_GROUP_APPLICATION_ID%TYPE
35: , Data_Group_Id FND_RESPONSIBILITY.DATA_GROUP_ID%TYPE
36: , Group_Application_Id FND_RESPONSIBILITY.GROUP_APPLICATION_ID%TYPE
37: , Request_Group_Id FND_RESPONSIBILITY.REQUEST_GROUP_ID%TYPE
38: , Last_Update_Date FND_RESPONSIBILITY.LAST_UPDATE_DATE%TYPE
39: , Last_Updated_By FND_RESPONSIBILITY.LAST_UPDATED_BY%TYPE

Line 36: , Group_Application_Id FND_RESPONSIBILITY.GROUP_APPLICATION_ID%TYPE

32: , Web_Host_Name FND_RESPONSIBILITY.WEB_HOST_NAME%TYPE
33: , Web_Agent_Name FND_RESPONSIBILITY.WEB_AGENT_NAME%TYPE
34: , Data_Group_Application_Id FND_RESPONSIBILITY.DATA_GROUP_APPLICATION_ID%TYPE
35: , Data_Group_Id FND_RESPONSIBILITY.DATA_GROUP_ID%TYPE
36: , Group_Application_Id FND_RESPONSIBILITY.GROUP_APPLICATION_ID%TYPE
37: , Request_Group_Id FND_RESPONSIBILITY.REQUEST_GROUP_ID%TYPE
38: , Last_Update_Date FND_RESPONSIBILITY.LAST_UPDATE_DATE%TYPE
39: , Last_Updated_By FND_RESPONSIBILITY.LAST_UPDATED_BY%TYPE
40: , Creation_Date FND_RESPONSIBILITY.CREATION_DATE%TYPE

Line 37: , Request_Group_Id FND_RESPONSIBILITY.REQUEST_GROUP_ID%TYPE

33: , Web_Agent_Name FND_RESPONSIBILITY.WEB_AGENT_NAME%TYPE
34: , Data_Group_Application_Id FND_RESPONSIBILITY.DATA_GROUP_APPLICATION_ID%TYPE
35: , Data_Group_Id FND_RESPONSIBILITY.DATA_GROUP_ID%TYPE
36: , Group_Application_Id FND_RESPONSIBILITY.GROUP_APPLICATION_ID%TYPE
37: , Request_Group_Id FND_RESPONSIBILITY.REQUEST_GROUP_ID%TYPE
38: , Last_Update_Date FND_RESPONSIBILITY.LAST_UPDATE_DATE%TYPE
39: , Last_Updated_By FND_RESPONSIBILITY.LAST_UPDATED_BY%TYPE
40: , Creation_Date FND_RESPONSIBILITY.CREATION_DATE%TYPE
41: , Created_By FND_RESPONSIBILITY.CREATED_BY%TYPE

Line 38: , Last_Update_Date FND_RESPONSIBILITY.LAST_UPDATE_DATE%TYPE

34: , Data_Group_Application_Id FND_RESPONSIBILITY.DATA_GROUP_APPLICATION_ID%TYPE
35: , Data_Group_Id FND_RESPONSIBILITY.DATA_GROUP_ID%TYPE
36: , Group_Application_Id FND_RESPONSIBILITY.GROUP_APPLICATION_ID%TYPE
37: , Request_Group_Id FND_RESPONSIBILITY.REQUEST_GROUP_ID%TYPE
38: , Last_Update_Date FND_RESPONSIBILITY.LAST_UPDATE_DATE%TYPE
39: , Last_Updated_By FND_RESPONSIBILITY.LAST_UPDATED_BY%TYPE
40: , Creation_Date FND_RESPONSIBILITY.CREATION_DATE%TYPE
41: , Created_By FND_RESPONSIBILITY.CREATED_BY%TYPE
42: , Last_Update_Login FND_RESPONSIBILITY.LAST_UPDATE_LOGIN%TYPE

Line 39: , Last_Updated_By FND_RESPONSIBILITY.LAST_UPDATED_BY%TYPE

35: , Data_Group_Id FND_RESPONSIBILITY.DATA_GROUP_ID%TYPE
36: , Group_Application_Id FND_RESPONSIBILITY.GROUP_APPLICATION_ID%TYPE
37: , Request_Group_Id FND_RESPONSIBILITY.REQUEST_GROUP_ID%TYPE
38: , Last_Update_Date FND_RESPONSIBILITY.LAST_UPDATE_DATE%TYPE
39: , Last_Updated_By FND_RESPONSIBILITY.LAST_UPDATED_BY%TYPE
40: , Creation_Date FND_RESPONSIBILITY.CREATION_DATE%TYPE
41: , Created_By FND_RESPONSIBILITY.CREATED_BY%TYPE
42: , Last_Update_Login FND_RESPONSIBILITY.LAST_UPDATE_LOGIN%TYPE
43: );

Line 40: , Creation_Date FND_RESPONSIBILITY.CREATION_DATE%TYPE

36: , Group_Application_Id FND_RESPONSIBILITY.GROUP_APPLICATION_ID%TYPE
37: , Request_Group_Id FND_RESPONSIBILITY.REQUEST_GROUP_ID%TYPE
38: , Last_Update_Date FND_RESPONSIBILITY.LAST_UPDATE_DATE%TYPE
39: , Last_Updated_By FND_RESPONSIBILITY.LAST_UPDATED_BY%TYPE
40: , Creation_Date FND_RESPONSIBILITY.CREATION_DATE%TYPE
41: , Created_By FND_RESPONSIBILITY.CREATED_BY%TYPE
42: , Last_Update_Login FND_RESPONSIBILITY.LAST_UPDATE_LOGIN%TYPE
43: );
44:

Line 41: , Created_By FND_RESPONSIBILITY.CREATED_BY%TYPE

37: , Request_Group_Id FND_RESPONSIBILITY.REQUEST_GROUP_ID%TYPE
38: , Last_Update_Date FND_RESPONSIBILITY.LAST_UPDATE_DATE%TYPE
39: , Last_Updated_By FND_RESPONSIBILITY.LAST_UPDATED_BY%TYPE
40: , Creation_Date FND_RESPONSIBILITY.CREATION_DATE%TYPE
41: , Created_By FND_RESPONSIBILITY.CREATED_BY%TYPE
42: , Last_Update_Login FND_RESPONSIBILITY.LAST_UPDATE_LOGIN%TYPE
43: );
44:
45: PROCEDURE UPDATE_ROW(

Line 42: , Last_Update_Login FND_RESPONSIBILITY.LAST_UPDATE_LOGIN%TYPE

38: , Last_Update_Date FND_RESPONSIBILITY.LAST_UPDATE_DATE%TYPE
39: , Last_Updated_By FND_RESPONSIBILITY.LAST_UPDATED_BY%TYPE
40: , Creation_Date FND_RESPONSIBILITY.CREATION_DATE%TYPE
41: , Created_By FND_RESPONSIBILITY.CREATED_BY%TYPE
42: , Last_Update_Login FND_RESPONSIBILITY.LAST_UPDATE_LOGIN%TYPE
43: );
44:
45: PROCEDURE UPDATE_ROW(
46: p_application_id IN NUMBER