336: ( (l_audit_log_val = 'MINIMAL') AND ( (l_action_key is NULL)
337: OR (l_action_key = 'WORKITEM_PURGE')) ) THEN
338: BEGIN
339: FORALL i in 1..l_task_det_rec.l_work_item_id_list.count SAVE EXCEPTIONS
340: insert into IEU_UWQM_AUDIT_LOG
341: (AUDIT_LOG_ID,
342: OBJECT_VERSION_NUMBER,
343: CREATED_BY,
344: CREATION_DATE,
393: ERROR_CODE,
394: LOGGING_LEVEL)
395: values
396: (
397: IEU_UWQM_AUDIT_LOG_S1.NEXTVAL,
398: 1,
399: FND_GLOBAL.USER_ID,
400: SYSDATE,
401: FND_GLOBAL.USER_ID,
573: ( (l_audit_log_val = 'MINIMAL') AND ( (l_action_key is NULL)
574: OR (l_action_key = 'WORKITEM_PURGE')) ) THEN
575: BEGIN
576: FORALL i in 1..l_task_det_rec.l_work_item_id_list.count SAVE EXCEPTIONS
577: insert into IEU_UWQM_AUDIT_LOG
578: (AUDIT_LOG_ID,
579: OBJECT_VERSION_NUMBER,
580: CREATED_BY,
581: CREATION_DATE,
630: ERROR_CODE,
631: LOGGING_LEVEL)
632: values
633: (
634: IEU_UWQM_AUDIT_LOG_S1.NEXTVAL,
635: 1,
636: FND_GLOBAL.USER_ID,
637: SYSDATE,
638: FND_GLOBAL.USER_ID,
792: ( (l_audit_log_val = 'MINIMAL') AND ( (l_action_key is NULL)
793: OR (l_action_key = 'WORKITEM_PURGE')) ) THEN
794: BEGIN
795: FORALL i in 1..l_task_det_rec.l_work_item_id_list.count SAVE EXCEPTIONS
796: insert into IEU_UWQM_AUDIT_LOG
797: (AUDIT_LOG_ID,
798: OBJECT_VERSION_NUMBER,
799: CREATED_BY,
800: CREATION_DATE,
849: ERROR_CODE,
850: LOGGING_LEVEL)
851: values
852: (
853: IEU_UWQM_AUDIT_LOG_S1.NEXTVAL,
854: 1,
855: FND_GLOBAL.USER_ID,
856: SYSDATE,
857: FND_GLOBAL.USER_ID,
966: IF ( (p_creation_date IS not null) AND (p_obj_code IS not null) )
967: THEN
968:
969: delete
970: from ieu_uwqm_audit_log
971: where workitem_pk_id in (select workitem_pk_id
972: from ieu_uwqm_audit_log
973: where trunc(to_date(creation_date, 'dd-mm-rrrr')) <=
974: trunc(to_date(p_creation_date, 'dd-mm-rrrr'))
968:
969: delete
970: from ieu_uwqm_audit_log
971: where workitem_pk_id in (select workitem_pk_id
972: from ieu_uwqm_audit_log
973: where trunc(to_date(creation_date, 'dd-mm-rrrr')) <=
974: trunc(to_date(p_creation_date, 'dd-mm-rrrr'))
975: and ((workitem_status_id_curr = 3) or (workitem_status_id_curr = 4)))
976: and workitem_obj_code = p_obj_code;