401: if (x_owner = 'SEED') then
402: l_user_id := 1;
403: end if;
404:
405: update qp_pte_request_types_b set
406: order_level_global_struct = x_order_level_global_struct,
407: line_level_global_struct = x_line_level_global_struct,
408: order_level_view_name = x_order_level_view_name,
409: line_level_view_name = x_line_level_view_name,
414: where request_type_code = x_request_type_code
415: and pte_code = x_pte_code;
416:
417: if sql%notfound then
418: insert into qp_pte_request_types_b (
419: request_type_code,
420: pte_code,
421: order_level_global_struct,
422: line_level_global_struct,
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:
475: else