1 PACKAGE GR_PROPERTIES_B_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHIPROS.pls 115.4 2002/10/25 16:02:12 gkelly ship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_property_id IN VARCHAR2,
7 p_property_type_indicator IN VARCHAR2,
8 p_length IN NUMBER,
9 p_precision IN NUMBER,
10 p_range_min IN NUMBER,
11 p_range_max IN NUMBER,
12 p_created_by IN NUMBER,
13 p_creation_date IN DATE,
14 p_last_updated_by IN NUMBER,
15 p_last_update_date IN DATE,
16 p_last_update_login IN NUMBER,
17 x_rowid OUT NOCOPY VARCHAR2,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_oracle_error OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2);
21 PROCEDURE Update_Row
22 (p_commit IN VARCHAR2,
23 p_called_by_form IN VARCHAR2,
24 p_rowid IN VARCHAR2,
25 p_property_id IN VARCHAR2,
26 p_property_type_indicator IN VARCHAR2,
27 p_length IN NUMBER,
28 p_precision IN NUMBER,
29 p_range_min IN NUMBER,
30 p_range_max IN NUMBER,
31 p_created_by IN NUMBER,
32 p_creation_date IN DATE,
33 p_last_updated_by IN NUMBER,
34 p_last_update_date IN DATE,
35 p_last_update_login IN NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_oracle_error OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2);
39 PROCEDURE Lock_Row
40 (p_commit IN VARCHAR2,
41 p_called_by_form IN VARCHAR2,
42 p_rowid IN VARCHAR2,
43 p_property_id IN VARCHAR2,
44 p_property_type_indicator IN VARCHAR2,
45 p_length IN NUMBER,
46 p_precision IN NUMBER,
47 p_range_min IN NUMBER,
48 p_range_max IN NUMBER,
49 p_created_by IN NUMBER,
50 p_creation_date IN DATE,
51 p_last_updated_by IN NUMBER,
52 p_last_update_date IN DATE,
53 p_last_update_login IN NUMBER,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_oracle_error OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2);
57 PROCEDURE Delete_Row
58 (p_commit IN VARCHAR2,
59 p_called_by_form IN VARCHAR2,
60 p_rowid IN VARCHAR2,
61 p_property_id IN VARCHAR2,
62 p_property_type_indicator IN VARCHAR2,
63 p_length IN NUMBER,
64 p_precision IN NUMBER,
65 p_range_min IN NUMBER,
66 p_range_max IN NUMBER,
67 p_created_by IN NUMBER,
68 p_creation_date IN DATE,
69 p_last_updated_by IN NUMBER,
70 p_last_update_date IN DATE,
71 p_last_update_login IN NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_oracle_error OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2);
75 PROCEDURE Check_Foreign_Keys
76 (p_property_id IN VARCHAR2,
77 p_property_type_indicator IN VARCHAR2,
78 p_length IN NUMBER,
79 p_precision IN NUMBER,
80 p_range_min IN NUMBER,
81 p_range_max IN NUMBER,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_oracle_error OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2);
85 PROCEDURE Check_Integrity
86 (p_called_by_form IN VARCHAR2,
87 p_property_id IN VARCHAR2,
88 p_property_type_indicator IN VARCHAR2,
89 p_length IN NUMBER,
90 p_precision IN NUMBER,
91 p_range_min IN NUMBER,
92 p_range_max IN NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_oracle_error OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2);
96 PROCEDURE Check_Primary_Key
97 (p_property_id IN VARCHAR2,
98 p_called_by_form IN VARCHAR2,
99 x_rowid OUT NOCOPY VARCHAR2,
100 x_key_exists OUT NOCOPY VARCHAR2);
101 END GR_PROPERTIES_B_PKG;