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