1 PACKAGE GR_TOXIC_SPECIES_B_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHITSS.pls 115.6 2002/10/28 21:41:11 gkelly ship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_toxic_species_code IN VARCHAR2,
7 /* Bug 1323951 28-Jan-2002 M. Thomas Added the following for Toxicity Calculation */
8 p_hierarchy_seq IN NUMBER,
9 /* Bug 1323951 28-Jan-2002 M. Thomas End of the changes for Toxicity Calculation */
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_toxic_species_code IN VARCHAR2,
24 /* Bug 1323951 28-Jan-2002 M. Thomas Added the following for Toxicity Calculation */
25 p_hierarchy_seq IN NUMBER,
26 /* Bug 1323951 28-Jan-2002 M. Thomas End of the changes for Toxicity Calculation */
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_toxic_species_code IN VARCHAR2,
40 p_created_by IN NUMBER,
41 p_creation_date IN DATE,
42 p_last_updated_by IN NUMBER,
43 p_last_update_date IN DATE,
44 p_last_update_login IN NUMBER,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_oracle_error OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2);
48 PROCEDURE Delete_Row
49 (p_commit IN VARCHAR2,
50 p_called_by_form IN VARCHAR2,
51 p_rowid IN VARCHAR2,
52 p_toxic_species_code IN VARCHAR2,
53 p_created_by IN NUMBER,
54 p_creation_date IN DATE,
55 p_last_updated_by IN NUMBER,
56 p_last_update_date IN DATE,
57 p_last_update_login IN NUMBER,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_oracle_error OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2);
61 PROCEDURE Check_Foreign_Keys
62 (p_toxic_species_code IN VARCHAR2,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_oracle_error OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2);
66 PROCEDURE Check_Integrity
67 (p_called_by_form IN VARCHAR2,
68 p_toxic_species_code IN VARCHAR2,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_oracle_error OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2);
72 PROCEDURE Check_Primary_Key
73 (p_toxic_species_code IN VARCHAR2,
74 p_called_by_form IN VARCHAR2,
75 x_rowid OUT NOCOPY VARCHAR2,
76 x_key_exists OUT NOCOPY VARCHAR2);
77 END GR_TOXIC_SPECIES_B_PKG;