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

Line 662: from pa_projects_all

658:
659: CURSOR cur_pa_proj
660: IS
661: SELECT start_date, completion_date
662: from pa_projects_all
663: where project_id = x_project_id;
664:
665: l_return_date DATE;
666:

Line 1136: FROM pa_projects_all

1132:
1133: CURSOR cur_pa_proj
1134: IS
1135: SELECT start_date, completion_date
1136: FROM pa_projects_all
1137: WHERE project_id = p_project_id;
1138:
1139:
1140: l_last_progress_date DATE;

Line 1257: FROM pa_projects_all

1253:
1254: CURSOR cur_pa_proj
1255: IS
1256: SELECT start_date, completion_date
1257: FROM pa_projects_all
1258: WHERE project_id = p_project_id;
1259:
1260: -- Bug 3974627 : Commented this cursor and added new ones
1261: /*

Line 2609: p_project_id IN pa_projects_all.project_id%TYPE

2605:
2606: -- Bug 3010538 : New API for the Task Weighting Enhancement.
2607: -- This is a function that returns the task weighting basis code given the project id.
2608: FUNCTION GET_TASK_WEIGHTING_BASIS(
2609: p_project_id IN pa_projects_all.project_id%TYPE
2610: , p_structure_type IN VARCHAR2 := 'WORKPLAN' -- FPM Dev CR 3
2611: )
2612: RETURN VARCHAR2 IS
2613: -- This cursor obtains the task weight basis code for the project id.

Line 2614: Cursor cur_weight_basis_code (c_project_id pa_projects_all.project_id%TYPE)

2610: , p_structure_type IN VARCHAR2 := 'WORKPLAN' -- FPM Dev CR 3
2611: )
2612: RETURN VARCHAR2 IS
2613: -- This cursor obtains the task weight basis code for the project id.
2614: Cursor cur_weight_basis_code (c_project_id pa_projects_all.project_id%TYPE)
2615: Is
2616: Select ppa.task_weight_basis_code
2617: From pa_proj_progress_attr ppa,pa_proj_structure_types pst,pa_structure_types st
2618: Where ppa.project_id = c_project_id

Line 2980: --FROM pa_projects_all

2976:
2977: -- Bug 4372462 : written new cursor proj_all
2978: --CURSOR proj_all IS
2979: --SELECT project_currency_code, projfunc_currency_code
2980: --FROM pa_projects_all
2981: --WHERE project_id = p_project_id;
2982:
2983: CURSOR proj_all IS
2984: SELECT ppa.project_currency_code,

Line 2993: FROM pa_projects_all ppa,

2989: ppfo.projfunc_cost_rate_type,
2990: ppfo.projfunc_cost_rate_date_type,
2991: ppfo.projfunc_cost_rate_date,
2992: ppfo.proj_fp_options_id
2993: FROM pa_projects_all ppa,
2994: pa_proj_fp_options ppfo
2995: WHERE ppa.project_id = p_project_id
2996: and ppfo.fin_plan_type_id = (select fin_plan_type_id
2997: from pa_fin_plan_types_b

Line 3042: ,pa_projects_all ppa

3038: 'REVENUE',ppfo.revenue_time_phased_code,
3039: ppfo.all_time_phased_code) time_phase_code
3040: FROM gl_sets_of_books gsb
3041: ,pa_implementations_all pia
3042: ,pa_projects_all ppa
3043: ,pa_budget_versions pbv
3044: ,pa_proj_fp_options ppfo
3045: WHERE ppa.project_id = pbv.project_id
3046: AND pbv.budget_version_id = ppfo.fin_plan_version_id

Line 6239: SELECT project_currency_code from pa_projects_all where project_id=p_project_id;

6235:
6236: --bug 4308359, start
6237: CURSOR cur_proj_curr
6238: IS
6239: SELECT project_currency_code from pa_projects_all where project_id=p_project_id;
6240:
6241: l_prj_currency_code VARCHAR2(120);
6242: --bug 4308359, end
6243:

Line 6562: SELECT project_currency_code from pa_projects_all where project_id=p_project_id;

6558:
6559: --bug 3908112
6560: CURSOR cur_proj_curr
6561: IS
6562: SELECT project_currency_code from pa_projects_all where project_id=p_project_id;
6563:
6564: l_prj_currency_code VARCHAR2(120);
6565: --end bug 3908112
6566:

Line 7382: from pa_projects_all

7378: and object_id_to1 = p_fin_task_ver_id;
7379:
7380: cursor c3(p_project_id NUMBER) is
7381: select structure_sharing_code
7382: from pa_projects_all
7383: where project_id = p_project_id;
7384:
7385: BEGIN
7386:

Line 8385: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

8381: --End of variables for Variable for Resource Attributes
8382:
8383: l_task_id pa_tasks.task_id%TYPE := P_task_id; --bug 3860575, Satish
8384: l_top_task_id pa_tasks.task_id%TYPE;
8385: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
8386: l_project_type pa_projects_all.project_type%TYPE;
8387: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8388: l_org_id pa_projects_all.org_id%TYPE;
8389: l_expenditure_OU pa_projects_all.org_id%TYPE;

Line 8386: l_project_type pa_projects_all.project_type%TYPE;

8382:
8383: l_task_id pa_tasks.task_id%TYPE := P_task_id; --bug 3860575, Satish
8384: l_top_task_id pa_tasks.task_id%TYPE;
8385: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
8386: l_project_type pa_projects_all.project_type%TYPE;
8387: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8388: l_org_id pa_projects_all.org_id%TYPE;
8389: l_expenditure_OU pa_projects_all.org_id%TYPE;
8390: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

Line 8388: l_org_id pa_projects_all.org_id%TYPE;

8384: l_top_task_id pa_tasks.task_id%TYPE;
8385: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
8386: l_project_type pa_projects_all.project_type%TYPE;
8387: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8388: l_org_id pa_projects_all.org_id%TYPE;
8389: l_expenditure_OU pa_projects_all.org_id%TYPE;
8390: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8391: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8392: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;

Line 8389: l_expenditure_OU pa_projects_all.org_id%TYPE;

8385: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
8386: l_project_type pa_projects_all.project_type%TYPE;
8387: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8388: l_org_id pa_projects_all.org_id%TYPE;
8389: l_expenditure_OU pa_projects_all.org_id%TYPE;
8390: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8391: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8392: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8393: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;

Line 8876: FROM pa_projects_all

8872:
8873: /* Select the project Type */
8874: SELECT project_type, carrying_out_organization_id
8875: INTO l_project_type, l_carrying_out_org_id
8876: FROM pa_projects_all
8877: WHERE project_id = p_project_id;
8878:
8879:
8880: /* Select the resource name TO BE CHECKED

Line 9549: p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

9545: end derive_etc_values;
9546:
9547: function published_dlv_prog_exists
9548: (
9549: p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
9550: p_dlv_proj_elt_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
9551: )return VARCHAR2
9552: IS
9553: l_result VARCHAR2(1) ;

Line 11932: from pa_projects_all

11928: -- Begin fix for Bug # 4185974.
11929:
11930: cursor cur_proj_sharing_code is
11931: select structure_sharing_Code
11932: from pa_projects_all
11933: where project_id=p_project_id;
11934:
11935: l_project_sharing_code VARCHAR2(150);
11936:

Line 12968: pa_projects_all ppa,

12964:
12965: IF l_cal_type = 'G' THEN
12966: SELECT ftcn.calendar_id INTO l_cal_id
12967: FROM fii_time_cal_name ftcn,
12968: pa_projects_all ppa,
12969: pa_implementations_all pia,
12970: gl_sets_of_books gsb
12971: WHERE ppa.project_id=p_project_id
12972: AND ppa.org_id=pia.org_id

Line 12979: pa_projects_all ppa,

12975: AND gsb.accounted_period_type=ftcn.period_type;
12976: ELSIF l_cal_type = 'P' THEN
12977: SELECT ftcn.calendar_id INTO l_cal_id
12978: FROM fii_time_cal_name ftcn,
12979: pa_projects_all ppa,
12980: pa_implementations_all pia
12981: WHERE ppa.project_id=p_project_id
12982: AND ppa.org_id=pia.org_id
12983: AND pia.period_set_name=ftcn.period_set_name