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

APPS.PA_FP_GEN_FCST_AMT_PVT dependencies on PA_PROJECTS_ALL

Line 9: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

5: /*=======================================================================================
6: This procedure will return the total transaction amount for the given planning resource
7: =======================================================================================*/
8: PROCEDURE GET_TOTAL_PLAN_TXN_AMTS
9: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
10: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
11: P_BV_ID_ETC_WP IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
12: P_BV_ID_ETC_FP IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
13: P_FP_COLS_REC_ETC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

Line 32: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;

28: /* Local variables for calling pa_fp_gen_amount_utils.get_values_for_planning_rate api */
29: l_res_format_id PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE;
30: l_resource_asn_rec PA_FP_GEN_AMOUNT_UTILS.RESOURCE_ASN_REC;
31: l_pa_tasks_rec PA_FP_GEN_AMOUNT_UTILS.PA_TASKS_REC;
32: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;
33: l_proj_fp_options_rec PA_FP_GEN_AMOUNT_UTILS.PROJ_FP_OPTIONS_REC;
34: /* end */
35: /* Local variables for calling get_planning_rate api */
36: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;

Line 61: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

57: l_txn_raw_cost pa_fp_rollup_tmp.txn_raw_cost%TYPE := NULL;
58: l_txn_burdened_cost pa_fp_rollup_tmp.txn_burdened_cost%TYPE := NULL;
59: l_txn_revenue pa_fp_rollup_tmp.txn_revenue%TYPE := NULL;
60:
61: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
62: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
63: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
64: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
65:

Line 62: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

58: l_txn_burdened_cost pa_fp_rollup_tmp.txn_burdened_cost%TYPE := NULL;
59: l_txn_revenue pa_fp_rollup_tmp.txn_revenue%TYPE := NULL;
60:
61: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
62: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
63: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
64: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
65:
66: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;

Line 63: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;

59: l_txn_revenue pa_fp_rollup_tmp.txn_revenue%TYPE := NULL;
60:
61: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
62: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
63: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
64: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
65:
66: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
67: l_assignment_id pa_project_assignments.assignment_id%TYPE := NULL;

Line 64: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;

60:
61: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
62: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
63: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
64: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
65:
66: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
67: l_assignment_id pa_project_assignments.assignment_id%TYPE := NULL;
68: l_cost_rate_multiplier CONSTANT pa_labor_cost_multipliers.multiplier%TYPE := 1;

Line 129: l_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

125: l_data VARCHAR2(2000);
126: l_msg_data VARCHAR2(2000);
127: l_msg_index_out NUMBER;
128:
129: l_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
130: /* Values for l_struct_sharing_code can be
131: SHARE_FULL
132: SHARE_PARTIAL
133: SPLIT_MAPPING

Line 836: FROM pa_projects_all

832: ,projfunc_currency_code
833: BULK COLLECT
834: INTO l_proj_currency_code_tab,
835: l_projfunc_currency_code_tab
836: FROM pa_projects_all
837: WHERE project_id = p_project_id;
838:
839: FOR i IN 1..l_res_asg_id_tab.count LOOP
840: --Calling the Get_values_for_planning_Rate api

Line 859: x_pa_projects_all_rec => l_pa_projects_all_rec,

855: p_txn_currency_code => l_txn_currency_code,
856: x_res_format_id => l_res_format_id,
857: x_resource_asn_rec => l_resource_asn_rec,
858: x_pa_tasks_rec => l_pa_tasks_rec,
859: x_pa_projects_all_rec => l_pa_projects_all_rec,
860: x_proj_fp_options_rec => l_proj_fp_options_rec,
861: x_return_status => x_return_status,
862: x_msg_count => x_msg_count,
863: x_msg_data => x_msg_data);

Line 896: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;

892: l_rate_task_id := NULL;
893: /* If task level attributes are not found
894: then the following atributes can be
895: taken from the project level */
896: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;
897: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;
898: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
899: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
900: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;

Line 897: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;

893: /* If task level attributes are not found
894: then the following atributes can be
895: taken from the project level */
896: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;
897: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;
898: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
899: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
900: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
901: ELSE

Line 898: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;

894: then the following atributes can be
895: taken from the project level */
896: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;
897: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;
898: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
899: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
900: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
901: ELSE
902: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;

Line 899: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;

895: taken from the project level */
896: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;
897: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;
898: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
899: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
900: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
901: ELSE
902: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
903: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;

Line 900: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;

896: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;
897: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;
898: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
899: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
900: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
901: ELSE
902: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
903: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
904: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;

Line 948: ,p_bill_job_grp_id => l_pa_projects_all_rec.x_bill_job_group_id

944: ,p_task_id => l_rate_task_id
945: ,p_top_task_id => l_top_task_id
946: ,p_person_id => l_resource_asn_rec.x_person_id
947: ,p_job_id => l_resource_asn_rec.x_job_id
948: ,p_bill_job_grp_id => l_pa_projects_all_rec.x_bill_job_group_id
949: ,p_resource_class => l_resource_asn_rec.x_resource_class_code
950: ,p_planning_resource_format => l_res_format_id
951: ,p_use_planning_rates_flag => l_proj_fp_options_rec.x_fp_use_planning_rt_flag
952: ,p_rate_based_flag => l_resource_asn_rec.x_rate_based_flag

Line 955: ,p_project_organz_id => l_pa_projects_all_rec.x_carrying_out_organization_id

951: ,p_use_planning_rates_flag => l_proj_fp_options_rec.x_fp_use_planning_rt_flag
952: ,p_rate_based_flag => l_resource_asn_rec.x_rate_based_flag
953: ,p_uom => l_resource_asn_rec.x_unit_of_measure
954: ,p_system_linkage => NULL
955: ,p_project_organz_id => l_pa_projects_all_rec.x_carrying_out_organization_id
956: ,p_rev_res_class_rate_sch_id => l_proj_fp_options_rec.x_fp_res_cl_bill_rate_sch_id
957: ,p_cost_res_class_rate_sch_id => l_proj_fp_options_rec.x_fp_res_cl_raw_cost_sch_id
958: ,p_rev_task_nl_rate_sch_id => l_task_nl_std_bill_rt_sch_id
959: ,p_rev_proj_nl_rate_sch_id => l_pa_projects_all_rec.x_non_lab_std_bill_rt_sch_id

Line 959: ,p_rev_proj_nl_rate_sch_id => l_pa_projects_all_rec.x_non_lab_std_bill_rt_sch_id

955: ,p_project_organz_id => l_pa_projects_all_rec.x_carrying_out_organization_id
956: ,p_rev_res_class_rate_sch_id => l_proj_fp_options_rec.x_fp_res_cl_bill_rate_sch_id
957: ,p_cost_res_class_rate_sch_id => l_proj_fp_options_rec.x_fp_res_cl_raw_cost_sch_id
958: ,p_rev_task_nl_rate_sch_id => l_task_nl_std_bill_rt_sch_id
959: ,p_rev_proj_nl_rate_sch_id => l_pa_projects_all_rec.x_non_lab_std_bill_rt_sch_id
960: ,p_rev_job_rate_sch_id => l_job_bill_rate_sch_id
961: ,p_rev_emp_rate_sch_id => l_emp_bill_rate_sch_id
962: ,p_plan_rev_job_rate_sch_id => l_proj_fp_options_rec.x_fp_rev_job_rate_sch_id
963: ,p_plan_cost_job_rate_sch_id => l_proj_fp_options_rec.x_fp_cost_job_rate_sch_id

Line 970: ,p_mcb_flag => l_pa_projects_all_rec.x_multi_currency_billing_flag

966: ,p_plan_rev_nlr_rate_sch_id => l_proj_fp_options_rec.x_fp_rev_non_lab_rs_rt_sch_id
967: ,p_plan_cost_nlr_rate_sch_id => l_proj_fp_options_rec.x_fp_cost_non_lab_rs_rt_sch_id
968: ,p_plan_burden_cost_sch_id => l_proj_fp_options_rec.x_fp_cost_burden_rate_sch_id
969: ,p_calculate_mode => l_calculate_mode
970: ,p_mcb_flag => l_pa_projects_all_rec.x_multi_currency_billing_flag
971: ,p_cost_rate_multiplier => l_cost_rate_multiplier
972: ,p_bill_rate_multiplier => l_bill_rate_multiplier
973: ,p_quantity => l_txn_plan_quantity
974: ,p_item_date => l_budget_lines_start_date

Line 983: ,p_project_org_id => l_pa_projects_all_rec.x_org_id

979: ,p_labor_bill_rate_org_id => l_lab_bill_rate_org_id
980: ,p_labor_std_bill_rate_schdl => NULL
981: ,p_labor_schdl_fixed_date => NULL
982: ,p_assignment_id => l_assignment_id
983: ,p_project_org_id => l_pa_projects_all_rec.x_org_id
984: ,p_project_type => l_pa_projects_all_rec.x_project_type
985: ,p_expenditure_type => nvl(l_resource_asn_rec.x_expenditure_type,
986: l_resource_asn_rec.x_rate_expenditure_type)
987: ,p_non_labor_resource => l_resource_asn_rec.x_non_labor_resource

Line 984: ,p_project_type => l_pa_projects_all_rec.x_project_type

980: ,p_labor_std_bill_rate_schdl => NULL
981: ,p_labor_schdl_fixed_date => NULL
982: ,p_assignment_id => l_assignment_id
983: ,p_project_org_id => l_pa_projects_all_rec.x_org_id
984: ,p_project_type => l_pa_projects_all_rec.x_project_type
985: ,p_expenditure_type => nvl(l_resource_asn_rec.x_expenditure_type,
986: l_resource_asn_rec.x_rate_expenditure_type)
987: ,p_non_labor_resource => l_resource_asn_rec.x_non_labor_resource
988: ,p_incurred_by_organz_id => l_resource_asn_rec.x_organization_id

Line 991: l_pa_projects_all_rec.x_org_id)

987: ,p_non_labor_resource => l_resource_asn_rec.x_non_labor_resource
988: ,p_incurred_by_organz_id => l_resource_asn_rec.x_organization_id
989: ,p_override_to_organz_id => l_resource_asn_rec.x_organization_id
990: ,p_expenditure_org_id => nvl(l_resource_asn_rec.x_rate_expenditure_org_id,
991: l_pa_projects_all_rec.x_org_id)
992: ,p_assignment_precedes_task => l_pa_projects_all_rec.x_assign_precedes_task
993: ,p_planning_transaction_id => l_budget_line_id
994: ,p_task_bill_rate_org_id => l_task_bill_rate_org_id
995: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id

Line 992: ,p_assignment_precedes_task => l_pa_projects_all_rec.x_assign_precedes_task

988: ,p_incurred_by_organz_id => l_resource_asn_rec.x_organization_id
989: ,p_override_to_organz_id => l_resource_asn_rec.x_organization_id
990: ,p_expenditure_org_id => nvl(l_resource_asn_rec.x_rate_expenditure_org_id,
991: l_pa_projects_all_rec.x_org_id)
992: ,p_assignment_precedes_task => l_pa_projects_all_rec.x_assign_precedes_task
993: ,p_planning_transaction_id => l_budget_line_id
994: ,p_task_bill_rate_org_id => l_task_bill_rate_org_id
995: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id
996: ,p_nlr_organization_id => nvl(l_resource_asn_rec.x_organization_id,

Line 995: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id

991: l_pa_projects_all_rec.x_org_id)
992: ,p_assignment_precedes_task => l_pa_projects_all_rec.x_assign_precedes_task
993: ,p_planning_transaction_id => l_budget_line_id
994: ,p_task_bill_rate_org_id => l_task_bill_rate_org_id
995: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id
996: ,p_nlr_organization_id => nvl(l_resource_asn_rec.x_organization_id,
997: l_pa_projects_all_rec.x_carrying_out_organization_id)
998: ,p_project_sch_date => l_pa_projects_all_rec.x_non_labor_sch_fixed_date
999: ,p_task_sch_date => l_task_sch_date

Line 997: l_pa_projects_all_rec.x_carrying_out_organization_id)

993: ,p_planning_transaction_id => l_budget_line_id
994: ,p_task_bill_rate_org_id => l_task_bill_rate_org_id
995: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id
996: ,p_nlr_organization_id => nvl(l_resource_asn_rec.x_organization_id,
997: l_pa_projects_all_rec.x_carrying_out_organization_id)
998: ,p_project_sch_date => l_pa_projects_all_rec.x_non_labor_sch_fixed_date
999: ,p_task_sch_date => l_task_sch_date
1000: ,p_project_sch_discount => l_pa_projects_all_rec.x_non_labor_schedule_discount
1001: ,p_task_sch_discount => l_task_sch_discount

Line 998: ,p_project_sch_date => l_pa_projects_all_rec.x_non_labor_sch_fixed_date

994: ,p_task_bill_rate_org_id => l_task_bill_rate_org_id
995: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id
996: ,p_nlr_organization_id => nvl(l_resource_asn_rec.x_organization_id,
997: l_pa_projects_all_rec.x_carrying_out_organization_id)
998: ,p_project_sch_date => l_pa_projects_all_rec.x_non_labor_sch_fixed_date
999: ,p_task_sch_date => l_task_sch_date
1000: ,p_project_sch_discount => l_pa_projects_all_rec.x_non_labor_schedule_discount
1001: ,p_task_sch_discount => l_task_sch_discount
1002: ,p_inventory_item_id => l_resource_asn_rec.x_inventory_item_id

Line 1000: ,p_project_sch_discount => l_pa_projects_all_rec.x_non_labor_schedule_discount

996: ,p_nlr_organization_id => nvl(l_resource_asn_rec.x_organization_id,
997: l_pa_projects_all_rec.x_carrying_out_organization_id)
998: ,p_project_sch_date => l_pa_projects_all_rec.x_non_labor_sch_fixed_date
999: ,p_task_sch_date => l_task_sch_date
1000: ,p_project_sch_discount => l_pa_projects_all_rec.x_non_labor_schedule_discount
1001: ,p_task_sch_discount => l_task_sch_discount
1002: ,p_inventory_item_id => l_resource_asn_rec.x_inventory_item_id
1003: ,p_BOM_resource_Id => l_resource_asn_rec.x_bom_resource_id
1004: ,p_mfc_cost_type_id => l_resource_asn_rec.x_mfc_cost_type_id