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 664: from pa_projects_all

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

Line 1142: FROM pa_projects_all

1138:
1139: CURSOR cur_pa_proj
1140: IS
1141: SELECT start_date, completion_date
1142: FROM pa_projects_all
1143: WHERE project_id = p_project_id;
1144:
1145:
1146: l_last_progress_date DATE;

Line 1264: FROM pa_projects_all

1260:
1261: CURSOR cur_pa_proj
1262: IS
1263: SELECT start_date, completion_date
1264: FROM pa_projects_all
1265: WHERE project_id = p_project_id;
1266:
1267: -- Bug 3974627 : Commented this cursor and added new ones
1268: /*

Line 2634: p_project_id IN pa_projects_all.project_id%TYPE

2630:
2631: -- Bug 3010538 : New API for the Task Weighting Enhancement.
2632: -- This is a function that returns the task weighting basis code given the project id.
2633: FUNCTION GET_TASK_WEIGHTING_BASIS(
2634: p_project_id IN pa_projects_all.project_id%TYPE
2635: , p_structure_type IN VARCHAR2 := 'WORKPLAN' -- FPM Dev CR 3
2636: )
2637: RETURN VARCHAR2 IS
2638: -- This cursor obtains the task weight basis code for the project id.

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

2635: , p_structure_type IN VARCHAR2 := 'WORKPLAN' -- FPM Dev CR 3
2636: )
2637: RETURN VARCHAR2 IS
2638: -- This cursor obtains the task weight basis code for the project id.
2639: Cursor cur_weight_basis_code (c_project_id pa_projects_all.project_id%TYPE)
2640: Is
2641: Select ppa.task_weight_basis_code
2642: From pa_proj_progress_attr ppa,pa_proj_structure_types pst,pa_structure_types st
2643: Where ppa.project_id = c_project_id

Line 3005: --FROM pa_projects_all

3001:
3002: -- Bug 4372462 : written new cursor proj_all
3003: --CURSOR proj_all IS
3004: --SELECT project_currency_code, projfunc_currency_code
3005: --FROM pa_projects_all
3006: --WHERE project_id = p_project_id;
3007:
3008: CURSOR proj_all IS
3009: SELECT ppa.project_currency_code,

Line 3018: FROM pa_projects_all ppa,

3014: ppfo.projfunc_cost_rate_type,
3015: ppfo.projfunc_cost_rate_date_type,
3016: ppfo.projfunc_cost_rate_date,
3017: ppfo.proj_fp_options_id
3018: FROM pa_projects_all ppa,
3019: pa_proj_fp_options ppfo
3020: WHERE ppa.project_id = p_project_id
3021: and ppfo.fin_plan_type_id = (select fin_plan_type_id
3022: from pa_fin_plan_types_b

Line 3067: ,pa_projects_all ppa

3063: 'REVENUE',ppfo.revenue_time_phased_code,
3064: ppfo.all_time_phased_code) time_phase_code
3065: FROM gl_sets_of_books gsb
3066: ,pa_implementations_all pia
3067: ,pa_projects_all ppa
3068: ,pa_budget_versions pbv
3069: ,pa_proj_fp_options ppfo
3070: WHERE ppa.project_id = pbv.project_id
3071: AND pbv.budget_version_id = ppfo.fin_plan_version_id

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

6270:
6271: --bug 4308359, start
6272: CURSOR cur_proj_curr
6273: IS
6274: SELECT project_currency_code from pa_projects_all where project_id=p_project_id;
6275:
6276: l_prj_currency_code VARCHAR2(120);
6277: --bug 4308359, end
6278:

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

6598:
6599: --bug 3908112
6600: CURSOR cur_proj_curr
6601: IS
6602: SELECT project_currency_code from pa_projects_all where project_id=p_project_id;
6603:
6604: l_prj_currency_code VARCHAR2(120);
6605: --end bug 3908112
6606:

Line 7422: from pa_projects_all

7418: and object_id_to1 = p_fin_task_ver_id;
7419:
7420: cursor c3(p_project_id NUMBER) is
7421: select structure_sharing_code
7422: from pa_projects_all
7423: where project_id = p_project_id;
7424:
7425: BEGIN
7426:

Line 8431: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;

8427: --End of variables for Variable for Resource Attributes
8428:
8429: l_task_id pa_tasks.task_id%TYPE := P_task_id; --bug 3860575, Satish
8430: l_top_task_id pa_tasks.task_id%TYPE;
8431: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
8432: l_project_type pa_projects_all.project_type%TYPE;
8433: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8434: l_org_id pa_projects_all.org_id%TYPE;
8435: l_expenditure_OU pa_projects_all.org_id%TYPE;

Line 8432: l_project_type pa_projects_all.project_type%TYPE;

8428:
8429: l_task_id pa_tasks.task_id%TYPE := P_task_id; --bug 3860575, Satish
8430: l_top_task_id pa_tasks.task_id%TYPE;
8431: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
8432: l_project_type pa_projects_all.project_type%TYPE;
8433: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8434: l_org_id pa_projects_all.org_id%TYPE;
8435: l_expenditure_OU pa_projects_all.org_id%TYPE;
8436: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

Line 8434: l_org_id pa_projects_all.org_id%TYPE;

8430: l_top_task_id pa_tasks.task_id%TYPE;
8431: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
8432: l_project_type pa_projects_all.project_type%TYPE;
8433: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8434: l_org_id pa_projects_all.org_id%TYPE;
8435: l_expenditure_OU pa_projects_all.org_id%TYPE;
8436: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8437: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8438: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;

Line 8435: l_expenditure_OU pa_projects_all.org_id%TYPE;

8431: l_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE;
8432: l_project_type pa_projects_all.project_type%TYPE;
8433: l_expenditure_type pa_resource_assignments.expenditure_type%TYPE;
8434: l_org_id pa_projects_all.org_id%TYPE;
8435: l_expenditure_OU pa_projects_all.org_id%TYPE;
8436: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8437: l_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE;
8438: l_nlr_organization_id pa_resource_assignments.organization_id%TYPE;
8439: l_rate_override_to_organz_id pa_resource_assignments.organization_id%TYPE;

Line 8932: FROM pa_projects_all

8928:
8929: /* Select the project Type */
8930: SELECT project_type, carrying_out_organization_id
8931: INTO l_project_type, l_carrying_out_org_id
8932: FROM pa_projects_all
8933: WHERE project_id = p_project_id;
8934:
8935:
8936: /* Select the resource name TO BE CHECKED

Line 9623: p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

9619: end derive_etc_values;
9620:
9621: function published_dlv_prog_exists
9622: (
9623: p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
9624: p_dlv_proj_elt_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
9625: )return VARCHAR2
9626: IS
9627: l_result VARCHAR2(1) ;

Line 12013: from pa_projects_all

12009: -- Begin fix for Bug # 4185974.
12010:
12011: cursor cur_proj_sharing_code is
12012: select structure_sharing_Code
12013: from pa_projects_all
12014: where project_id=p_project_id;
12015:
12016: l_project_sharing_code VARCHAR2(150);
12017:

Line 13065: pa_projects_all ppa,

13061:
13062: IF l_cal_type = 'G' THEN
13063: SELECT ftcn.calendar_id INTO l_cal_id
13064: FROM PA_time_cal_name ftcn, /* Modified for bug 12979524 */
13065: pa_projects_all ppa,
13066: pa_implementations_all pia,
13067: gl_sets_of_books gsb
13068: WHERE ppa.project_id=p_project_id
13069: AND ppa.org_id=pia.org_id

Line 13076: pa_projects_all ppa,

13072: AND gsb.accounted_period_type=ftcn.period_type;
13073: ELSIF l_cal_type = 'P' THEN
13074: SELECT ftcn.calendar_id INTO l_cal_id
13075: FROM pa_time_cal_name ftcn, /* Modified for bug 12979524 */
13076: pa_projects_all ppa,
13077: pa_implementations_all pia
13078: WHERE ppa.project_id=p_project_id
13079: AND ppa.org_id=pia.org_id
13080: AND pia.period_set_name=ftcn.period_set_name