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