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_ALTERNATE_TASK_PVT dependencies on PA_TASKS

Line 71: l_new_task_id PA_TASKS.TASK_ID%type;

67: X_Msg_Count OUT NOCOPY Number)
68: IS
69:
70: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
71: l_new_task_id PA_TASKS.TASK_ID%type;
72: l_count Number := -1;
73: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
74: l_attribute1 SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
75: l_attribute2 SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 175: select PA_TASKS_S.NEXTVAL INTO l_new_task_id from sys.dual;

171:
172: IF l_valid_status_tbl(i) = 'V' THEN -- Insert records which are valid
173: print_msg('Inside IF loop :: ');
174:
175: select PA_TASKS_S.NEXTVAL INTO l_new_task_id from sys.dual;
176:
177:
178: INSERT INTO PA_ALTERNATE_TASKS (
179: ALT_TASK_ID ,

Line 389: select project_id from pa_tasks where task_id =

385: AND r.cbs_element_id = (select cbs_element_id from pa_alternate_tasks where alt_task_id = c_Alt_Task_Id)
386: );
387:
388: cursor getProjectId(c_Alt_Task_Id IN NUMBER) IS
389: select project_id from pa_tasks where task_id =
390: (select proj_element_id from pa_alternate_tasks where alt_task_id = c_Alt_Task_Id);
391:
392: Cursor getTaskandCbsId(c_Alt_Task_Id IN NUMBER) IS
393: Select proj_element_id,cbs_element_id

Line 1334: and PPE1.Proj_element_id not in (Select pt.Task_Id from pa_tasks pt where pt.project_id=p_Source_Project_Id)

1330: Select distinct PPE1.Proj_element_id Source_Task_Id, PPE2.Proj_element_id Target_Task_Id
1331: From PA_PROJ_ELEMENTS PPE1, PA_PROJ_ELEMENTS PPE2
1332: Where PPE1.name=PPE2.name AND PPE1.Element_Number=PPE2.Element_Number AND
1333: PPE1.project_id=p_Source_Project_Id AND PPE2.project_id=p_Target_Project_Id
1334: and PPE1.Proj_element_id not in (Select pt.Task_Id from pa_tasks pt where pt.project_id=p_Source_Project_Id)
1335: and PPE2.Proj_element_id not in (Select pt.Task_Id from pa_tasks pt where pt.project_id=p_Target_Project_Id)
1336: and PPE1.OBJECT_TYPE=PPE2.OBJECT_TYPE and PPE1.OBJECT_TYPE='PA_TASKS'
1337: UNION
1338: Select distinct PPE1.task_id Source_Task_Id, PPE2.task_id Target_Task_Id

Line 1335: and PPE2.Proj_element_id not in (Select pt.Task_Id from pa_tasks pt where pt.project_id=p_Target_Project_Id)

1331: From PA_PROJ_ELEMENTS PPE1, PA_PROJ_ELEMENTS PPE2
1332: Where PPE1.name=PPE2.name AND PPE1.Element_Number=PPE2.Element_Number AND
1333: PPE1.project_id=p_Source_Project_Id AND PPE2.project_id=p_Target_Project_Id
1334: and PPE1.Proj_element_id not in (Select pt.Task_Id from pa_tasks pt where pt.project_id=p_Source_Project_Id)
1335: and PPE2.Proj_element_id not in (Select pt.Task_Id from pa_tasks pt where pt.project_id=p_Target_Project_Id)
1336: and PPE1.OBJECT_TYPE=PPE2.OBJECT_TYPE and PPE1.OBJECT_TYPE='PA_TASKS'
1337: UNION
1338: Select distinct PPE1.task_id Source_Task_Id, PPE2.task_id Target_Task_Id
1339: From PA_TASKS PPE1, PA_TASKS PPE2

Line 1336: and PPE1.OBJECT_TYPE=PPE2.OBJECT_TYPE and PPE1.OBJECT_TYPE='PA_TASKS'

1332: Where PPE1.name=PPE2.name AND PPE1.Element_Number=PPE2.Element_Number AND
1333: PPE1.project_id=p_Source_Project_Id AND PPE2.project_id=p_Target_Project_Id
1334: and PPE1.Proj_element_id not in (Select pt.Task_Id from pa_tasks pt where pt.project_id=p_Source_Project_Id)
1335: and PPE2.Proj_element_id not in (Select pt.Task_Id from pa_tasks pt where pt.project_id=p_Target_Project_Id)
1336: and PPE1.OBJECT_TYPE=PPE2.OBJECT_TYPE and PPE1.OBJECT_TYPE='PA_TASKS'
1337: UNION
1338: Select distinct PPE1.task_id Source_Task_Id, PPE2.task_id Target_Task_Id
1339: From PA_TASKS PPE1, PA_TASKS PPE2
1340: Where PPE1.task_name=PPE2.task_name AND PPE1.task_Number=PPE2.task_Number AND

Line 1339: From PA_TASKS PPE1, PA_TASKS PPE2

1335: and PPE2.Proj_element_id not in (Select pt.Task_Id from pa_tasks pt where pt.project_id=p_Target_Project_Id)
1336: and PPE1.OBJECT_TYPE=PPE2.OBJECT_TYPE and PPE1.OBJECT_TYPE='PA_TASKS'
1337: UNION
1338: Select distinct PPE1.task_id Source_Task_Id, PPE2.task_id Target_Task_Id
1339: From PA_TASKS PPE1, PA_TASKS PPE2
1340: Where PPE1.task_name=PPE2.task_name AND PPE1.task_Number=PPE2.task_Number AND
1341: PPE1.project_id=p_Source_Project_Id AND PPE2.project_id=p_Target_Project_Id;
1342:
1343: BEGIN