APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_CI_TYPES_TL

Line 370: FROM pa_control_items paci, pa_ci_types_tl pacitl

366: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
367:
368: SELECT
369: pacitl.name into x_ci_type_name
370: FROM pa_control_items paci, pa_ci_types_tl pacitl
371: WHERE
372: paci.ci_id = p_ci_id
373: and paci.ci_type_id = pacitl.ci_type_id
374: and pacitl.language = userenv('lang');

Line 681: l_ci_type_name pa_ci_types_tl.short_name%type;

677: l_token_v_type VARCHAR2(30);
678: l_res_resgr_mismatch_flag VARCHAR2(1) := 'N';
679: l_chg_doc_token varchar2(250);
680: l_ci_number pa_control_items.ci_number%type;
681: l_ci_type_name pa_ci_types_tl.short_name%type;
682: l_count number;
683: l_token_ci_id pa_control_items.ci_id%type;
684: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
685: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 1104: pa_ci_types_tl cit

1100: begin
1101: select ci.ci_number,cit.short_name into
1102: l_ci_number,l_ci_type_name from
1103: pa_control_items ci,
1104: pa_ci_types_tl cit
1105: where ci.ci_id = l_token_ci_id and
1106: cit.ci_type_id = ci.ci_type_id and
1107: cit.language = userenv('LANG');
1108: l_chg_doc_token := l_ci_type_name;

Line 2802: l_ci_type_name pa_ci_types_tl.short_name%type;

2798: l_s_rev_bv_id pa_budget_versions.budget_version_id%type;
2799: l_count number;
2800: l_s_bv_fp_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2801: l_ci_number pa_control_items.ci_number%type;
2802: l_ci_type_name pa_ci_types_tl.short_name%type;
2803: l_s_bv_time_phased_code pa_proj_fp_options.revenue_time_phased_code%type;
2804: l_s_bv_resource_list_id pa_proj_fp_options.revenue_resource_list_id%type;
2805:
2806: l_ci_aprv_bv_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 2857: pa_ci_types_tl cit

2853: begin
2854: select ci.ci_number,cit.short_name into
2855: l_ci_number,l_ci_type_name from
2856: pa_control_items ci,
2857: pa_ci_types_tl cit
2858: where ci.ci_id = p_s_ci_id and
2859: cit.ci_type_id = ci.ci_type_id and
2860: cit.language = userenv('LANG');
2861: l_token_ci_id := l_ci_type_name;