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.4.12020000.2 2013/03/28 12:22:55 bpottipa 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.4.12020000.2 2013/03/28 12:22:55 bpottipa 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 36: g_module_name VARCHAR2(100):= 'pa.plsql.pa_fp_org_fcst_gen_pub';

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

Line 56: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.budget_version_in_error'

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

Line 72: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;

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

Line 73: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table;

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

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

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

Line 127: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'

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

Line 567: l_fi_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 568: l_fi_proj_organization_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 569: l_fi_proj_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 570: l_fi_exp_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 571: l_fi_exp_orgid_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 572: l_fi_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 573: l_fi_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 574: l_fi_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 576: l_fi_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;

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

Line 577: l_fi_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

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

Line 578: l_fi_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

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

Line 579: l_fi_item_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 580: l_fi_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 581: l_fi_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 582: l_fi_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 583: l_fi_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 584: l_fi_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 585: l_fi_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 586: l_fi_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 587: l_fi_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 588: l_fi_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 589: l_fi_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 592: l_fe_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 593: l_fe_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 594: l_fe_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 595: l_fe_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 596: l_fe_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 597: l_fe_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 598: l_fe_pvdr_rcvr_code_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;

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

Line 599: l_fe_other_organization_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 600: l_fe_other_org_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 601: l_fe_txn_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 602: l_fe_assignment_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 603: l_fe_resource_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 606: l_fl_forecast_line_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 607: l_fl_forecast_element_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 608: l_fl_budget_version_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 609: l_fl_project_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 610: l_fl_task_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 611: l_fl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;

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

Line 612: l_fl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

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

Line 613: l_fl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

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

Line 614: l_fl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 615: l_fl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 616: l_fl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 617: l_fl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 618: l_fl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 619: l_fl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 620: l_fl_tp_rev_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 621: l_fl_tp_rev_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 622: l_fl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 623: l_fl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 624: l_fl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

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

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

Line 629: l_bl_res_asg_id_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 630: l_bl_start_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

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

Line 631: l_bl_end_date_tab pa_fp_org_fcst_gen_pub.date_data_type_table;

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

Line 632: l_bl_period_name_tab pa_fp_org_fcst_gen_pub.char240_data_type_table;

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

Line 633: l_bl_quantity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 634: l_bl_raw_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 635: l_bl_burdened_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 636: l_bl_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 637: l_bl_borrowed_revenue_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 638: l_bl_tp_revenue_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 639: l_bl_tp_revenue_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 640: l_bl_lent_resource_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 641: l_bl_tp_cost_in_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 642: l_bl_tp_cost_out_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 643: l_bl_unassigned_time_cost_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 644: l_bl_utilization_percent_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 645: l_bl_utilization_hours_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 646: l_bl_capacity_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 647: l_bl_head_count_tab pa_fp_org_fcst_gen_pub.number_data_type_table;

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

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

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

Line 917: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 939: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 977: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1000: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1054: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1096: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1126: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1220: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1257: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1282: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1351: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1411: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1477: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1524: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1629: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1689: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1755: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1781: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1826: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 1845: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 2187: RAISE pa_fp_org_fcst_gen_pub.proj_action_reloop;

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

Line 2214: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 2449: WHEN pa_fp_org_fcst_gen_pub.proj_action_reloop THEN

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

Line 2778: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 3009: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 3126: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 3153: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 3472: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 3544: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 3948: RAISE pa_fp_org_fcst_gen_pub.error_reloop;

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

Line 3967: WHEN pa_fp_org_fcst_gen_pub.error_reloop THEN

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

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

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

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

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

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

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

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

5622: WHEN Others THEN
5623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5624: x_msg_count := 1;
5625: x_msg_data := SQLERRM;
5626: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'pa_fp_org_fcst_gen_pub'
5627: ,p_procedure_name => 'COPY_RESOURCE_ASSIGNMENTS');
5628:
5629: IF P_PA_DEBUG_MODE = 'Y' THEN
5630: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

5687: BEGIN
5688:
5689: x_msg_count := 0;
5690: x_return_status := FND_API.G_RET_STS_SUCCESS;
5691: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Copy_Budget_Lines');
5692: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5693: l_debug_mode := NVL(l_debug_mode, 'Y');
5694: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
5695:

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

6107: WHEN Others THEN
6108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6109: x_msg_count := 1;
6110: x_msg_data := SQLERRM;
6111: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'pa_fp_org_fcst_gen_pub'
6112: ,p_procedure_name => 'COPY_BUDGET_LINES');
6113:
6114: IF P_PA_DEBUG_MODE = 'Y' THEN
6115: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 6123: END pa_fp_org_fcst_gen_pub;

6119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6120: END Copy_Budget_Lines;
6121:
6122:
6123: END pa_fp_org_fcst_gen_pub;