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

Line 971: truncate_table('BIX_CALL_DETAILS_STG');

967: --IF (g_debug_flag = 'Y') THEN
968: --write_log('Number of rows deleted from BIX_CALL_DETAILS_F : ' || to_char(l_total_rows_deleted));
969: --END IF;
970:
971: truncate_table('BIX_CALL_DETAILS_STG');
972: --truncate_table('BIX_CALL_PROCESSED_RECS');
973: --IF (g_debug_flag = 'Y') THEN
974: --write_log('Done truncating bix_call_details_stg
975: --and bix_call_processed_recs');

Line 974: --write_log('Done truncating bix_call_details_stg

970:
971: truncate_table('BIX_CALL_DETAILS_STG');
972: --truncate_table('BIX_CALL_PROCESSED_RECS');
973: --IF (g_debug_flag = 'Y') THEN
974: --write_log('Done truncating bix_call_details_stg
975: --and bix_call_processed_recs');
976: --
977: --write_log('Finished procedure clean_up at ' ||
978: --to_char(sysdate,'mm/dd/yyyy hh24:mi:ss'));

Line 3977: INTO bix_call_details_stg STG

3973:
3974: FORALL k IN 1 .. counter
3975:
3976: INSERT
3977: INTO bix_call_details_stg STG
3978: (
3979: time_id ,
3980: period_type_id ,
3981: period_start_date ,

Line 4101: MERGE INTO BIX_CALL_DETAILS_STG STG

4097: l_target_record.agentcall_contact_count(k)
4098: )
4099: ;
4100: /****
4101: MERGE INTO BIX_CALL_DETAILS_STG STG
4102: USING (
4103: SELECT
4104: --l_target_record.media_id(k) media_id,
4105: to_char(l_target_record.period_start_date(k),'J') time_id,

Line 4660: FROM bix_call_details_stg stg

4656: g_request_id,
4657: g_program_appl_id,
4658: g_program_id,
4659: g_sysdate
4660: FROM bix_call_details_stg stg
4661: GROUP BY
4662: TIME_ID,
4663: PERIOD_TYPE_ID,
4664: PERIOD_START_DATE,

Line 4745: FROM bix_call_details_stg stg

4741: SUM(AGENTCALL_PR_COUNT) AGENTCALL_PR_COUNT,
4742: SUM(AGENTCALL_CONTACT_COUNT) AGENTCALL_CONTACT_COUNT,
4743: NVL(SUM(AGENT_CONT_CALLS_HAND_NA),-1) AGENT_CONT_CALLS_HAND_NA,
4744: SUM(AGENT_CONT_CALLS_TC_NA) AGENT_CONT_CALLS_TC_NA
4745: FROM bix_call_details_stg stg
4746: GROUP BY
4747: TIME_ID,
4748: PERIOD_TYPE_ID,
4749: PERIOD_START_DATE,

Line 5099: INSERT /+ APPEND / INTO bix_call_details_stg STG

5095: --This can be a INSERT and not a MERGE if we assume that all the
5096: --half hour rows would be inserted at this time into the STAGING table,
5097: --which would be the case, provided we wait for all the workers to complete.
5098: --
5099: INSERT /*+ APPEND */ INTO bix_call_details_stg STG
5100: (
5101: STG.TIME_ID,
5102: STG.PERIOD_TYPE_ID,
5103: STG.PERIOD_START_DATE,

Line 5348: FROM bix_call_details_stg stg,

5344: g_request_id,
5345: g_program_appl_id,
5346: g_program_id,
5347: g_sysdate
5348: FROM bix_call_details_stg stg,
5349: fii_time_day ftd
5350: WHERE stg.time_id = ftd.report_date_julian
5351: AND stg.period_type_id = 1
5352: GROUP BY

Line 5678: truncate_table('BIX_CALL_DETAILS_STG');

5674:
5675: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_CALL_DETAILS_F');
5676:
5677: truncate_table('bix_medias_for_worker');
5678: truncate_table('BIX_CALL_DETAILS_STG');
5679: truncate_table('BIX_CALL_DETAILS_F');
5680:
5681:
5682: cleanup_oltp; --001 close open medias and other processings before getting

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

5683: --the end collection date
5684:
5685: --truncate_table('BIX_CALL_PROCESSED_RECS');
5686: --IF (g_debug_flag = 'Y') THEN
5687: --write_log('Done truncating bix_call_details_stg and bix_call_procesed_recs');
5688: --END IF;
5689:
5690: --Analyze with zero rows to enable MERGE on FACT to perform with index
5691: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,

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

5688: --END IF;
5689:
5690: --Analyze with zero rows to enable MERGE on FACT to perform with index
5691: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
5692: --tabName => 'BIX_CALL_DETAILS_STG',
5693: --cascade => TRUE,
5694: --degree => bis_common_parameters.get_degree_of_parallelism,
5695: --estimate_percent => 10,
5696: --granularity => 'GLOBAL');

Line 5758: INTO bix_call_details_stg STG

5754:
5755: /* Inserting PR count only into bix_call_details for the purpose of marketing mv */
5756:
5757: INSERT /*+ APPEND */
5758: INTO bix_call_details_stg STG
5759: (
5760: time_id ,
5761: period_type_id ,
5762: period_start_date ,

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

5977:
5978: --END IF;
5979:
5980: --DBMS_STATS.gather_table_stats(ownname => g_bix_schema,
5981: --tabName => 'BIX_CALL_DETAILS_STG',
5982: --cascade => TRUE,
5983: --degree => bis_common_parameters.get_degree_of_parallelism,
5984: --estimate_percent => 10,
5985: --granularity => 'GLOBAL');

Line 6014: truncate_table('BIX_CALL_DETAILS_STG');

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

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

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