[Home] [Help]
PACKAGE: APPS.JTF_RS_GROUPS_AUD_PVT
Source
1 Package JTF_RS_GROUPS_AUD_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfrsags.pls 120.0.12010000.2 2009/05/11 07:35:14 rgokavar ship $ */
3 -- API Name : JTF_RS_GROUPS_AUD_PVT
4 -- Type : Private
5 -- Purpose : Inserts IN the JTF_RS_GROUPS_AUD_VL
6 -- Modification History
7 -- DATE NAME PURPOSE
8 -- 17 Jan 2000 S Choudhury Created
9 -- Notes:
10 --
11
12
13 /*FOR INSERT */
14 PROCEDURE INSERT_GROUP(
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_ID IN NUMBER,
19 P_GROUP_NUMBER IN VARCHAR2,
20 P_EMAIL_ADDRESS IN VARCHAR2,
21 P_START_DATE_ACTIVE IN DATE,
22 P_END_DATE_ACTIVE IN DATE,
23 P_ACCOUNTING_CODE IN VARCHAR2,
24 P_EXCLUSIVE_FLAG IN VARCHAR2,
25 P_GROUP_NAME IN VARCHAR2,
26 P_GROUP_DESC IN VARCHAR2,
27 P_OBJECT_VERSION_NUMBER IN NUMBER,
28 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
29 X_MSG_COUNT OUT NOCOPY NUMBER,
30 X_MSG_DATA OUT NOCOPY VARCHAR2,
31 P_TIME_ZONE IN NUMBER );
32
33
34 /* FOR UPDATE */
35
36 PROCEDURE UPDATE_GROUP(
37 P_API_VERSION IN NUMBER,
38 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40 P_GROUP_ID IN NUMBER,
41 P_GROUP_NUMBER IN VARCHAR2,
42 P_EMAIL_ADDRESS IN VARCHAR2,
43 P_START_DATE_ACTIVE IN DATE,
44 P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
45 P_ACCOUNTING_CODE IN VARCHAR2,
46 P_EXCLUSIVE_FLAG IN VARCHAR2,
47 P_GROUP_NAME IN VARCHAR2,
48 P_GROUP_DESC IN VARCHAR2,
49 P_OBJECT_VERSION_NUMBER IN NUMBER,
50 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
51 X_MSG_COUNT OUT NOCOPY NUMBER,
52 X_MSG_DATA OUT NOCOPY VARCHAR2,
53 P_TIME_ZONE IN NUMBER);
54
55
56 --FOR DELETE
57
58 PROCEDURE DELETE_GROUP(
59 P_API_VERSION IN NUMBER,
60 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
61 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
62 P_GROUP_ID IN NUMBER,
63 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
64 X_MSG_COUNT OUT NOCOPY NUMBER,
65 X_MSG_DATA OUT NOCOPY VARCHAR2 );
66
67 END; -- Package Specification JTF_RS_GROUPS_AUD_PVT