APPS.PA_FP_SPREAD_AMTS_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 2652: x_time_phase_code OUT NOCOPY pa_proj_fp_options.

2648: x_accounted_period_type OUT NOCOPY gl_sets_of_books.
2649: accounted_period_type%TYPE,
2650: x_pa_period_type OUT NOCOPY pa_implementations_all.
2651: pa_period_type%TYPE,
2652: x_time_phase_code OUT NOCOPY pa_proj_fp_options.
2653: all_time_phased_code%TYPE,
2654: x_return_status OUT NOCOPY VARCHAR2,
2655: x_msg_count OUT NOCOPY NUMBER,
2656: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 2686: ,pa_proj_fp_options ppfo

2682: FROM gl_sets_of_books gsb
2683: ,pa_implementations_all pia
2684: ,pa_projects_all ppa
2685: ,pa_budget_versions pbv
2686: ,pa_proj_fp_options ppfo
2687: WHERE ppa.project_id = pbv.project_id
2688: AND pbv.budget_version_id = ppfo.fin_plan_version_id
2689: /* MOAC Changes: AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99) */
2690: AND ppa.org_id = pia.org_id

Line 2779: p_time_phase_code IN pa_proj_fp_options.

2775: p_accounted_period_type IN gl_sets_of_books.
2776: accounted_period_type%TYPE,
2777: p_pa_period_type IN pa_implementations_all.
2778: pa_period_type%TYPE,
2779: p_time_phase_code IN pa_proj_fp_options.
2780: all_time_phased_code%TYPE,
2781: x_spread_amounts OUT NOCOPY spread_table_type,
2782: x_return_status OUT NOCOPY VARCHAR2,
2783: x_msg_count OUT NOCOPY NUMBER,

Line 2795: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%TYPE;

2791:
2792: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
2793: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
2794: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
2795: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2796: l_start_date DATE;
2797: l_end_date DATE;
2798:
2799: tmp_rec spread_record_type;

Line 2993: --l_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

2989: v_start_end start_end_date_record_type;
2990: i INTEGER;
2991: bl_exist BOOLEAN;
2992:
2993: --l_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
2994: l_line_start INTEGER;
2995: l_line_end INTEGER;
2996: l_line_start_date DATE;
2997: l_line_end_date DATE;

Line 3071: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%TYPE;

3067:
3068: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
3069: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
3070: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
3071: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3072:
3073: /* bug fix:5726773 */
3074: l_neg_qty_er_flag VARCHAR2(1);
3075: