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 228: PA_PROJECTS_ALL P, PA_IMPLEMENTATIONS_ALL I,

224: X_FP_COLS_REC.X_TRACK_WORKPLAN_COSTS_FLAG,
225: X_FP_COLS_REC.X_GEN_SRC_WP_VERSION_ID,
226: X_FP_COLS_REC.X_GEN_SRC_WP_VER_CODE
227: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT, PA_PROJ_FP_OPTIONS OPT1,
228: PA_PROJECTS_ALL P, PA_IMPLEMENTATIONS_ALL I,
229: PA_FIN_PLAN_AMOUNT_SETS FP,
230: PA_FIN_PLAN_TYPES_B FB
231: WHERE BV.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
232: AND OPT.PROJECT_ID = BV.PROJECT_ID

Line 346: pa_projects_all.project_id%TYPE,

342: END CHK_CMT_TXN_CURRENCY;
343:
344: PROCEDURE Get_Curr_Original_Version_Info(
345: p_project_id IN
346: pa_projects_all.project_id%TYPE,
347: p_fin_plan_type_id IN
348: pa_budget_versions.fin_plan_type_id%TYPE,
349: p_version_type IN
350: pa_budget_versions.version_type%TYPE,

Line 718: X_PA_PROJECTS_ALL_REC OUT NOCOPY PA_PROJECTS_ALL_REC,

714: X_RES_FORMAT_ID OUT NOCOPY
715: PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,
716: X_RESOURCE_ASN_REC OUT NOCOPY RESOURCE_ASN_REC,
717: X_PA_TASKS_REC OUT NOCOPY PA_TASKS_REC,
718: X_PA_PROJECTS_ALL_REC OUT NOCOPY PA_PROJECTS_ALL_REC,
719: X_PROJ_FP_OPTIONS_REC OUT NOCOPY PROJ_FP_OPTIONS_REC,
720: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
721: X_MSG_COUNT OUT NOCOPY NUMBER,
722: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 782: FROM pa_projects_all ppa

778: ,job_bill_rate_schedule_id
779: ,labor_bill_rate_org_id
780: ,labor_sch_type
781: ,non_labor_sch_type
782: FROM pa_projects_all ppa
783: WHERE ppa.project_id = c_proj_id;
784:
785:
786: --get_projects_all_rec get_projects_all_csr%ROWTYPE;

Line 881: -- Local variables for pa_projects_all table

877: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
878: l_top_task_id pa_tasks.top_task_id%TYPE;
879: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
880:
881: -- Local variables for pa_projects_all table
882: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
883: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
884: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
885: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

Line 882: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;

878: l_top_task_id pa_tasks.top_task_id%TYPE;
879: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
880:
881: -- Local variables for pa_projects_all table
882: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
883: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
884: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
885: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
886: l_org_id pa_projects_all.org_id%TYPE;

Line 883: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

879: l_lab_sch_type pa_tasks.emp_bill_rate_schedule_id%TYPE;
880:
881: -- Local variables for pa_projects_all table
882: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
883: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
884: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
885: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
886: l_org_id pa_projects_all.org_id%TYPE;
887: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;

Line 884: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;

880:
881: -- Local variables for pa_projects_all table
882: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
883: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
884: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
885: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
886: l_org_id pa_projects_all.org_id%TYPE;
887: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
888: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;

Line 885: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

881: -- Local variables for pa_projects_all table
882: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
883: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
884: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
885: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
886: l_org_id pa_projects_all.org_id%TYPE;
887: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
888: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
889: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;

Line 886: l_org_id pa_projects_all.org_id%TYPE;

882: l_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE;
883: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
884: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
885: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
886: l_org_id pa_projects_all.org_id%TYPE;
887: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
888: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
889: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
890: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;

Line 887: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;

883: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
884: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
885: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
886: l_org_id pa_projects_all.org_id%TYPE;
887: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
888: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
889: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
890: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
891: l_project_type pa_projects_all.project_type%TYPE;

Line 888: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;

884: l_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE;
885: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
886: l_org_id pa_projects_all.org_id%TYPE;
887: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
888: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
889: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
890: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
891: l_project_type pa_projects_all.project_type%TYPE;
892: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 889: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;

885: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
886: l_org_id pa_projects_all.org_id%TYPE;
887: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
888: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
889: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
890: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
891: l_project_type pa_projects_all.project_type%TYPE;
892: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
893: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 890: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;

886: l_org_id pa_projects_all.org_id%TYPE;
887: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
888: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
889: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
890: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
891: l_project_type pa_projects_all.project_type%TYPE;
892: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
893: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
894: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

Line 891: l_project_type pa_projects_all.project_type%TYPE;

887: l_project_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE;
888: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
889: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
890: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
891: l_project_type pa_projects_all.project_type%TYPE;
892: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
893: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
894: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
895: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

Line 892: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

888: l_project_sch_discount pa_projects_all.non_labor_schedule_discount%TYPE;
889: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
890: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
891: l_project_type pa_projects_all.project_type%TYPE;
892: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
893: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
894: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
895: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
896: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;

Line 893: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

889: l_project_sch_date pa_projects_all.non_labor_schedule_fixed_date%TYPE;
890: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
891: l_project_type pa_projects_all.project_type%TYPE;
892: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
893: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
894: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
895: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
896: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
897: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;

Line 894: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

890: l_proj_nl_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE;
891: l_project_type pa_projects_all.project_type%TYPE;
892: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
893: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
894: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
895: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
896: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
897: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
898: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;

Line 895: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

891: l_project_type pa_projects_all.project_type%TYPE;
892: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
893: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
894: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
895: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
896: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
897: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
898: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
899: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;

Line 896: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;

892: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
893: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
894: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
895: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
896: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
897: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
898: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
899: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
900: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;

Line 897: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;

893: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
894: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
895: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
896: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
897: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
898: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
899: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
900: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
901: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

Line 898: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;

894: l_proj_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
895: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
896: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
897: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
898: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
899: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
900: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
901: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
902: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

Line 899: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;

895: l_proj_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
896: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
897: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
898: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
899: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
900: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
901: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
902: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
903:

Line 900: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;

896: l_proj_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
897: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
898: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
899: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
900: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
901: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
902: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
903:
904: -- Local variables for pa_resource_list_members table

Line 901: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;

897: l_proj_lab_sch_type pa_projects_all.labor_sch_type%TYPE;
898: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
899: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
900: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
901: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
902: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
903:
904: -- Local variables for pa_resource_list_members table
905: l_res_format_id pa_resource_list_members.res_format_id%TYPE;

Line 902: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;

898: l_proj_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
899: l_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE;
900: l_lab_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE;
901: l_job_bill_rate_sch_id pa_projects_all.job_bill_rate_schedule_id%TYPE;
902: l_emp_bill_rate_sch_id pa_projects_all.emp_bill_rate_schedule_id%TYPE;
903:
904: -- Local variables for pa_resource_list_members table
905: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
906:

Line 984: FETCH get_projects_all_csr INTO x_pa_projects_all_rec;

980: l_rate_expenditure_type := get_resource_asn_rec.rate_expenditure_type;
981: l_rate_organization_id := get_resource_asn_rec.rate_organization_id; */
982:
983: OPEN get_projects_all_csr(p_project_id);
984: FETCH get_projects_all_csr INTO x_pa_projects_all_rec;
985: CLOSE get_projects_all_csr;
986:
987: /* l_assign_precedes_task := get_projects_all_rec.assign_precedes_task;
988: l_bill_job_group_id := get_projects_all_rec.bill_job_group_id;

Line 1463: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

1459: l_rev_gen_method VARCHAR2(1);
1460: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
1461:
1462: l_source_wp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1463: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1464: l_source_fp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1465: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1466:
1467: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;