DBA Data[Home] [Help]

APPS.PER_MLS_MIGRATION dependencies on PER_GRADES_TL

Line 152: delete from per_grades_tl

148: ** Clear out any existing data for this range of records
149: **
150: ** Don't delete just yet.
151: **
152: delete from per_grades_tl
153: where grade_id between p_start_pkid
154: and p_end_pkid;
155: */
156:

Line 178: insert into per_grades_tl(

174:
175: /*
176: ** Insert the TL rows.
177: */
178: insert into per_grades_tl(
179: grade_id,
180: language,
181: source_lang,
182: name,

Line 206: from per_grades_tl gtl

202: where g.grade_definition_id = gd.grade_definition_id
203: and g.grade_id between p_start_pkid
204: and p_end_pkid
205: and not exists (select '1'
206: from per_grades_tl gtl
207: where gtl.grade_id = g.grade_id
208: and gtl.language = l_current_language);
209:
210: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;