APPS.PA_FP_SPREAD_AMTS_PKG dependencies on GL_SETS_OF_BOOKS

Line 2646: x_period_set_name OUT NOCOPY gl_sets_of_books.

2642:
2643: PROCEDURE get_options (
2644: p_budget_version_id IN pa_budget_versions.
2645: budget_version_id%TYPE,
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.

Line 2648: x_accounted_period_type OUT NOCOPY gl_sets_of_books.

2644: p_budget_version_id IN pa_budget_versions.
2645: budget_version_id%TYPE,
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.

Line 2682: FROM gl_sets_of_books gsb

2678: ,decode(pbv.version_type,
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

Line 2773: p_period_set_name IN gl_sets_of_books.

2769:
2770: PROCEDURE get_periods (
2771: p_start_date IN pa_budget_lines.start_date%TYPE,
2772: p_end_date IN pa_budget_lines.end_date%TYPE,
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.

Line 2775: p_accounted_period_type IN gl_sets_of_books.

2771: p_start_date IN pa_budget_lines.start_date%TYPE,
2772: p_end_date IN pa_budget_lines.end_date%TYPE,
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.

Line 2792: l_period_set_name gl_sets_of_books.period_set_name%TYPE;

2788: l_msg_data VARCHAR2(2000);
2789: l_msg_index_out NUMBER;
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;

Line 2793: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;

2789: l_msg_index_out NUMBER;
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;

Line 3068: l_period_set_name gl_sets_of_books.period_set_name%TYPE;

3064: l_dummy_count INTEGER;
3065: l_bl_line_id Number;
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:

Line 3069: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;

3065: l_bl_line_id Number;
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 */