DBA Data[Home] [Help]

PACKAGE: APPS.HZ_CLASS_CATEGORIES_PKG

Source


1 PACKAGE HZ_CLASS_CATEGORIES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHCSCTS.pls 115.5 2002/11/21 20:33:28 sponnamb ship $ */
3 
4 PROCEDURE Insert_Row (
5     X_CLASS_CATEGORY                        IN     VARCHAR2,
6     X_ALLOW_MULTI_PARENT_FLAG               IN     VARCHAR2,
7     X_ALLOW_MULTI_ASSIGN_FLAG               IN     VARCHAR2,
8     X_ALLOW_LEAF_NODE_ONLY_FLAG             IN     VARCHAR2,
9     X_OBJECT_VERSION_NUMBER                 IN     NUMBER,
10     X_CREATED_BY_MODULE                     IN     VARCHAR2,
11     X_APPLICATION_ID                        IN     NUMBER,
12     X_DELIMITER				    IN     VARCHAR2
13 );
14 
15 PROCEDURE Update_Row (
16     X_CLASS_CATEGORY                        IN     VARCHAR2,
17     X_ALLOW_MULTI_PARENT_FLAG               IN     VARCHAR2,
18     X_ALLOW_MULTI_ASSIGN_FLAG               IN     VARCHAR2,
19     X_ALLOW_LEAF_NODE_ONLY_FLAG             IN     VARCHAR2,
20     X_OBJECT_VERSION_NUMBER                 IN     NUMBER,
21     X_CREATED_BY_MODULE                     IN     VARCHAR2,
22     X_APPLICATION_ID                        IN     NUMBER,
23     X_DELIMITER				    IN     VARCHAR2
24 );
25 
26 PROCEDURE Lock_Row (
27     X_CLASS_CATEGORY                        IN     VARCHAR2,
28     X_ALLOW_MULTI_PARENT_FLAG               IN     VARCHAR2,
29     X_ALLOW_MULTI_ASSIGN_FLAG               IN     VARCHAR2,
30     X_CREATED_BY                            IN     NUMBER,
31     X_CREATION_DATE                         IN     DATE,
32     X_LAST_UPDATE_LOGIN                     IN     NUMBER,
33     X_LAST_UPDATE_DATE                      IN     DATE,
34     X_LAST_UPDATED_BY                       IN     NUMBER,
35     X_ALLOW_LEAF_NODE_ONLY_FLAG             IN     VARCHAR2,
36     X_OBJECT_VERSION_NUMBER                 IN     NUMBER,
37     X_CREATED_BY_MODULE                     IN     VARCHAR2,
38     X_APPLICATION_ID                        IN     NUMBER,
39     X_DELIMITER				    IN     VARCHAR2
40 );
41 
42 PROCEDURE Select_Row (
43     X_CLASS_CATEGORY                        IN OUT NOCOPY VARCHAR2,
44     X_ALLOW_MULTI_PARENT_FLAG               OUT NOCOPY    VARCHAR2,
45     X_ALLOW_MULTI_ASSIGN_FLAG               OUT NOCOPY    VARCHAR2,
46     X_ALLOW_LEAF_NODE_ONLY_FLAG             OUT NOCOPY    VARCHAR2,
47     X_CREATED_BY_MODULE                     OUT NOCOPY    VARCHAR2,
48     X_APPLICATION_ID                        OUT NOCOPY    NUMBER,
49     X_DELIMITER				    OUT NOCOPY    VARCHAR2
50 );
51 
52 PROCEDURE Delete_Row (
53     X_CLASS_CATEGORY                        IN     VARCHAR2
54 );
55 
56 END HZ_CLASS_CATEGORIES_PKG;