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_AMOUNT_UTILS dependencies on PA_PROJECTS_ALL

Line 247: PA_PROJECTS_ALL P, PA_IMPLEMENTATIONS_ALL I,

243: X_FP_COLS_REC.X_TRACK_WORKPLAN_COSTS_FLAG,
244: X_FP_COLS_REC.X_GEN_SRC_WP_VERSION_ID,
245: X_FP_COLS_REC.X_GEN_SRC_WP_VER_CODE
246: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT, PA_PROJ_FP_OPTIONS OPT1,
247: PA_PROJECTS_ALL P, PA_IMPLEMENTATIONS_ALL I,
248: PA_FIN_PLAN_AMOUNT_SETS FP,
249: PA_FIN_PLAN_TYPES_B FB
250: WHERE BV.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
251: AND OPT.PROJECT_ID = BV.PROJECT_ID

Line 366: pa_projects_all.project_id%TYPE,

362: END CHK_CMT_TXN_CURRENCY;
363:
364: PROCEDURE Get_Curr_Original_Version_Info(
365: p_project_id IN
366: pa_projects_all.project_id%TYPE,
367: p_fin_plan_type_id IN
368: pa_budget_versions.fin_plan_type_id%TYPE,
369: p_version_type IN
370: pa_budget_versions.version_type%TYPE,

Line 738: X_PA_PROJECTS_ALL_REC OUT NOCOPY PA_PROJECTS_ALL_REC,

734: X_RES_FORMAT_ID OUT NOCOPY
735: PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,
736: X_RESOURCE_ASN_REC OUT NOCOPY RESOURCE_ASN_REC,
737: X_PA_TASKS_REC OUT NOCOPY PA_TASKS_REC,
738: X_PA_PROJECTS_ALL_REC OUT NOCOPY PA_PROJECTS_ALL_REC,
739: X_PROJ_FP_OPTIONS_REC OUT NOCOPY PROJ_FP_OPTIONS_REC,
740: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
741: X_MSG_COUNT OUT NOCOPY NUMBER,
742: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 802: FROM pa_projects_all ppa

798: ,job_bill_rate_schedule_id
799: ,labor_bill_rate_org_id
800: ,labor_sch_type
801: ,non_labor_sch_type
802: FROM pa_projects_all ppa
803: WHERE ppa.project_id = c_proj_id;
804:
805:
806: --get_projects_all_rec get_projects_all_csr%ROWTYPE;

Line 901: -- Local variables for pa_projects_all table

897: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
898: l_top_task_id pa_tasks.top_task_id%TYPE;
899: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
900:
901: -- Local variables for pa_projects_all table
902: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
903: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
904: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
905: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

Line 902: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;

898: l_top_task_id pa_tasks.top_task_id%TYPE;
899: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
900:
901: -- Local variables for pa_projects_all table
902: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
903: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
904: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
905: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
906: l_org_id pa_projects_all.org_id%TYPE;

Line 903: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

899: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
900:
901: -- Local variables for pa_projects_all table
902: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
903: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
904: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
905: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
906: l_org_id pa_projects_all.org_id%TYPE;
907: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;

Line 904: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;

900:
901: -- Local variables for pa_projects_all table
902: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
903: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
904: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
905: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
906: l_org_id pa_projects_all.org_id%TYPE;
907: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
908: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;

Line 905: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

901: -- Local variables for pa_projects_all table
902: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
903: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
904: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
905: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
906: l_org_id pa_projects_all.org_id%TYPE;
907: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
908: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
909: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;

Line 906: l_org_id pa_projects_all.org_id%TYPE;

902: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
903: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
904: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
905: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
906: l_org_id pa_projects_all.org_id%TYPE;
907: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
908: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
909: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
910: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;

Line 907: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;

903: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
904: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
905: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
906: l_org_id pa_projects_all.org_id%TYPE;
907: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
908: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
909: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
910: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
911: l_project_type pa_projects_all.project_type%TYPE;

Line 908: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;

904: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
905: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
906: l_org_id pa_projects_all.org_id%TYPE;
907: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
908: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
909: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
910: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
911: l_project_type pa_projects_all.project_type%TYPE;
912: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 909: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;

905: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
906: l_org_id pa_projects_all.org_id%TYPE;
907: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
908: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
909: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
910: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
911: l_project_type pa_projects_all.project_type%TYPE;
912: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
913: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 910: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;

906: l_org_id pa_projects_all.org_id%TYPE;
907: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
908: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
909: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
910: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
911: l_project_type pa_projects_all.project_type%TYPE;
912: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
913: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
914: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

Line 911: l_project_type pa_projects_all.project_type%TYPE;

907: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
908: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
909: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
910: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
911: l_project_type pa_projects_all.project_type%TYPE;
912: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
913: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
914: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
915: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

Line 912: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

908: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
909: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
910: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
911: l_project_type pa_projects_all.project_type%TYPE;
912: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
913: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
914: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
915: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
916: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;

Line 913: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

909: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
910: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
911: l_project_type pa_projects_all.project_type%TYPE;
912: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
913: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
914: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
915: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
916: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
917: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;

Line 914: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

910: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
911: l_project_type pa_projects_all.project_type%TYPE;
912: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
913: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
914: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
915: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
916: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
917: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
918: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;

Line 915: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

911: l_project_type pa_projects_all.project_type%TYPE;
912: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
913: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
914: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
915: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
916: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
917: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
918: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
919: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;

Line 916: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;

912: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
913: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
914: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
915: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
916: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
917: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
918: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
919: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
920: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;

Line 917: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;

913: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
914: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
915: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
916: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
917: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
918: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
919: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
920: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
921: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

Line 918: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;

914: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
915: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
916: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
917: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
918: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
919: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
920: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
921: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
922: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

Line 919: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;

915: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
916: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
917: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
918: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
919: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
920: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
921: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
922: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
923:

Line 920: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;

916: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
917: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
918: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
919: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
920: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
921: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
922: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
923:
924: -- Local variables for pa_resource_list_members table

Line 921: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

917: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
918: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
919: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
920: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
921: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
922: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
923:
924: -- Local variables for pa_resource_list_members table
925: l_res_format_id pa_resource_list_members.res_format_id%TYPE;

Line 922: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

918: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
919: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
920: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
921: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
922: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
923:
924: -- Local variables for pa_resource_list_members table
925: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
926:

Line 1004: FETCH get_projects_all_csr INTO x_pa_projects_all_rec;

1000: l_rate_expenditure_type := get_resource_asn_rec.rate_expenditure_type;
1001: l_rate_organization_id := get_resource_asn_rec.rate_organization_id; */
1002:
1003: OPEN get_projects_all_csr(p_project_id);
1004: FETCH get_projects_all_csr INTO x_pa_projects_all_rec;
1005: CLOSE get_projects_all_csr;
1006:
1007: /* l_assign_precedes_task := get_projects_all_rec.assign_precedes_task;
1008: l_bill_job_group_id := get_projects_all_rec.bill_job_group_id;

Line 1483: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

1479: l_rev_gen_method VARCHAR2(1);
1480: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
1481:
1482: l_source_wp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1483: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1484: l_source_fp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1485: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1486:
1487: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;