[Home] [Help]
PACKAGE: APPS.JTF_RS_GROUPS_AUD_PVT
Source
1 Package JTF_RS_GROUPS_AUD_PVT AS
2 /* $Header: jtfrsags.pls 120.0 2005/05/11 08:19:07 appldev 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
32
33 /* FOR UPDATE */
34
35 PROCEDURE UPDATE_GROUP(
36 P_API_VERSION IN NUMBER,
37 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39 P_GROUP_ID IN NUMBER,
40 P_GROUP_NUMBER IN VARCHAR2,
41 P_EMAIL_ADDRESS IN VARCHAR2,
42 P_START_DATE_ACTIVE IN DATE,
43 P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
44 P_ACCOUNTING_CODE IN VARCHAR2,
45 P_EXCLUSIVE_FLAG IN VARCHAR2,
46 P_GROUP_NAME IN VARCHAR2,
47 P_GROUP_DESC IN VARCHAR2,
48 P_OBJECT_VERSION_NUMBER 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
54 --FOR DELETE
55
56 PROCEDURE DELETE_GROUP(
57 P_API_VERSION IN NUMBER,
58 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60 P_GROUP_ID IN NUMBER,
61 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62 X_MSG_COUNT OUT NOCOPY NUMBER,
63 X_MSG_DATA OUT NOCOPY VARCHAR2 );
64
65 END; -- Package Specification JTF_RS_GROUPS_AUD_PVT