eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_UTILS dependencies on CN_PROCESS_AUDITS

Line 434: cn_utils.appindcr(code, 'cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, ' || parent_audit_id || ',');

430: BEGIN
431: cn_debug.print_msg('record_process_start>>', 1);
432:
433: cn_utils.appindcr(code, 'x_proc_audit_id := NULL; -- Will get a value in the call below');
434: cn_utils.appindcr(code, 'cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, ' || parent_audit_id || ',');
435: cn_utils.appindcr(code, ' ''' || audit_type || ''',' || audit_desc || ', NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL,'||g_org_id||');');
436: --AE cn_utils.appindcr(code, 'COMMIT;');
437: cn_utils.appendcr(code);
438:

Line 457: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, 0, ' || message || ');');

453: code IN OUT NOCOPY cn_utils.code_type) IS
454: BEGIN
455: cn_debug.print_msg('record_process_status>>', 1);
456: -- Generate code to record success of the process
457: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, 0, ' || message || ');');
458: --AE cn_utils.appindcr(code, 'COMMIT;');
459: cn_utils.appendcr(code);
460: cn_debug.print_msg('record_process_success<<', 1);
461: END record_process_success;

Line 488: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, SQLCODE,');

484: ELSE
485: --AE cn_utils.appindcr(code, 'WHEN OTHERS THEN ROLLBACK;');
486: cn_utils.appindcr(code, 'WHEN OTHERS THEN ');
487: END IF;
488: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, SQLCODE,');
489: cn_utils.appindcr(code, ' SQLERRM);');
490: --AE cn_utils.appindcr(code, 'COMMIT;');
491: cn_utils.appendcr(code);
492:

Line 522: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, SQLCODE,');

518: ELSE
519: --AE cn_utils.appindcr(code, 'WHEN OTHERS THEN ROLLBACK;');
520: cn_utils.appindcr(code, 'WHEN OTHERS THEN ');
521: END IF;
522: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, SQLCODE,');
523: cn_utils.appindcr(code, ' SQLERRM);');
524: --AE cn_utils.appindcr(code, 'COMMIT;');
525: cn_utils.appendcr(code);
526:

Line 1581: RETURN cn_process_audits.process_audit_id%TYPE IS

1577:
1578:
1579:
1580: FUNCTION get_proc_audit_id
1581: RETURN cn_process_audits.process_audit_id%TYPE IS
1582: x_process_audit_id cn_process_audits.process_audit_id%TYPE;
1583: BEGIN
1584: SELECT cn_process_audits_s.NEXTVAL
1585: INTO x_process_audit_id

Line 1582: x_process_audit_id cn_process_audits.process_audit_id%TYPE;

1578:
1579:
1580: FUNCTION get_proc_audit_id
1581: RETURN cn_process_audits.process_audit_id%TYPE IS
1582: x_process_audit_id cn_process_audits.process_audit_id%TYPE;
1583: BEGIN
1584: SELECT cn_process_audits_s.NEXTVAL
1585: INTO x_process_audit_id
1586: FROM sys.dual;

Line 1584: SELECT cn_process_audits_s.NEXTVAL

1580: FUNCTION get_proc_audit_id
1581: RETURN cn_process_audits.process_audit_id%TYPE IS
1582: x_process_audit_id cn_process_audits.process_audit_id%TYPE;
1583: BEGIN
1584: SELECT cn_process_audits_s.NEXTVAL
1585: INTO x_process_audit_id
1586: FROM sys.dual;
1587: RETURN x_process_audit_id;
1588: END get_proc_audit_id;