[Home] [Help]
PACKAGE: APPS.JTF_RS_GROUP_RELATE_AUD_PVT
Source
1 Package JTF_RS_GROUP_RELATE_AUD_PVT AS
2 /* $Header: jtfrsafs.pls 120.0 2005/05/11 08:19:05 appldev ship $ */
3 -- API Name : JTF_RS_GROUP_RELATE_AUD_PVT
4 -- Type : Private
5 -- Purpose : Inserts IN the JTF_RS_GROUP_RELATE_AUD
6 -- Modification History
7 -- DATE NAME PURPOSE
8 -- 20 JAN 2000 S Choudhury Created
9 -- Notes:
10 --
11
12
13 /*FOR INSERT */
14 PROCEDURE INSERT_GROUP_RELATE(
15 P_API_VERSION IN NUMBER,
16 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18 P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
19 P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
20 P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
21 P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
22 P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
23 P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
24 P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
25 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
26 X_MSG_COUNT OUT NOCOPY NUMBER,
27 X_MSG_DATA OUT NOCOPY VARCHAR2 );
28
29
30 /*FOR UPDATE */
31 PROCEDURE UPDATE_GROUP_RELATE(
32 P_API_VERSION IN NUMBER,
33 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
34 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35 P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
36 P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
37 P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
38 P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
39 P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
40 P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
41 P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
42 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43 X_MSG_COUNT OUT NOCOPY NUMBER,
44 X_MSG_DATA OUT NOCOPY VARCHAR2);
45
46
47 --FOR DELETE
48
49 PROCEDURE DELETE_GROUP_RELATE(
50 P_API_VERSION IN NUMBER,
51 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53 P_GROUP_RELATE_ID IN NUMBER,
54 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55 X_MSG_COUNT OUT NOCOPY NUMBER,
56 X_MSG_DATA OUT NOCOPY VARCHAR2 );
57
58
59 END; -- Package Specification JTF_RS_GROUP_RELATE_AUD_PVT