APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_AUD_AUTO_AUDITS

Line 453: from AP_AUD_AUTO_AUDITS

449: p_audit_report OUT NOCOPY BOOLEAN) IS
450:
451: CURSOR audit_list_cur IS
452: select auto_audit_id
453: from AP_AUD_AUTO_AUDITS
454: where employee_id = p_employee_id
455: and TRUNC(SYSDATE)
456: BETWEEN TRUNC(NVL(START_DATE,SYSDATE))
457: AND TRUNC(NVL(END_DATE,SYSDATE));

Line 1245: FROM ap_aud_auto_audits

1241: employee_id,
1242: audit_reason_code,
1243: start_date,
1244: end_date
1245: FROM ap_aud_auto_audits
1246: WHERE employee_id = p_employee_id
1247: AND trunc(sysdate) between trunc(start_date) and trunc(NVL(end_date, sysdate))
1248: order by end_date desc;
1249:

Line 1286: UPDATE AP_AUD_AUTO_AUDITS

1282: OR open_dated = true
1283: ) THEN
1284: create_record := false;
1285: ELSE
1286: UPDATE AP_AUD_AUTO_AUDITS
1287: SET END_DATE = ld_end_date, START_DATE = ld_start_date
1288: WHERE AUTO_AUDIT_ID = audit_rec.auto_audit_id;
1289: END IF;
1290: END IF; -- record_exists = true

Line 1294: INSERT INTO AP_AUD_AUTO_AUDITS(

1290: END IF; -- record_exists = true
1291:
1292: IF create_record = true THEN
1293:
1294: INSERT INTO AP_AUD_AUTO_AUDITS(
1295: AUTO_AUDIT_ID,
1296: EMPLOYEE_ID,
1297: AUDIT_REASON_CODE,
1298: START_DATE,

Line 1306: AP_AUD_AUTO_AUDITS_S.nextval,

1302: LAST_UPDATE_LOGIN,
1303: LAST_UPDATE_DATE,
1304: LAST_UPDATED_BY)
1305: VALUES (
1306: AP_AUD_AUTO_AUDITS_S.nextval,
1307: p_employee_id,
1308: p_reason_code,
1309: SYSDATE,
1310: DECODE(p_duration,