eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_FP_ORG_FCST_GEN_PUB

Line 1: PACKAGE BODY pa_fp_org_fcst_gen_pub as

1: PACKAGE BODY pa_fp_org_fcst_gen_pub as
2: /* $Header: PAFPORGB.pls 120.3.12010000.2 2008/08/25 10:49:13 bifernan ship $ */
3: /**
4: -- Start of Comments
5: -- Package name : PA_FP_ORG_FCST_GEN_PUB

Line 5: -- Package name : PA_FP_ORG_FCST_GEN_PUB

1: PACKAGE BODY pa_fp_org_fcst_gen_pub as
2: /* $Header: PAFPORGB.pls 120.3.12010000.2 2008/08/25 10:49:13 bifernan ship $ */
3: /**
4: -- Start of Comments
5: -- Package name : PA_FP_ORG_FCST_GEN_PUB
6: -- Purpose :
7: -- History :
8: -- 27-SEP-2002 sdebroy FPB2: Changes made due to addition of
9: -- budget_line_id into pa_budget_lines

Line 35: g_module_name VARCHAR2(100):= 'pa.plsql.pa_fp_org_fcst_gen_pub';

31: REM | 03-OCT-2005 Riyengar MRC Elimination Changes:
32: **/
33:
34: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
35: g_module_name VARCHAR2(100):= 'pa.plsql.pa_fp_org_fcst_gen_pub';
36: g_plsql_max_array_size NUMBER := 200;
37:
38: FUNCTION budget_version_in_error
39: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

Line 55: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.budget_version_in_error'

51:
52: EXCEPTION
53: WHEN OTHERS THEN
54: FND_MSG_PUB.add_exc_msg(
55: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.budget_version_in_error'
56: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
57:
58: IF P_PA_DEBUG_MODE = 'Y' THEN
59: pa_debug.write_file('budget_version_in_error: ' || SQLERRM);

Line 71: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;

67: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE
68: := NULL
69: ) RETURN NUMBER IS
70: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
71: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;
72: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table;
73:
74: l_debug_mode VARCHAR2(30);
75:

Line 72: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table;

68: := NULL
69: ) RETURN NUMBER IS
70: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
71: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;
72: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table;
73:
74: l_debug_mode VARCHAR2(30);
75:
76: CURSOR get_amt_det IS

Line 86: pa_debug.init_err_stack('PA_FP_ORG_FCST_GEN_PUB.get_amttype_id');

82: l_stage number := 0;
83:
84: BEGIN
85: IF P_PA_DEBUG_MODE = 'Y' THEN
86: pa_debug.init_err_stack('PA_FP_ORG_FCST_GEN_PUB.get_amttype_id');
87: END IF;
88:
89: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
90: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 126: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'

122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: FND_MSG_PUB.add_exc_msg(
126: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'
127: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
128:
129: IF P_PA_DEBUG_MODE = 'Y' THEN
130: pa_debug.write_file('get_amttype_id: ' || SQLERRM);

Line 566: l_fi_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

562:
563: /* PLSQL Table Declarations */
564:
565: /* Forecast Item PL/SQL tables */
566: l_fi_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
567: l_fi_proj_organization_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
568: l_fi_proj_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
569: l_fi_exp_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
570: l_fi_exp_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 567: l_fi_proj_organization_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

563: /* PLSQL Table Declarations */
564:
565: /* Forecast Item PL/SQL tables */
566: l_fi_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
567: l_fi_proj_organization_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
568: l_fi_proj_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
569: l_fi_exp_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
570: l_fi_exp_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
571: l_fi_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 568: l_fi_proj_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

564:
565: /* Forecast Item PL/SQL tables */
566: l_fi_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
567: l_fi_proj_organization_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
568: l_fi_proj_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
569: l_fi_exp_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
570: l_fi_exp_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
571: l_fi_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
572: l_fi_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 569: l_fi_exp_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

565: /* Forecast Item PL/SQL tables */
566: l_fi_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
567: l_fi_proj_organization_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
568: l_fi_proj_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
569: l_fi_exp_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
570: l_fi_exp_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
571: l_fi_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
572: l_fi_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
573: l_fi_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 570: l_fi_exp_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

566: l_fi_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
567: l_fi_proj_organization_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
568: l_fi_proj_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
569: l_fi_exp_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
570: l_fi_exp_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
571: l_fi_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
572: l_fi_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
573: l_fi_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
574:

Line 571: l_fi_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

567: l_fi_proj_organization_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
568: l_fi_proj_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
569: l_fi_exp_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
570: l_fi_exp_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
571: l_fi_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
572: l_fi_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
573: l_fi_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
574:
575: l_fi_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;

Line 572: l_fi_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

568: l_fi_proj_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
569: l_fi_exp_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
570: l_fi_exp_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
571: l_fi_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
572: l_fi_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
573: l_fi_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
574:
575: l_fi_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
576: l_fi_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

Line 573: l_fi_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

569: l_fi_exp_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
570: l_fi_exp_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
571: l_fi_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
572: l_fi_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
573: l_fi_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
574:
575: l_fi_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
576: l_fi_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
577: l_fi_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

Line 575: l_fi_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;

571: l_fi_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
572: l_fi_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
573: l_fi_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
574:
575: l_fi_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
576: l_fi_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
577: l_fi_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
578: l_fi_item_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
579: l_fi_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 576: l_fi_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

572: l_fi_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
573: l_fi_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
574:
575: l_fi_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
576: l_fi_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
577: l_fi_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
578: l_fi_item_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
579: l_fi_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
580: l_fi_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 577: l_fi_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

573: l_fi_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
574:
575: l_fi_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
576: l_fi_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
577: l_fi_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
578: l_fi_item_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
579: l_fi_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
580: l_fi_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
581: l_fi_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 578: l_fi_item_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

574:
575: l_fi_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
576: l_fi_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
577: l_fi_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
578: l_fi_item_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
579: l_fi_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
580: l_fi_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
581: l_fi_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
582: l_fi_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 579: l_fi_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

575: l_fi_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
576: l_fi_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
577: l_fi_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
578: l_fi_item_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
579: l_fi_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
580: l_fi_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
581: l_fi_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
582: l_fi_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
583: l_fi_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 580: l_fi_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

576: l_fi_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
577: l_fi_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
578: l_fi_item_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
579: l_fi_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
580: l_fi_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
581: l_fi_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
582: l_fi_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
583: l_fi_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
584: l_fi_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 581: l_fi_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

577: l_fi_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
578: l_fi_item_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
579: l_fi_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
580: l_fi_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
581: l_fi_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
582: l_fi_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
583: l_fi_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
584: l_fi_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
585: l_fi_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 582: l_fi_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

578: l_fi_item_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
579: l_fi_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
580: l_fi_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
581: l_fi_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
582: l_fi_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
583: l_fi_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
584: l_fi_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
585: l_fi_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
586: l_fi_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 583: l_fi_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

579: l_fi_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
580: l_fi_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
581: l_fi_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
582: l_fi_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
583: l_fi_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
584: l_fi_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
585: l_fi_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
586: l_fi_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
587: l_fi_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 584: l_fi_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

580: l_fi_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
581: l_fi_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
582: l_fi_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
583: l_fi_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
584: l_fi_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
585: l_fi_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
586: l_fi_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
587: l_fi_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
588: l_fi_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 585: l_fi_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

581: l_fi_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
582: l_fi_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
583: l_fi_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
584: l_fi_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
585: l_fi_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
586: l_fi_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
587: l_fi_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
588: l_fi_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
589:

Line 586: l_fi_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

582: l_fi_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
583: l_fi_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
584: l_fi_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
585: l_fi_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
586: l_fi_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
587: l_fi_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
588: l_fi_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
589:
590: /* Forecast Element PL/SQL Tables */

Line 587: l_fi_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

583: l_fi_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
584: l_fi_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
585: l_fi_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
586: l_fi_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
587: l_fi_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
588: l_fi_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
589:
590: /* Forecast Element PL/SQL Tables */
591: l_fe_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 588: l_fi_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

584: l_fi_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
585: l_fi_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
586: l_fi_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
587: l_fi_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
588: l_fi_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
589:
590: /* Forecast Element PL/SQL Tables */
591: l_fe_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
592: l_fe_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 591: l_fe_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

587: l_fi_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
588: l_fi_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
589:
590: /* Forecast Element PL/SQL Tables */
591: l_fe_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
592: l_fe_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
593: l_fe_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
594: l_fe_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
595: l_fe_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 592: l_fe_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

588: l_fi_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
589:
590: /* Forecast Element PL/SQL Tables */
591: l_fe_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
592: l_fe_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
593: l_fe_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
594: l_fe_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
595: l_fe_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
596: l_fe_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 593: l_fe_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

589:
590: /* Forecast Element PL/SQL Tables */
591: l_fe_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
592: l_fe_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
593: l_fe_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
594: l_fe_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
595: l_fe_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
596: l_fe_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
597: l_fe_pvdr_rcvr_code_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;

Line 594: l_fe_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

590: /* Forecast Element PL/SQL Tables */
591: l_fe_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
592: l_fe_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
593: l_fe_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
594: l_fe_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
595: l_fe_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
596: l_fe_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
597: l_fe_pvdr_rcvr_code_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
598: l_fe_other_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 595: l_fe_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

591: l_fe_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
592: l_fe_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
593: l_fe_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
594: l_fe_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
595: l_fe_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
596: l_fe_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
597: l_fe_pvdr_rcvr_code_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
598: l_fe_other_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
599: l_fe_other_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 596: l_fe_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

592: l_fe_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
593: l_fe_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
594: l_fe_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
595: l_fe_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
596: l_fe_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
597: l_fe_pvdr_rcvr_code_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
598: l_fe_other_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
599: l_fe_other_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
600: l_fe_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 597: l_fe_pvdr_rcvr_code_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;

593: l_fe_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
594: l_fe_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
595: l_fe_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
596: l_fe_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
597: l_fe_pvdr_rcvr_code_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
598: l_fe_other_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
599: l_fe_other_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
600: l_fe_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
601: l_fe_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 598: l_fe_other_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

594: l_fe_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
595: l_fe_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
596: l_fe_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
597: l_fe_pvdr_rcvr_code_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
598: l_fe_other_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
599: l_fe_other_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
600: l_fe_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
601: l_fe_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
602: l_fe_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 599: l_fe_other_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

595: l_fe_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
596: l_fe_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
597: l_fe_pvdr_rcvr_code_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
598: l_fe_other_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
599: l_fe_other_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
600: l_fe_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
601: l_fe_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
602: l_fe_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
603:

Line 600: l_fe_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

596: l_fe_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
597: l_fe_pvdr_rcvr_code_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
598: l_fe_other_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
599: l_fe_other_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
600: l_fe_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
601: l_fe_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
602: l_fe_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
603:
604: /* Forecast Lines PL/SQL Tables */

Line 601: l_fe_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

597: l_fe_pvdr_rcvr_code_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
598: l_fe_other_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
599: l_fe_other_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
600: l_fe_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
601: l_fe_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
602: l_fe_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
603:
604: /* Forecast Lines PL/SQL Tables */
605: l_fl_forecast_line_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 602: l_fe_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

598: l_fe_other_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
599: l_fe_other_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
600: l_fe_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
601: l_fe_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
602: l_fe_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
603:
604: /* Forecast Lines PL/SQL Tables */
605: l_fl_forecast_line_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
606: l_fl_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 605: l_fl_forecast_line_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

601: l_fe_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
602: l_fe_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
603:
604: /* Forecast Lines PL/SQL Tables */
605: l_fl_forecast_line_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
606: l_fl_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
607: l_fl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
608: l_fl_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
609: l_fl_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 606: l_fl_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

602: l_fe_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
603:
604: /* Forecast Lines PL/SQL Tables */
605: l_fl_forecast_line_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
606: l_fl_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
607: l_fl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
608: l_fl_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
609: l_fl_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
610: l_fl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;

Line 607: l_fl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

603:
604: /* Forecast Lines PL/SQL Tables */
605: l_fl_forecast_line_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
606: l_fl_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
607: l_fl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
608: l_fl_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
609: l_fl_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
610: l_fl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
611: l_fl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

Line 608: l_fl_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

604: /* Forecast Lines PL/SQL Tables */
605: l_fl_forecast_line_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
606: l_fl_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
607: l_fl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
608: l_fl_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
609: l_fl_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
610: l_fl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
611: l_fl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
612: l_fl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

Line 609: l_fl_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

605: l_fl_forecast_line_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
606: l_fl_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
607: l_fl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
608: l_fl_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
609: l_fl_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
610: l_fl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
611: l_fl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
612: l_fl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
613: l_fl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 610: l_fl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;

606: l_fl_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
607: l_fl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
608: l_fl_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
609: l_fl_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
610: l_fl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
611: l_fl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
612: l_fl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
613: l_fl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
614: l_fl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 611: l_fl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

607: l_fl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
608: l_fl_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
609: l_fl_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
610: l_fl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
611: l_fl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
612: l_fl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
613: l_fl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
614: l_fl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
615: l_fl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 612: l_fl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

608: l_fl_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
609: l_fl_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
610: l_fl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
611: l_fl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
612: l_fl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
613: l_fl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
614: l_fl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
615: l_fl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
616: l_fl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 613: l_fl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

609: l_fl_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
610: l_fl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
611: l_fl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
612: l_fl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
613: l_fl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
614: l_fl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
615: l_fl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
616: l_fl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
617: l_fl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 614: l_fl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

610: l_fl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
611: l_fl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
612: l_fl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
613: l_fl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
614: l_fl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
615: l_fl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
616: l_fl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
617: l_fl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
618: l_fl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 615: l_fl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

611: l_fl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
612: l_fl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
613: l_fl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
614: l_fl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
615: l_fl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
616: l_fl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
617: l_fl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
618: l_fl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
619: l_fl_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 616: l_fl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

612: l_fl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
613: l_fl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
614: l_fl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
615: l_fl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
616: l_fl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
617: l_fl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
618: l_fl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
619: l_fl_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
620: l_fl_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 617: l_fl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

613: l_fl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
614: l_fl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
615: l_fl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
616: l_fl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
617: l_fl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
618: l_fl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
619: l_fl_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
620: l_fl_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
621: l_fl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 618: l_fl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

614: l_fl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
615: l_fl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
616: l_fl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
617: l_fl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
618: l_fl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
619: l_fl_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
620: l_fl_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
621: l_fl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
622: l_fl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 619: l_fl_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

615: l_fl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
616: l_fl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
617: l_fl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
618: l_fl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
619: l_fl_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
620: l_fl_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
621: l_fl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
622: l_fl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
623: l_fl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 620: l_fl_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

616: l_fl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
617: l_fl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
618: l_fl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
619: l_fl_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
620: l_fl_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
621: l_fl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
622: l_fl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
623: l_fl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
624:

Line 621: l_fl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

617: l_fl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
618: l_fl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
619: l_fl_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
620: l_fl_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
621: l_fl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
622: l_fl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
623: l_fl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
624:
625: /* Budget Lines PL/SQL Tables */

Line 622: l_fl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

618: l_fl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
619: l_fl_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
620: l_fl_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
621: l_fl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
622: l_fl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
623: l_fl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
624:
625: /* Budget Lines PL/SQL Tables */
626: l_bl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table; /* FPB2: budget_version_id */

Line 623: l_fl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

619: l_fl_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
620: l_fl_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
621: l_fl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
622: l_fl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
623: l_fl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
624:
625: /* Budget Lines PL/SQL Tables */
626: l_bl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table; /* FPB2: budget_version_id */
627:

Line 626: l_bl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table; /* FPB2: budget_version_id */

622: l_fl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
623: l_fl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
624:
625: /* Budget Lines PL/SQL Tables */
626: l_bl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table; /* FPB2: budget_version_id */
627:
628: l_bl_res_asg_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
629: l_bl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
630: l_bl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

Line 628: l_bl_res_asg_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

624:
625: /* Budget Lines PL/SQL Tables */
626: l_bl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table; /* FPB2: budget_version_id */
627:
628: l_bl_res_asg_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
629: l_bl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
630: l_bl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
631: l_bl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
632: l_bl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 629: l_bl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

625: /* Budget Lines PL/SQL Tables */
626: l_bl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table; /* FPB2: budget_version_id */
627:
628: l_bl_res_asg_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
629: l_bl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
630: l_bl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
631: l_bl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
632: l_bl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
633: l_bl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 630: l_bl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

626: l_bl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table; /* FPB2: budget_version_id */
627:
628: l_bl_res_asg_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
629: l_bl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
630: l_bl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
631: l_bl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
632: l_bl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
633: l_bl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
634: l_bl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 631: l_bl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;

627:
628: l_bl_res_asg_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
629: l_bl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
630: l_bl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
631: l_bl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
632: l_bl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
633: l_bl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
634: l_bl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
635: l_bl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 632: l_bl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

628: l_bl_res_asg_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
629: l_bl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
630: l_bl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
631: l_bl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
632: l_bl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
633: l_bl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
634: l_bl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
635: l_bl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
636: l_bl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 633: l_bl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

629: l_bl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
630: l_bl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
631: l_bl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
632: l_bl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
633: l_bl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
634: l_bl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
635: l_bl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
636: l_bl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
637: l_bl_tp_revenue_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 634: l_bl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

630: l_bl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;
631: l_bl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
632: l_bl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
633: l_bl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
634: l_bl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
635: l_bl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
636: l_bl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
637: l_bl_tp_revenue_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
638: l_bl_tp_revenue_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 635: l_bl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

631: l_bl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;
632: l_bl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
633: l_bl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
634: l_bl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
635: l_bl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
636: l_bl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
637: l_bl_tp_revenue_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
638: l_bl_tp_revenue_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
639: l_bl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 636: l_bl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

632: l_bl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
633: l_bl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
634: l_bl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
635: l_bl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
636: l_bl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
637: l_bl_tp_revenue_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
638: l_bl_tp_revenue_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
639: l_bl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
640: l_bl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 637: l_bl_tp_revenue_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

633: l_bl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
634: l_bl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
635: l_bl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
636: l_bl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
637: l_bl_tp_revenue_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
638: l_bl_tp_revenue_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
639: l_bl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
640: l_bl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
641: l_bl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 638: l_bl_tp_revenue_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

634: l_bl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
635: l_bl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
636: l_bl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
637: l_bl_tp_revenue_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
638: l_bl_tp_revenue_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
639: l_bl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
640: l_bl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
641: l_bl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
642: l_bl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 639: l_bl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

635: l_bl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
636: l_bl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
637: l_bl_tp_revenue_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
638: l_bl_tp_revenue_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
639: l_bl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
640: l_bl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
641: l_bl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
642: l_bl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
643: l_bl_utilization_percent_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 640: l_bl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

636: l_bl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
637: l_bl_tp_revenue_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
638: l_bl_tp_revenue_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
639: l_bl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
640: l_bl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
641: l_bl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
642: l_bl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
643: l_bl_utilization_percent_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
644: l_bl_utilization_hours_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 641: l_bl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

637: l_bl_tp_revenue_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
638: l_bl_tp_revenue_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
639: l_bl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
640: l_bl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
641: l_bl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
642: l_bl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
643: l_bl_utilization_percent_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
644: l_bl_utilization_hours_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
645: l_bl_capacity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 642: l_bl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

638: l_bl_tp_revenue_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
639: l_bl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
640: l_bl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
641: l_bl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
642: l_bl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
643: l_bl_utilization_percent_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
644: l_bl_utilization_hours_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
645: l_bl_capacity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
646: l_bl_head_count_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

Line 643: l_bl_utilization_percent_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

639: l_bl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
640: l_bl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
641: l_bl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
642: l_bl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
643: l_bl_utilization_percent_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
644: l_bl_utilization_hours_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
645: l_bl_capacity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
646: l_bl_head_count_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
647:

Line 644: l_bl_utilization_hours_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

640: l_bl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
641: l_bl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
642: l_bl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
643: l_bl_utilization_percent_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
644: l_bl_utilization_hours_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
645: l_bl_capacity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
646: l_bl_head_count_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
647:
648: BEGIN

Line 645: l_bl_capacity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

641: l_bl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
642: l_bl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
643: l_bl_utilization_percent_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
644: l_bl_utilization_hours_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
645: l_bl_capacity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
646: l_bl_head_count_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
647:
648: BEGIN
649:

Line 646: l_bl_head_count_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

642: l_bl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
643: l_bl_utilization_percent_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
644: l_bl_utilization_hours_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
645: l_bl_capacity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
646: l_bl_head_count_tab pa_fp_org_fcst_gen_pub.number_data_type_table;
647:
648: BEGIN
649:
650: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 651: pa_debug.init_err_stack('PA_FP_ORG_FCST_GEN_PUB.gen_org_fcst');

647:
648: BEGIN
649:
650: IF P_PA_DEBUG_MODE = 'Y' THEN
651: pa_debug.init_err_stack('PA_FP_ORG_FCST_GEN_PUB.gen_org_fcst');
652: END IF;
653:
654: --fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
655: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 916: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

912: IF P_PA_DEBUG_MODE = 'Y' THEN
913: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
914: END IF;
915: rollback to org_project;
916: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
917: END IF;
918:
919: l_stage := 1400;
920:

Line 938: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

934: IF P_PA_DEBUG_MODE = 'Y' THEN
935: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
936: END IF;
937: rollback to org_project;
938: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
939: END;
940: ELSE
941: l_stage := 1500;
942: pa_debug.g_err_stage := l_stage||': Fetching from org_hierarchy';

Line 976: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

972: IF P_PA_DEBUG_MODE = 'Y' THEN
973: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
974: END IF;
975: rollback to org_project;
976: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
977: END;
978:
979: l_stage := 1700;
980: -- hr_utility.trace(to_char(l_stage));

Line 999: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

995: IF P_PA_DEBUG_MODE = 'Y' THEN
996: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
997: END IF;
998: rollback to org_project;
999: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1000: END IF;
1001: END IF;
1002:
1003: SELECT '-'||decode(substr(to_char(l_org_id),1,1),'-',

Line 1053: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1049: IF P_PA_DEBUG_MODE = 'Y' THEN
1050: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1051: END IF;
1052: rollback to org_project;
1053: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1054: END IF;
1055: l_stage := 2000;
1056: -- hr_utility.trace(to_char(l_stage));
1057: pa_debug.g_err_stage := l_stage||': Org Project ID is ['||l_project_id||']';

Line 1095: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1091: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1092: END IF;
1093: */
1094: rollback to org_project;
1095: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1096: END IF;
1097: l_stage := 2200;
1098: -- hr_utility.trace('2200: Own Task Id = '||to_char(l_own_task_id));
1099: pa_debug.g_err_stage := l_stage||': Own Task Id = '||l_own_task_id;

Line 1125: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1121: */
1122: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1123: ,p_msg_name => 'PA_FP_OWN_TASK_NOT_FOUND');
1124: rollback to org_project;
1125: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1126: END IF;
1127:
1128: IF l_task_organization_id <> l_organization_id THEN
1129: l_stage := 2400;

Line 1219: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1215: IF P_PA_DEBUG_MODE = 'Y' THEN
1216: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1217: END IF;
1218: rollback to org_project;
1219: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1220: END IF;
1221:
1222: l_stage := 2600;
1223: -- hr_utility.trace(to_char(l_stage));

Line 1256: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1252: IF P_PA_DEBUG_MODE = 'Y' THEN
1253: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1254: END IF;
1255: rollback to org_project;
1256: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1257: END IF;
1258:
1259: IF l_own_task_id < 0 THEN
1260: l_stage := 2700;

Line 1281: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1277: END IF;
1278: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1279: ,p_msg_name => 'PA_FP_OWN_TASK_NOT_FOUND');
1280: rollback to org_project;
1281: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1282: END IF;
1283:
1284: IF l_task_organization_id <> l_organization_id THEN
1285: l_stage := 2800;

Line 1350: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1346: IF P_PA_DEBUG_MODE = 'Y' THEN
1347: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1348: END IF;
1349: rollback to org_project;
1350: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1351: END IF;
1352:
1353: l_stage := 3000;
1354: -- hr_utility.trace(to_char(l_stage));

Line 1410: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1406: IF P_PA_DEBUG_MODE = 'Y' THEN
1407: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1408: END IF;
1409: rollback to org_project;
1410: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1411: END IF;
1412:
1413: l_stage := 3100;
1414: -- hr_utility.trace(to_char(l_stage));

Line 1476: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1472: IF P_PA_DEBUG_MODE = 'Y' THEN
1473: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1474: END IF;
1475: rollback to org_project;
1476: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1477: END IF;
1478:
1479: l_stage := 3300;
1480: -- hr_utility.trace(to_char(l_stage));

Line 1523: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1519: IF P_PA_DEBUG_MODE = 'Y' THEN
1520: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1521: END IF;
1522: rollback to org_project;
1523: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1524: END IF;
1525: END IF;
1526:
1527: l_stage := 3500;

Line 1628: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1624: IF P_PA_DEBUG_MODE = 'Y' THEN
1625: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1626: END IF;
1627: rollback to org_project;
1628: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1629: END IF;
1630:
1631: l_stage := 3750;
1632: -- hr_utility.trace(to_char(l_stage));

Line 1688: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1684: IF P_PA_DEBUG_MODE = 'Y' THEN
1685: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1686: END IF;
1687: rollback to org_project;
1688: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1689: END IF;
1690: ELSE /* Budget version passed */
1691: l_budget_ctr := 1;
1692: l_stage := 3800;

Line 1754: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1750: IF P_PA_DEBUG_MODE = 'Y' THEN
1751: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1752: END IF;
1753: rollback to org_project;
1754: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1755: END IF;
1756:
1757: IF l_own_task_id < 0 THEN
1758: l_stage := 4000;

Line 1780: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1776: END IF;
1777: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1778: ,p_msg_name => 'PA_FP_OWN_TASK_NOT_FOUND');
1779: rollback to org_project;
1780: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1781: END IF;
1782:
1783: IF l_task_organization_id <> l_organization_id THEN
1784: l_stage := 4100;

Line 1825: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1821: IF P_PA_DEBUG_MODE = 'Y' THEN
1822: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1823: END IF;
1824: rollback to org_project;
1825: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1826: END IF;
1827:
1828: /* DELETE existing data for budget version */
1829:

Line 1844: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

1840: x_msg_count => l_msg_count,
1841: x_msg_data => l_msg_data);
1842:
1843: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1844: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1845: END IF;
1846: l_stage := 4900;
1847: -- hr_utility.trace(to_char(l_stage));
1848: UPDATE pa_budget_versions

Line 2186: RAISE pa_fp_org_fcst_gen_pub.proj_action_reloop;

2182: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
2183: END IF;
2184: l_pfi_txn_project_id := l_fi_txn_project_id_tab(i);
2185:
2186: RAISE pa_fp_org_fcst_gen_pub.proj_action_reloop;
2187: END IF;
2188:
2189:
2190: IF (l_pfi_txn_project_id IS NULL OR

Line 2213: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

2209: IF P_PA_DEBUG_MODE = 'Y' THEN
2210: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
2211: END IF;
2212: rollback to org_project;
2213: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
2214: END IF;
2215: ELSE
2216: l_prob_percent := 100;
2217: END IF;

Line 2448: WHEN pa_fp_org_fcst_gen_pub.proj_action_reloop THEN

2444: l_stage := 7000;
2445: -- hr_utility.trace(to_char(l_stage));
2446:
2447: EXCEPTION
2448: WHEN pa_fp_org_fcst_gen_pub.proj_action_reloop THEN
2449: -- hr_utility.trace('UserDefined Txn Project Skipping - '||to_char(l_stage)||'-'||SQLERRM);
2450: pa_debug.g_err_stage := l_stage||': UserDefined Txn Project Skipping - '||'['||SQLERRM||']';
2451: IF P_PA_DEBUG_MODE = 'Y' THEN
2452: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 2777: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

2773: IF P_PA_DEBUG_MODE = 'Y' THEN
2774: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
2775: END IF;
2776: rollback to org_project;
2777: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
2778: END IF;
2779:
2780: END IF;
2781:

Line 3008: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

3004: IF P_PA_DEBUG_MODE = 'Y' THEN
3005: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
3006: END IF;
3007: rollback to org_project;
3008: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
3009: END IF;
3010:
3011: l_stage := 8300;
3012: -- hr_utility.trace(to_char(l_stage));

Line 3125: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

3121: IF P_PA_DEBUG_MODE = 'Y' THEN
3122: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
3123: END IF;
3124: rollback to org_project;
3125: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
3126: END IF;
3127:
3128: l_stage := 8800;
3129: -- hr_utility.trace(to_char(l_stage));

Line 3152: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

3148: IF P_PA_DEBUG_MODE = 'Y' THEN
3149: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
3150: END IF;
3151: rollback to org_project;
3152: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
3153: END IF;
3154: l_stage := 8900;
3155: -- hr_utility.trace(to_char(l_stage));
3156: END LOOP;

Line 3471: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

3467: IF P_PA_DEBUG_MODE = 'Y' THEN
3468: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
3469: END IF;
3470: rollback to org_project;
3471: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
3472: END IF;
3473: END IF; /* l_bl_res_asg_id_tab.count <> 0 */
3474:
3475: l_stage := 9900;

Line 3543: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

3539: IF P_PA_DEBUG_MODE = 'Y' THEN
3540: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
3541: END IF;
3542: rollback to org_project;
3543: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
3544: END IF;
3545:
3546: l_stage := 10000;
3547: -- hr_utility.trace(to_char(l_stage));

Line 3947: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

3943: IF P_PA_DEBUG_MODE = 'Y' THEN
3944: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
3945: END IF;
3946: rollback to org_project;
3947: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
3948: END IF;
3949: END IF;
3950: l_stage := 11400;
3951: -- hr_utility.trace(to_char(l_stage));

Line 3966: WHEN pa_fp_org_fcst_gen_pub.error_reloop THEN

3962: END IF;
3963: l_stage := 11600;
3964: -- hr_utility.trace(to_char(l_stage));
3965: EXCEPTION
3966: WHEN pa_fp_org_fcst_gen_pub.error_reloop THEN
3967: -- hr_utility.trace('UserDefined Skipping - '||to_char(l_stage)||'-'||SQLERRM);
3968: pa_debug.g_err_stage := l_stage||': UserDefined Skipping - '||'['||SQLERRM||']';
3969: IF P_PA_DEBUG_MODE = 'Y' THEN
3970: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 4420: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Create_Res_Task_Maps');

4416: BEGIN
4417:
4418: x_msg_count := 0;
4419: x_return_status := FND_API.G_RET_STS_SUCCESS;
4420: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Create_Res_Task_Maps');
4421: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4422: l_debug_mode := NVL(l_debug_mode, 'Y');
4423: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4424:

Line 4922: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_org_fcst_gen_pub'

4918: WHEN Others THEN
4919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4920: x_msg_count := 1;
4921: x_msg_data := SQLERRM;
4922: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_org_fcst_gen_pub'
4923: ,p_procedure_name => 'CREATE_RES_TASK_MAPS');
4924: IF P_PA_DEBUG_MODE = 'Y' THEN
4925: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
4926: pa_debug.write('create_res_task_maps: ' || g_module_name,pa_debug.g_err_stage,5);

Line 4972: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Copy_Resource_Assignments');

4968: BEGIN
4969:
4970: x_msg_count := 0;
4971: x_return_status := FND_API.G_RET_STS_SUCCESS;
4972: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Copy_Resource_Assignments');
4973: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4974: l_debug_mode := NVL(l_debug_mode, 'Y');
4975: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4976:

Line 5621: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'pa_fp_org_fcst_gen_pub'

5617: WHEN Others THEN
5618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5619: x_msg_count := 1;
5620: x_msg_data := SQLERRM;
5621: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'pa_fp_org_fcst_gen_pub'
5622: ,p_procedure_name => 'COPY_RESOURCE_ASSIGNMENTS');
5623:
5624: IF P_PA_DEBUG_MODE = 'Y' THEN
5625: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 5686: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Copy_Budget_Lines');

5682: BEGIN
5683:
5684: x_msg_count := 0;
5685: x_return_status := FND_API.G_RET_STS_SUCCESS;
5686: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Copy_Budget_Lines');
5687: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5688: l_debug_mode := NVL(l_debug_mode, 'Y');
5689: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
5690:

Line 6106: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'pa_fp_org_fcst_gen_pub'

6102: WHEN Others THEN
6103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6104: x_msg_count := 1;
6105: x_msg_data := SQLERRM;
6106: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'pa_fp_org_fcst_gen_pub'
6107: ,p_procedure_name => 'COPY_BUDGET_LINES');
6108:
6109: IF P_PA_DEBUG_MODE = 'Y' THEN
6110: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 6118: END pa_fp_org_fcst_gen_pub;

6114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6115: END Copy_Budget_Lines;
6116:
6117:
6118: END pa_fp_org_fcst_gen_pub;