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_BUDGET_PUB dependencies on PA_PROJECTS

Line 59: from pa_projects

55:
56: cursor l_project_id_csr(p_project_id_in NUMBER)
57: IS
58: select 'X'
59: from pa_projects
60: where project_id = p_project_id_in;
61:
62: cursor l_project_number_csr(p_project_number_in VARCHAR2)
63: is

Line 65: from pa_projects

61:
62: cursor l_project_number_csr(p_project_number_in VARCHAR2)
63: is
64: select project_id
65: from pa_projects
66: where segment1 = p_project_number_in;
67:
68: l_dummy VARCHAR2(1);
69: l_old_stack VARCHAR2(630);

Line 1086: from pa_projects

1082:
1083: -- Added for Bug: 2269791
1084: select segment1
1085: into x_project_number
1086: from pa_projects
1087: where project_id = x_project_id;
1088:
1089: select time_phased_type_code, categorization_code
1090: into x_period_type, x_categorization_code

Line 1823: -- (segment1) that is passed in to fetch value of project_id from pa_projects

1819:
1820:
1821: --------------------------------------------------------------------------------
1822: -- If project_id is passed in then use it otherwise use the project_number
1823: -- (segment1) that is passed in to fetch value of project_id from pa_projects
1824: -- table. If both are missing then raise an error.
1825:
1826: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
1827: AND p_project_number IS NOT NULL)

Line 2668: pa_projects p,

2664: IS
2665: SELECT v.resource_list_id,
2666: t.project_type_class_code
2667: FROM pa_project_types t,
2668: pa_projects p,
2669: gms_budget_versions v
2670: WHERE v.budget_version_id = p_draft_version_id
2671: AND v.project_id = p.project_id
2672: AND p.project_type = t.project_type;

Line 2682: pa_projects p,

2678: SELECT v.resource_list_id,
2679: t.project_type_class_code,
2680: prl.group_resource_type_id
2681: FROM pa_project_types t,
2682: pa_projects p,
2683: pa_resource_lists prl,
2684: gms_budget_versions v
2685: WHERE v.budget_version_id = p_draft_version_id
2686: AND v.project_id = p.project_id

Line 2709: FROM pa_projects

2705:
2706: CURSOR l_project_csr(p_project_id IN NUMBER)
2707: IS
2708: SELECT segment1
2709: FROM pa_projects
2710: WHERE project_id = p_project_id;
2711:
2712: CURSOR l_wf_notif_role_csr(p_award_id IN NUMBER)
2713: IS

Line 2920: -- (segment1) that is passed in to fetch value of project_id from pa_projects

2916: p_workflow_started := 'N';
2917: ------------------------------------------------------------------------------------
2918:
2919: -- If project_id is passed in then use it otherwise use the project_number
2920: -- (segment1) that is passed in to fetch value of project_id from pa_projects
2921: -- table. If both are missing then raise an error.
2922:
2923: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
2924: AND p_project_number IS NOT NULL)

Line 4341: -- (segment1) that is passed in to fetch value of project_id from pa_projects

4337: --------------------------------------------------------------------------------
4338: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after award info validation');
4339:
4340: -- If project_id is passed in then use it otherwise use the project_number
4341: -- (segment1) that is passed in to fetch value of project_id from pa_projects
4342: -- table. If both are missing then raise an error.
4343:
4344: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
4345: AND p_project_number IS NOT NULL)

Line 5283: -- (segment1) that is passed in to fetch value of project_id from pa_projects

5279:
5280: -----------------------------------------------------------------------------
5281:
5282: -- If project_id is passed in then use it otherwise use the project_number
5283: -- (segment1) that is passed in to fetch value of project_id from pa_projects
5284: -- table. If both are missing then raise an error.
5285:
5286: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5287: AND p_project_number IS NOT NULL)

Line 5737: -- (segment1) that is passed in to fetch value of project_id from pa_projects

5733:
5734: -----------------------------------------------------------------------------
5735:
5736: -- If project_id is passed in then use it otherwise use the project_number
5737: -- (segment1) that is passed in to fetch value of project_id from pa_projects
5738: -- table. If both are missing then raise an error.
5739:
5740: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5741: AND p_project_number IS NOT NULL)

Line 6520: -- (segment1) that is passed in to fetch value of project_id from pa_projects

6516:
6517: ---------------------------------------------------------------------------
6518:
6519: -- If project_id is passed in then use it otherwise use the project_number
6520: -- (segment1) that is passed in to fetch value of project_id from pa_projects
6521: -- table. If both are missing then raise an error.
6522:
6523: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
6524: AND p_project_number IS NOT NULL)

Line 7202: -- (segment1) that is passed in to fetch value of project_id from pa_projects

7198:
7199: --------------------------------------------------------------------------------
7200:
7201: -- If project_id is passed in then use it otherwise use the project_number
7202: -- (segment1) that is passed in to fetch value of project_id from pa_projects
7203: -- table. If both are missing then raise an error.
7204:
7205: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
7206: AND p_project_number IS NOT NULL)