1 PACKAGE GR_EIN_NUMBERS_B_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHIEINS.pls 115.2 2002/10/29 16:41:28 mgrosser noship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_european_index_number IN VARCHAR2,
7 p_eec_number IN VARCHAR2,
8 p_primary_cas_number IN VARCHAR2,
9 p_chemical_formula IN VARCHAR2,
10 p_created_by IN NUMBER,
11 p_creation_date IN DATE,
12 p_last_updated_by IN NUMBER,
13 p_last_update_date IN DATE,
14 p_last_update_login IN NUMBER,
15 x_rowid OUT NOCOPY VARCHAR2,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_oracle_error OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2);
19 PROCEDURE Update_Row
20 (p_commit IN VARCHAR2,
21 p_called_by_form IN VARCHAR2,
22 p_rowid IN VARCHAR2,
23 p_european_index_number IN VARCHAR2,
24 p_eec_number IN VARCHAR2,
25 p_primary_cas_number IN VARCHAR2,
26 p_chemical_formula IN VARCHAR2,
27 p_created_by IN NUMBER,
28 p_creation_date IN DATE,
29 p_last_updated_by IN NUMBER,
30 p_last_update_date IN DATE,
31 p_last_update_login IN NUMBER,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_oracle_error OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2);
35 PROCEDURE Lock_Row
36 (p_commit IN VARCHAR2,
37 p_called_by_form IN VARCHAR2,
38 p_rowid IN VARCHAR2,
39 p_european_index_number IN VARCHAR2,
40 p_eec_number IN VARCHAR2,
41 p_primary_cas_number IN VARCHAR2,
42 p_chemical_formula IN VARCHAR2,
43 p_created_by IN NUMBER,
44 p_creation_date IN DATE,
45 p_last_updated_by IN NUMBER,
46 p_last_update_date IN DATE,
47 p_last_update_login IN NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_oracle_error OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2);
51 PROCEDURE Delete_Row
52 (p_commit IN VARCHAR2,
53 p_called_by_form IN VARCHAR2,
54 p_rowid IN VARCHAR2,
55 p_european_index_number IN VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_oracle_error OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2);
59 PROCEDURE Check_Foreign_Keys
60 (p_european_index_number IN VARCHAR2,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_oracle_error OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2);
64 PROCEDURE Check_Integrity
65 (p_called_by_form IN VARCHAR2,
66 p_european_index_number IN VARCHAR2,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_oracle_error OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2);
70 PROCEDURE Check_Primary_Key
71 (p_european_index_number IN VARCHAR2,
72 p_called_by_form IN VARCHAR2,
73 x_rowid OUT NOCOPY VARCHAR2,
74 x_key_exists OUT NOCOPY VARCHAR2);
75 END GR_EIN_NUMBERS_B_PKG;