DBA Data[Home] [Help]

APPS.PA_FP_SPREAD_AMTS_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 2650: x_pa_period_type OUT NOCOPY pa_implementations_all.

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

Line 2683: ,pa_implementations_all pia

2679: 'COST',ppfo.cost_time_phased_code,
2680: 'REVENUE',ppfo.revenue_time_phased_code,
2681: ppfo.all_time_phased_code) time_phase_code
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

Line 2777: p_pa_period_type IN pa_implementations_all.

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

Line 2794: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;

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

Line 3070: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;

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