1 PACKAGE GR_ITEM_SAFETY_PHRASES_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHIISPS.pls 115.4 2002/10/25 21:11:23 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_safety_phrase_code IN VARCHAR2,
8 p_temperature IN NUMBER,
9 p_temperature_scale IN VARCHAR2,
10 p_created_by IN NUMBER,
11 p_creation_date IN DATE,
12 p_last_update_date IN DATE,
13 p_last_updated_by IN NUMBER,
14 p_last_update_login IN NUMBER,
15 p_phrase_code IN VARCHAR2,
16 x_rowid OUT NOCOPY VARCHAR2,
17 x_return_status OUT NOCOPY VARCHAR2,
18 x_oracle_error OUT NOCOPY NUMBER,
19 x_msg_data OUT NOCOPY VARCHAR2);
20 PROCEDURE Update_Row
21 (p_commit IN VARCHAR2,
22 p_called_by_form IN VARCHAR2,
23 p_rowid IN VARCHAR2,
24 p_item_code IN VARCHAR2,
25 p_safety_phrase_code IN VARCHAR2,
26 p_temperature IN NUMBER,
27 p_temperature_scale IN VARCHAR2,
28 p_created_by IN NUMBER,
29 p_creation_date IN DATE,
30 p_last_update_date IN DATE,
31 p_last_updated_by IN NUMBER,
32 p_last_update_login IN NUMBER,
33 p_phrase_code IN VARCHAR2,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_oracle_error OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2);
37 PROCEDURE Lock_Row
38 (p_commit IN VARCHAR2,
39 p_called_by_form IN VARCHAR2,
40 p_rowid IN VARCHAR2,
41 p_item_code IN VARCHAR2,
42 p_safety_phrase_code IN VARCHAR2,
43 p_temperature IN NUMBER,
44 p_temperature_scale IN VARCHAR2,
45 p_created_by IN NUMBER,
46 p_creation_date IN DATE,
47 p_last_update_date IN DATE,
48 p_last_updated_by IN NUMBER,
49 p_last_update_login IN NUMBER,
50 p_phrase_code IN VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_oracle_error OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2);
54 PROCEDURE Delete_Row
55 (p_commit IN VARCHAR2,
56 p_called_by_form IN VARCHAR2,
57 p_rowid IN VARCHAR2,
58 p_item_code IN VARCHAR2,
59 p_safety_phrase_code IN VARCHAR2,
60 p_temperature IN NUMBER,
61 p_temperature_scale IN VARCHAR2,
62 p_created_by IN NUMBER,
63 p_creation_date IN DATE,
64 p_last_update_date IN DATE,
65 p_last_updated_by IN NUMBER,
66 p_last_update_login IN NUMBER,
67 p_phrase_code IN VARCHAR2,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_oracle_error OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2);
71 /*
72 ** p_delete_option has one of two values.
73 ** 'I' - Delete all rows for the item.
74 ** 'S' - Delete all rows for the safety phrase.
75 */
76 PROCEDURE Delete_Rows
77 (p_commit IN VARCHAR2,
78 p_called_by_form IN VARCHAR2,
79 p_delete_option IN VARCHAR2,
80 p_item_code IN VARCHAR2,
81 p_safety_phrase_code IN VARCHAR2,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_oracle_error OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2);
85 PROCEDURE Check_Foreign_Keys
86 (p_item_code IN VARCHAR2,
87 p_safety_phrase_code IN VARCHAR2,
88 p_temperature IN NUMBER,
89 p_temperature_scale IN VARCHAR2,
90 p_created_by IN NUMBER,
91 p_creation_date IN DATE,
92 p_last_update_date IN DATE,
93 p_last_updated_by IN NUMBER,
94 p_last_update_login IN NUMBER,
95 p_phrase_code 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_Integrity
100 (p_called_by_form IN VARCHAR2,
101 p_item_code IN VARCHAR2,
102 p_safety_phrase_code IN VARCHAR2,
103 p_temperature IN NUMBER,
104 p_temperature_scale IN VARCHAR2,
105 p_created_by IN NUMBER,
106 p_creation_date IN DATE,
107 p_last_update_date IN DATE,
108 p_last_updated_by IN NUMBER,
109 p_last_update_login IN NUMBER,
110 p_phrase_code IN VARCHAR2,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_oracle_error OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2);
114 PROCEDURE Check_Primary_Key
115 (p_item_code IN VARCHAR2,
116 p_safety_phrase_code IN VARCHAR2,
117 p_called_by_form IN VARCHAR2,
118 x_rowid OUT NOCOPY VARCHAR2,
119 x_key_exists OUT NOCOPY VARCHAR2);
120 END GR_ITEM_SAFETY_PHRASES_PKG;