1 PACKAGE GR_TOXIC_ROUTES_B_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHITRS.pls 115.3 2002/10/28 21:30:52 gkelly ship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_toxic_route_code IN VARCHAR2,
7 p_created_by IN NUMBER,
8 p_creation_date IN DATE,
9 p_last_updated_by IN NUMBER,
10 p_last_update_date IN DATE,
11 p_last_update_login IN NUMBER,
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_toxic_route_code IN VARCHAR2,
21 p_created_by IN NUMBER,
22 p_creation_date IN DATE,
23 p_last_updated_by IN NUMBER,
24 p_last_update_date IN DATE,
25 p_last_update_login IN NUMBER,
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_toxic_route_code IN VARCHAR2,
34 p_created_by IN NUMBER,
35 p_creation_date IN DATE,
36 p_last_updated_by IN NUMBER,
37 p_last_update_date IN DATE,
38 p_last_update_login IN NUMBER,
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_toxic_route_code IN VARCHAR2,
47 p_created_by IN NUMBER,
48 p_creation_date IN DATE,
49 p_last_updated_by IN NUMBER,
50 p_last_update_date IN DATE,
51 p_last_update_login IN NUMBER,
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_toxic_route_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_toxic_route_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_toxic_route_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_TOXIC_ROUTES_B_PKG;