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_ACTIONS_PVT dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 321: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEM_VER_SCHEDULE';

317: BULK COLLECT INTO l_element_version_id_tbl ;
318:
319:
320: IF p_debug_mode = 'Y' THEN
321: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEM_VER_SCHEDULE';
322: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
323: END IF;
324:
325: -- populate the element version table

Line 327: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(

323: END IF;
324:
325: -- populate the element version table
326: FORALL i in l_element_version_id_tbl.FIRST..l_element_version_id_tbl.LAST
327: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(
328: pev_schedule_id
329: ,element_version_id
330: ,project_id
331: ,proj_element_id

Line 345: pa_proj_elem_ver_schedule_s.nextval

341: ,source_object_type
342: )
343: VALUES
344: (
345: pa_proj_elem_ver_schedule_s.nextval
346: ,l_element_version_id_tbl(i)
347: ,nvl(p_project_id,-99)
348: ,l_proj_element_id_tbl(i)
349: ,SYSDATE

Line 596: UPDATE PA_PROJ_ELEM_VER_SCHEDULE

592: -- 1. Due Date (Shedule Finish Date)
593: -- 2. Completion Date (Actual Finish Date)
594:
595: FORALL i in p_element_version_id_tbl.FIRST..p_element_version_id_tbl.LAST
596: UPDATE PA_PROJ_ELEM_VER_SCHEDULE
597: SET scheduled_finish_date = p_due_date_tbl(i)
598: ,actual_finish_date = p_completion_date_tbl(i)
599: ,record_version_number = nvl(record_version_number,0) + 1
600: ,last_update_date = SYSDATE

Line 742: -- Delete from PA_PROJ_ELEM_VER_SCHEDULE Table

738: WHERE proj_element_id = l_proj_element_id_tbl(i)
739: RETURNING element_version_id
740: BULK COLLECT INTO l_elem_version_id_tbl;
741:
742: -- Delete from PA_PROJ_ELEM_VER_SCHEDULE Table
743:
744: /* Following Code has been commented for Performance Fix Bug # 3614361
745: Basing logic on Element Version Id will improve performance
746: in the below delete statement

Line 748: DELETE FROM pa_proj_elem_ver_schedule

744: /* Following Code has been commented for Performance Fix Bug # 3614361
745: Basing logic on Element Version Id will improve performance
746: in the below delete statement
747: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST
748: DELETE FROM pa_proj_elem_ver_schedule
749: WHERE proj_element_id = l_proj_element_id_tbl(i) ;
750: */
751:
752: -- Bug 3614361 Start

Line 754: DELETE FROM pa_proj_elem_ver_schedule

750: */
751:
752: -- Bug 3614361 Start
753: FORALL i in l_elem_version_id_tbl.FIRST..l_elem_version_id_tbl.LAST
754: DELETE FROM pa_proj_elem_ver_schedule
755: WHERE element_version_id = l_elem_version_id_tbl(i) ;
756: -- 3614361 End
757:
758: -- Delete from PA_OBJECT_RELATIONSHIPS table

Line 780: -- Delete the entries from PA_PROJ_ELEM_VER_SCHEDULE table

776: WHERE OBJECT_ID_TO2 = p_proj_element_id_tbl(i)
777: AND OBJECT_ID_FROM2 = p_object_id ;
778: END IF ;
779:
780: -- Delete the entries from PA_PROJ_ELEM_VER_SCHEDULE table
781: IF nvl(p_element_version_id_tbl.LAST,0)>0 THEN
782:
783: IF p_debug_mode = 'Y' THEN
784: pa_debug.g_err_stage:='Delete entries from PA_PROJ_ELEM_VER_SCHEDULE table' ;

Line 784: pa_debug.g_err_stage:='Delete entries from PA_PROJ_ELEM_VER_SCHEDULE table' ;

780: -- Delete the entries from PA_PROJ_ELEM_VER_SCHEDULE table
781: IF nvl(p_element_version_id_tbl.LAST,0)>0 THEN
782:
783: IF p_debug_mode = 'Y' THEN
784: pa_debug.g_err_stage:='Delete entries from PA_PROJ_ELEM_VER_SCHEDULE table' ;
785: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
786: END IF;
787:
788: FORALL i in p_element_version_id_tbl.FIRST..p_element_version_id_tbl.LAST

Line 789: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE

785: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
786: END IF;
787:
788: FORALL i in p_element_version_id_tbl.FIRST..p_element_version_id_tbl.LAST
789: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE
790: WHERE element_version_id = p_element_version_id_tbl(i) ;
791:
792: END IF ;
793:

Line 1070: -- Delete from PA_PROJ_ELEM_VER_SCHEDULE Table

1066: -- Delete from PA_PROJ_ELEMENT_VERSIONS Table
1067: DELETE FROM pa_proj_element_versions
1068: WHERE element_version_id = p_action_ver_id ;
1069:
1070: -- Delete from PA_PROJ_ELEM_VER_SCHEDULE Table
1071: DELETE FROM pa_proj_elem_ver_schedule
1072: WHERE element_version_id = p_action_ver_id ;
1073:
1074: -- Delete from PA_OBJECT_RELATIONSHIPS table

Line 1071: DELETE FROM pa_proj_elem_ver_schedule

1067: DELETE FROM pa_proj_element_versions
1068: WHERE element_version_id = p_action_ver_id ;
1069:
1070: -- Delete from PA_PROJ_ELEM_VER_SCHEDULE Table
1071: DELETE FROM pa_proj_elem_ver_schedule
1072: WHERE element_version_id = p_action_ver_id ;
1073:
1074: -- Delete from PA_OBJECT_RELATIONSHIPS table
1075: DELETE FROM PA_OBJECT_RELATIONSHIPS

Line 1347: pa_proj_elem_ver_schedule psc,

1343: ,pa_tasks_s.nextval -- Target Action Proj Element Id -- Included for Bug # 3431156
1344: ,null -- record version number
1345: FROM pa_proj_elements ppe,
1346: pa_proj_element_versions ppv,
1347: pa_proj_elem_ver_schedule psc,
1348: pa_object_relationships obj,
1349: pa_projects_all pa,
1350: pa_project_types_all ppt
1351: WHERE obj.object_id_from2 = p_source_object_id