APPS.QP_LOADER_PVT dependencies on QP_PTE_REQUEST_TYPES_TL

Line 372: update qp_pte_request_types_tl set

368: )
369: is
370: begin
371:
372: update qp_pte_request_types_tl set
373: request_type_desc = nvl(x_request_type_desc, request_type_desc),
374: last_update_date = to_date(x_last_update_date,'YYYY/MM/DD'),
375: last_updated_by = decode(x_owner, 'SEED', 1, 0),
376: last_update_login = 0,

Line 446: insert into qp_pte_request_types_tl (

442: 0,
443: l_user_id
444: );
445:
446: insert into qp_pte_request_types_tl (
447: request_type_code,
448: request_type_desc,
449: source_lang,
450: language,

Line 470: from qp_pte_request_types_tl t,

466: from fnd_languages l
467: where l.installed_flag in ('I', 'B')
468: and not exists
469: (select null
470: from qp_pte_request_types_tl t,
471: qp_pte_request_types_b b
472: where t.request_type_code = x_request_type_code
473: and t.language = l.language_code);
474:

Line 476: update qp_pte_request_types_tl set

472: where t.request_type_code = x_request_type_code
473: and t.language = l.language_code);
474:
475: else
476: update qp_pte_request_types_tl set
477: request_type_desc = nvl(x_request_type_desc, request_type_desc),
478: last_update_date=to_date(x_last_update_date,'YYYY/MM/DD'),
479: last_updated_by = l_user_id,
480: last_update_login = 0,