DBA Data[Home] [Help]

PACKAGE BODY: APPS.JTF_RS_GROUP_RELATE_IUHK

Source


1 PACKAGE BODY jtf_rs_group_relate_iuhk AS
2  /* $Header: jtfrsnfb.pls 120.0 2005/05/11 08:20:45 appldev ship $ */
3 
4   /*****************************************************************************************
5    This is a vertical industry user hook  API for the jtf_rs_group_relate_pvt package
6   ******************************************************************************************/
7 
8 
9   PROCEDURE  create_res_group_relate_pre
10   (P_GROUP_ID             IN   JTF_RS_GROUPS_B.GROUP_ID%TYPE,
11    P_RELATED_GROUP_ID     IN   JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
12    P_RELATION_TYPE        IN   JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
13    P_START_DATE_ACTIVE    IN   JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
14    P_END_DATE_ACTIVE      IN   JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  NULL,
15    P_DATA                 OUT NOCOPY  VARCHAR2,
16    P_COUNT                OUT NOCOPY  NUMBER,
17    P_RETURN_CODE          OUT NOCOPY  VARCHAR2
18   )
19   IS
20   BEGIN
21     NULL;
22   END;
23 
24 
25   PROCEDURE  update_res_group_relate_pre
26   (P_GROUP_RELATE_ID      IN   JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
27    P_START_DATE_ACTIVE    IN   JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
28    P_END_DATE_ACTIVE      IN   JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
29    P_OBJECT_VERSION_NUM   IN   JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
30    P_DATA                   OUT NOCOPY  VARCHAR2,
31    P_COUNT            OUT NOCOPY  NUMBER,
32    P_RETURN_CODE            OUT NOCOPY  VARCHAR2
33   )
34   IS
35   BEGIN
36     NULL;
37   END;
38 
39 
40   PROCEDURE  delete_res_group_relate_pre
41   (P_GROUP_RELATE_ID      IN   JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
42    P_OBJECT_VERSION_NUM   IN   JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
43    P_DATA                 OUT NOCOPY  VARCHAR2,
44    P_COUNT                OUT NOCOPY  NUMBER,
45    P_RETURN_CODE          OUT NOCOPY  VARCHAR2
46   )
47   IS
48   BEGIN
49     NULL;
50   END;
51 
52    PROCEDURE  create_res_group_relate_post
53   (P_GROUP_RELATE_ID      IN   JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
54    P_GROUP_ID             IN   JTF_RS_GROUPS_B.GROUP_ID%TYPE,
55    P_RELATED_GROUP_ID     IN   JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
56    P_RELATION_TYPE        IN   JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
57    P_START_DATE_ACTIVE    IN   JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
58    P_END_DATE_ACTIVE      IN   JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  NULL,
59    P_DATA                 OUT NOCOPY  VARCHAR2,
60    P_COUNT                OUT NOCOPY  NUMBER,
61    P_RETURN_CODE          OUT NOCOPY  VARCHAR2
62   )
63  IS
64   BEGIN
65     NULL;
66   END;
67 
68 
69   PROCEDURE  update_res_group_relate_post
70   (P_GROUP_RELATE_ID      IN   JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
71    P_START_DATE_ACTIVE    IN   JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
72    P_END_DATE_ACTIVE      IN   JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
73    P_OBJECT_VERSION_NUM   IN   JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
74    P_DATA                   OUT NOCOPY  VARCHAR2,
75    P_COUNT            OUT NOCOPY  NUMBER,
76    P_RETURN_CODE            OUT NOCOPY VARCHAR2
77   )
78  IS
79   BEGIN
80     NULL;
81   END;
82 
83 
84   PROCEDURE  delete_res_group_relate_post
85   (P_GROUP_RELATE_ID      IN   JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
86    P_OBJECT_VERSION_NUM   IN   JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
87    P_DATA                 OUT NOCOPY  VARCHAR2,
88    P_COUNT                OUT NOCOPY  NUMBER,
89    P_RETURN_CODE          OUT NOCOPY  VARCHAR2
90   )
91  IS
92   BEGIN
93     NULL;
94   END;
95 
96 
97 
98 END jtf_rs_group_relate_iuhk;