APPS.XTR_AUDIT dependencies on XTR_TERM_ACTIONS

Line 47: XTR_TERM_ACTIONS_RETRIEVE(to_char(audit_requestion_id),

43: event_cur.EVENT,
44: l_date_from,
45: l_date_to );
46: else
47: XTR_TERM_ACTIONS_RETRIEVE(to_char(audit_requestion_id),
48: audit_requestion_id,
49: event_cur.EVENT,
50: l_date_from,
51: l_date_to );

Line 430: PROCEDURE XTR_TERM_ACTIONS_RETRIEVE(p_audit_requested_by IN VARCHAR2,

426: dbms_sql.close_cursor(v_cursor);
427: --
428: END XTR_AUDIT_RETRIEVE;
429:
430: PROCEDURE XTR_TERM_ACTIONS_RETRIEVE(p_audit_requested_by IN VARCHAR2,
431: p_audit_request_id IN NUMBER,
432: p_event_name IN VARCHAR2,
433: p_date_from IN VARCHAR2,
434: p_date_to IN VARCHAR2)

Line 460: 'XTR_TERM_ACTIONS',

456: sysdate,
457: to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS'),
458: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'),
459: null,
460: 'XTR_TERM_ACTIONS',
461: to_char(DEAL_NO) ||'|'||INCREASE_EFFECTIVE_FROM_DATE,
462: 'PRINCIPAL',
463: CREATED_ON,
464: CREATED_BY,

Line 469: from XTR_TERM_ACTIONS

465: null,
466: to_char(PRINCIPAL_ADJUST),
467: null,
468: null
469: from XTR_TERM_ACTIONS
470: where (CREATED_ON between to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS') and
471: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'))
472: and INCREASE_EFFECTIVE_FROM_DATE is not null
473: and PRINCIPAL_ADJUST is not null

Line 481: 'XTR_TERM_ACTIONS',

477: sysdate,
478: to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS'),
479: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'),
480: null,
481: 'XTR_TERM_ACTIONS',
482: to_char(DEAL_NO) ||'|'||EFFECTIVE_FROM_DATE,
483: 'INTEREST',
484: CREATED_ON,
485: CREATED_BY,

Line 490: from XTR_TERM_ACTIONS

486: null,
487: to_char(NEW_INTEREST_RATE),
488: null,
489: null
490: from XTR_TERM_ACTIONS
491: where (CREATED_ON between to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS') and
492: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'))
493: and EFFECTIVE_FROM_DATE is not null
494: and NEW_INTEREST_RATE is not null

Line 502: 'XTR_TERM_ACTIONS',

498: sysdate,
499: to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS'),
500: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'),
501: null,
502: 'XTR_TERM_ACTIONS',
503: to_char(DEAL_NO) ||'|'||FROM_START_DATE ,
504: 'SCHEDULE',
505: CREATED_ON,
506: CREATED_BY,

Line 511: from XTR_TERM_ACTIONS

507: null,
508: PAYMENT_SCHEDULE_CODE ,
509: null,
510: null
511: from XTR_TERM_ACTIONS
512: where (CREATED_ON between to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS') and
513: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'))
514: and FROM_START_DATE is not null
515: and PAYMENT_SCHEDULE_CODE is not null;

Line 518: END XTR_TERM_ACTIONS_RETRIEVE;

514: and FROM_START_DATE is not null
515: and PAYMENT_SCHEDULE_CODE is not null;
516:
517:
518: END XTR_TERM_ACTIONS_RETRIEVE;
519:
520:
521: PROCEDURE SUBMIT_AUDIT_REPORT( p_audit_request_id NUMBER,
522: p_event_group VARCHAR2,