APPS.PER_MLS_MIGRATION dependencies on PER_COMPETENCES

Line 451: delete from per_competences_tl

447: ** Clear out any existing data for this range of records
448: **
449: ** Don't delete just yet.
450: **
451: delete from per_competences_tl
452: where competence_id between p_start_pkid
453: and p_end_pkid;
454: */
455:

Line 477: insert into per_competences_tl(

473:
474: /*
475: ** Insert the TL rows.
476: */
477: insert into per_competences_tl(
478: competence_id,
479: language,
480: source_lang,
481: name,

Line 505: from per_competences c,

501: c.creation_date,
502: c.last_updated_by,
503: c.last_update_date,
504: c.last_update_login
505: from per_competences c,
506: per_competence_definitions cd
507: where c.competence_definition_id = cd.competence_definition_id
508: and c.competence_id between p_start_pkid
509: and p_end_pkid

Line 511: from per_competences_tl ctl

507: where c.competence_definition_id = cd.competence_definition_id
508: and c.competence_id between p_start_pkid
509: and p_end_pkid
510: and not exists (select '1'
511: from per_competences_tl ctl
512: where ctl.competence_id = c.competence_id
513: and ctl.language = l_current_language);
514:
515: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;