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.PJM_TASK_AUTOASSIGN_COPY dependencies on PJM_DEFAULT_TASKS

Line 20: FROM pjm_default_tasks

16: ) RETURN NUMBER IS
17:
18: CURSOR c IS
19: SELECT task_id
20: FROM pjm_default_tasks
21: WHERE organization_id = P_Org_ID
22: AND project_id = P_Project_ID
23: AND assignment_type = P_Assignment_Type
24: AND inventory_item_id is null

Line 118: FROM pjm_default_tasks dt

114: , task_attribute12
115: , task_attribute13
116: , task_attribute14
117: , task_attribute15
118: FROM pjm_default_tasks dt
119: WHERE project_id = P_From_Project_ID
120: AND organization_id = nvl( P_Organization_ID , organization_id )
121: AND EXISTS (
122: --

Line 188: FROM pjm_default_tasks dt

184: , task_attribute12
185: , task_attribute13
186: , task_attribute14
187: , task_attribute15
188: FROM pjm_default_tasks dt
189: WHERE project_id = P_From_Project_ID
190: AND organization_id = nvl( P_Organization_ID , organization_id )
191: AND EXISTS (
192: --

Line 255: UPDATE pjm_default_tasks

251: -- existing rule if found
252: --
253: IF ( P_Copy_Option = 'REPLACE' ) THEN
254:
255: UPDATE pjm_default_tasks
256: SET task_id = TaskID
257: , last_update_date = SYSDATE
258: , last_updated_by = UserID
259: , last_update_login = LoginID

Line 284: INSERT INTO pjm_default_tasks

280: -- This is the default behavior for the "MERGE" copy option.
281: -- The UPDATE statement above already handles the copy of the
282: -- rule if existing rule is found.
283: --
284: INSERT INTO pjm_default_tasks
285: ( assignment_type
286: , project_id
287: , task_id
288: , organization_id

Line 362: FROM pjm_default_tasks

358: , DSrcRec.Task_Attribute15
359: FROM dual
360: WHERE NOT EXISTS (
361: SELECT NULL
362: FROM pjm_default_tasks
363: WHERE project_id = P_To_Project_ID
364: AND organization_id = DSrcRec.Organization_ID
365: AND assignment_type = DSrcRec.Assignment_Type
366: AND nvl(inventory_item_id , -1) = nvl(DSrcRec.Inventory_Item_ID , -1)

Line 413: UPDATE pjm_default_tasks

409: -- existing rule if found
410: --
411: IF ( P_Copy_Option = 'REPLACE' ) THEN
412:
413: UPDATE pjm_default_tasks
414: SET task_id = TaskID
415: , last_update_date = SYSDATE
416: , last_updated_by = UserID
417: , last_update_login = LoginID

Line 442: INSERT INTO pjm_default_tasks

438: -- This is the default behavior for the "MERGE" copy option.
439: -- The UPDATE statement above already handles the copy of the
440: -- rule if existing rule is found.
441: --
442: INSERT INTO pjm_default_tasks
443: ( assignment_type
444: , project_id
445: , task_id
446: , organization_id

Line 520: FROM pjm_default_tasks

516: , SrcRec.Task_Attribute15
517: FROM dual
518: WHERE NOT EXISTS (
519: SELECT NULL
520: FROM pjm_default_tasks
521: WHERE project_id = P_To_Project_ID
522: AND organization_id = SrcRec.Organization_ID
523: AND assignment_type = SrcRec.Assignment_Type
524: AND nvl(inventory_item_id , -1) = nvl(SrcRec.Inventory_Item_ID , -1)