APPS.XTR_AUDIT dependencies on XTR_AUDIT

Line 1: PACKAGE BODY XTR_AUDIT AS

1: PACKAGE BODY XTR_AUDIT AS
2: /* $Header: xtraudtb.pls 120.5 2005/06/29 05:51:36 badiredd ship $ */
3:
4:
5:

Line 6: PROCEDURE XTR_AUDIT_REPORT(

2: /* $Header: xtraudtb.pls 120.5 2005/06/29 05:51:36 badiredd ship $ */
3:
4:
5:
6: PROCEDURE XTR_AUDIT_REPORT(
7: errbuf OUT NOCOPY VARCHAR2,
8: retcode OUT NOCOPY VARCHAR2,
9: p_event_group VARCHAR2,
10: p_audit_from_date VARCHAR2,

Line 16: from XTR_AUDIT_GROUPS

12: IS
13:
14: cursor AUDIT_EVENTS is
15: select EVENT
16: from XTR_AUDIT_GROUPS
17: where GROUP_CODE = p_event_group
18: and EVENT <> 'AUDIT_GROUP_CODE_ROW';
19:
20: cursor NEW_REQUEST is

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 41: XTR_AUDIT_RETRIEVE( to_char(fnd_global.user_id),

37:
38: FOR event_cur in AUDIT_EVENTS LOOP
39: --dbms_output.put_line('event = '|| event_cur.EVENT);
40: if event_cur.EVENT <> 'TERM DEPOSIT/ADVANCE ADJUSTMENTS' then
41: XTR_AUDIT_RETRIEVE( to_char(fnd_global.user_id),
42: audit_requestion_id,
43: event_cur.EVENT,
44: l_date_from,
45: l_date_to );

Line 57: END XTR_AUDIT_REPORT;

53: END LOOP;
54:
55: SUBMIT_AUDIT_REPORT(to_char(audit_requestion_id),p_event_group, p_audit_from_date, p_audit_to_date );
56:
57: END XTR_AUDIT_REPORT;
58:
59: PROCEDURE XTR_AUDIT_RETRIEVE(p_audit_requested_by IN VARCHAR2,
60: p_audit_request_id IN NUMBER,
61: p_event_name IN VARCHAR2,

Line 59: PROCEDURE XTR_AUDIT_RETRIEVE(p_audit_requested_by IN VARCHAR2,

55: SUBMIT_AUDIT_REPORT(to_char(audit_requestion_id),p_event_group, p_audit_from_date, p_audit_to_date );
56:
57: END XTR_AUDIT_REPORT;
58:
59: PROCEDURE XTR_AUDIT_RETRIEVE(p_audit_requested_by IN VARCHAR2,
60: p_audit_request_id IN NUMBER,
61: p_event_name IN VARCHAR2,
62: p_date_from IN VARCHAR2,
63: p_date_to IN VARCHAR2) is

Line 68: v_table_column xtr_audit_columns_v.table_column%TYPE;

64:
65: native constant integer := 1;
66: V_MAX_COL constant integer := 60;
67: v_counter binary_integer;
68: v_table_column xtr_audit_columns_v.table_column%TYPE;
69: v_select varchar2(4000);
70: v_num_col integer;
71: v_sql varchar2(4000);
72: v_rec_num binary_integer := 1;

Line 124: from XTR_AUDIT_COLUMNS

120: upper(nvl(p_key_yn,'N')),
121: upper(column_type)
122: --* Bug#3121210, rravunny
123: --*decode(event,'INTERGROUP TRANSFERS',decode(nvl(P_KEY_YN, 'N'),'Y',decode(table_column,'DEAL_NUMBER',1,'TRANSACTION_NUMBER',1,0),0),0)
124: from XTR_AUDIT_COLUMNS
125: where event = pc_event
126: and ( nvl(audit_yn, 'N') = 'Y' or
127: nvl(P_KEY_YN, 'N') = 'Y' )
128: --* Bug#3121210, rravunny

Line 332: insert into XTR_AUDIT_SUMMARY(

328: -- Insert any differences between individual columns
329: --
330: FOR v_counter IN 1..v_num_col LOOP
331: IF nvl(v_old(v_counter),'JJ') <> nvl(v_new(v_counter),'JJ') THEN
332: insert into XTR_AUDIT_SUMMARY(
333: AUDIT_REQUESTED_BY,
334: AUDIT_REQUEST_ID,
335: AUDIT_REQUESTED_ON,
336: AUDIT_RECORDS_FROM,

Line 372: insert into XTR_AUDIT_SUMMARY(

368:
369: IF v_new_created_on between
370: to_date(p_date_from, 'DD/MM/YYYY HH24:MI:SS') and
371: to_date(p_date_to , 'DD/MM/YYYY HH24:MI:SS') THEN
372: insert into XTR_AUDIT_SUMMARY(
373: AUDIT_REQUESTED_BY,
374: AUDIT_REQUEST_ID,
375: AUDIT_REQUESTED_ON,
376: AUDIT_RECORDS_FROM,

Line 421: END XTR_AUDIT_RETRIEVE;

417: v_rec_num := v_rec_num + 1;
418: END LOOP;
419: dbms_sql.close_cursor(v_cursor);
420: --
421: END XTR_AUDIT_RETRIEVE;
422:
423: PROCEDURE XTR_TERM_ACTIONS_RETRIEVE(p_audit_requested_by IN VARCHAR2,
424: p_audit_request_id IN NUMBER,
425: p_event_name IN VARCHAR2,

Line 431: insert into XTR_AUDIT_SUMMARY(

427: p_date_to IN VARCHAR2)
428: IS
429: BEGIN
430:
431: insert into XTR_AUDIT_SUMMARY(
432: AUDIT_REQUESTED_BY,
433: AUDIT_REQUEST_ID,
434: AUDIT_REQUESTED_ON,
435: AUDIT_RECORDS_FROM,

Line 596: END XTR_AUDIT;

592: END IF;
593:
594: END SUBMIT_AUDIT_REPORT;
595:
596: END XTR_AUDIT;