[Home] [Help]
PACKAGE: APPS.JTF_RS_GROUP_RELATE_CUHK
Source
1 PACKAGE jtf_rs_group_relate_cuhk AS
2 /* $Header: jtfrscfs.pls 120.0 2005/05/11 08:19:38 appldev ship $ */
3
4 /*****************************************************************************************
5 This is a user hook API for the jtf_rs_group_relate_pvt package
6 ******************************************************************************************/
7
8
9 /*for create resource group relate */
10
11 PROCEDURE create_res_group_relate_pre
12 (P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
13 P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
14 P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
15 P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
16 P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
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_group_relate_pre
24 (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
25 P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
26 P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
27 P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
28 P_DATA OUT NOCOPY VARCHAR2,
29 P_COUNT OUT NOCOPY NUMBER,
30 P_RETURN_CODE OUT NOCOPY VARCHAR2
31 );
32
33
34 PROCEDURE delete_res_group_relate_pre
35 (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
36 P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
37 P_DATA OUT NOCOPY VARCHAR2,
38 P_COUNT OUT NOCOPY NUMBER,
39 P_RETURN_CODE OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE create_res_group_relate_post
43 (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
44 P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
45 P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
46 P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
47 P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
48 P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
49 P_DATA OUT NOCOPY VARCHAR2,
50 P_COUNT OUT NOCOPY NUMBER,
51 P_RETURN_CODE OUT NOCOPY VARCHAR2
52 );
53
54
55 PROCEDURE update_res_group_relate_post
56 (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
57 P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
58 P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
59 P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
60 P_DATA OUT NOCOPY VARCHAR2,
61 P_COUNT OUT NOCOPY NUMBER,
62 P_RETURN_CODE OUT NOCOPY VARCHAR2
63 );
64
65
66 PROCEDURE delete_res_group_relate_post
67 (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
68 P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
69 P_DATA OUT NOCOPY VARCHAR2,
70 P_COUNT OUT NOCOPY NUMBER,
71 P_RETURN_CODE OUT NOCOPY VARCHAR2
72 );
73
74 FUNCTION Ok_To_Generate_Msg
75 (P_GROUP_RELATE_ID IN NUMBER,
76 X_RETURN_STATUS OUT NOCOPY VARCHAR2)
77 RETURN BOOLEAN;
78 END jtf_rs_group_relate_cuhk;