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_CALL_UPDATE_PKG dependencies on BIX_CALL_DETAILS_STG

Line 964: truncate_table('BIX_CALL_DETAILS_STG');

960: --IF (g_debug_flag = 'Y') THEN
961: --write_log('Number of rows deleted from BIX_CALL_DETAILS_F : ' || to_char(l_total_rows_deleted));
962: --END IF;
963:
964: truncate_table('BIX_CALL_DETAILS_STG');
965: --truncate_table('BIX_CALL_PROCESSED_RECS');
966: --IF (g_debug_flag = 'Y') THEN
967: --write_log('Done truncating bix_call_details_stg
968: --and bix_call_processed_recs');

Line 967: --write_log('Done truncating bix_call_details_stg

963:
964: truncate_table('BIX_CALL_DETAILS_STG');
965: --truncate_table('BIX_CALL_PROCESSED_RECS');
966: --IF (g_debug_flag = 'Y') THEN
967: --write_log('Done truncating bix_call_details_stg
968: --and bix_call_processed_recs');
969: --
970: --write_log('Finished procedure clean_up at ' ||
971: --to_char(sysdate,'mm/dd/yyyy hh24:mi:ss'));

Line 4052: INTO bix_call_details_stg STG

4048: --end loop;
4049:
4050: FORALL k IN 1 .. counter
4051: INSERT /*+ APPEND */
4052: INTO bix_call_details_stg STG
4053: (
4054: time_id ,
4055: period_type_id ,
4056: period_start_date ,

Line 4176: MERGE INTO BIX_CALL_DETAILS_STG STG

4172: l_target_record.agentcall_contact_count(k)
4173: )
4174: ;
4175: /****
4176: MERGE INTO BIX_CALL_DETAILS_STG STG
4177: USING (
4178: SELECT
4179: --l_target_record.media_id(k) media_id,
4180: to_char(l_target_record.period_start_date(k),'J') time_id,

Line 4718: FROM bix_call_details_stg stg

4714: SUM(AGENTCALL_ORR_COUNT) AGENTCALL_ORR_COUNT,
4715: SUM(AGENTCALL_PR_COUNT) AGENTCALL_PR_COUNT,
4716: SUM(AGENTCALL_CONTACT_COUNT) AGENTCALL_CONTACT_COUNT,
4717: NVL(SUM(AGENT_CONT_CALLS_HAND_NA),-1) AGENT_CONT_CALLS_HAND_NA
4718: FROM bix_call_details_stg stg
4719: GROUP BY
4720: TIME_ID,
4721: PERIOD_TYPE_ID,
4722: PERIOD_START_DATE,

Line 4808: FROM bix_call_details_stg stg

4804: --decode(period_type_id,-1,SUM(AGENT_CONT_CALLS_HAND_NA),-1) AGENT_CONT_CALLS_HAND_NA,
4805: --decode(period_type_id,-1,SUM(AGENT_CONT_CALLS_TC_NA),0) AGENT_CONT_CALLS_TC_NA
4806: decode(period_type_id,1,SUM(AGENT_CONT_CALLS_HAND_NA),-1) AGENT_CONT_CALLS_HAND_NA,
4807: decode(period_type_id,1,SUM(AGENT_CONT_CALLS_TC_NA),0) AGENT_CONT_CALLS_TC_NA
4808: FROM bix_call_details_stg stg
4809: GROUP BY
4810: TIME_ID,
4811: PERIOD_TYPE_ID,
4812: PERIOD_START_DATE,

Line 5162: INSERT /+ APPEND / INTO bix_call_details_stg STG

5158: --This can be a INSERT and not a MERGE if we assume that all the
5159: --half hour rows would be inserted at this time into the STAGING table,
5160: --which would be the case, provided we wait for all the workers to complete.
5161: --
5162: INSERT /*+ APPEND */ INTO bix_call_details_stg STG
5163: (
5164: STG.TIME_ID,
5165: STG.PERIOD_TYPE_ID,
5166: STG.PERIOD_START_DATE,

Line 5314: FROM bix_call_details_stg stg,

5310: g_request_id,
5311: g_program_appl_id,
5312: g_program_id,
5313: g_sysdate
5314: FROM bix_call_details_stg stg,
5315: fii_time_day ftd
5316: WHERE stg.time_id = ftd.report_date_julian
5317: AND stg.period_type_id = 1
5318: GROUP BY

Line 5647: truncate_table('BIX_CALL_DETAILS_STG');

5643: retcode := 0;
5644:
5645: truncate_table('bix_medias_for_worker');
5646:
5647: truncate_table('BIX_CALL_DETAILS_STG');
5648: --truncate_table('BIX_CALL_PROCESSED_RECS');
5649:
5650: cleanup_oltp; --001
5651:

Line 5653: --write_log('Done truncating bix_call_details_stg and bix_call_procesed_recs');

5649:
5650: cleanup_oltp; --001
5651:
5652: --IF (g_debug_flag = 'Y') THEN
5653: --write_log('Done truncating bix_call_details_stg and bix_call_procesed_recs');
5654: --END IF;
5655:
5656: --Analyze with zero rows to enable MERGE on FACT to perform with index
5657: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,

Line 5658: tabName => 'BIX_CALL_DETAILS_STG',

5654: --END IF;
5655:
5656: --Analyze with zero rows to enable MERGE on FACT to perform with index
5657: DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
5658: tabName => 'BIX_CALL_DETAILS_STG',
5659: cascade => TRUE,
5660: degree => bis_common_parameters.get_degree_of_parallelism,
5661: estimate_percent => 10,
5662: granularity => 'GLOBAL');

Line 5742: INTO bix_call_details_stg STG

5738:
5739: /* Inserting PR count only into bix_call_details for the purpose of marketing mv */
5740:
5741: INSERT /*+ APPEND */
5742: INTO bix_call_details_stg STG
5743: (
5744: time_id ,
5745: period_type_id ,
5746: period_start_date ,

Line 5972: --tabName => 'BIX_CALL_DETAILS_STG',

5968:
5969: --END IF;
5970:
5971: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
5972: --tabName => 'BIX_CALL_DETAILS_STG',
5973: --cascade => TRUE,
5974: --degree => bis_common_parameters.get_degree_of_parallelism,
5975: --estimate_percent => 10,
5976: --granularity => 'GLOBAL');

Line 6010: truncate_table('BIX_CALL_DETAILS_STG');

6006: --write_log('Finished Procedure BIX_CALL_LOAD with success at : ' ||
6007: --to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
6008:
6009: --END IF;
6010: truncate_table('BIX_CALL_DETAILS_STG');
6011: --truncate_table('BIX_CALL_PROCESSED_RECS');
6012: --IF (g_debug_flag = 'Y') THEN
6013: --write_log('Done truncating bix_call_details_stg and bix_call_procesed_recs');
6014: --

Line 6013: --write_log('Done truncating bix_call_details_stg and bix_call_procesed_recs');

6009: --END IF;
6010: truncate_table('BIX_CALL_DETAILS_STG');
6011: --truncate_table('BIX_CALL_PROCESSED_RECS');
6012: --IF (g_debug_flag = 'Y') THEN
6013: --write_log('Done truncating bix_call_details_stg and bix_call_procesed_recs');
6014: --
6015: --write_log('Calling procedure WRAPUP');
6016: --END IF;
6017: bis_collection_utilities.wrapup(