PACKAGE: APPS.BIS_RESPONSIBILITY_PUB

Source

1 PACKAGE BIS_RESPONSIBILITY_PUB as
2 /* $Header: BISPRSPS.pls 120.0 2005/06/01 15:36:39 appldev noship $ */
3 /*
4 REM +=======================================================================+
5 REM |    Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA     |
6 REM |                         All rights reserved.                          |
7 REM +=======================================================================+
8 REM | FILENAME                                                              |
9 REM |     BISPRSPS.pls                                                      |
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
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
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(
46                p_application_id         IN NUMBER
47              , p_responsibility_id      IN NUMBER
48              , p_menu_id                IN NUMBER
49              , x_return_status          OUT NOCOPY VARCHAR2
50              , x_msg_count              OUT NOCOPY NUMBER
51              , x_msg_data               OUT NOCOPY VARCHAR2
52             );
53 
54 PROCEDURE LOCK_ROW(
55            p_application_id         IN      NUMBER
56          , p_responsibility_id      IN      NUMBER
57          , p_last_update_date       IN      DATE
58          ) ;
59 
60 END BIS_RESPONSIBILITY_PUB;