APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_AUD_AUTO_AUDITS

Line 513: from AP_AUD_AUTO_AUDITS

509: p_audit_report OUT NOCOPY BOOLEAN) IS
510:
511: CURSOR audit_list_cur IS
512: select auto_audit_id
513: from AP_AUD_AUTO_AUDITS
514: where employee_id = p_employee_id
515: and TRUNC(SYSDATE)
516: BETWEEN TRUNC(NVL(START_DATE,SYSDATE))
517: AND TRUNC(NVL(END_DATE,SYSDATE));

Line 1365: FROM ap_aud_auto_audits

1361: employee_id,
1362: audit_reason_code,
1363: start_date,
1364: end_date
1365: FROM ap_aud_auto_audits
1366: WHERE employee_id = p_employee_id
1367: AND trunc(sysdate) between trunc(start_date) and trunc(NVL(end_date, sysdate))
1368: order by end_date desc;
1369:

Line 1404: UPDATE AP_AUD_AUTO_AUDITS

1400: OR open_dated = true
1401: ) THEN
1402: create_record := false;
1403: ELSE
1404: UPDATE AP_AUD_AUTO_AUDITS
1405: SET END_DATE = ld_end_date, START_DATE = ld_start_date
1406: WHERE AUTO_AUDIT_ID = audit_rec.auto_audit_id;
1407: END IF;
1408: END IF; -- record_exists = true

Line 1411: INSERT INTO AP_AUD_AUTO_AUDITS(

1407: END IF;
1408: END IF; -- record_exists = true
1409:
1410: IF create_record = true THEN
1411: INSERT INTO AP_AUD_AUTO_AUDITS(
1412: AUTO_AUDIT_ID,
1413: EMPLOYEE_ID,
1414: AUDIT_REASON_CODE,
1415: START_DATE,

Line 1423: AP_AUD_AUTO_AUDITS_S.nextval,

1419: LAST_UPDATE_LOGIN,
1420: LAST_UPDATE_DATE,
1421: LAST_UPDATED_BY)
1422: VALUES (
1423: AP_AUD_AUTO_AUDITS_S.nextval,
1424: p_employee_id,
1425: p_reason_code,
1426: SYSDATE,
1427: DECODE(p_duration,