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_PURGE_TABLES_PVT dependencies on CN_ARC_AUDIT_ALL

Line 2896: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;

2892: elsif (p_run_mode = 'P') Then
2893: l_run_mode := 'PURGE';
2894: end if;
2895:
2896: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;
2897: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables: l_cn_archive_all_s : ' || l_cn_archive_all_s);
2898: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables before archive_cn_tables_transactions ');
2899:
2900: archive_cn_tables_transactions ( p_start_period_id => p_start_period_id,

Line 2969: INTO cn_arc_audit_all

2965: END IF;
2966:
2967:
2968: INSERT
2969: INTO cn_arc_audit_all
2970: (ARCHIVE_PURGE_ID,TOT_AP_TABLES_COUNT,TOT_AP_ROWS,ARCHIVE_PURGE_DATE,START_PERIOD_ID,END_PERIOD_ID,ORG_ID,RUN_MODE,
2971: ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2972: VALUES
2973: (

Line 3039: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;

3035: elsif (p_run_mode = 'P') Then
3036: l_run_mode := 'PURGE';
3037: end if;
3038:
3039: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;
3040:
3041: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables: l_cn_archive_all_s : ' || l_cn_archive_all_s);
3042:
3043:

Line 3173: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;

3169:
3170: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: x_start_date: ' || x_start_date);
3171: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: x_end_date: ' || x_end_date);
3172:
3173: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;
3174:
3175: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: l_cn_archive_all_s : ' || l_cn_archive_all_s);
3176:
3177:

Line 3254: INTO cn_arc_audit_all

3250: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: x_return_status : ' || x_return_status);
3251:
3252:
3253: INSERT
3254: INTO cn_arc_audit_all
3255: (ARCHIVE_PURGE_ID,TOT_AP_TABLES_COUNT,TOT_AP_ROWS,ARCHIVE_PURGE_DATE,START_PERIOD_ID,END_PERIOD_ID,ORG_ID,RUN_MODE,
3256: ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
3257: VALUES
3258: (