APPS.XTR_AUDIT dependencies on XTR_AUDIT_SUMMARY

Line 21: select XTR_AUDIT_SUMMARY_S.nextval

17: where GROUP_CODE = p_event_group
18: and EVENT <> 'AUDIT_GROUP_CODE_ROW';
19:
20: cursor NEW_REQUEST is
21: select XTR_AUDIT_SUMMARY_S.nextval
22: from dual;
23:
24:
25: audit_requestion_id NUMBER := 999;

Line 339: insert into XTR_AUDIT_SUMMARY(

335: -- Insert any differences between individual columns
336: --
337: FOR v_counter IN 1..v_num_col LOOP
338: IF nvl(v_old(v_counter),'JJ') <> nvl(v_new(v_counter),'JJ') THEN
339: insert into XTR_AUDIT_SUMMARY(
340: AUDIT_REQUESTED_BY,
341: AUDIT_REQUEST_ID,
342: AUDIT_REQUESTED_ON,
343: AUDIT_RECORDS_FROM,

Line 379: insert into XTR_AUDIT_SUMMARY(

375:
376: IF v_new_created_on between
377: to_date(p_date_from, 'DD/MM/YYYY HH24:MI:SS') and
378: to_date(p_date_to , 'DD/MM/YYYY HH24:MI:SS') THEN
379: insert into XTR_AUDIT_SUMMARY(
380: AUDIT_REQUESTED_BY,
381: AUDIT_REQUEST_ID,
382: AUDIT_REQUESTED_ON,
383: AUDIT_RECORDS_FROM,

Line 438: insert into XTR_AUDIT_SUMMARY(

434: p_date_to IN VARCHAR2)
435: IS
436: BEGIN
437:
438: insert into XTR_AUDIT_SUMMARY(
439: AUDIT_REQUESTED_BY,
440: AUDIT_REQUEST_ID,
441: AUDIT_REQUESTED_ON,
442: AUDIT_RECORDS_FROM,