DBA Data[Home] [Help]

APPS.QP_LOADER_DIST_PUB dependencies on QP_SEGMENTS_TL

Line 252: update qp_segments_tl

248: l_prc_context_id,
249: x_segment_mapping_column,
250: x_segment_code,
251: 'Update') = -1 then
252: update qp_segments_tl
253: set user_segment_name = decode(seeded_segment_name, user_segment_name,
254: x_seeded_segment_name, user_segment_name),
255: --seeded_segment_name = nvl(seeded_segment_name, x_seeded_segment_name),
256: seeded_segment_name = nvl(x_seeded_segment_name, seeded_segment_name),

Line 353: update qp_segments_tl set

349: last_update_date = nvl(to_date(x_last_update_date,'YYYY/MM/DD'),sysdate),
350: last_update_login = 0
351: where segment_id = l_segment_id;
352:
353: update qp_segments_tl set
354: user_segment_name = decode(seeded_segment_name, user_segment_name,
355: x_seeded_segment_name, user_segment_name),
356: seeded_segment_name = nvl(seeded_segment_name, x_seeded_segment_name),
357: user_description = decode(seeded_description,

Line 422: insert into qp_segments_tl (

418: l_user_id
419: );
420: commit;
421: ---
422: insert into qp_segments_tl (
423: segment_id,
424: seeded_segment_name,
425: user_segment_name,
426: seeded_description,

Line 451: from qp_segments_tl t

447: l_user_id
448: from fnd_languages l
449: where l.installed_flag in ('I', 'B') and
450: not exists (select null
451: from qp_segments_tl t
452: where t.segment_id = l_segment_id and
453: t.language = l.language_code);
454: commit;
455: end if;