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 17: P_STRUCTURE_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE Default 'SHARE_FULL', -- Changes done for bug#10406949->FP Bug#12800007

13: P_FP_COLS_REC_ETC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
14: P_FP_COLS_REC_ETC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
15: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
16: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
17: P_STRUCTURE_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE Default 'SHARE_FULL', -- Changes done for bug#10406949->FP Bug#12800007
18: P_LATEST_PUBLISH_FP_WBS_ID IN NUMBER,
19: P_CALLING_CONTEXT IN VARCHAR2,
20: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
21: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 33: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;

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

Line 62: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

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

Line 63: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

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

Line 64: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;

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

Line 65: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;

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

Line 131: l_struct_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

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

Line 849: FROM pa_projects_all

845: ,projfunc_currency_code
846: BULK COLLECT
847: INTO l_proj_currency_code_tab,
848: l_projfunc_currency_code_tab
849: FROM pa_projects_all
850: WHERE project_id = p_project_id;
851:
852: FOR i IN 1..l_res_asg_id_tab.count LOOP
853: --Calling the Get_values_for_planning_Rate api

Line 872: x_pa_projects_all_rec => l_pa_projects_all_rec,

868: p_txn_currency_code => l_txn_currency_code,
869: x_res_format_id => l_res_format_id,
870: x_resource_asn_rec => l_resource_asn_rec,
871: x_pa_tasks_rec => l_pa_tasks_rec,
872: x_pa_projects_all_rec => l_pa_projects_all_rec,
873: x_proj_fp_options_rec => l_proj_fp_options_rec,
874: x_return_status => x_return_status,
875: x_msg_count => x_msg_count,
876: x_msg_data => x_msg_data);

Line 909: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;

905: l_rate_task_id := NULL;
906: /* If task level attributes are not found
907: then the following atributes can be
908: taken from the project level */
909: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;
910: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;
911: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
912: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
913: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;

Line 910: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;

906: /* If task level attributes are not found
907: then the following atributes can be
908: taken from the project level */
909: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;
910: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;
911: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
912: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
913: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
914: ELSE

Line 911: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;

907: then the following atributes can be
908: taken from the project level */
909: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;
910: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;
911: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
912: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
913: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
914: ELSE
915: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;

Line 912: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;

908: taken from the project level */
909: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;
910: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;
911: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
912: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
913: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
914: ELSE
915: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
916: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;

Line 913: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;

909: l_emp_bill_rate_sch_id := l_pa_projects_all_rec.x_emp_bill_rate_schedule_id;
910: l_job_bill_rate_sch_id := l_pa_projects_all_rec.x_job_bill_rate_schedule_id;
911: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
912: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
913: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
914: ELSE
915: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
916: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
917: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;

Line 961: ,p_bill_job_grp_id => l_pa_projects_all_rec.x_bill_job_group_id

957: ,p_task_id => l_rate_task_id
958: ,p_top_task_id => l_top_task_id
959: ,p_person_id => l_resource_asn_rec.x_person_id
960: ,p_job_id => l_resource_asn_rec.x_job_id
961: ,p_bill_job_grp_id => l_pa_projects_all_rec.x_bill_job_group_id
962: ,p_resource_class => l_resource_asn_rec.x_resource_class_code
963: ,p_planning_resource_format => l_res_format_id
964: ,p_use_planning_rates_flag => l_proj_fp_options_rec.x_fp_use_planning_rt_flag
965: ,p_rate_based_flag => l_resource_asn_rec.x_rate_based_flag

Line 968: ,p_project_organz_id => l_pa_projects_all_rec.x_carrying_out_organization_id

964: ,p_use_planning_rates_flag => l_proj_fp_options_rec.x_fp_use_planning_rt_flag
965: ,p_rate_based_flag => l_resource_asn_rec.x_rate_based_flag
966: ,p_uom => l_resource_asn_rec.x_unit_of_measure
967: ,p_system_linkage => NULL
968: ,p_project_organz_id => l_pa_projects_all_rec.x_carrying_out_organization_id
969: ,p_rev_res_class_rate_sch_id => l_proj_fp_options_rec.x_fp_res_cl_bill_rate_sch_id
970: ,p_cost_res_class_rate_sch_id => l_proj_fp_options_rec.x_fp_res_cl_raw_cost_sch_id
971: ,p_rev_task_nl_rate_sch_id => l_task_nl_std_bill_rt_sch_id
972: ,p_rev_proj_nl_rate_sch_id => l_pa_projects_all_rec.x_non_lab_std_bill_rt_sch_id

Line 972: ,p_rev_proj_nl_rate_sch_id => l_pa_projects_all_rec.x_non_lab_std_bill_rt_sch_id

968: ,p_project_organz_id => l_pa_projects_all_rec.x_carrying_out_organization_id
969: ,p_rev_res_class_rate_sch_id => l_proj_fp_options_rec.x_fp_res_cl_bill_rate_sch_id
970: ,p_cost_res_class_rate_sch_id => l_proj_fp_options_rec.x_fp_res_cl_raw_cost_sch_id
971: ,p_rev_task_nl_rate_sch_id => l_task_nl_std_bill_rt_sch_id
972: ,p_rev_proj_nl_rate_sch_id => l_pa_projects_all_rec.x_non_lab_std_bill_rt_sch_id
973: ,p_rev_job_rate_sch_id => l_job_bill_rate_sch_id
974: ,p_rev_emp_rate_sch_id => l_emp_bill_rate_sch_id
975: ,p_plan_rev_job_rate_sch_id => l_proj_fp_options_rec.x_fp_rev_job_rate_sch_id
976: ,p_plan_cost_job_rate_sch_id => l_proj_fp_options_rec.x_fp_cost_job_rate_sch_id

Line 983: ,p_mcb_flag => l_pa_projects_all_rec.x_multi_currency_billing_flag

979: ,p_plan_rev_nlr_rate_sch_id => l_proj_fp_options_rec.x_fp_rev_non_lab_rs_rt_sch_id
980: ,p_plan_cost_nlr_rate_sch_id => l_proj_fp_options_rec.x_fp_cost_non_lab_rs_rt_sch_id
981: ,p_plan_burden_cost_sch_id => l_proj_fp_options_rec.x_fp_cost_burden_rate_sch_id
982: ,p_calculate_mode => l_calculate_mode
983: ,p_mcb_flag => l_pa_projects_all_rec.x_multi_currency_billing_flag
984: ,p_cost_rate_multiplier => l_cost_rate_multiplier
985: ,p_bill_rate_multiplier => l_bill_rate_multiplier
986: ,p_quantity => l_txn_plan_quantity
987: ,p_item_date => l_budget_lines_start_date

Line 996: ,p_project_org_id => l_pa_projects_all_rec.x_org_id

992: ,p_labor_bill_rate_org_id => l_lab_bill_rate_org_id
993: ,p_labor_std_bill_rate_schdl => NULL
994: ,p_labor_schdl_fixed_date => NULL
995: ,p_assignment_id => l_assignment_id
996: ,p_project_org_id => l_pa_projects_all_rec.x_org_id
997: ,p_project_type => l_pa_projects_all_rec.x_project_type
998: ,p_expenditure_type => nvl(l_resource_asn_rec.x_expenditure_type,
999: l_resource_asn_rec.x_rate_expenditure_type)
1000: ,p_non_labor_resource => l_resource_asn_rec.x_non_labor_resource

Line 997: ,p_project_type => l_pa_projects_all_rec.x_project_type

993: ,p_labor_std_bill_rate_schdl => NULL
994: ,p_labor_schdl_fixed_date => NULL
995: ,p_assignment_id => l_assignment_id
996: ,p_project_org_id => l_pa_projects_all_rec.x_org_id
997: ,p_project_type => l_pa_projects_all_rec.x_project_type
998: ,p_expenditure_type => nvl(l_resource_asn_rec.x_expenditure_type,
999: l_resource_asn_rec.x_rate_expenditure_type)
1000: ,p_non_labor_resource => l_resource_asn_rec.x_non_labor_resource
1001: ,p_incurred_by_organz_id => l_resource_asn_rec.x_organization_id

Line 1004: l_pa_projects_all_rec.x_org_id)

1000: ,p_non_labor_resource => l_resource_asn_rec.x_non_labor_resource
1001: ,p_incurred_by_organz_id => l_resource_asn_rec.x_organization_id
1002: ,p_override_to_organz_id => l_resource_asn_rec.x_organization_id
1003: ,p_expenditure_org_id => nvl(l_resource_asn_rec.x_rate_expenditure_org_id,
1004: l_pa_projects_all_rec.x_org_id)
1005: ,p_assignment_precedes_task => l_pa_projects_all_rec.x_assign_precedes_task
1006: ,p_planning_transaction_id => l_budget_line_id
1007: ,p_task_bill_rate_org_id => l_task_bill_rate_org_id
1008: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id

Line 1005: ,p_assignment_precedes_task => l_pa_projects_all_rec.x_assign_precedes_task

1001: ,p_incurred_by_organz_id => l_resource_asn_rec.x_organization_id
1002: ,p_override_to_organz_id => l_resource_asn_rec.x_organization_id
1003: ,p_expenditure_org_id => nvl(l_resource_asn_rec.x_rate_expenditure_org_id,
1004: l_pa_projects_all_rec.x_org_id)
1005: ,p_assignment_precedes_task => l_pa_projects_all_rec.x_assign_precedes_task
1006: ,p_planning_transaction_id => l_budget_line_id
1007: ,p_task_bill_rate_org_id => l_task_bill_rate_org_id
1008: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id
1009: ,p_nlr_organization_id => nvl(l_resource_asn_rec.x_organization_id,

Line 1008: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id

1004: l_pa_projects_all_rec.x_org_id)
1005: ,p_assignment_precedes_task => l_pa_projects_all_rec.x_assign_precedes_task
1006: ,p_planning_transaction_id => l_budget_line_id
1007: ,p_task_bill_rate_org_id => l_task_bill_rate_org_id
1008: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id
1009: ,p_nlr_organization_id => nvl(l_resource_asn_rec.x_organization_id,
1010: l_pa_projects_all_rec.x_carrying_out_organization_id)
1011: ,p_project_sch_date => l_pa_projects_all_rec.x_non_labor_sch_fixed_date
1012: ,p_task_sch_date => l_task_sch_date

Line 1010: l_pa_projects_all_rec.x_carrying_out_organization_id)

1006: ,p_planning_transaction_id => l_budget_line_id
1007: ,p_task_bill_rate_org_id => l_task_bill_rate_org_id
1008: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id
1009: ,p_nlr_organization_id => nvl(l_resource_asn_rec.x_organization_id,
1010: l_pa_projects_all_rec.x_carrying_out_organization_id)
1011: ,p_project_sch_date => l_pa_projects_all_rec.x_non_labor_sch_fixed_date
1012: ,p_task_sch_date => l_task_sch_date
1013: ,p_project_sch_discount => l_pa_projects_all_rec.x_non_labor_schedule_discount
1014: ,p_task_sch_discount => l_task_sch_discount

Line 1011: ,p_project_sch_date => l_pa_projects_all_rec.x_non_labor_sch_fixed_date

1007: ,p_task_bill_rate_org_id => l_task_bill_rate_org_id
1008: ,p_project_bill_rate_org_id => l_pa_projects_all_rec.x_non_labor_bill_rate_org_id
1009: ,p_nlr_organization_id => nvl(l_resource_asn_rec.x_organization_id,
1010: l_pa_projects_all_rec.x_carrying_out_organization_id)
1011: ,p_project_sch_date => l_pa_projects_all_rec.x_non_labor_sch_fixed_date
1012: ,p_task_sch_date => l_task_sch_date
1013: ,p_project_sch_discount => l_pa_projects_all_rec.x_non_labor_schedule_discount
1014: ,p_task_sch_discount => l_task_sch_discount
1015: ,p_inventory_item_id => l_resource_asn_rec.x_inventory_item_id

Line 1013: ,p_project_sch_discount => l_pa_projects_all_rec.x_non_labor_schedule_discount

1009: ,p_nlr_organization_id => nvl(l_resource_asn_rec.x_organization_id,
1010: l_pa_projects_all_rec.x_carrying_out_organization_id)
1011: ,p_project_sch_date => l_pa_projects_all_rec.x_non_labor_sch_fixed_date
1012: ,p_task_sch_date => l_task_sch_date
1013: ,p_project_sch_discount => l_pa_projects_all_rec.x_non_labor_schedule_discount
1014: ,p_task_sch_discount => l_task_sch_discount
1015: ,p_inventory_item_id => l_resource_asn_rec.x_inventory_item_id
1016: ,p_BOM_resource_Id => l_resource_asn_rec.x_bom_resource_id
1017: ,p_mfc_cost_type_id => l_resource_asn_rec.x_mfc_cost_type_id