[Home] [Help]
PACKAGE BODY: APPS.JTF_RS_DYNAMIC_GROUPS_IUHK
Source
1 PACKAGE BODY jtf_rs_dynamic_groups_iuhk AS
2 /* $Header: jtfrsnyb.pls 120.0 2005/05/11 08:21:00 appldev ship $ */
3
4 /*****************************************************************************************
5 This is a vertical industry user hook API for the jjtf_rs_dynamic_groups_pvt package
6 ******************************************************************************************/
7
8
9 PROCEDURE create_dynamic_groups_pre
10 (P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
11 P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
12 P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
13 P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
14 P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
15 P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
16 P_DATA OUT NOCOPY VARCHAR2,
17 P_COUNT OUT NOCOPY NUMBER,
18 P_RETURN_CODE OUT NOCOPY VARCHAR2
19 )
20 IS
21 BEGIN
22 NULL;
23 END;
24
25
26 PROCEDURE update_dynamic_groups_pre
27 (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
28 P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
29 P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
30 P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
31 P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32 P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
33 P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
34 P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
35 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
36 P_DATA OUT NOCOPY VARCHAR2,
37 P_COUNT OUT NOCOPY NUMBER,
38 P_RETURN_CODE OUT NOCOPY VARCHAR2
39 )
40 IS
41 BEGIN
42 NULL;
43 END;
44
45
46 PROCEDURE delete_dynamic_groups_pre
47 (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
48 P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
49 P_DATA OUT NOCOPY VARCHAR2,
50 P_COUNT OUT NOCOPY NUMBER,
51 P_RETURN_CODE OUT NOCOPY VARCHAR2
52 )
53 IS
54 BEGIN
55 NULL;
56 END;
57
58
59 PROCEDURE create_dynamic_groups_post
60 (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
61 P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
62 P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
63 P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
64 P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
65 P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
66 P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
67 P_DATA OUT NOCOPY VARCHAR2,
68 P_COUNT OUT NOCOPY NUMBER,
69 P_RETURN_CODE OUT NOCOPY VARCHAR2
70 )
71 IS
72 BEGIN
73 NULL;
74 END;
75
76
77
78 PROCEDURE update_dynamic_groups_post
79 (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
80 P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
81 P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
82 P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
83 P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
84 P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
85 P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
86 P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
87 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
88 P_DATA OUT NOCOPY VARCHAR2,
89 P_COUNT OUT NOCOPY NUMBER,
90 P_RETURN_CODE OUT NOCOPY VARCHAR2
91 )
92 IS
93 BEGIN
94 NULL;
95 END;
96
97
98
99 PROCEDURE delete_dynamic_groups_post
100 (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
101 P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
102 P_DATA OUT NOCOPY VARCHAR2,
103 P_COUNT OUT NOCOPY NUMBER,
104 P_RETURN_CODE OUT NOCOPY VARCHAR2
105 )
106 IS
107 BEGIN
108 NULL;
109 END;
110
111
112 END jtf_rs_dynamic_groups_iuhk;