DBA Data[Home] [Help]

PACKAGE: APPS.JTF_RS_GROUP_MEMBERS_AUD_PVT

Source


1 Package JTF_RS_GROUP_MEMBERS_AUD_PVT AS
2   /* $Header: jtfrsams.pls 120.0 2005/05/11 08:19:09 appldev ship $ */
3 -- API Name	: JTF_RS_GROUP_MEMBERS_AUD_PVT
4 -- Type		: Private
5 -- Purpose	: Inserts IN  the JTF_RS_GROUP_MEMBERS_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_MEMBER(
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_MEMBER_ID       IN  NUMBER,
19     P_GROUP_ID              IN  NUMBER,
20     P_RESOURCE_ID           IN  NUMBER,
21     P_PERSON_ID             IN  NUMBER,
22     P_OBJECT_VERSION_NUMBER IN NUMBER,
23     X_RETURN_STATUS         OUT NOCOPY VARCHAR2,
24     X_MSG_COUNT             OUT NOCOPY NUMBER,
25     X_MSG_DATA              OUT NOCOPY VARCHAR2 );
26 
27    /* for update */
28    PROCEDURE   UPDATE_MEMBER(
29     P_API_VERSION	    IN	NUMBER,
30     P_INIT_MSG_LIST	    IN	VARCHAR2  DEFAULT FND_API.G_FALSE,
31     P_COMMIT		    IN	VARCHAR2  DEFAULT FND_API.G_FALSE,
32     P_GROUP_MEMBER_ID       IN  NUMBER,
33     P_GROUP_ID              IN  NUMBER,
34     P_RESOURCE_ID           IN  NUMBER,
35     P_PERSON_ID             IN  NUMBER,
36     P_OBJECT_VERSION_NUMBER IN NUMBER,
37     X_RETURN_STATUS         OUT NOCOPY VARCHAR2,
38     X_MSG_COUNT             OUT NOCOPY NUMBER,
39     X_MSG_DATA              OUT NOCOPY VARCHAR2  );
40 
41 
42    --FOR DELETE
43 
44    PROCEDURE   DELETE_MEMBER(
45     P_API_VERSION	IN  NUMBER,
46     P_INIT_MSG_LIST	IN  VARCHAR2  DEFAULT FND_API.G_FALSE,
47     P_COMMIT		IN  VARCHAR2  DEFAULT FND_API.G_FALSE,
48     P_GROUP_MEMBER_ID   IN  NUMBER,
49     X_RETURN_STATUS     OUT NOCOPY VARCHAR2,
50     X_MSG_COUNT         OUT NOCOPY NUMBER,
51     X_MSG_DATA          OUT NOCOPY VARCHAR2 );
52 
53 END; -- Package Specification JTF_RS_GROUP_MEMBERS_AUD_PVT