1 PACKAGE GR_PHRASE_CONFLICTS_PKG AUTHID CURRENT_USER AS
2 /*$Header: GRHIPCS.pls 115.3 2002/10/28 20:02:41 methomas ship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_phrase_code IN VARCHAR2,
7 p_phrase_code_also_involved IN VARCHAR2,
8 p_phrase_code_solution IN VARCHAR2,
9 p_created_by IN NUMBER,
10 p_creation_date IN DATE,
11 p_last_updated_by IN NUMBER,
12 p_last_update_date IN DATE,
13 p_last_update_login IN NUMBER,
14 x_rowid OUT NOCOPY VARCHAR2,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_oracle_error OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2);
18 PROCEDURE Update_Row
19 (p_commit IN VARCHAR2,
20 p_called_by_form IN VARCHAR2,
21 p_rowid IN VARCHAR2,
22 p_phrase_code IN VARCHAR2,
23 p_phrase_code_also_involved IN VARCHAR2,
24 p_phrase_code_solution IN VARCHAR2,
25 p_created_by IN NUMBER,
26 p_creation_date IN DATE,
27 p_last_updated_by IN NUMBER,
28 p_last_update_date IN DATE,
29 p_last_update_login IN NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_oracle_error OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2);
33 PROCEDURE Lock_Row
34 (p_commit IN VARCHAR2,
35 p_called_by_form IN VARCHAR2,
36 p_rowid IN VARCHAR2,
37 p_phrase_code IN VARCHAR2,
38 p_phrase_code_also_involved IN VARCHAR2,
39 p_phrase_code_solution 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_phrase_code IN VARCHAR2,
53 p_phrase_code_also_involved IN VARCHAR2,
54 p_phrase_code_solution IN VARCHAR2,
55 p_created_by IN NUMBER,
56 p_creation_date IN DATE,
57 p_last_updated_by IN NUMBER,
58 p_last_update_date IN DATE,
59 p_last_update_login IN NUMBER,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_oracle_error OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2);
63 PROCEDURE Delete_Rows
64 (p_commit IN VARCHAR2,
65 p_called_by_form IN VARCHAR2,
66 p_phrase_code IN VARCHAR2,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_oracle_error OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2);
70 PROCEDURE Check_Foreign_Keys
71 (p_phrase_code IN VARCHAR2,
72 p_phrase_code_also_involved IN VARCHAR2,
73 p_phrase_code_solution IN VARCHAR2,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_oracle_error OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2);
77 PROCEDURE Check_Integrity
78 (p_called_by_form IN VARCHAR2,
79 p_phrase_code IN VARCHAR2,
80 p_phrase_code_also_involved IN VARCHAR2,
81 p_phrase_code_solution 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_Primary_Key
86 (p_phrase_code IN VARCHAR2,
87 p_phrase_code_also_involved IN VARCHAR2,
88 p_called_by_form IN VARCHAR2,
89 x_rowid OUT NOCOPY VARCHAR2,
90 x_key_exists OUT NOCOPY VARCHAR2);
91 END GR_PHRASE_CONFLICTS_PKG;