1 PACKAGE HZ_DSS_ASSIGNMENTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARHPDSAS.pls 115.1 2002/09/30 06:22:57 cvijayan noship $ */
3
4 PROCEDURE Insert_Row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_assignment_id IN OUT NOCOPY NUMBER,
7 x_status IN VARCHAR2,
8 x_owner_table_name IN VARCHAR2,
9 x_owner_table_id1 IN VARCHAR2,
10 x_owner_table_id2 IN VARCHAR2 DEFAULT NULL,
11 x_owner_table_id3 IN VARCHAR2 DEFAULT NULL,
12 x_owner_table_id4 IN VARCHAR2 DEFAULT NULL,
13 x_owner_table_id5 IN VARCHAR2 DEFAULT NULL,
14 x_dss_group_code IN VARCHAR2,
15 x_object_version_number IN NUMBER
16 );
17
18 PROCEDURE Update_Row (
19 x_rowid IN OUT NOCOPY VARCHAR2,
20 x_status IN VARCHAR2,
21 x_owner_table_name IN VARCHAR2,
22 x_owner_table_id1 IN VARCHAR2,
23 x_owner_table_id2 IN VARCHAR2 DEFAULT NULL,
24 x_owner_table_id3 IN VARCHAR2 DEFAULT NULL,
25 x_owner_table_id4 IN VARCHAR2 DEFAULT NULL,
26 x_owner_table_id5 IN VARCHAR2 DEFAULT NULL,
27 x_dss_group_code IN VARCHAR2,
28 x_object_version_number IN NUMBER
29 );
30
31 PROCEDURE Lock_Row (
32 x_rowid IN OUT NOCOPY VARCHAR2,
33 x_assignment_id IN NUMBER,
34 x_status IN VARCHAR2,
35 x_owner_table_name IN VARCHAR2,
36 x_owner_table_id1 IN VARCHAR2,
37 x_owner_table_id2 IN VARCHAR2 DEFAULT NULL,
38 x_owner_table_id3 IN VARCHAR2 DEFAULT NULL,
39 x_owner_table_id4 IN VARCHAR2 DEFAULT NULL,
40 x_owner_table_id5 IN VARCHAR2 DEFAULT NULL,
41 x_dss_group_code IN VARCHAR2,
42 x_last_update_date IN DATE,
43 x_last_updated_by IN NUMBER,
44 x_creation_date IN DATE,
45 x_created_by IN NUMBER,
46 x_last_update_login IN NUMBER,
47 x_object_version_number IN NUMBER
48 );
49
50 PROCEDURE Select_Row (
51 x_assignment_id IN OUT NOCOPY NUMBER,
52 x_status OUT NOCOPY VARCHAR2,
53 x_owner_table_name OUT NOCOPY VARCHAR2,
54 x_owner_table_id1 OUT NOCOPY VARCHAR2,
55 x_owner_table_id2 OUT NOCOPY VARCHAR2,
56 x_owner_table_id3 OUT NOCOPY VARCHAR2,
57 x_owner_table_id4 OUT NOCOPY VARCHAR2,
58 x_owner_table_id5 OUT NOCOPY VARCHAR2,
59 x_dss_group_code OUT NOCOPY VARCHAR2,
60 x_object_version_number OUT NOCOPY NUMBER
61 );
62
63 PROCEDURE Delete_Row (
64 x_assignment_id IN NUMBER
65 );
66
67 END HZ_DSS_ASSIGNMENTS_PKG;