DBA Data[Home] [Help]

PACKAGE: APPS.JTF_RS_ROLE_RELATE_VUHK

Source


1 PACKAGE jtf_rs_role_relate_vuhk AUTHID CURRENT_USER AS
2  /* $Header: jtfrsils.pls 120.0 2005/05/11 08:20:17 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 
22 
23   PROCEDURE  update_res_role_relate_pre
24   (
25    P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
26    P_START_DATE_ACTIVE    IN     JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
27    P_END_DATE_ACTIVE      IN     JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
28    P_OBJECT_VERSION_NUM   IN     JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
29    P_DATA                   OUT NOCOPY  VARCHAR2,
30    P_COUNT            OUT NOCOPY  NUMBER,
31    P_RETURN_CODE            OUT NOCOPY  VARCHAR2
32   );
33 
34 
35   PROCEDURE  delete_res_role_relate_pre
36   (P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
37    P_OBJECT_VERSION_NUM   IN  JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
38    P_DATA                 OUT NOCOPY  VARCHAR2,
39    P_COUNT                OUT NOCOPY  NUMBER,
40    P_RETURN_CODE          OUT NOCOPY  VARCHAR2
41   );
42 
43    PROCEDURE  create_res_role_relate_post
44   (P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
45    P_ROLE_RESOURCE_TYPE   IN   JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
46    P_ROLE_RESOURCE_ID     IN   JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
47    P_ROLE_ID              IN   JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
48    P_START_DATE_ACTIVE    IN   JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
49    P_END_DATE_ACTIVE      IN   JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  NULL,
50    P_DATA                 OUT NOCOPY  VARCHAR2,
51    P_COUNT                OUT NOCOPY  NUMBER,
52    P_RETURN_CODE          OUT NOCOPY  VARCHAR2
53   );
54 
55 
56   PROCEDURE  update_res_role_relate_post
57   (
58    P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
59    P_START_DATE_ACTIVE    IN     JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
60    P_END_DATE_ACTIVE      IN     JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
61    P_OBJECT_VERSION_NUM   IN     JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
62    P_DATA                 OUT NOCOPY  VARCHAR2,
63    P_COUNT                OUT NOCOPY  NUMBER,
64    P_RETURN_CODE          OUT NOCOPY  VARCHAR2
65   );
66 
67 
68   PROCEDURE  delete_res_role_relate_post
69   (P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
70    P_OBJECT_VERSION_NUM   IN  JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
71    P_DATA                   OUT NOCOPY  VARCHAR2,
72    P_COUNT            OUT NOCOPY  NUMBER,
73    P_RETURN_CODE            OUT NOCOPY VARCHAR2
74   );
75 
76 
77 END jtf_rs_role_relate_vuhk;