[Home] [Help]
113: END IF;
114:
115: write_log('BIX Schema : ' || g_bix_schema);
116:
117: write_log('Truncating the table bix_email_details_f and bix_interactions_temp');
118: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_EMAIL_DETAILS_F');
119: Truncate_Table('BIX_EMAIL_DETAILS_F');
120: Truncate_Table('BIX_INTERACTIONS_TEMP');
121: write_log('Done truncating the table bix_email_details_f and bix_interactions_temp');
116:
117: write_log('Truncating the table bix_email_details_f and bix_interactions_temp');
118: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_EMAIL_DETAILS_F');
119: Truncate_Table('BIX_EMAIL_DETAILS_F');
120: Truncate_Table('BIX_INTERACTIONS_TEMP');
121: write_log('Done truncating the table bix_email_details_f and bix_interactions_temp');
122:
123: write_log('Setting the sore and hash are size');
124: execute immediate 'alter session set sort_area_size=104857600';
117: write_log('Truncating the table bix_email_details_f and bix_interactions_temp');
118: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_EMAIL_DETAILS_F');
119: Truncate_Table('BIX_EMAIL_DETAILS_F');
120: Truncate_Table('BIX_INTERACTIONS_TEMP');
121: write_log('Done truncating the table bix_email_details_f and bix_interactions_temp');
122:
123: write_log('Setting the sore and hash are size');
124: execute immediate 'alter session set sort_area_size=104857600';
125: execute immediate 'alter session set hash_area_size=104857600';
461: write_log('Total rows inserted/updated in bix_email_details_f for resolution : ' ||
462: to_char(l_root_interaction_id.COUNT));
463: g_rows_ins_upd := g_rows_ins_upd + (l_root_interaction_id.COUNT);
464:
465: /* Update the bix_interactions_temp table to keep track of depth by interaction */
466: --
467: --BIX_INTERACTION_TEMP is used for UPDATE program. This is used to keep track of
468: --whet we need to subtract - example yesterday an email might have been ONE AND DONE.
469: --Today the customer replies to it and it is no longer DONE. So we need to go back and subtract
469: --Today the customer replies to it and it is no longer DONE. So we need to go back and subtract
470: --yesterday's ONE AND DONE
471: --
472: FORALL i IN l_root_interaction_id.FIRST .. l_root_interaction_id.LAST
473: INSERT INTO BIX_INTERACTIONS_TEMP bit (
474: interaction_id,
475: created_by,
476: creation_date,
477: last_updated_by,
494: g_sysdate);
495:
496: COMMIT;
497:
498: write_log('Total rows inserted/updated in bix_interactions_temp : ' || to_char(l_root_interaction_id.COUNT));
499: g_rows_ins_upd := g_rows_ins_upd + l_root_interaction_id.COUNT;
500:
501: l_one_done_rsln.TRIM(l_no_of_records);
502: l_two_done_rsln.TRIM(l_no_of_records);
525:
526: BEGIN
527: write_log('Start of the procedure clean_up at ' || to_char(sysdate,'mm/dd/yyyy hh24:mi:ss'));
528:
529: write_log('Truncating the table bix_email_details_f and bix_interactions_temp');
530: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_EMAIL_DETAILS_F');
531: Truncate_Table('BIX_EMAIL_DETAILS_F');
532: Truncate_Table('BIX_INTERACTIONS_TEMP');
533: write_log('Done truncating the table bix_email_details_f and bix_interactions_temp');
528:
529: write_log('Truncating the table bix_email_details_f and bix_interactions_temp');
530: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_EMAIL_DETAILS_F');
531: Truncate_Table('BIX_EMAIL_DETAILS_F');
532: Truncate_Table('BIX_INTERACTIONS_TEMP');
533: write_log('Done truncating the table bix_email_details_f and bix_interactions_temp');
534:
535: write_log('Finished procedure clean_up at ' || to_char(sysdate,'mm/dd/yyyy hh24:mi:ss'));
536:
529: write_log('Truncating the table bix_email_details_f and bix_interactions_temp');
530: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_EMAIL_DETAILS_F');
531: Truncate_Table('BIX_EMAIL_DETAILS_F');
532: Truncate_Table('BIX_INTERACTIONS_TEMP');
533: write_log('Done truncating the table bix_email_details_f and bix_interactions_temp');
534:
535: write_log('Finished procedure clean_up at ' || to_char(sysdate,'mm/dd/yyyy hh24:mi:ss'));
536:
537: EXCEPTION