1 PACKAGE GR_ITEM_CLASSNS_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHIIHCS.pls 115.3 2002/10/25 19:58:29 methomas ship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_item_code IN VARCHAR2,
7 p_hazard_classification_code IN VARCHAR2,
8 p_created_by IN NUMBER,
9 p_creation_date IN DATE,
10 p_last_update_date IN DATE,
11 p_last_updated_by IN NUMBER,
12 p_last_update_login IN NUMBER,
13 x_rowid OUT NOCOPY VARCHAR2,
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_oracle_error OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2);
17 PROCEDURE Update_Row
18 (p_commit IN VARCHAR2,
19 p_called_by_form IN VARCHAR2,
20 p_rowid IN VARCHAR2,
21 p_item_code IN VARCHAR2,
22 p_hazard_classification_code IN VARCHAR2,
23 p_created_by IN NUMBER,
24 p_creation_date IN DATE,
25 p_last_update_date IN DATE,
26 p_last_updated_by IN NUMBER,
27 p_last_update_login IN NUMBER,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_oracle_error OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2);
31 PROCEDURE Lock_Row
32 (p_commit IN VARCHAR2,
33 p_called_by_form IN VARCHAR2,
34 p_rowid IN VARCHAR2,
35 p_item_code IN VARCHAR2,
36 p_hazard_classification_code IN VARCHAR2,
37 p_created_by IN NUMBER,
38 p_creation_date IN DATE,
39 p_last_update_date IN DATE,
40 p_last_updated_by IN NUMBER,
41 p_last_update_login IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_oracle_error OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2);
45 PROCEDURE Delete_Row
46 (p_commit IN VARCHAR2,
47 p_called_by_form IN VARCHAR2,
48 p_rowid IN VARCHAR2,
49 p_item_code IN VARCHAR2,
50 p_hazard_classification_code IN VARCHAR2,
51 p_created_by IN NUMBER,
52 p_creation_date IN DATE,
53 p_last_update_date IN DATE,
54 p_last_updated_by IN NUMBER,
55 p_last_update_login IN NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_oracle_error OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2);
59 /*
60 ** p_delete_option has one of two values.
61 ** 'I' - Delete all rows for the item.
62 ** 'H' - Delete all rows for the hazard classification.
63 */
64 PROCEDURE Delete_Rows
65 (p_commit IN VARCHAR2,
66 p_called_by_form IN VARCHAR2,
67 p_delete_option IN VARCHAR2,
68 p_item_code IN VARCHAR2,
69 p_hazard_classification_code IN VARCHAR2,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_oracle_error OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2);
73 PROCEDURE Check_Foreign_Keys
74 (p_item_code IN VARCHAR2,
75 p_hazard_classification_code IN VARCHAR2,
76 p_created_by IN NUMBER,
77 p_creation_date IN DATE,
78 p_last_update_date IN DATE,
79 p_last_updated_by IN NUMBER,
80 p_last_update_login IN NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_oracle_error OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2);
84 PROCEDURE Check_Integrity
85 (p_called_by_form IN VARCHAR2,
86 p_item_code IN VARCHAR2,
87 p_hazard_classification_code IN VARCHAR2,
88 p_created_by IN NUMBER,
89 p_creation_date IN DATE,
90 p_last_update_date IN DATE,
91 p_last_updated_by IN NUMBER,
92 p_last_update_login 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_item_code IN VARCHAR2,
98 p_hazard_classification_code IN VARCHAR2,
99 p_called_by_form IN VARCHAR2,
100 x_rowid OUT NOCOPY VARCHAR2,
101 x_key_exists OUT NOCOPY VARCHAR2);
102 END GR_ITEM_CLASSNS_PKG;