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 1824: -- (segment1) that is passed in to fetch value of project_id from pa_projects

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

Line 2669: pa_projects p,

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

Line 2683: pa_projects p,

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

Line 2710: FROM pa_projects

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

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

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

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

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

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

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

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

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

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

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

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

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