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 423: PROCEDURE XTR_TERM_ACTIONS_RETRIEVE(p_audit_requested_by IN VARCHAR2,

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,
426: p_date_from IN VARCHAR2,
427: p_date_to IN VARCHAR2)

Line 453: 'XTR_TERM_ACTIONS',

449: sysdate,
450: to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS'),
451: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'),
452: null,
453: 'XTR_TERM_ACTIONS',
454: to_char(DEAL_NO) ||'|'||INCREASE_EFFECTIVE_FROM_DATE,
455: 'PRINCIPAL',
456: CREATED_ON,
457: CREATED_BY,

Line 462: from XTR_TERM_ACTIONS

458: null,
459: to_char(PRINCIPAL_ADJUST),
460: null,
461: null
462: from XTR_TERM_ACTIONS
463: where (CREATED_ON between to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS') and
464: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'))
465: and INCREASE_EFFECTIVE_FROM_DATE is not null
466: and PRINCIPAL_ADJUST is not null

Line 474: 'XTR_TERM_ACTIONS',

470: sysdate,
471: to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS'),
472: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'),
473: null,
474: 'XTR_TERM_ACTIONS',
475: to_char(DEAL_NO) ||'|'||EFFECTIVE_FROM_DATE,
476: 'INTEREST',
477: CREATED_ON,
478: CREATED_BY,

Line 483: from XTR_TERM_ACTIONS

479: null,
480: to_char(NEW_INTEREST_RATE),
481: null,
482: null
483: from XTR_TERM_ACTIONS
484: where (CREATED_ON between to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS') and
485: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'))
486: and EFFECTIVE_FROM_DATE is not null
487: and NEW_INTEREST_RATE is not null

Line 495: 'XTR_TERM_ACTIONS',

491: sysdate,
492: to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS'),
493: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'),
494: null,
495: 'XTR_TERM_ACTIONS',
496: to_char(DEAL_NO) ||'|'||FROM_START_DATE ,
497: 'SCHEDULE',
498: CREATED_ON,
499: CREATED_BY,

Line 504: from XTR_TERM_ACTIONS

500: null,
501: PAYMENT_SCHEDULE_CODE ,
502: null,
503: null
504: from XTR_TERM_ACTIONS
505: where (CREATED_ON between to_date(p_date_from,'DD/MM/YYYY HH24:MI:SS') and
506: to_date(p_date_to,'DD/MM/YYYY HH24:MI:SS'))
507: and FROM_START_DATE is not null
508: and PAYMENT_SCHEDULE_CODE is not null;

Line 511: END XTR_TERM_ACTIONS_RETRIEVE;

507: and FROM_START_DATE is not null
508: and PAYMENT_SCHEDULE_CODE is not null;
509:
510:
511: END XTR_TERM_ACTIONS_RETRIEVE;
512:
513:
514: PROCEDURE SUBMIT_AUDIT_REPORT( p_audit_request_id NUMBER,
515: p_event_group VARCHAR2,