APPS.PA_FP_SPREAD_AMTS_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 1922: x_time_phase_code OUT NOCOPY pa_proj_fp_options.

1918: x_accounted_period_type OUT NOCOPY gl_sets_of_books.
1919: accounted_period_type%TYPE,
1920: x_pa_period_type OUT NOCOPY pa_implementations_all.
1921: pa_period_type%TYPE,
1922: x_time_phase_code OUT NOCOPY pa_proj_fp_options.
1923: all_time_phased_code%TYPE,
1924: x_return_status OUT NOCOPY VARCHAR2,
1925: x_msg_count OUT NOCOPY NUMBER,
1926: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1956: ,pa_proj_fp_options ppfo

1952: FROM gl_sets_of_books gsb
1953: ,pa_implementations_all pia
1954: ,pa_projects_all ppa
1955: ,pa_budget_versions pbv
1956: ,pa_proj_fp_options ppfo
1957: WHERE ppa.project_id = pbv.project_id
1958: AND pbv.budget_version_id = ppfo.fin_plan_version_id
1959: /* MOAC Changes: AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99) */
1960: AND ppa.org_id = pia.org_id

Line 2049: p_time_phase_code IN pa_proj_fp_options.

2045: p_accounted_period_type IN gl_sets_of_books.
2046: accounted_period_type%TYPE,
2047: p_pa_period_type IN pa_implementations_all.
2048: pa_period_type%TYPE,
2049: p_time_phase_code IN pa_proj_fp_options.
2050: all_time_phased_code%TYPE,
2051: x_spread_amounts OUT NOCOPY spread_table_type,
2052: x_return_status OUT NOCOPY VARCHAR2,
2053: x_msg_count OUT NOCOPY NUMBER,

Line 2065: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%TYPE;

2061:
2062: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
2063: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
2064: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
2065: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2066: l_start_date DATE;
2067: l_end_date DATE;
2068:
2069: tmp_rec spread_record_type;

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

2259: v_start_end start_end_date_record_type;
2260: i INTEGER;
2261: bl_exist BOOLEAN;
2262:
2263: --l_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
2264: l_line_start INTEGER;
2265: l_line_end INTEGER;
2266: l_line_start_date DATE;
2267: l_line_end_date DATE;

Line 2341: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%TYPE;

2337:
2338: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
2339: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
2340: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
2341: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2342:
2343: /* bug fix:5726773 */
2344: l_neg_qty_er_flag VARCHAR2(1);
2345: