[Home] [Help]
342: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
343:
344: SELECT
345: pacitl.name into x_ci_type_name
346: FROM pa_control_items paci, pa_ci_types_tl pacitl
347: WHERE
348: paci.ci_id = p_ci_id
349: and paci.ci_type_id = pacitl.ci_type_id
350: and pacitl.language = userenv('lang');
653: l_token_v_type VARCHAR2(30);
654: l_res_resgr_mismatch_flag VARCHAR2(1) := 'N';
655: l_chg_doc_token varchar2(250);
656: l_ci_number pa_control_items.ci_number%type;
657: l_ci_type_name pa_ci_types_tl.short_name%type;
658: l_count number;
659: l_token_ci_id pa_control_items.ci_id%type;
660: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
661: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
1066: begin
1067: select ci.ci_number,cit.short_name into
1068: l_ci_number,l_ci_type_name from
1069: pa_control_items ci,
1070: pa_ci_types_tl cit
1071: where ci.ci_id = l_token_ci_id and
1072: cit.ci_type_id = ci.ci_type_id and
1073: cit.language = userenv('LANG');
1074: l_chg_doc_token := l_ci_type_name;
2749: l_s_rev_bv_id pa_budget_versions.budget_version_id%type;
2750: l_count number;
2751: l_s_bv_fp_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2752: l_ci_number pa_control_items.ci_number%type;
2753: l_ci_type_name pa_ci_types_tl.short_name%type;
2754: l_s_bv_time_phased_code pa_proj_fp_options.revenue_time_phased_code%type;
2755: l_s_bv_resource_list_id pa_proj_fp_options.revenue_resource_list_id%type;
2756:
2757: l_ci_aprv_bv_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2804: begin
2805: select ci.ci_number,cit.short_name into
2806: l_ci_number,l_ci_type_name from
2807: pa_control_items ci,
2808: pa_ci_types_tl cit
2809: where ci.ci_id = p_s_ci_id and
2810: cit.ci_type_id = ci.ci_type_id and
2811: cit.language = userenv('LANG');
2812: l_token_ci_id := l_ci_type_name;