DBA Data[Home] [Help]

APPS.IEU_WR_CON_PVT dependencies on IEU_UWQM_AUDIT_LOG

Line 340: insert into IEU_UWQM_AUDIT_LOG

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,

Line 397: IEU_UWQM_AUDIT_LOG_S1.NEXTVAL,

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,

Line 577: insert into IEU_UWQM_AUDIT_LOG

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,

Line 634: IEU_UWQM_AUDIT_LOG_S1.NEXTVAL,

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,

Line 796: insert into IEU_UWQM_AUDIT_LOG

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,

Line 853: IEU_UWQM_AUDIT_LOG_S1.NEXTVAL,

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,

Line 970: from ieu_uwqm_audit_log

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'))

Line 972: from ieu_uwqm_audit_log

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;