[Home] [Help]
PACKAGE: APPS.JTF_RS_ROLE_RELATE_AUD_PVT
Source
1 Package JTF_RS_ROLE_RELATE_AUD_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfrsals.pls 120.0 2005/05/11 08:19:08 appldev ship $ */
3 -- API Name : JTF_RS_ROLE_RELATE_AUD_PVT
4 -- Type : Private
5 -- Purpose : Inserts IN the JTF_RS_ROLE_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_ROLE_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_ROLE_RELATE_ID IN NUMBER,
19 P_ROLE_RESOURCE_TYPE IN VARCHAR2,
20 P_ROLE_RESOURCE_ID IN NUMBER,
21 P_ROLE_ID IN NUMBER,
22 P_START_DATE_ACTIVE IN DATE,
23 P_END_DATE_ACTIVE IN DATE,
24 P_OBJECT_VERSION_NUMBER IN NUMBER,
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_ROLE_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_ROLE_RELATE_ID IN NUMBER,
36 P_ROLE_RESOURCE_TYPE IN VARCHAR2,
37 P_ROLE_RESOURCE_ID IN NUMBER,
38 P_ROLE_ID IN NUMBER,
39 P_START_DATE_ACTIVE IN DATE,
40 P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
41 P_OBJECT_VERSION_NUMBER IN NUMBER,
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_ROLE_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_ROLE_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_ROLE_RELATE_AUD_PVT