DBA Data[Home] [Help]

PACKAGE BODY: APPS.JTF_RS_ROLE_RELATE_IUHK

Source


1 PACKAGE BODY jtf_rs_role_relate_iuhk AS
2  /* $Header: jtfrsnlb.pls 120.0 2005/05/11 08:20:50 appldev ship $ */
3 
4   /*****************************************************************************************
5    This is a user hook  API for the jtf_rs_role_relate_pvt package
6   ******************************************************************************************/
7 
8 
9   /*for create resource role relate */
10 
11   PROCEDURE  create_res_role_relate_pre
12   (P_ROLE_RESOURCE_TYPE    JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
13    P_ROLE_RESOURCE_ID       JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
14    P_ROLE_ID                 JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
15    P_START_DATE_ACTIVE      JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
16    P_END_DATE_ACTIVE         JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE ,
17    P_DATA                   OUT NOCOPY  VARCHAR2,
18    P_COUNT                  OUT NOCOPY  NUMBER,
19    P_RETURN_CODE            OUT NOCOPY  VARCHAR2
20   )
21   IS
22   BEGIN
23     NULL;
24   END;
25 
26 
27   PROCEDURE  update_res_role_relate_pre
28   (
29    P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
30    P_START_DATE_ACTIVE    IN     JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
31    P_END_DATE_ACTIVE      IN     JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
32    P_OBJECT_VERSION_NUM   IN     JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
33    P_DATA                   OUT NOCOPY  VARCHAR2,
34    P_COUNT            OUT NOCOPY  NUMBER,
35    P_RETURN_CODE            OUT NOCOPY  VARCHAR2
36   )
37  IS
38   BEGIN
39     NULL;
40   END;
41 
42 
43   PROCEDURE  delete_res_role_relate_pre
44   (P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
45    P_OBJECT_VERSION_NUM   IN  JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
46    P_DATA                 OUT NOCOPY  VARCHAR2,
47    P_COUNT                OUT NOCOPY  NUMBER,
48    P_RETURN_CODE          OUT NOCOPY  VARCHAR2
49   )
50  IS
51   BEGIN
52     NULL;
53   END;
54 
55 
56    PROCEDURE  create_res_role_relate_post
57   (P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
58    P_ROLE_RESOURCE_TYPE   IN   JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
59    P_ROLE_RESOURCE_ID     IN   JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
60    P_ROLE_ID              IN   JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
61    P_START_DATE_ACTIVE    IN   JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
62    P_END_DATE_ACTIVE      IN   JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  NULL,
63    P_DATA                 OUT NOCOPY  VARCHAR2,
64    P_COUNT                OUT NOCOPY  NUMBER,
65    P_RETURN_CODE          OUT NOCOPY  VARCHAR2
66   )
67  IS
68   BEGIN
69     NULL;
70   END;
71 
72 
73 
74   PROCEDURE  update_res_role_relate_post
75   (
76    P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
77    P_START_DATE_ACTIVE    IN     JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
78    P_END_DATE_ACTIVE      IN     JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
79    P_OBJECT_VERSION_NUM   IN     JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
80    P_DATA                 OUT NOCOPY  VARCHAR2,
81    P_COUNT                OUT NOCOPY  NUMBER,
82    P_RETURN_CODE          OUT NOCOPY  VARCHAR2
83   )
84  IS
85   BEGIN
86     NULL;
87   END;
88 
89 
90 
91   PROCEDURE  delete_res_role_relate_post
92   (P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93    P_OBJECT_VERSION_NUM   IN  JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
94    P_DATA                   OUT NOCOPY  VARCHAR2,
95    P_COUNT            OUT NOCOPY  NUMBER,
96    P_RETURN_CODE            OUT NOCOPY  VARCHAR2
97   )
98  IS
99   BEGIN
100     NULL;
101   END;
102 
103 
104 
105 END jtf_rs_role_relate_iuhk;