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.BIX_DM_EMAIL_SUMMARY_PKG dependencies on BIX_DM_EMAIL_GROUP_SUM

Line 168: DELETE bix_dm_email_group_sum

164:
165: /* Delete from Email Group Summary tables */
166:
167: LOOP
168: DELETE bix_dm_email_group_sum
169: WHERE last_update_date > g_program_start_date
170: AND rownum <= g_commit_chunk_size ;
171:
172: IF(SQL%ROWCOUNT < g_commit_chunk_size) THEN

Line 1225: DELETE bix_dm_email_group_sum

1221: ' BIX_DM_EMAIL_SUMMARY_PKG.COLLECT_GROUP_SUMMARY: '||
1222: ' Start Deleting the rows from Agent Group Email summary table ');
1223:
1224: LOOP
1225: DELETE bix_dm_email_group_sum
1226: WHERE period_start_date_time BETWEEN g_rounded_collect_start_date
1227: AND g_rounded_collect_end_date
1228: AND rownum <= g_commit_chunk_size ;
1229:

Line 1249: INSERT INTO bix_dm_email_group_sum

1245: l_counter := 0;
1246:
1247: FOR group_emails IN group_email_sum LOOP
1248:
1249: INSERT INTO bix_dm_email_group_sum
1250: (
1251: email_group_summary_id,
1252: email_account_id,
1253: classification_id,

Line 1281: bix_dm_email_group_sum_s.nextval,

1277: program_update_date
1278: )
1279: VALUES
1280: (
1281: bix_dm_email_group_sum_s.nextval,
1282: group_emails.email_account_id,
1283: group_emails.classification_id,
1284: group_emails.group_id,
1285: group_emails.period_start_date,