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.GMS_CLIENT_EXTN_BUDGET_WF dependencies on PA_PROJECTS

Line 226: FROM pa_projects

222: , description
223: , project_type
224: , pm_product_code
225: , carrying_out_organization_id
226: FROM pa_projects
227: WHERE project_id = p_project_id;
228: --
229:
230: CURSOR l_organization_csr ( p_carrying_out_organization_id NUMBER )

Line 322: l_pm_project_reference pa_projects.pm_project_reference%TYPE;

318: l_award_id gms_awards.award_id%TYPE;
319: l_award_number gms_awards.award_number%TYPE;
320: l_award_short_name gms_awards.award_short_name%TYPE;
321:
322: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
323: l_pa_project_number pa_projects.segment1%TYPE;
324: l_project_name pa_projects.name%TYPE;
325: l_description pa_projects.description%TYPE;
326: l_project_type pa_projects.project_type%TYPE;

Line 323: l_pa_project_number pa_projects.segment1%TYPE;

319: l_award_number gms_awards.award_number%TYPE;
320: l_award_short_name gms_awards.award_short_name%TYPE;
321:
322: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
323: l_pa_project_number pa_projects.segment1%TYPE;
324: l_project_name pa_projects.name%TYPE;
325: l_description pa_projects.description%TYPE;
326: l_project_type pa_projects.project_type%TYPE;
327: l_pm_project_product_code pa_projects.pm_product_code%TYPE;

Line 324: l_project_name pa_projects.name%TYPE;

320: l_award_short_name gms_awards.award_short_name%TYPE;
321:
322: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
323: l_pa_project_number pa_projects.segment1%TYPE;
324: l_project_name pa_projects.name%TYPE;
325: l_description pa_projects.description%TYPE;
326: l_project_type pa_projects.project_type%TYPE;
327: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
328: l_carrying_out_org_id NUMBER;

Line 325: l_description pa_projects.description%TYPE;

321:
322: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
323: l_pa_project_number pa_projects.segment1%TYPE;
324: l_project_name pa_projects.name%TYPE;
325: l_description pa_projects.description%TYPE;
326: l_project_type pa_projects.project_type%TYPE;
327: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
328: l_carrying_out_org_id NUMBER;
329: l_carrying_out_org_name hr_organization_units.name%TYPE;

Line 326: l_project_type pa_projects.project_type%TYPE;

322: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
323: l_pa_project_number pa_projects.segment1%TYPE;
324: l_project_name pa_projects.name%TYPE;
325: l_description pa_projects.description%TYPE;
326: l_project_type pa_projects.project_type%TYPE;
327: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
328: l_carrying_out_org_id NUMBER;
329: l_carrying_out_org_name hr_organization_units.name%TYPE;
330: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;

Line 327: l_pm_project_product_code pa_projects.pm_product_code%TYPE;

323: l_pa_project_number pa_projects.segment1%TYPE;
324: l_project_name pa_projects.name%TYPE;
325: l_description pa_projects.description%TYPE;
326: l_project_type pa_projects.project_type%TYPE;
327: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
328: l_carrying_out_org_id NUMBER;
329: l_carrying_out_org_name hr_organization_units.name%TYPE;
330: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
331:

Line 964: FROM pa_projects

960: , description
961: , project_type
962: , pm_product_code
963: , carrying_out_organization_id
964: FROM pa_projects
965: WHERE project_id = p_project_id;
966: --
967:
968: CURSOR l_organization_csr ( p_carrying_out_organization_id NUMBER )

Line 1060: l_pm_project_reference pa_projects.pm_project_reference%TYPE;

1056: l_award_id gms_awards.award_id%TYPE;
1057: l_award_number gms_awards.award_number%TYPE;
1058: l_award_short_name gms_awards.award_short_name%TYPE;
1059:
1060: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
1061: l_pa_project_number pa_projects.segment1%TYPE;
1062: l_project_name pa_projects.name%TYPE;
1063: l_description pa_projects.description%TYPE;
1064: l_project_type pa_projects.project_type%TYPE;

Line 1061: l_pa_project_number pa_projects.segment1%TYPE;

1057: l_award_number gms_awards.award_number%TYPE;
1058: l_award_short_name gms_awards.award_short_name%TYPE;
1059:
1060: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
1061: l_pa_project_number pa_projects.segment1%TYPE;
1062: l_project_name pa_projects.name%TYPE;
1063: l_description pa_projects.description%TYPE;
1064: l_project_type pa_projects.project_type%TYPE;
1065: l_pm_project_product_code pa_projects.pm_product_code%TYPE;

Line 1062: l_project_name pa_projects.name%TYPE;

1058: l_award_short_name gms_awards.award_short_name%TYPE;
1059:
1060: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
1061: l_pa_project_number pa_projects.segment1%TYPE;
1062: l_project_name pa_projects.name%TYPE;
1063: l_description pa_projects.description%TYPE;
1064: l_project_type pa_projects.project_type%TYPE;
1065: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
1066: l_carrying_out_org_id NUMBER;

Line 1063: l_description pa_projects.description%TYPE;

1059:
1060: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
1061: l_pa_project_number pa_projects.segment1%TYPE;
1062: l_project_name pa_projects.name%TYPE;
1063: l_description pa_projects.description%TYPE;
1064: l_project_type pa_projects.project_type%TYPE;
1065: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
1066: l_carrying_out_org_id NUMBER;
1067: l_carrying_out_org_name hr_organization_units.name%TYPE;

Line 1064: l_project_type pa_projects.project_type%TYPE;

1060: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
1061: l_pa_project_number pa_projects.segment1%TYPE;
1062: l_project_name pa_projects.name%TYPE;
1063: l_description pa_projects.description%TYPE;
1064: l_project_type pa_projects.project_type%TYPE;
1065: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
1066: l_carrying_out_org_id NUMBER;
1067: l_carrying_out_org_name hr_organization_units.name%TYPE;
1068: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;

Line 1065: l_pm_project_product_code pa_projects.pm_product_code%TYPE;

1061: l_pa_project_number pa_projects.segment1%TYPE;
1062: l_project_name pa_projects.name%TYPE;
1063: l_description pa_projects.description%TYPE;
1064: l_project_type pa_projects.project_type%TYPE;
1065: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
1066: l_carrying_out_org_id NUMBER;
1067: l_carrying_out_org_name hr_organization_units.name%TYPE;
1068: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1069: