PACKAGE: APPS.CSC_PROF_GROUPS_PKG

Source

1 PACKAGE CSC_PROF_GROUPS_PKG AUTHID CURRENT_USER as
2 /* $Header: csctpgrs.pls 115.10 2002/12/03 18:29:06 jamose ship $ */
3 -- Start of Comments
4 -- Package name     : CSC_PROF_GROUPS_PKG
5 -- Purpose          :
6 -- History          :
7 -- 29 Nov 02   jamose made changes for the NOCOPY and FND_API.G_MISS*
8 -- NOTE             :
9 -- End of Comments
10 
11 PROCEDURE Insert_Row(
12           px_GROUP_ID   IN OUT NOCOPY NUMBER,
13           p_CREATED_BY    NUMBER,
14           p_CREATION_DATE    DATE,
15           p_LAST_UPDATED_BY    NUMBER,
16           p_LAST_UPDATE_DATE    DATE,
17           p_LAST_UPDATE_LOGIN    NUMBER,
18           p_GROUP_NAME    VARCHAR2,
19           p_GROUP_NAME_CODE    VARCHAR2,
20           p_DESCRIPTION    VARCHAR2,
21           p_START_DATE_ACTIVE    DATE,
22           p_END_DATE_ACTIVE    DATE,
23           p_USE_IN_CUSTOMER_DASHBOARD    VARCHAR2,
24           p_PARTY_TYPE    VARCHAR2,
25           p_SEEDED_FLAG    VARCHAR2,
26 	       x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
27           p_APPLICATION_ID    NUMBER);
28 
29 
30 PROCEDURE Update_Row(
31           p_GROUP_ID    NUMBER,
32           p_LAST_UPDATED_BY    NUMBER,
33           p_LAST_UPDATE_DATE    DATE,
34           p_LAST_UPDATE_LOGIN    NUMBER,
35           p_GROUP_NAME    VARCHAR2,
36           p_GROUP_NAME_CODE    VARCHAR2,
37           p_DESCRIPTION    VARCHAR2,
38           p_START_DATE_ACTIVE    DATE,
39           p_END_DATE_ACTIVE    DATE,
40           p_USE_IN_CUSTOMER_DASHBOARD    VARCHAR2,
41           p_PARTY_TYPE    VARCHAR2,
42           p_SEEDED_FLAG    VARCHAR2,
43 	  px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
44           p_APPLICATION_ID    NUMBER );
45 
46 PROCEDURE Delete_Row(
47     p_GROUP_ID  NUMBER,
48     p_OBJECT_VERSION_NUMBER NUMBER);
49 
50 procedure LOCK_ROW (
51   P_GROUP_ID in NUMBER,
52   P_OBJECT_VERSION_NUMBER in NUMBER );
53 
54 procedure ADD_LANGUAGE;
55 
56 PROCEDURE TRANSLATE_ROW (
57    p_group_id                    IN      NUMBER,
58    p_group_name                  IN      VARCHAR2,
59    p_description                 IN      VARCHAR2,
60    p_owner                       IN      VARCHAR2 );
61 
62 PROCEDURE LOAD_ROW(
63    p_GROUP_ID                    IN      NUMBER,
64    p_LAST_UPDATED_BY             IN      NUMBER,
65    p_LAST_UPDATE_DATE            IN      DATE,
66    p_LAST_UPDATE_LOGIN           IN      NUMBER,
67    p_GROUP_NAME                  IN      VARCHAR2,
68    p_GROUP_NAME_CODE             IN      VARCHAR2,
69    p_DESCRIPTION                 IN      VARCHAR2,
70    p_START_DATE_ACTIVE           IN      DATE,
71    p_END_DATE_ACTIVE             IN      DATE,
72    p_USE_IN_CUSTOMER_DASHBOARD   IN      VARCHAR2,
73    p_PARTY_TYPE                  IN      VARCHAR2,
74    p_SEEDED_FLAG		 IN      VARCHAR2,
75    px_OBJECT_VERSION_NUMBER      IN OUT NOCOPY NUMBER ,
76    p_APPLICATION_ID              IN      NUMBER,
77    p_OWNER                       IN      VARCHAR2);
78 
79 End CSC_PROF_GROUPS_PKG;