[Home] [Help]
PACKAGE: APPS.JTF_RS_DYNAMIC_GROUPS_VUHK
Source
1 PACKAGE jtf_rs_dynamic_groups_vuhk AUTHID CURRENT_USER AS
2 /* $Header: jtfrsiys.pls 120.0 2005/05/11 08:20:23 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
21
22 PROCEDURE update_dynamic_groups_pre
23 (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
24 P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
25 P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
26 P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
27 P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
28 P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
29 P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
30 P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
31 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
32 P_DATA OUT NOCOPY VARCHAR2,
33 P_COUNT OUT NOCOPY NUMBER,
34 P_RETURN_CODE OUT NOCOPY VARCHAR2
35 );
36
37
38 PROCEDURE delete_dynamic_groups_pre
39 (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
40 P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
41 P_DATA OUT NOCOPY VARCHAR2,
42 P_COUNT OUT NOCOPY NUMBER,
43 P_RETURN_CODE OUT NOCOPY VARCHAR2
44 );
45
46
47 PROCEDURE create_dynamic_groups_post
48 (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
49 P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
50 P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
51 P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
52 P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
53 P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
54 P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
55 P_DATA OUT NOCOPY VARCHAR2,
56 P_COUNT OUT NOCOPY NUMBER,
57 P_RETURN_CODE OUT NOCOPY VARCHAR2
58 );
59
60
61 PROCEDURE update_dynamic_groups_post
62 (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
63 P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
64 P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
65 P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
66 P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
67 P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
68 P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
69 P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
70 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.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 PROCEDURE delete_dynamic_groups_post
78 (P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
79 P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.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
85 END jtf_rs_dynamic_groups_vuhk;