PACKAGE: APPS.CSC_PROF_GROUP_CATEGORIES_PKG

Source

1 PACKAGE CSC_PROF_GROUP_CATEGORIES_PKG as
2 /* $Header: csctpcas.pls 120.1 2005/08/24 03:04:06 vshastry noship $ */
3 -- Start of Comments
4 -- Package name     : CSC_PROF_GROUP_CATEGORIES_PKG
5 -- Purpose          :
6 -- History          :
7 -- 26 Nov 2002 JAmose For Fnd_Api.G_Miss* changes
8 -- NOTE             :
9 -- End of Comments
10 
11 PROCEDURE Insert_Row(
12           px_GROUP_CATEGORY_ID   IN OUT NOCOPY NUMBER,
13           p_GROUP_ID    NUMBER,
14           p_CATEGORY_CODE    VARCHAR2,
15           p_CATEGORY_SEQUENCE    NUMBER,
16           p_CREATED_BY    NUMBER,
17           p_CREATION_DATE    DATE,
18           p_LAST_UPDATED_BY    NUMBER,
19           p_LAST_UPDATE_DATE    DATE,
20           p_LAST_UPDATE_LOGIN    NUMBER,
21           p_SEEDED_FLAG     VARCHAR2);
22 
23 PROCEDURE Update_Row(
24           p_GROUP_CATEGORY_ID    NUMBER,
25           p_GROUP_ID    NUMBER,
26           p_CATEGORY_CODE    VARCHAR2,
27           p_CATEGORY_SEQUENCE    NUMBER,
28           p_LAST_UPDATED_BY    NUMBER,
29           p_LAST_UPDATE_DATE    DATE,
30           p_LAST_UPDATE_LOGIN    NUMBER,
31           p_SEEDED_FLAG     VARCHAR2);
32 
33 PROCEDURE Lock_Row(
34           p_GROUP_CATEGORY_ID    NUMBER,
35           p_GROUP_ID    NUMBER,
36           p_CATEGORY_CODE    VARCHAR2,
37           p_CATEGORY_SEQUENCE    NUMBER,
38           p_CREATED_BY    NUMBER,
39           p_CREATION_DATE    DATE,
40           p_LAST_UPDATED_BY    NUMBER,
41           p_LAST_UPDATE_DATE    DATE,
42           p_LAST_UPDATE_LOGIN    NUMBER,
43           p_SEEDED_FLAG     VARCHAR2);
44 
45 PROCEDURE Delete_Row(
46           p_GROUP_CATEGORY_ID  NUMBER);
47 
48 Procedure LOAD_ROW (
49  	  p_GROUP_CATEGORY_ID    IN NUMBER,
50  	  p_GROUP_ID             IN NUMBER,
51  	  p_CATEGORY_CODE        IN VARCHAR2,
52  	  p_CATEGORY_SEQUENCE    IN NUMBER,
53           p_SEEDED_FLAG          IN VARCHAR2,
54           p_last_updated_by      IN NUMBER,
55           p_last_update_date     IN DATE ) ;
56 
57 End CSC_PROF_GROUP_CATEGORIES_PKG;