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

Line 135: from pa_project_types_all t, pa_projects_all p -- Modified pa_projects and pa_project_types to pa_projects_all and pa_project_types_all for bug#3512486

131: where project_type = x_project_type;
132:
133: cursor c2 is
134: select project_type_class_code
135: from pa_project_types_all t, pa_projects_all p -- Modified pa_projects and pa_project_types to pa_projects_all and pa_project_types_all for bug#3512486
136: where p.project_id = x_project_id
137: and p.project_type = t.project_type
138: -- and nvl(p.org_id, -99) = nvl(t.org_id, -99); -- Added the and condition for bug#3512486
139: and p.org_id = t.org_id ;

Line 208: from pa_projects_all

204: x_rowid IN varchar2 ) return number
205: is
206: cursor c1 is
207: select project_id
208: from pa_projects_all
209: where name = x_project_name
210: AND (x_ROWID IS NULL OR x_ROWID <> pa_projects_all.ROWID);
211:
212: c1_rec c1%rowtype;

Line 210: AND (x_ROWID IS NULL OR x_ROWID <> pa_projects_all.ROWID);

206: cursor c1 is
207: select project_id
208: from pa_projects_all
209: where name = x_project_name
210: AND (x_ROWID IS NULL OR x_ROWID <> pa_projects_all.ROWID);
211:
212: c1_rec c1%rowtype;
213:
214: begin

Line 251: from pa_projects_all

247: x_rowid IN varchar2 ) return number
248: is
249: cursor c1 is
250: select project_id
251: from pa_projects_all
252: where long_name = x_long_name
253: AND (x_ROWID IS NULL OR x_ROWID <> pa_projects_all.ROWID);
254:
255: c1_rec c1%rowtype;

Line 253: AND (x_ROWID IS NULL OR x_ROWID <> pa_projects_all.ROWID);

249: cursor c1 is
250: select project_id
251: from pa_projects_all
252: where long_name = x_long_name
253: AND (x_ROWID IS NULL OR x_ROWID <> pa_projects_all.ROWID);
254:
255: c1_rec c1%rowtype;
256:
257: begin

Line 293: from pa_projects_all

289: x_rowid IN varchar2 ) return number
290: is
291: cursor c1 is
292: select project_id
293: from pa_projects_all
294: where segment1 = x_project_number
295: AND (x_ROWID IS NULL OR x_ROWID <> pa_projects_all.ROWID);
296:
297: c1_rec c1%rowtype;

Line 295: AND (x_ROWID IS NULL OR x_ROWID <> pa_projects_all.ROWID);

291: cursor c1 is
292: select project_id
293: from pa_projects_all
294: where segment1 = x_project_number
295: AND (x_ROWID IS NULL OR x_ROWID <> pa_projects_all.ROWID);
296:
297: c1_rec c1%rowtype;
298:
299: begin

Line 626: PA_PROJECTS_ALL PPA,

622: AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE_ACTIVE)
623: AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))
624: */
625: FROM PA_VALID_CATEGORIES_V VC,
626: PA_PROJECTS_ALL PPA,
627: PA_PROJECT_TYPES_ALL PPTA
628: WHERE VC.MANDATORY_FLAG = 'Y'
629: AND PPA.PROJECT_ID = x_project_id
630: AND PPA.PROJECT_TYPE = PPTA.PROJECT_TYPE

Line 758: -- by another project in pa_projects.created_from_project_id

754: -- FUNCTION
755: -- check_created_proj_reference
756: -- PURPOSE
757: -- This function returns 1 if a project is referenced
758: -- by another project in pa_projects.created_from_project_id
759: -- and returns 0 if a project is not referenced.
760: --
761: -- If Oracle error occured, Oracle error code is returned.
762: --

Line 772: FROM pa_projects

768: cursor c1 is
769: select 1
770: from sys.dual
771: where exists (SELECT null
772: FROM pa_projects
773: where created_from_project_id = x_project_id);
774:
775: c1_rec c1%rowtype;
776:

Line 850: FROM pa_projects_all ppa, pa_forecasting_options_all pfoa

846: -- Bug 5750591: Cursor to check whether the project_id passed is PJR Unassigned time project
847: l_temp_char VARCHAR2(1);
848: CURSOR c_is_unassigned_time_proj(l_project_id IN NUMBER) IS
849: SELECT 'Y'
850: FROM pa_projects_all ppa, pa_forecasting_options_all pfoa
851: WHERE ppa.project_id = l_project_id
852: AND ppa.org_id = pfoa.org_id
853: AND (pfoa.bill_unassign_proj_id = ppa.project_id OR pfoa.nonbill_unassign_proj_id = ppa.project_id);
854:

Line 1689: -- modified the cusror to select from pa_projects_all

1685: x_action_code IN VARCHAR2 ) return VARCHAR2
1686: IS
1687: --
1688: -- Bug 940541
1689: -- modified the cusror to select from pa_projects_all
1690: -- since project_id is unique across operating units, it should
1691: -- be fine to select from pa_projects_all table.
1692:
1693: CURSOR l_project_csr IS

Line 1691: -- be fine to select from pa_projects_all table.

1687: --
1688: -- Bug 940541
1689: -- modified the cusror to select from pa_projects_all
1690: -- since project_id is unique across operating units, it should
1691: -- be fine to select from pa_projects_all table.
1692:
1693: CURSOR l_project_csr IS
1694: SELECT project_status_code
1695: FROM pa_projects_all pap

Line 1695: FROM pa_projects_all pap

1691: -- be fine to select from pa_projects_all table.
1692:
1693: CURSOR l_project_csr IS
1694: SELECT project_status_code
1695: FROM pa_projects_all pap
1696: WHERE pap.project_id = x_project_id;
1697: l_project_status_code VARCHAR2(30);
1698: l_action_allowed VARCHAR2(1) := 'N';
1699:

Line 1832: FROM PA_PROJECTS_ALL PP

1828: CURSOR C_schedule_in_use IS
1829: SELECT '1'
1830: FROM dual
1831: WHERE EXISTS (SELECT 'Y'
1832: FROM PA_PROJECTS_ALL PP
1833: WHERE PP.labor_tp_schedule_id=p_tp_schedule_id
1834: OR PP.nl_tp_schedule_id=p_tp_schedule_id
1835: )
1836: OR EXISTS

Line 1873: FUNCTION Is_Admin_Project (p_project_id IN pa_projects_all.project_id%TYPE)

1869: --
1870: -- HISTORY
1871: -- 21-NOV-00 A.Layton Created
1872: --
1873: FUNCTION Is_Admin_Project (p_project_id IN pa_projects_all.project_id%TYPE)
1874: RETURN VARCHAR2
1875: IS
1876:
1877: l_admin_flag VARCHAR2(1);

Line 1883: pa_projects_all proj

1879: BEGIN
1880:
1881: SELECT administrative_flag INTO l_admin_flag
1882: FROM pa_project_types_all pt,
1883: pa_projects_all proj
1884: WHERE pt.project_type = proj.project_type
1885: --AND nvl(pt.org_id, -99) = nvl(proj.org_id, -99)
1886: AND pt.org_id = proj.org_id --avajain
1887: AND proj.project_id = p_project_id;

Line 1908: FUNCTION Is_Unassigned_Time_Project (p_project_id IN pa_projects_all.project_id%TYPE)

1904: --
1905: -- HISTORY
1906: -- 25-SEP-00 A.Layton Created
1907: --
1908: FUNCTION Is_Unassigned_Time_Project (p_project_id IN pa_projects_all.project_id%TYPE)
1909: RETURN VARCHAR2
1910: IS
1911:
1912: l_unassigned_time_flag VARCHAR2(1) := 'N';

Line 1918: pa_projects_all proj

1914: BEGIN
1915:
1916: SELECT pt.unassigned_time INTO l_unassigned_time_flag
1917: FROM pa_project_types_all pt,
1918: pa_projects_all proj
1919: WHERE pt.project_type = proj.project_type
1920: --AND nvl(pt.org_id, -99) = nvl(proj.org_id, -99)
1921: AND pt.org_id = proj.org_id
1922: AND proj.project_id = p_project_id;

Line 2053: from pa_projects_all

2049: p_rowid IN varchar2 ) return number
2050: is
2051: cursor c1 is
2052: select project_id
2053: from pa_projects_all
2054: where pm_project_reference = p_proj_ref
2055: and pm_product_code = p_prod_code -- added for bug 4870305
2056: AND (p_ROWID IS NULL OR p_ROWID <> pa_projects_all.ROWID);
2057:

Line 2056: AND (p_ROWID IS NULL OR p_ROWID <> pa_projects_all.ROWID);

2052: select project_id
2053: from pa_projects_all
2054: where pm_project_reference = p_proj_ref
2055: and pm_product_code = p_prod_code -- added for bug 4870305
2056: AND (p_ROWID IS NULL OR p_ROWID <> pa_projects_all.ROWID);
2057:
2058: c1_rec c1%rowtype;
2059:
2060: begin