APPS.PA_PROJECT_PUB dependencies on PA_PJI_PROJ_EVENTS_LOG

Line 43128: delete from PA_PJI_PROJ_EVENTS_LOG where event_type = 'DEFER_ROLLUP'

43124: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE=null where project_id=p_project_id
43125: and DEFER_CODE is not null AND parent_structure_version_id=p_structure_version_id;
43126: --Added for bug 16444969
43127: begin
43128: delete from PA_PJI_PROJ_EVENTS_LOG where event_type = 'DEFER_ROLLUP'
43129: and event_object = p_project_id and attribute4=p_structure_version_id;
43130: EXCEPTION
43131: when OTHERS then
43132: null;

Line 43140: for i in (select event_object, event_id, attribute4 from PA_PJI_PROJ_EVENTS_LOG where event_type = 'DEFER_ROLLUP')

43136: commit;
43137: END IF;
43138:
43139: else
43140: for i in (select event_object, event_id, attribute4 from PA_PJI_PROJ_EVENTS_LOG where event_type = 'DEFER_ROLLUP')
43141: loop
43142: PA_TASK_PVT1.Defer_Calc_Task_Weigthage (
43143: p_init_msg_list => p_init_msg_list
43144: ,p_commit => FND_API.G_FALSE

Line 43201: delete from PA_PJI_PROJ_EVENTS_LOG where event_type = 'DEFER_ROLLUP' and event_id = i.event_id

43197:
43198:
43199:
43200:
43201: delete from PA_PJI_PROJ_EVENTS_LOG where event_type = 'DEFER_ROLLUP' and event_id = i.event_id
43202: and event_object = i.event_object;
43203:
43204: IF(p_commit=FND_API.G_TRUE) THEN
43205: commit;