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 | |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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:
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(
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