[Home] [Help]
PACKAGE: APPS.JTF_RS_GROUP_RELATE_VUHK
Source
1 PACKAGE jtf_rs_group_relate_vuhk AUTHID CURRENT_USER AS
2 /* $Header: jtfrsifs.pls 120.0 2005/05/11 08:20:14 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
20
21 PROCEDURE update_res_group_relate_pre
22 (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
23 P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
24 P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
25 P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
26 P_DATA OUT NOCOPY VARCHAR2,
27 P_COUNT OUT NOCOPY NUMBER,
28 P_RETURN_CODE OUT NOCOPY VARCHAR2
29 );
30
31
32 PROCEDURE delete_res_group_relate_pre
33 (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
34 P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
35 P_DATA OUT NOCOPY VARCHAR2,
36 P_COUNT OUT NOCOPY NUMBER,
37 P_RETURN_CODE OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE create_res_group_relate_post
41 (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
42 P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
43 P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
44 P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
45 P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
46 P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
47 P_DATA OUT NOCOPY VARCHAR2,
48 P_COUNT OUT NOCOPY NUMBER,
49 P_RETURN_CODE OUT NOCOPY VARCHAR2
50 );
51
52
53 PROCEDURE update_res_group_relate_post
54 (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
55 P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
56 P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
57 P_OBJECT_VERSION_NUM IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
58 P_DATA OUT NOCOPY VARCHAR2,
59 P_COUNT OUT NOCOPY NUMBER,
60 P_RETURN_CODE OUT NOCOPY VARCHAR2
61 );
62
63
64 PROCEDURE delete_res_group_relate_post
65 (P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
66 P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
67 P_DATA OUT NOCOPY VARCHAR2,
68 P_COUNT OUT NOCOPY NUMBER,
69 P_RETURN_CODE OUT NOCOPY VARCHAR2
70 );
71
72
73 END jtf_rs_group_relate_vuhk;