APPS.PA_FP_ROLLUP_PKG dependencies on PA_PROJECTS_ALL

Line 587: , pa_projects_all p

583: BEGIN
584: SELECT org_project_flag
585: INTO l_org_forecast_flag
586: FROM pa_budget_versions v
587: , pa_projects_all p
588: , pa_project_types_all pt
589: WHERE v.budget_version_id = p_budget_version_id
590: AND v.project_id = p.project_id
591: AND p.project_type = pt.project_type

Line 2055: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;

2051: L_INSERTING_RES_GROUP_LEVEL boolean := false;
2052: L_INSERTING_TASK_LEVEL boolean := false;
2053: L_INSERTING_PARENT_TASK_LEVEL boolean := false;
2054:
2055: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
2056:
2057: BEGIN
2058:
2059: -- Set the error stack.

Line 2128: FROM pa_projects_all

2124: /* #2801522: Getting the project currency code for storing in the 'QAUNTITY' record. */
2125:
2126: SELECT project_currency_code
2127: INTO l_proj_currency_code
2128: FROM pa_projects_all
2129: WHERE project_id = l_project_id;
2130:
2131: IF (l_period_profile_id IS NOT NULL) THEN
2132:

Line 3685: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;

3681: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
3682: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
3683: l_project_id pa_projects.project_id%TYPE;
3684: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
3685: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
3686:
3687: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
3688:
3689: l_curr_rollup_level NUMBER := 0;

Line 3782: FROM pa_projects_all

3778: /* #2801522: Getting the project currency code for storing in the 'QAUNTITY' record. */
3779:
3780: SELECT project_currency_code
3781: INTO l_proj_currency_code
3782: FROM pa_projects_all
3783: WHERE project_id = l_project_id;
3784:
3785: /* set total number of levels in rollup.
3786: Total number of level = number of levels in WBS + resource group (in case resource list is grouped)

Line 4425: l_project_currency_code pa_projects_all.project_currency_code%type;

4421: l_task_id pa_tasks.task_id%type;
4422: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
4423:
4424: --Bug # 2615807.
4425: l_project_currency_code pa_projects_all.project_currency_code%type;
4426: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;
4427:
4428:
4429: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 4426: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;

4422: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
4423:
4424: --Bug # 2615807.
4425: l_project_currency_code pa_projects_all.project_currency_code%type;
4426: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;
4427:
4428:
4429: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
4430: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type();

Line 4522: from pa_projects_all

4518:
4519: --Bug # 2615807.
4520: select project_currency_code,projfunc_currency_code
4521: into l_project_currency_code,l_projfunc_currency_code
4522: from pa_projects_all
4523: where project_id = l_project_id;
4524:
4525: IF (p_txn_currency_code IS NULL) THEN
4526: