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 1701: -- modified the cusror to select from pa_projects_all

1697: x_action_code IN VARCHAR2 ) return VARCHAR2
1698: IS
1699: --
1700: -- Bug 940541
1701: -- modified the cusror to select from pa_projects_all
1702: -- since project_id is unique across operating units, it should
1703: -- be fine to select from pa_projects_all table.
1704:
1705: CURSOR l_project_csr IS

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

1699: --
1700: -- Bug 940541
1701: -- modified the cusror to select from pa_projects_all
1702: -- since project_id is unique across operating units, it should
1703: -- be fine to select from pa_projects_all table.
1704:
1705: CURSOR l_project_csr IS
1706: SELECT project_status_code
1707: FROM pa_projects_all pap

Line 1707: FROM pa_projects_all pap

1703: -- be fine to select from pa_projects_all table.
1704:
1705: CURSOR l_project_csr IS
1706: SELECT project_status_code
1707: FROM pa_projects_all pap
1708: WHERE pap.project_id = x_project_id;
1709: l_project_status_code VARCHAR2(30);
1710: l_action_allowed VARCHAR2(1) := 'N';
1711:

Line 1844: FROM PA_PROJECTS_ALL PP

1840: CURSOR C_schedule_in_use IS
1841: SELECT '1'
1842: FROM dual
1843: WHERE EXISTS (SELECT 'Y'
1844: FROM PA_PROJECTS_ALL PP
1845: WHERE PP.labor_tp_schedule_id=p_tp_schedule_id
1846: OR PP.nl_tp_schedule_id=p_tp_schedule_id
1847: )
1848: OR EXISTS

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

1881: --
1882: -- HISTORY
1883: -- 21-NOV-00 A.Layton Created
1884: --
1885: FUNCTION Is_Admin_Project (p_project_id IN pa_projects_all.project_id%TYPE)
1886: RETURN VARCHAR2
1887: IS
1888:
1889: l_admin_flag VARCHAR2(1);

Line 1895: pa_projects_all proj

1891: BEGIN
1892:
1893: SELECT administrative_flag INTO l_admin_flag
1894: FROM pa_project_types_all pt,
1895: pa_projects_all proj
1896: WHERE pt.project_type = proj.project_type
1897: --AND nvl(pt.org_id, -99) = nvl(proj.org_id, -99)
1898: AND pt.org_id = proj.org_id --avajain
1899: AND proj.project_id = p_project_id;

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

1916: --
1917: -- HISTORY
1918: -- 25-SEP-00 A.Layton Created
1919: --
1920: FUNCTION Is_Unassigned_Time_Project (p_project_id IN pa_projects_all.project_id%TYPE)
1921: RETURN VARCHAR2
1922: IS
1923:
1924: l_unassigned_time_flag VARCHAR2(1) := 'N';

Line 1930: pa_projects_all proj

1926: BEGIN
1927:
1928: SELECT pt.unassigned_time INTO l_unassigned_time_flag
1929: FROM pa_project_types_all pt,
1930: pa_projects_all proj
1931: WHERE pt.project_type = proj.project_type
1932: --AND nvl(pt.org_id, -99) = nvl(proj.org_id, -99)
1933: AND pt.org_id = proj.org_id
1934: AND proj.project_id = p_project_id;

Line 2065: from pa_projects_all

2061: p_rowid IN varchar2 ) return number
2062: is
2063: cursor c1 is
2064: select project_id
2065: from pa_projects_all
2066: where pm_project_reference = p_proj_ref
2067: and pm_product_code = p_prod_code -- added for bug 4870305
2068: AND (p_ROWID IS NULL OR p_ROWID <> pa_projects_all.ROWID);
2069:

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

2064: select project_id
2065: from pa_projects_all
2066: where pm_project_reference = p_proj_ref
2067: and pm_product_code = p_prod_code -- added for bug 4870305
2068: AND (p_ROWID IS NULL OR p_ROWID <> pa_projects_all.ROWID);
2069:
2070: c1_rec c1%rowtype;
2071:
2072: begin