1 PACKAGE GR_RISK_PHRASES_TL_PKG AS
2 /*$Header: GRHIRPTS.pls 120.1 2006/06/16 21:41:34 pbamb noship $*/
3 PROCEDURE Insert_Row
4 (p_commit IN VARCHAR2,
5 p_called_by_form IN VARCHAR2,
6 p_risk_phrase_code IN VARCHAR2,
7 p_language IN VARCHAR2,
8 p_source_language IN VARCHAR2,
9 p_risk_description IN VARCHAR2,
10 p_created_by IN NUMBER,
11 p_creation_date IN DATE,
12 p_last_updated_by IN NUMBER,
13 p_last_update_date IN DATE,
14 p_last_update_login IN NUMBER,
15 x_rowid OUT NOCOPY VARCHAR2,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_oracle_error OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2);
19 PROCEDURE Update_Row
20 (p_commit IN VARCHAR2,
21 p_called_by_form IN VARCHAR2,
22 p_rowid IN VARCHAR2,
23 p_risk_phrase_code IN VARCHAR2,
24 p_language IN VARCHAR2,
25 p_source_language IN VARCHAR2,
26 p_risk_description IN VARCHAR2,
27 p_created_by IN NUMBER,
28 p_creation_date IN DATE,
29 p_last_updated_by IN NUMBER,
30 p_last_update_date IN DATE,
31 p_last_update_login IN NUMBER,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_oracle_error OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2);
35 PROCEDURE Add_Language
36 (p_commit IN VARCHAR2,
37 p_called_by_form IN VARCHAR2,
38 p_risk_phrase_code IN VARCHAR2,
39 p_language IN VARCHAR2,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_oracle_error OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2);
43 PROCEDURE Lock_Row
44 (p_commit IN VARCHAR2,
45 p_called_by_form IN VARCHAR2,
46 p_rowid IN VARCHAR2,
47 p_risk_phrase_code IN VARCHAR2,
48 p_language IN VARCHAR2,
49 p_source_language IN VARCHAR2,
50 p_risk_description IN VARCHAR2,
51 p_created_by IN NUMBER,
52 p_creation_date IN DATE,
53 p_last_updated_by IN NUMBER,
54 p_last_update_date IN DATE,
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 PROCEDURE Delete_Row
60 (p_commit IN VARCHAR2,
61 p_called_by_form IN VARCHAR2,
62 p_rowid IN VARCHAR2,
63 p_risk_phrase_code IN VARCHAR2,
64 p_language IN VARCHAR2,
65 p_source_language IN VARCHAR2,
66 p_risk_description IN VARCHAR2,
67 p_created_by IN NUMBER,
68 p_creation_date IN DATE,
69 p_last_updated_by IN NUMBER,
70 p_last_update_date IN DATE,
71 p_last_update_login IN NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_oracle_error OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2);
75 PROCEDURE Delete_Rows
76 (p_commit IN VARCHAR2,
77 p_called_by_form IN VARCHAR2,
78 p_risk_phrase_code IN VARCHAR2,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_oracle_error OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2);
82 PROCEDURE Check_Foreign_Keys
83 (p_risk_phrase_code IN VARCHAR2,
84 p_language IN VARCHAR2,
85 p_source_language IN VARCHAR2,
86 p_risk_description IN VARCHAR2,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_oracle_error OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2);
90 PROCEDURE Check_Integrity
91 (p_called_by_form IN VARCHAR2,
92 p_risk_phrase_code IN VARCHAR2,
93 p_language IN VARCHAR2,
94 p_source_language IN VARCHAR2,
95 p_risk_description 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_Primary_Key
100 (p_risk_phrase_code IN VARCHAR2,
101 p_language IN VARCHAR2,
102 p_called_by_form IN VARCHAR2,
103 x_rowid OUT NOCOPY VARCHAR2,
104 x_key_exists OUT NOCOPY VARCHAR2);
105 PROCEDURE translate_row (
106 X_RISK_PHRASE_CODE IN VARCHAR2
107 ,X_LANGUAGE IN VARCHAR2
108 ,X_SOURCE_LANG IN VARCHAR2
109 ,X_RISK_DESCRIPTION IN VARCHAR2
110 );
111
112 PROCEDURE load_row (
113 X_RISK_PHRASE_CODE IN VARCHAR2
114 ,X_LANGUAGE IN VARCHAR2
115 ,X_SOURCE_LANG IN VARCHAR2
116 ,X_RISK_DESCRIPTION IN VARCHAR2
117 );
118
119
120 /*Bug# 5237433 */
121 PROCEDURE translate_row (
122 X_RISK_PHRASE_CODE IN VARCHAR2
123 ,X_RISK_DESCRIPTION IN VARCHAR2
124 ,X_OWNER IN VARCHAR2
125 );
126
127 PROCEDURE load_row (
128 X_RISK_PHRASE_CODE IN VARCHAR2
129 ,X_RISK_DESCRIPTION IN VARCHAR2
130 ,X_OWNER IN VARCHAR2
131 );
132
133 /* 21-Jan-2002 Melanie Grosser BUG 2190024 - Added procedure NEW_LANGUAGE
134 to be called from GRNLINS.sql. Generated
135 from tltblgen.
136 */
137 procedure NEW_LANGUAGE;
138
139
140 END GR_RISK_PHRASES_TL_PKG;