1 PACKAGE GR_SAFETY_CATEGORIES_B_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHICABS.pls 115.1 2002/10/28 16:50:25 gkelly ship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_safety_category_code IN VARCHAR2,
7 p_last_updated_by IN NUMBER,
8 p_last_update_login IN NUMBER,
9 p_last_update_date IN DATE,
10 p_created_by IN NUMBER,
11 p_creation_date IN DATE,
12 x_rowid OUT NOCOPY VARCHAR2,
13 x_return_status OUT NOCOPY VARCHAR2,
14 x_oracle_error OUT NOCOPY NUMBER,
15 x_msg_data OUT NOCOPY VARCHAR2);
16 PROCEDURE Update_Row
17 (p_commit IN VARCHAR2,
18 p_called_by_form IN VARCHAR2,
19 p_rowid IN VARCHAR2,
20 p_safety_category_code IN VARCHAR2,
21 p_last_updated_by IN NUMBER,
22 p_last_update_login IN NUMBER,
23 p_last_update_date IN DATE,
24 p_created_by IN NUMBER,
25 p_creation_date IN DATE,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_oracle_error OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2);
29 PROCEDURE Lock_Row
30 (p_commit IN VARCHAR2,
31 p_called_by_form IN VARCHAR2,
32 p_rowid IN VARCHAR2,
33 p_safety_category_code IN VARCHAR2,
34 p_last_updated_by IN NUMBER,
35 p_last_update_login IN NUMBER,
36 p_last_update_date IN DATE,
37 p_created_by IN NUMBER,
38 p_creation_date IN DATE,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_oracle_error OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2);
42 PROCEDURE Delete_Row
43 (p_commit IN VARCHAR2,
44 p_called_by_form IN VARCHAR2,
45 p_rowid IN VARCHAR2,
46 p_safety_category_code IN VARCHAR2,
47 p_last_updated_by IN NUMBER,
48 p_last_update_login IN NUMBER,
49 p_last_update_date IN DATE,
50 p_created_by IN NUMBER,
51 p_creation_date IN DATE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_oracle_error OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2);
55 PROCEDURE Check_Foreign_Keys
56 (p_safety_category_code IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_oracle_error OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2);
60 PROCEDURE Check_Integrity
61 (p_called_by_form IN VARCHAR2,
62 p_safety_category_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_Primary_Key
67 (p_safety_category_code IN VARCHAR2,
68 p_called_by_form IN VARCHAR2,
69 x_rowid OUT NOCOPY VARCHAR2,
70 x_key_exists OUT NOCOPY VARCHAR2);
71 END GR_SAFETY_CATEGORIES_B_PKG;
[Home] [Help]