DBA Data[Home] [Help]

APPS.PA_FP_SPREAD_AMTS_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 1920: x_pa_period_type OUT NOCOPY pa_implementations_all.

1916: x_period_set_name OUT NOCOPY gl_sets_of_books.
1917: period_set_name%TYPE,
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,

Line 1953: ,pa_implementations_all pia

1949: 'COST',ppfo.cost_time_phased_code,
1950: 'REVENUE',ppfo.revenue_time_phased_code,
1951: ppfo.all_time_phased_code) time_phase_code
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

Line 2047: p_pa_period_type IN pa_implementations_all.

2043: p_period_set_name IN gl_sets_of_books.
2044: period_set_name%TYPE,
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,

Line 2064: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;

2060: l_debug_mode VARCHAR2(30);
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:

Line 2340: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;

2336: l_dummy_bl_id Number;
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);