1 PACKAGE HZ_DSS_ENTITIES_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARHPDSES.pls 115.1 2002/09/30 06:24:34 cvijayan noship $ */
3
4 PROCEDURE Insert_Row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_entity_id IN OUT NOCOPY NUMBER,
7 x_status IN VARCHAR2,
8 x_object_id IN NUMBER DEFAULT NULL,
9 x_instance_set_id IN NUMBER DEFAULT NULL,
10 x_parent_entity_id IN NUMBER DEFAULT NULL,
11 x_parent_fk_column1 IN VARCHAR2 DEFAULT NULL,
12 x_parent_fk_column2 IN VARCHAR2 DEFAULT NULL,
13 x_parent_fk_column3 IN VARCHAR2 DEFAULT NULL,
14 x_parent_fk_column4 IN VARCHAR2 DEFAULT NULL,
15 x_parent_fk_column5 IN VARCHAR2 DEFAULT NULL,
16 x_group_assignment_level IN VARCHAR2,
17 x_object_version_number IN NUMBER
18 );
19
20 PROCEDURE Update_Row (
21 x_rowid IN OUT NOCOPY VARCHAR2,
22 x_status IN VARCHAR2,
23 x_object_id IN NUMBER DEFAULT NULL,
24 x_instance_set_id IN NUMBER DEFAULT NULL,
25 x_parent_entity_id IN NUMBER DEFAULT NULL,
26 x_parent_fk_column1 IN VARCHAR2 DEFAULT NULL,
27 x_parent_fk_column2 IN VARCHAR2 DEFAULT NULL,
28 x_parent_fk_column3 IN VARCHAR2 DEFAULT NULL,
29 x_parent_fk_column4 IN VARCHAR2 DEFAULT NULL,
30 x_parent_fk_column5 IN VARCHAR2 DEFAULT NULL,
31 x_group_assignment_level IN VARCHAR2,
32 x_object_version_number IN NUMBER
33 );
34
35 PROCEDURE Lock_Row (
36 x_rowid IN OUT NOCOPY VARCHAR2,
37 x_entity_id IN NUMBER,
38 x_status IN VARCHAR2,
39 x_object_id IN NUMBER DEFAULT NULL,
40 x_instance_set_id IN NUMBER DEFAULT NULL,
41 x_parent_entity_id IN NUMBER DEFAULT NULL,
42 x_parent_fk_column1 IN VARCHAR2 DEFAULT NULL,
43 x_parent_fk_column2 IN VARCHAR2 DEFAULT NULL,
44 x_parent_fk_column3 IN VARCHAR2 DEFAULT NULL,
45 x_parent_fk_column4 IN VARCHAR2 DEFAULT NULL,
46 x_parent_fk_column5 IN VARCHAR2 DEFAULT NULL,
47 x_group_assignment_level IN VARCHAR2,
48 x_last_update_date IN DATE,
49 x_last_updated_by IN NUMBER,
50 x_creation_date IN DATE,
51 x_created_by IN NUMBER,
52 x_last_update_login IN NUMBER,
53 x_object_version_number IN NUMBER
54 );
55
56 PROCEDURE Select_Row (
57 x_entity_id IN OUT NOCOPY NUMBER,
58 x_status OUT NOCOPY VARCHAR2,
59 x_object_id OUT NOCOPY NUMBER,
60 x_instance_set_id OUT NOCOPY NUMBER,
61 x_parent_entity_id OUT NOCOPY NUMBER,
62 x_parent_fk_column1 OUT NOCOPY VARCHAR2,
63 x_parent_fk_column2 OUT NOCOPY VARCHAR2,
64 x_parent_fk_column3 OUT NOCOPY VARCHAR2,
65 x_parent_fk_column4 OUT NOCOPY VARCHAR2,
66 x_parent_fk_column5 OUT NOCOPY VARCHAR2,
67 x_group_assignment_level OUT NOCOPY VARCHAR2,
68 x_object_version_number OUT NOCOPY NUMBER
69 );
70
71 PROCEDURE Delete_Row (
72 x_entity_id IN NUMBER
73 );
74
75 END HZ_DSS_ENTITIES_PKG;