[Home] [Help]
24:
25: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP';
26:
27: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
28: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
29: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
30: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
31: l_commit_flag VARCHAR2(1);
32: l_init_msg_flag VARCHAR2(1);
25: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP';
26:
27: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
28: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
29: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
30: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
31: l_commit_flag VARCHAR2(1);
32: l_init_msg_flag VARCHAR2(1);
33: l_ret_status VARCHAR2(100);
26:
27: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
28: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
29: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
30: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
31: l_commit_flag VARCHAR2(1);
32: l_init_msg_flag VARCHAR2(1);
33: l_ret_status VARCHAR2(100);
34: l_msg_count NUMBER;
47: l_source_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
48:
49: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
50:
51: l_res_as_id PA_PLSQL_DATATYPES.IdTabTyp; /* Bug 4160375 */
52: BEGIN
53: --hr_utility.trace_on(null,'mftest');
54: --hr_utility.trace('---BEGIN---');
55:
921: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
922: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
923: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
924: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
925: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
926: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
927: --this pl/sql table is used to update the initial res_asg_id from the generated amounts
928: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
929: --this pl/sql table will have res_asg_id for which manual budget lines are already deleted
922: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
923: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
924: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
925: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
926: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
927: --this pl/sql table is used to update the initial res_asg_id from the generated amounts
928: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
929: --this pl/sql table will have res_asg_id for which manual budget lines are already deleted
930: P_COMMIT_FLAG IN VARCHAR2,
924: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
925: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
926: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
927: --this pl/sql table is used to update the initial res_asg_id from the generated amounts
928: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
929: --this pl/sql table will have res_asg_id for which manual budget lines are already deleted
930: P_COMMIT_FLAG IN VARCHAR2,
931: P_INIT_MSG_FLAG IN VARCHAR2,
932: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1622: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;
1623: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;
1624:
1625: --Declaring PL/SQL tables for bulk binding
1626: l_proj_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
1627: l_proj_start_date PA_PLSQL_DATATYPES.DateTabTyp;
1628: l_proj_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
1629: l_proj_project_role_id PA_PLSQL_DATATYPES.IdTabTyp;
1630: l_proj_fcst_job_id PA_PLSQL_DATATYPES.IdTabTyp;
1623: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;
1624:
1625: --Declaring PL/SQL tables for bulk binding
1626: l_proj_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
1627: l_proj_start_date PA_PLSQL_DATATYPES.DateTabTyp;
1628: l_proj_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
1629: l_proj_project_role_id PA_PLSQL_DATATYPES.IdTabTyp;
1630: l_proj_fcst_job_id PA_PLSQL_DATATYPES.IdTabTyp;
1631: l_proj_fcst_job_group_id PA_PLSQL_DATATYPES.IdTabTyp;
1624:
1625: --Declaring PL/SQL tables for bulk binding
1626: l_proj_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
1627: l_proj_start_date PA_PLSQL_DATATYPES.DateTabTyp;
1628: l_proj_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
1629: l_proj_project_role_id PA_PLSQL_DATATYPES.IdTabTyp;
1630: l_proj_fcst_job_id PA_PLSQL_DATATYPES.IdTabTyp;
1631: l_proj_fcst_job_group_id PA_PLSQL_DATATYPES.IdTabTyp;
1632: l_proj_meaning PA_PLSQL_DATATYPES.Char80TabTyp;
1625: --Declaring PL/SQL tables for bulk binding
1626: l_proj_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
1627: l_proj_start_date PA_PLSQL_DATATYPES.DateTabTyp;
1628: l_proj_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
1629: l_proj_project_role_id PA_PLSQL_DATATYPES.IdTabTyp;
1630: l_proj_fcst_job_id PA_PLSQL_DATATYPES.IdTabTyp;
1631: l_proj_fcst_job_group_id PA_PLSQL_DATATYPES.IdTabTyp;
1632: l_proj_meaning PA_PLSQL_DATATYPES.Char80TabTyp;
1633: l_proj_named_role PA_PLSQL_DATATYPES.Char80TabTyp;
1626: l_proj_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
1627: l_proj_start_date PA_PLSQL_DATATYPES.DateTabTyp;
1628: l_proj_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
1629: l_proj_project_role_id PA_PLSQL_DATATYPES.IdTabTyp;
1630: l_proj_fcst_job_id PA_PLSQL_DATATYPES.IdTabTyp;
1631: l_proj_fcst_job_group_id PA_PLSQL_DATATYPES.IdTabTyp;
1632: l_proj_meaning PA_PLSQL_DATATYPES.Char80TabTyp;
1633: l_proj_named_role PA_PLSQL_DATATYPES.Char80TabTyp;
1634: l_proj_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1627: l_proj_start_date PA_PLSQL_DATATYPES.DateTabTyp;
1628: l_proj_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
1629: l_proj_project_role_id PA_PLSQL_DATATYPES.IdTabTyp;
1630: l_proj_fcst_job_id PA_PLSQL_DATATYPES.IdTabTyp;
1631: l_proj_fcst_job_group_id PA_PLSQL_DATATYPES.IdTabTyp;
1632: l_proj_meaning PA_PLSQL_DATATYPES.Char80TabTyp;
1633: l_proj_named_role PA_PLSQL_DATATYPES.Char80TabTyp;
1634: l_proj_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1635: l_proj_exp_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1628: l_proj_resource_id PA_PLSQL_DATATYPES.IdTabTyp;
1629: l_proj_project_role_id PA_PLSQL_DATATYPES.IdTabTyp;
1630: l_proj_fcst_job_id PA_PLSQL_DATATYPES.IdTabTyp;
1631: l_proj_fcst_job_group_id PA_PLSQL_DATATYPES.IdTabTyp;
1632: l_proj_meaning PA_PLSQL_DATATYPES.Char80TabTyp;
1633: l_proj_named_role PA_PLSQL_DATATYPES.Char80TabTyp;
1634: l_proj_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1635: l_proj_exp_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1636: l_proj_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1629: l_proj_project_role_id PA_PLSQL_DATATYPES.IdTabTyp;
1630: l_proj_fcst_job_id PA_PLSQL_DATATYPES.IdTabTyp;
1631: l_proj_fcst_job_group_id PA_PLSQL_DATATYPES.IdTabTyp;
1632: l_proj_meaning PA_PLSQL_DATATYPES.Char80TabTyp;
1633: l_proj_named_role PA_PLSQL_DATATYPES.Char80TabTyp;
1634: l_proj_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1635: l_proj_exp_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1636: l_proj_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1637: l_proj_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1630: l_proj_fcst_job_id PA_PLSQL_DATATYPES.IdTabTyp;
1631: l_proj_fcst_job_group_id PA_PLSQL_DATATYPES.IdTabTyp;
1632: l_proj_meaning PA_PLSQL_DATATYPES.Char80TabTyp;
1633: l_proj_named_role PA_PLSQL_DATATYPES.Char80TabTyp;
1634: l_proj_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1635: l_proj_exp_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1636: l_proj_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1637: l_proj_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1638: l_fi_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1631: l_proj_fcst_job_group_id PA_PLSQL_DATATYPES.IdTabTyp;
1632: l_proj_meaning PA_PLSQL_DATATYPES.Char80TabTyp;
1633: l_proj_named_role PA_PLSQL_DATATYPES.Char80TabTyp;
1634: l_proj_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1635: l_proj_exp_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1636: l_proj_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1637: l_proj_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1638: l_fi_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1639: l_proj_exp_type PA_PLSQL_DATATYPES.Char30TabTyp;
1632: l_proj_meaning PA_PLSQL_DATATYPES.Char80TabTyp;
1633: l_proj_named_role PA_PLSQL_DATATYPES.Char80TabTyp;
1634: l_proj_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1635: l_proj_exp_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1636: l_proj_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1637: l_proj_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1638: l_fi_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1639: l_proj_exp_type PA_PLSQL_DATATYPES.Char30TabTyp;
1640: l_proj_person_id PA_PLSQL_DATATYPES.IdTabTyp;
1633: l_proj_named_role PA_PLSQL_DATATYPES.Char80TabTyp;
1634: l_proj_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1635: l_proj_exp_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1636: l_proj_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1637: l_proj_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1638: l_fi_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1639: l_proj_exp_type PA_PLSQL_DATATYPES.Char30TabTyp;
1640: l_proj_person_id PA_PLSQL_DATATYPES.IdTabTyp;
1641: l_proj_revenue_bill_rate PA_PLSQL_DATATYPES.NumTabTyp;
1634: l_proj_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1635: l_proj_exp_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1636: l_proj_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1637: l_proj_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1638: l_fi_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1639: l_proj_exp_type PA_PLSQL_DATATYPES.Char30TabTyp;
1640: l_proj_person_id PA_PLSQL_DATATYPES.IdTabTyp;
1641: l_proj_revenue_bill_rate PA_PLSQL_DATATYPES.NumTabTyp;
1642: l_proj_short_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1635: l_proj_exp_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1636: l_proj_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1637: l_proj_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1638: l_fi_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1639: l_proj_exp_type PA_PLSQL_DATATYPES.Char30TabTyp;
1640: l_proj_person_id PA_PLSQL_DATATYPES.IdTabTyp;
1641: l_proj_revenue_bill_rate PA_PLSQL_DATATYPES.NumTabTyp;
1642: l_proj_short_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1643: l_proj_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
1636: l_proj_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1637: l_proj_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1638: l_fi_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1639: l_proj_exp_type PA_PLSQL_DATATYPES.Char30TabTyp;
1640: l_proj_person_id PA_PLSQL_DATATYPES.IdTabTyp;
1641: l_proj_revenue_bill_rate PA_PLSQL_DATATYPES.NumTabTyp;
1642: l_proj_short_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1643: l_proj_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
1644: l_proj_billable_flag PA_PLSQL_DATATYPES.Char2TabTyp;
1637: l_proj_expenditure_org_id PA_PLSQL_DATATYPES.IdTabTyp;
1638: l_fi_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1639: l_proj_exp_type PA_PLSQL_DATATYPES.Char30TabTyp;
1640: l_proj_person_id PA_PLSQL_DATATYPES.IdTabTyp;
1641: l_proj_revenue_bill_rate PA_PLSQL_DATATYPES.NumTabTyp;
1642: l_proj_short_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1643: l_proj_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
1644: l_proj_billable_flag PA_PLSQL_DATATYPES.Char2TabTyp;
1645: l_proj_process_code PA_PLSQL_DATATYPES.Char30TabTyp;
1638: l_fi_exp_organization_id PA_PLSQL_DATATYPES.IdTabTyp;
1639: l_proj_exp_type PA_PLSQL_DATATYPES.Char30TabTyp;
1640: l_proj_person_id PA_PLSQL_DATATYPES.IdTabTyp;
1641: l_proj_revenue_bill_rate PA_PLSQL_DATATYPES.NumTabTyp;
1642: l_proj_short_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1643: l_proj_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
1644: l_proj_billable_flag PA_PLSQL_DATATYPES.Char2TabTyp;
1645: l_proj_process_code PA_PLSQL_DATATYPES.Char30TabTyp;
1646: l_proj_error_msg_code PA_PLSQL_DATATYPES.Char30TabTyp;
1639: l_proj_exp_type PA_PLSQL_DATATYPES.Char30TabTyp;
1640: l_proj_person_id PA_PLSQL_DATATYPES.IdTabTyp;
1641: l_proj_revenue_bill_rate PA_PLSQL_DATATYPES.NumTabTyp;
1642: l_proj_short_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1643: l_proj_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
1644: l_proj_billable_flag PA_PLSQL_DATATYPES.Char2TabTyp;
1645: l_proj_process_code PA_PLSQL_DATATYPES.Char30TabTyp;
1646: l_proj_error_msg_code PA_PLSQL_DATATYPES.Char30TabTyp;
1647: l_proj_end_date PA_PLSQL_DATATYPES.DateTabTyp;
1640: l_proj_person_id PA_PLSQL_DATATYPES.IdTabTyp;
1641: l_proj_revenue_bill_rate PA_PLSQL_DATATYPES.NumTabTyp;
1642: l_proj_short_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1643: l_proj_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
1644: l_proj_billable_flag PA_PLSQL_DATATYPES.Char2TabTyp;
1645: l_proj_process_code PA_PLSQL_DATATYPES.Char30TabTyp;
1646: l_proj_error_msg_code PA_PLSQL_DATATYPES.Char30TabTyp;
1647: l_proj_end_date PA_PLSQL_DATATYPES.DateTabTyp;
1648: l_proj_fc_res_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
1641: l_proj_revenue_bill_rate PA_PLSQL_DATATYPES.NumTabTyp;
1642: l_proj_short_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1643: l_proj_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
1644: l_proj_billable_flag PA_PLSQL_DATATYPES.Char2TabTyp;
1645: l_proj_process_code PA_PLSQL_DATATYPES.Char30TabTyp;
1646: l_proj_error_msg_code PA_PLSQL_DATATYPES.Char30TabTyp;
1647: l_proj_end_date PA_PLSQL_DATATYPES.DateTabTyp;
1648: l_proj_fc_res_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
1649:
1642: l_proj_short_assignment_type PA_PLSQL_DATATYPES.Char30TabTyp;
1643: l_proj_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
1644: l_proj_billable_flag PA_PLSQL_DATATYPES.Char2TabTyp;
1645: l_proj_process_code PA_PLSQL_DATATYPES.Char30TabTyp;
1646: l_proj_error_msg_code PA_PLSQL_DATATYPES.Char30TabTyp;
1647: l_proj_end_date PA_PLSQL_DATATYPES.DateTabTyp;
1648: l_proj_fc_res_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
1649:
1650: l_role_error_code PA_RESOURCE_ASSIGNMENTS.PLAN_ERROR_CODE%TYPE;
1643: l_proj_status_code PA_PLSQL_DATATYPES.Char30TabTyp;
1644: l_proj_billable_flag PA_PLSQL_DATATYPES.Char2TabTyp;
1645: l_proj_process_code PA_PLSQL_DATATYPES.Char30TabTyp;
1646: l_proj_error_msg_code PA_PLSQL_DATATYPES.Char30TabTyp;
1647: l_proj_end_date PA_PLSQL_DATATYPES.DateTabTyp;
1648: l_proj_fc_res_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
1649:
1650: l_role_error_code PA_RESOURCE_ASSIGNMENTS.PLAN_ERROR_CODE%TYPE;
1651:
1644: l_proj_billable_flag PA_PLSQL_DATATYPES.Char2TabTyp;
1645: l_proj_process_code PA_PLSQL_DATATYPES.Char30TabTyp;
1646: l_proj_error_msg_code PA_PLSQL_DATATYPES.Char30TabTyp;
1647: l_proj_end_date PA_PLSQL_DATATYPES.DateTabTyp;
1648: l_proj_fc_res_type_code PA_PLSQL_DATATYPES.Char30TabTyp;
1649:
1650: l_role_error_code PA_RESOURCE_ASSIGNMENTS.PLAN_ERROR_CODE%TYPE;
1651:
1652: l_err_code VARCHAR2(30);
1718: l_asgmt_status_flag VARCHAR2(1);
1719: l_commit_cnt NUMBER:= 0;
1720: l_event_error_msg VARCHAR2(100);
1721:
1722: l_bl_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1723: l_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1724: l_bl_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1725: l_bl_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1726: l_bl_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1719: l_commit_cnt NUMBER:= 0;
1720: l_event_error_msg VARCHAR2(100);
1721:
1722: l_bl_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1723: l_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1724: l_bl_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1725: l_bl_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1726: l_bl_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1727: l_bl_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1720: l_event_error_msg VARCHAR2(100);
1721:
1722: l_bl_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1723: l_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1724: l_bl_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1725: l_bl_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1726: l_bl_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1727: l_bl_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1728: l_bl_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1721:
1722: l_bl_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1723: l_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1724: l_bl_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1725: l_bl_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1726: l_bl_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1727: l_bl_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1728: l_bl_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1729: l_bl_cost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1722: l_bl_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1723: l_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1724: l_bl_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1725: l_bl_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1726: l_bl_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1727: l_bl_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1728: l_bl_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1729: l_bl_cost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1730: l_bl_bcost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1723: l_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1724: l_bl_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1725: l_bl_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1726: l_bl_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1727: l_bl_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1728: l_bl_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1729: l_bl_cost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1730: l_bl_bcost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1731: l_bl_rev_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1724: l_bl_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1725: l_bl_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1726: l_bl_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1727: l_bl_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1728: l_bl_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1729: l_bl_cost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1730: l_bl_bcost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1731: l_bl_rev_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1732: l_bl_oth_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1725: l_bl_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1726: l_bl_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1727: l_bl_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1728: l_bl_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1729: l_bl_cost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1730: l_bl_bcost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1731: l_bl_rev_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1732: l_bl_oth_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1733:
1726: l_bl_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1727: l_bl_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1728: l_bl_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1729: l_bl_cost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1730: l_bl_bcost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1731: l_bl_rev_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1732: l_bl_oth_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1733:
1734: l_rt_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1727: l_bl_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1728: l_bl_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1729: l_bl_cost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1730: l_bl_bcost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1731: l_bl_rev_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1732: l_bl_oth_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1733:
1734: l_rt_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1735: l_rt_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1728: l_bl_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
1729: l_bl_cost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1730: l_bl_bcost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1731: l_bl_rev_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1732: l_bl_oth_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1733:
1734: l_rt_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1735: l_rt_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1736: l_rt_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1730: l_bl_bcost_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1731: l_bl_rev_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1732: l_bl_oth_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1733:
1734: l_rt_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1735: l_rt_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1736: l_rt_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1737: l_rt_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1738:
1731: l_bl_rev_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1732: l_bl_oth_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1733:
1734: l_rt_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1735: l_rt_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1736: l_rt_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1737: l_rt_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1738:
1739: l_rt_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1732: l_bl_oth_rej_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1733:
1734: l_rt_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1735: l_rt_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1736: l_rt_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1737: l_rt_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1738:
1739: l_rt_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1740: l_rt_exp_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1733:
1734: l_rt_forecast_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1735: l_rt_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1736: l_rt_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1737: l_rt_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1738:
1739: l_rt_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1740: l_rt_exp_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1741: l_rt_exp_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1735: l_rt_pd_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1736: l_rt_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1737: l_rt_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1738:
1739: l_rt_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1740: l_rt_exp_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1741: l_rt_exp_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1742:
1743: -- M-closeout: Bill Rate Override ER ------------------------------------------
1736: l_rt_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1737: l_rt_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1738:
1739: l_rt_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1740: l_rt_exp_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1741: l_rt_exp_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1742:
1743: -- M-closeout: Bill Rate Override ER ------------------------------------------
1744: l_rt_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1737: l_rt_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1738:
1739: l_rt_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
1740: l_rt_exp_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1741: l_rt_exp_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1742:
1743: -- M-closeout: Bill Rate Override ER ------------------------------------------
1744: l_rt_res_assignment_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1745: l_rt_uom_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1782: l_rej_txn_currency_code_tab SYSTEM.pa_varchar2_80_tbl_type:=SYSTEM.pa_varchar2_80_tbl_type();
1783: l_rej_revenue_rej_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1784: -- END OF M-closeout: Bill Rate Override ER ------------------------------------------
1785:
1786: l_rt_exp_func_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1787: l_rt_exp_func_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1788: l_rt_exp_func_bur_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1789: l_rt_exp_func_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1790: l_rt_projfunc_bill_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1783: l_rej_revenue_rej_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1784: -- END OF M-closeout: Bill Rate Override ER ------------------------------------------
1785:
1786: l_rt_exp_func_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1787: l_rt_exp_func_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1788: l_rt_exp_func_bur_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1789: l_rt_exp_func_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1790: l_rt_projfunc_bill_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1791: l_rt_projfunc_raw_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1784: -- END OF M-closeout: Bill Rate Override ER ------------------------------------------
1785:
1786: l_rt_exp_func_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1787: l_rt_exp_func_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1788: l_rt_exp_func_bur_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1789: l_rt_exp_func_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1790: l_rt_projfunc_bill_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1791: l_rt_projfunc_raw_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1792: l_rt_projfunc_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1785:
1786: l_rt_exp_func_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1787: l_rt_exp_func_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1788: l_rt_exp_func_bur_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1789: l_rt_exp_func_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1790: l_rt_projfunc_bill_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1791: l_rt_projfunc_raw_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1792: l_rt_projfunc_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1793: l_rt_projfunc_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1786: l_rt_exp_func_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1787: l_rt_exp_func_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1788: l_rt_exp_func_bur_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1789: l_rt_exp_func_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1790: l_rt_projfunc_bill_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1791: l_rt_projfunc_raw_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1792: l_rt_projfunc_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1793: l_rt_projfunc_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1794: l_rt_projfunc_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1787: l_rt_exp_func_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1788: l_rt_exp_func_bur_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1789: l_rt_exp_func_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1790: l_rt_projfunc_bill_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1791: l_rt_projfunc_raw_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1792: l_rt_projfunc_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1793: l_rt_projfunc_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1794: l_rt_projfunc_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1795: l_rt_projfunc_bd_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1788: l_rt_exp_func_bur_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1789: l_rt_exp_func_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1790: l_rt_projfunc_bill_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1791: l_rt_projfunc_raw_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1792: l_rt_projfunc_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1793: l_rt_projfunc_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1794: l_rt_projfunc_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1795: l_rt_projfunc_bd_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1796: l_rt_rev_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1789: l_rt_exp_func_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1790: l_rt_projfunc_bill_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1791: l_rt_projfunc_raw_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1792: l_rt_projfunc_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1793: l_rt_projfunc_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1794: l_rt_projfunc_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1795: l_rt_projfunc_bd_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1796: l_rt_rev_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1797: l_rt_cst_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1790: l_rt_projfunc_bill_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1791: l_rt_projfunc_raw_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1792: l_rt_projfunc_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1793: l_rt_projfunc_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1794: l_rt_projfunc_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1795: l_rt_projfunc_bd_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1796: l_rt_rev_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1797: l_rt_cst_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1798: l_rt_burdned_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1791: l_rt_projfunc_raw_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
1792: l_rt_projfunc_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1793: l_rt_projfunc_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1794: l_rt_projfunc_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1795: l_rt_projfunc_bd_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1796: l_rt_rev_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1797: l_rt_cst_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1798: l_rt_burdned_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1799: l_rt_others_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1792: l_rt_projfunc_raw_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1793: l_rt_projfunc_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1794: l_rt_projfunc_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1795: l_rt_projfunc_bd_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1796: l_rt_rev_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1797: l_rt_cst_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1798: l_rt_burdned_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1799: l_rt_others_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1800: l_bulk_fetch_count NUMBER:= 0;
1793: l_rt_projfunc_raw_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1794: l_rt_projfunc_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1795: l_rt_projfunc_bd_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1796: l_rt_rev_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1797: l_rt_cst_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1798: l_rt_burdned_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1799: l_rt_others_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1800: l_bulk_fetch_count NUMBER:= 0;
1801: l_markup_percentage NUMBER;
1794: l_rt_projfunc_burdned_cst_tab PA_PLSQL_DATATYPES.NumTabTyp;
1795: l_rt_projfunc_bd_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1796: l_rt_rev_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1797: l_rt_cst_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1798: l_rt_burdned_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1799: l_rt_others_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1800: l_bulk_fetch_count NUMBER:= 0;
1801: l_markup_percentage NUMBER;
1802: l_cost_based_error_code VARCHAR2(100);
1795: l_rt_projfunc_bd_cst_rt_tab PA_PLSQL_DATATYPES.NumTabTyp;
1796: l_rt_rev_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1797: l_rt_cst_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1798: l_rt_burdned_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1799: l_rt_others_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1800: l_bulk_fetch_count NUMBER:= 0;
1801: l_markup_percentage NUMBER;
1802: l_cost_based_error_code VARCHAR2(100);
1803:
1800: l_bulk_fetch_count NUMBER:= 0;
1801: l_markup_percentage NUMBER;
1802: l_cost_based_error_code VARCHAR2(100);
1803:
1804: l_prj_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1805: l_avg_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1806:
1807: l_rowcount number :=0;
1808:
1801: l_markup_percentage NUMBER;
1802: l_cost_based_error_code VARCHAR2(100);
1803:
1804: l_prj_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1805: l_avg_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1806:
1807: l_rowcount number :=0;
1808:
1809: l_amount_set_id PA_PROJ_FP_OPTIONS.COST_AMOUNT_SET_ID%TYPE;
1843: l_burden_rate_flag PA_FIN_PLAN_AMOUNT_SETS.BURDEN_RATE_FLAG%TYPE;
1844:
1845: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1846:
1847: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1848: l_res_assgn_id_tmp_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1849: l_total_plan_quantity number;
1850: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1851:
1846:
1847: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1848: l_res_assgn_id_tmp_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1849: l_total_plan_quantity number;
1850: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1851:
1852: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1853: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1854: l_sysdate DATE := SYSDATE;
1852: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1853: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1854: l_sysdate DATE := SYSDATE;
1855: l_sysdate_trunc DATE;
1856: l_proj_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1857: l_proj_exp_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1858: l_proj_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1859: -- M-Closeout ER: Bill Rate Override ER
1860: l_proj_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1853: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1854: l_sysdate DATE := SYSDATE;
1855: l_sysdate_trunc DATE;
1856: l_proj_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1857: l_proj_exp_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1858: l_proj_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1859: -- M-Closeout ER: Bill Rate Override ER
1860: l_proj_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1861: l_proj_bill_rate_cur_ovrd_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1854: l_sysdate DATE := SYSDATE;
1855: l_sysdate_trunc DATE;
1856: l_proj_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1857: l_proj_exp_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1858: l_proj_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1859: -- M-Closeout ER: Bill Rate Override ER
1860: l_proj_bill_rate_override_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
1861: l_proj_bill_rate_cur_ovrd_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1862: l_calculate_mode VARCHAR2(30);
1942:
1943: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1944: l_count NUMBER;
1945: l_count1 NUMBER;
1946: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1947: l_chk_duplicate_flag VARCHAR2(1) := 'N';
1948: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1949:
1950: l_resource_class_id PA_RESOURCE_CLASSES_B.RESOURCE_CLASS_ID%TYPE;
1944: l_count NUMBER;
1945: l_count1 NUMBER;
1946: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1947: l_chk_duplicate_flag VARCHAR2(1) := 'N';
1948: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1949:
1950: l_resource_class_id PA_RESOURCE_CLASSES_B.RESOURCE_CLASS_ID%TYPE;
1951: l_dp_counter NUMBER;
1952: l_dp_flag VARCHAR2(1);
1951: l_dp_counter NUMBER;
1952: l_dp_flag VARCHAR2(1);
1953:
1954: tmp_flag varchar2(1);
1955: tmp_rlm_tab pa_plsql_datatypes.IdTabTyp;
1956: tmp_task_tab pa_plsql_datatypes.IdTabTyp;
1957: tmp_ra_tab pa_plsql_datatypes.IdTabTyp;
1958:
1959: --Local pl/sql table to call Map_Rlmi_Rbs api
1952: l_dp_flag VARCHAR2(1);
1953:
1954: tmp_flag varchar2(1);
1955: tmp_rlm_tab pa_plsql_datatypes.IdTabTyp;
1956: tmp_task_tab pa_plsql_datatypes.IdTabTyp;
1957: tmp_ra_tab pa_plsql_datatypes.IdTabTyp;
1958:
1959: --Local pl/sql table to call Map_Rlmi_Rbs api
1960: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1953:
1954: tmp_flag varchar2(1);
1955: tmp_rlm_tab pa_plsql_datatypes.IdTabTyp;
1956: tmp_task_tab pa_plsql_datatypes.IdTabTyp;
1957: tmp_ra_tab pa_plsql_datatypes.IdTabTyp;
1958:
1959: --Local pl/sql table to call Map_Rlmi_Rbs api
1960: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1961: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1956: tmp_task_tab pa_plsql_datatypes.IdTabTyp;
1957: tmp_ra_tab pa_plsql_datatypes.IdTabTyp;
1958:
1959: --Local pl/sql table to call Map_Rlmi_Rbs api
1960: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1961: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1962: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1963: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1964: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1957: tmp_ra_tab pa_plsql_datatypes.IdTabTyp;
1958:
1959: --Local pl/sql table to call Map_Rlmi_Rbs api
1960: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1961: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1962: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1963: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1964: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1965: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1958:
1959: --Local pl/sql table to call Map_Rlmi_Rbs api
1960: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1961: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1962: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1963: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1964: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1965: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1966: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1959: --Local pl/sql table to call Map_Rlmi_Rbs api
1960: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1961: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1962: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1963: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1964: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1965: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1966: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1967: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1960: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1961: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1962: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1963: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1964: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1965: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1966: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1967: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1968: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
1961: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1962: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1963: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1964: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1965: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1966: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1967: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1968: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
1969: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1962: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1963: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1964: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1965: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1966: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1967: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1968: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
1969: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1970: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1963: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1964: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1965: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1966: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1967: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1968: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
1969: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1970: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1971: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1964: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1965: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1966: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1967: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1968: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
1969: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1970: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1971: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1972: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1965: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1966: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1967: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1968: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
1969: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1970: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1971: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1972: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1973: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1966: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1967: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1968: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
1969: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1970: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1971: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1972: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1973: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1974: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1967: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1968: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
1969: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1970: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1971: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1972: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1973: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1974: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1975: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1968: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
1969: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1970: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1971: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1972: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1973: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1974: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1975: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1976: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1969: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1970: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1971: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1972: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1973: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1974: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1975: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1976: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1977: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1970: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1971: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1972: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1973: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1974: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1975: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1976: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1977: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1978: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1971: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1972: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1973: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1974: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1975: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1976: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1977: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1978: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1979: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1972: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1973: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1974: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1975: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1976: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1977: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1978: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1979: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1980: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1973: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1974: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1975: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1976: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1977: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1978: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1979: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1980: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1981: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1974: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1975: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1976: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1977: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1978: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1979: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1980: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1981: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1982: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1975: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1976: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1977: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1978: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1979: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1980: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1981: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1982: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1983: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
1976: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1977: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1978: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1979: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1980: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1981: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1982: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1983: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
1984: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1977: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1978: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1979: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1980: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1981: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1982: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1983: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
1984: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1985: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1978: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1979: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1980: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1981: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1982: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1983: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
1984: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1985: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1986: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1979: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1980: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1981: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1982: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1983: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
1984: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1985: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1986: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1987: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1980: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1981: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1982: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1983: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
1984: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1985: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1986: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1987: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1988: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1981: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1982: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1983: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
1984: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1985: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1986: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1987: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1988: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1989: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1982: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1983: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
1984: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1985: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1986: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1987: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1988: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1989: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1990: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1983: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
1984: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1985: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1986: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1987: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1988: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1989: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1990: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1991: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
1984: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1985: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1986: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1987: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1988: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1989: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1990: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1991: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
1992: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1985: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1986: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1987: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1988: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1989: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1990: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1991: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
1992: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1993: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1986: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1987: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1988: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1989: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1990: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1991: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
1992: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1993: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1994: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1988: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
1989: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1990: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1991: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
1992: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1993: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1994: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1995: l_map_txn_accum_header_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1996:
1989: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1990: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1991: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
1992: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1993: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1994: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1995: l_map_txn_accum_header_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1996:
1997: --Local PL/SQL table used for calling Calculate API
1990: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1991: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
1992: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1993: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1994: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1995: l_map_txn_accum_header_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1996:
1997: --Local PL/SQL table used for calling Calculate API
1998: l_t_refresh_rates_flag VARCHAR2(1) := 'Y';
1991: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
1992: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1993: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1994: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1995: l_map_txn_accum_header_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1996:
1997: --Local PL/SQL table used for calling Calculate API
1998: l_t_refresh_rates_flag VARCHAR2(1) := 'Y';
1999: l_t_refresh_conv_rates_flag VARCHAR2(1) := 'N';
2045: -- cost-based revenue amounts, since an Index exists for the column.
2046: l_bl_id_counter NUMBER;
2047:
2048: -- Bug 4549862: Added pl/sql tables for budget line update.
2049: l_upd_bl_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2050: l_upd_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2051: l_upd_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2052: l_upd_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2053: l_upd_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2046: l_bl_id_counter NUMBER;
2047:
2048: -- Bug 4549862: Added pl/sql tables for budget line update.
2049: l_upd_bl_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2050: l_upd_bl_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2051: l_upd_bl_RES_ASSIGNMENT_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2052: l_upd_bl_PERIOD_NAME_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2053: l_upd_bl_QUANTITY_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2054: l_upd_bl_TXN_CURRENCY_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2061: l_upd_bl_REV_REJ_CODE_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2062: l_upd_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2063:
2064: -- Bug 4549862: PL/SQL tables for rejection code processing
2065: l_rej_code_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2066: l_rej_code_txn_currency_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2067: l_rej_code_msg_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2068:
2069: BEGIN
2062: l_upd_bl_COST_IND_C_SET_ID_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
2063:
2064: -- Bug 4549862: PL/SQL tables for rejection code processing
2065: l_rej_code_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2066: l_rej_code_txn_currency_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2067: l_rej_code_msg_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2068:
2069: BEGIN
2070: /* Setting the initial values */
2063:
2064: -- Bug 4549862: PL/SQL tables for rejection code processing
2065: l_rej_code_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2066: l_rej_code_txn_currency_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2067: l_rej_code_msg_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2068:
2069: BEGIN
2070: /* Setting the initial values */
2071: IF p_init_msg_flag = 'Y' THEN
4741: FROM PA_RESOURCE_ASSIGNMENTS T
4742: WHERE T.RESOURCE_ASSIGNMENT_ID = c_res_asgn_id;
4743:
4744: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
4745: l_unique_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
4746: l_res_list_member_id PA_PLSQL_DATATYPES.IdTabTyp;
4747: l_task_id PA_PLSQL_DATATYPES.IdTabTyp;
4748: l_res_asgn_id PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605
4749: l_mapped_fin_task_version_id PA_PLSQL_DATATYPES.IdTabTyp;
4742: WHERE T.RESOURCE_ASSIGNMENT_ID = c_res_asgn_id;
4743:
4744: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
4745: l_unique_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
4746: l_res_list_member_id PA_PLSQL_DATATYPES.IdTabTyp;
4747: l_task_id PA_PLSQL_DATATYPES.IdTabTyp;
4748: l_res_asgn_id PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605
4749: l_mapped_fin_task_version_id PA_PLSQL_DATATYPES.IdTabTyp;
4750: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4743:
4744: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
4745: l_unique_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
4746: l_res_list_member_id PA_PLSQL_DATATYPES.IdTabTyp;
4747: l_task_id PA_PLSQL_DATATYPES.IdTabTyp;
4748: l_res_asgn_id PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605
4749: l_mapped_fin_task_version_id PA_PLSQL_DATATYPES.IdTabTyp;
4750: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4751: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4744: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
4745: l_unique_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
4746: l_res_list_member_id PA_PLSQL_DATATYPES.IdTabTyp;
4747: l_task_id PA_PLSQL_DATATYPES.IdTabTyp;
4748: l_res_asgn_id PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605
4749: l_mapped_fin_task_version_id PA_PLSQL_DATATYPES.IdTabTyp;
4750: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4751: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4752: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
4745: l_unique_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
4746: l_res_list_member_id PA_PLSQL_DATATYPES.IdTabTyp;
4747: l_task_id PA_PLSQL_DATATYPES.IdTabTyp;
4748: l_res_asgn_id PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605
4749: l_mapped_fin_task_version_id PA_PLSQL_DATATYPES.IdTabTyp;
4750: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4751: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4752: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
4753: l_last_update_login NUMBER := FND_GLOBAL.login_id;
4746: l_res_list_member_id PA_PLSQL_DATATYPES.IdTabTyp;
4747: l_task_id PA_PLSQL_DATATYPES.IdTabTyp;
4748: l_res_asgn_id PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605
4749: l_mapped_fin_task_version_id PA_PLSQL_DATATYPES.IdTabTyp;
4750: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4751: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4752: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
4753: l_last_update_login NUMBER := FND_GLOBAL.login_id;
4754: l_sysdate DATE := SYSDATE;
4747: l_task_id PA_PLSQL_DATATYPES.IdTabTyp;
4748: l_res_asgn_id PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605
4749: l_mapped_fin_task_version_id PA_PLSQL_DATATYPES.IdTabTyp;
4750: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4751: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
4752: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
4753: l_last_update_login NUMBER := FND_GLOBAL.login_id;
4754: l_sysdate DATE := SYSDATE;
4755: l_ret_status VARCHAR2(100);
4810: l_ins_ra_id_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
4811: l_Cbs_Element_Id_tab SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE(); -- bug#16200605
4812: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- bug#16200605
4813: l_cbs_element_id NUMBER; -- bug#16200605
4814: l_cbs_ele_ids PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605
4815: BEGIN
4816: X_MSG_COUNT := 0;
4817: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4818:
5810: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG';
5811:
5812: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
5813:
5814: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5815: l_res_assgn_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
5816: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5817: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16827157
5818: l_txn_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5811:
5812: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
5813:
5814: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5815: l_res_assgn_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
5816: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5817: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16827157
5818: l_txn_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5819: l_txn_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5812: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
5813:
5814: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5815: l_res_assgn_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
5816: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5817: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16827157
5818: l_txn_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5819: l_txn_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5820: l_txn_sub_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5813:
5814: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5815: l_res_assgn_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
5816: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5817: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16827157
5818: l_txn_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5819: l_txn_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5820: l_txn_sub_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5821: l_mapped_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5814: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5815: l_res_assgn_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
5816: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5817: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16827157
5818: l_txn_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5819: l_txn_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5820: l_txn_sub_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5821: l_mapped_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5822:
5815: l_res_assgn_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
5816: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5817: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16827157
5818: l_txn_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5819: l_txn_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5820: l_txn_sub_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5821: l_mapped_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5822:
5823: l_count number;
5816: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5817: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16827157
5818: l_txn_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5819: l_txn_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5820: l_txn_sub_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5821: l_mapped_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5822:
5823: l_count number;
5824: l_project_id NUMBER(15);
5817: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16827157
5818: l_txn_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5819: l_txn_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5820: l_txn_sub_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5821: l_mapped_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5822:
5823: l_count number;
5824: l_project_id NUMBER(15);
5825:
5823: l_count number;
5824: l_project_id NUMBER(15);
5825:
5826: tmp_count number;
5827: tmp_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp; -- PA_PLSQL_DATATYPES.Char30TabTyp;
5828: tmp_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5829: tmp_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5830:
5831: l_txn_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5824: l_project_id NUMBER(15);
5825:
5826: tmp_count number;
5827: tmp_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp; -- PA_PLSQL_DATATYPES.Char30TabTyp;
5828: tmp_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5829: tmp_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5830:
5831: l_txn_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5832: l_txn_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
5825:
5826: tmp_count number;
5827: tmp_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp; -- PA_PLSQL_DATATYPES.Char30TabTyp;
5828: tmp_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5829: tmp_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5830:
5831: l_txn_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5832: l_txn_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
5833: l_txn_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
5827: tmp_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp; -- PA_PLSQL_DATATYPES.Char30TabTyp;
5828: tmp_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5829: tmp_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5830:
5831: l_txn_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5832: l_txn_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
5833: l_txn_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
5834:
5835: l_txn_resource_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5828: tmp_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5829: tmp_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5830:
5831: l_txn_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5832: l_txn_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
5833: l_txn_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
5834:
5835: l_txn_resource_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5836:
5829: tmp_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5830:
5831: l_txn_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5832: l_txn_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
5833: l_txn_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
5834:
5835: l_txn_resource_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5836:
5837: /* Variables for Manually Added Plan Lines logic */
5831: l_txn_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5832: l_txn_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
5833: l_txn_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
5834:
5835: l_txn_resource_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5836:
5837: /* Variables for Manually Added Plan Lines logic */
5838: l_etc_start_date DATE;
5839: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
6240: */
6241: PROCEDURE DEL_MANUAL_BDGT_LINES
6242: ( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6243: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6244: PX_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6245: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6246: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6247: X_MSG_COUNT OUT NOCOPY NUMBER,
6248: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6241: PROCEDURE DEL_MANUAL_BDGT_LINES
6242: ( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6243: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6244: PX_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6245: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6246: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6247: X_MSG_COUNT OUT NOCOPY NUMBER,
6248: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6249: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.DEL_MANUAL_BDGT_LINES';
6247: X_MSG_COUNT OUT NOCOPY NUMBER,
6248: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6249: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.DEL_MANUAL_BDGT_LINES';
6250:
6251: l_del_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6252: l_exist_flag VARCHAR2(1) := 'N';
6253: l_count NUMBER;
6254:
6255: BEGIN
6340:
6341: PROCEDURE UPDATE_INIT_AMOUNTS
6342: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6343: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6344: P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
6345: --this pl/sql table will have newly created res_asg_id from the source
6346: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6347: X_MSG_COUNT OUT NOCOPY NUMBER,
6348: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6457:
6458: PROCEDURE GET_GENERATED_RES_ASG
6459: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6460: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6461: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6462: P_CHK_DUPLICATE_FLAG IN VARCHAR2,
6463: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6464: X_MSG_COUNT OUT NOCOPY NUMBER,
6465: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6464: X_MSG_COUNT OUT NOCOPY NUMBER,
6465: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6466: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GET_GENERATED_RES_ASG';
6467:
6468: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6469: l_cmt_res_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6470: l_exist_flag VARCHAR2(1);
6471:
6472: BEGIN
6465: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6466: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GET_GENERATED_RES_ASG';
6467:
6468: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6469: l_cmt_res_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6470: l_exist_flag VARCHAR2(1);
6471:
6472: BEGIN
6473: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6555: X_MSG_COUNT OUT NOCOPY NUMBER,
6556: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6557: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.INSERT_TXN_CURRENCY';
6558:
6559: l_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
6560: l_budget_version_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6561: l_proj_fp_options_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6562:
6563: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
6556: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6557: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.INSERT_TXN_CURRENCY';
6558:
6559: l_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
6560: l_budget_version_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6561: l_proj_fp_options_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6562:
6563: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
6564: l_pc pa_budget_lines.txn_currency_code%type;
6557: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.INSERT_TXN_CURRENCY';
6558:
6559: l_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
6560: l_budget_version_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6561: l_proj_fp_options_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6562:
6563: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
6564: l_pc pa_budget_lines.txn_currency_code%type;
6565: l_pfc pa_budget_lines.txn_currency_code%type;
6817: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
6818: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
6819: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
6820: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
6821: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
6822: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6823: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6824: P_COMMIT_FLAG IN VARCHAR2,
6825: P_INIT_MSG_FLAG IN VARCHAR2,
6818: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
6819: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
6820: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
6821: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
6822: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6823: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6824: P_COMMIT_FLAG IN VARCHAR2,
6825: P_INIT_MSG_FLAG IN VARCHAR2,
6826: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6819: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
6820: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
6821: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
6822: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6823: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6824: P_COMMIT_FLAG IN VARCHAR2,
6825: P_INIT_MSG_FLAG IN VARCHAR2,
6826: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6827: X_MSG_COUNT OUT NOCOPY NUMBER,
6831:
6832: /*local variable for calling get planning rates*/
6833: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6834: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6835: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6836: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6837: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6838: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6839: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
6832: /*local variable for calling get planning rates*/
6833: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6834: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6835: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6836: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6837: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6838: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6839: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
6840: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
6834: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
6835: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6836: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6837: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6838: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6839: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
6840: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
6841: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
6842: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
6835: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6836: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6837: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6838: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6839: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
6840: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
6841: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
6842: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
6843: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6836: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6837: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6838: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6839: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
6840: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
6841: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
6842: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
6843: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6844: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6837: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
6838: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6839: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
6840: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
6841: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
6842: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
6843: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6844: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6845: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6838: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6839: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
6840: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
6841: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
6842: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
6843: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6844: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6845: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6846: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
6839: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
6840: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
6841: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
6842: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
6843: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6844: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6845: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6846: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
6847: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6840: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
6841: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
6842: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
6843: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6844: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6845: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6846: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
6847: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6848: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6841: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
6842: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
6843: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6844: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6845: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6846: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
6847: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6848: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6849: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6842: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
6843: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6844: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6845: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6846: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
6847: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6848: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6849: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6850: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6843: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6844: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6845: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6846: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
6847: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6848: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6849: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6850: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6851: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6844: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6845: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6846: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
6847: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6848: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6849: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6850: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6851: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6852: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6845: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6846: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
6847: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6848: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6849: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6850: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6851: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6852: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6853: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6846: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
6847: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6848: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6849: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6850: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6851: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6852: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6853: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6854: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6847: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6848: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6849: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6850: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6851: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6852: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6853: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6854: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6855: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6848: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6849: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6850: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6851: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6852: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6853: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6854: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6855: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6856: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6849: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6850: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6851: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6852: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6853: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6854: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6855: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6856: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6857:
6850: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6851: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6852: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6853: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6854: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6855: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6856: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6857:
6858: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
6851: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6852: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6853: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6854: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6855: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6856: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6857:
6858: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
6859: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6852: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6853: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6854: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6855: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6856: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6857:
6858: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
6859: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6860: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6854: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
6855: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6856: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6857:
6858: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
6859: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6860: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6861: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
6862: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6855: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6856: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6857:
6858: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
6859: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6860: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6861: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
6862: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6863: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6856: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6857:
6858: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
6859: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6860: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6861: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
6862: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6863: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6864: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6857:
6858: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
6859: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6860: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6861: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
6862: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6863: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6864: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6865: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6858: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
6859: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6860: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6861: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
6862: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6863: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6864: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6865: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6866: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
6859: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6860: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6861: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
6862: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6863: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6864: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6865: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6866: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
6867: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6860: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6861: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
6862: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6863: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6864: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6865: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6866: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
6867: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6868:
6861: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
6862: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6863: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6864: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6865: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6866: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
6867: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6868:
6869: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
6862: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6863: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6864: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6865: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6866: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
6867: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6868:
6869: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
6870: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6863: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6864: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6865: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6866: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
6867: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6868:
6869: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
6870: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6871: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6865: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6866: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
6867: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6868:
6869: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
6870: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6871: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6872: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6873: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6866: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
6867: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6868:
6869: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
6870: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6871: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6872: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6873: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6874: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6867: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6868:
6869: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
6870: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6871: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6872: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6873: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6874: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6875:
6868:
6869: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
6870: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6871: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6872: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6873: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6874: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6875:
6876: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6869: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
6870: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6871: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6872: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6873: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6874: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6875:
6876: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6877: l_cost_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6870: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6871: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
6872: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6873: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6874: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6875:
6876: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6877: l_cost_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6878:
6872: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
6873: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6874: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6875:
6876: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6877: l_cost_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6878:
6879: l_res_format_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6880:
6873: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6874: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
6875:
6876: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6877: l_cost_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6878:
6879: l_res_format_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6880:
6881: l_bill_rate number;
6875:
6876: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6877: l_cost_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6878:
6879: l_res_format_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6880:
6881: l_bill_rate number;
6882: l_cost_rate number;
6883: l_burden_cost_rate number;
7364: P_CALLED_MODE IN VARCHAR2,
7365: P_INC_CHG_DOC_FLAG IN VARCHAR2,
7366: P_INC_BILL_EVENT_FLAG IN VARCHAR2,
7367: P_INC_OPEN_COMMIT_FLAG IN VARCHAR2,
7368: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
7369: P_INIT_MSG_FLAG IN VARCHAR2,
7370: P_COMMIT_FLAG IN VARCHAR2,
7371: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
7372: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
7367: P_INC_OPEN_COMMIT_FLAG IN VARCHAR2,
7368: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
7369: P_INIT_MSG_FLAG IN VARCHAR2,
7370: P_COMMIT_FLAG IN VARCHAR2,
7371: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
7372: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
7373: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7374: X_MSG_COUNT OUT NOCOPY NUMBER,
7375: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
7368: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
7369: P_INIT_MSG_FLAG IN VARCHAR2,
7370: P_COMMIT_FLAG IN VARCHAR2,
7371: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
7372: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
7373: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7374: X_MSG_COUNT OUT NOCOPY NUMBER,
7375: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
7376: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GEN_WP_REV_BDGT_AMT_WRP';
7377:
7378: /*local variable for calling get planning rates*/
7379: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7380: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7381: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7382: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7383: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
7384: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7385: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
7378: /*local variable for calling get planning rates*/
7379: l_res_asg_id_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7380: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7381: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7382: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7383: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
7384: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7385: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
7386: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
7380: l_ra_quantity_tab SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
7381: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7382: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7383: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
7384: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7385: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
7386: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
7387: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
7388: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
7381: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7382: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7383: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
7384: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7385: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
7386: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
7387: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
7388: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
7389: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7382: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7383: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
7384: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7385: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
7386: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
7387: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
7388: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
7389: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7390: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7383: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
7384: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7385: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
7386: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
7387: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
7388: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
7389: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7390: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7391: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7384: l_ra_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7385: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
7386: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
7387: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
7388: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
7389: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7390: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7391: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7392: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
7385: l_uom_tab pa_plsql_datatypes.Char30TabTyp;
7386: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
7387: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
7388: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
7389: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7390: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7391: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7392: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
7393: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7386: l_rate_based_flag_tab pa_plsql_datatypes.Char30TabTyp;
7387: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
7388: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
7389: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7390: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7391: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7392: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
7393: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7394: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7387: l_resource_class_code_tab pa_plsql_datatypes.Char30TabTyp;
7388: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
7389: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7390: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7391: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7392: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
7393: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7394: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7395: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7388: l_organization_id_tab pa_plsql_datatypes.Char30TabTyp;
7389: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7390: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7391: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7392: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
7393: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7394: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7395: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7396: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7389: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7390: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7391: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7392: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
7393: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7394: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7395: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7396: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7397: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7390: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7391: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7392: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
7393: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7394: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7395: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7396: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7397: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7398: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7391: l_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7392: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
7393: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7394: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7395: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7396: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7397: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7398: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7399: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7392: l_non_labor_resource_tab pa_plsql_datatypes.Char30TabTyp;
7393: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7394: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7395: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7396: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7397: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7398: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7399: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7400: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7393: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7394: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7395: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7396: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7397: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7398: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7399: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7400: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7401: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7394: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7395: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7396: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7397: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7398: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7399: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7400: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7401: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7402: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7395: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7396: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7397: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7398: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7399: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7400: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7401: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7402: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7403:
7396: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7397: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7398: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7399: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7400: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7401: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7402: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7403:
7404: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
7397: l_rate_incur_by_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7398: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7399: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7400: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7401: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7402: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7403:
7404: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
7405: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7398: l_rate_ovrd_to_organz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7399: l_rate_expenditure_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7400: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7401: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7402: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7403:
7404: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
7405: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7406: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7400: l_rate_expenditure_type_tab pa_plsql_datatypes.Char30TabTyp;
7401: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7402: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7403:
7404: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
7405: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7406: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7407: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
7408: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7401: l_rate_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7402: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7403:
7404: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
7405: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7406: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7407: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
7408: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7409: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7402: l_project_assignment_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7403:
7404: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
7405: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7406: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7407: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
7408: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7409: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7410: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7403:
7404: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
7405: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7406: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7407: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
7408: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7409: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7410: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7411: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7404: l_assign_precedes_task_tab pa_plsql_datatypes.Char30TabTyp;
7405: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7406: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7407: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
7408: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7409: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7410: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7411: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7412: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
7405: l_bill_job_group_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7406: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7407: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
7408: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7409: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7410: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7411: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7412: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
7413: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7406: l_carry_out_organiz_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7407: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
7408: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7409: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7410: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7411: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7412: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
7413: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7414:
7407: l_multi_currency_bill_flag_tab pa_plsql_datatypes.Char30TabTyp;
7408: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7409: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7410: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7411: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7412: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
7413: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7414:
7415: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
7408: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7409: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7410: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7411: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7412: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
7413: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7414:
7415: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
7416: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7409: l_non_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7410: l_non_lab_sch_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7411: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7412: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
7413: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7414:
7415: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
7416: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7417: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7411: l_non_lab_sch_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7412: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
7413: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7414:
7415: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
7416: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7417: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7418: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7419: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7412: l_project_type_tab pa_plsql_datatypes.Char30TabTyp;
7413: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7414:
7415: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
7416: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7417: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7418: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7419: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7420: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7413: l_lab_bill_rate_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7414:
7415: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
7416: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7417: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7418: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7419: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7420: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7421:
7414:
7415: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
7416: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7417: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7418: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7419: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7420: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7421:
7422: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7415: l_lab_sch_FIXED_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
7416: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7417: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7418: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7419: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7420: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7421:
7422: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7423: l_cost_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7416: l_top_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7417: l_scheduled_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
7418: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7419: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7420: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7421:
7422: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7423: l_cost_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7424:
7418: l_labor_scheduled_discount_tab PA_PLSQL_DATATYPES.NumTabTyp;
7419: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7420: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7421:
7422: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7423: l_cost_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7424:
7425: l_res_format_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7426:
7419: l_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7420: l_non_labor_sch_type_tab pa_plsql_datatypes.Char30TabTyp;
7421:
7422: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7423: l_cost_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7424:
7425: l_res_format_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7426:
7427: l_bill_rate number;
7421:
7422: l_rev_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7423: l_cost_res_class_rt_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7424:
7425: l_res_format_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
7426:
7427: l_bill_rate number;
7428: l_cost_rate number;
7429: l_burden_cost_rate number;