APPS.BIX_UWQ_SUMMARY_PKG dependencies on BIX_DM_UWQ_GROUP_SUM

Line 158: DELETE FROM bix_dm_uwq_group_sum

154: END LOOP;
155:
156: LOOP
157:
158: DELETE FROM bix_dm_uwq_group_sum
159: WHERE last_update_date >= v_sysdate
160: AND rownum <= v_delete_size;
161:
162: IF SQL%ROWCOUNT >= v_delete_size --this means we need to loop again

Line 191: v_table_name := 'BIX_DM_UWQ_GROUP_SUM';

187: v_delete_count := 0;
188: insert_log_table;
189:
190: --Create error log table entry for group summary
191: v_table_name := 'BIX_DM_UWQ_GROUP_SUM';
192: v_insert_count := 0;
193: v_delete_count := 0;
194: insert_log_table;
195:

Line 622: --This procedure populates the BIX_DM_UWQ_GROUP_SUM table.

618: p_end_date IN DATE
619: )
620:
621: --
622: --This procedure populates the BIX_DM_UWQ_GROUP_SUM table.
623: --There is no need to go after the OLTP tables. Instead, the
624: --calculations are based off the BIX_DM_UWQ_AGENT_SUM table.
625: --
626: IS

Line 669: v_table_name := 'BIX_DM_UWQ_GROUP_SUM';

665:
666: v_insert_count := 0;
667: v_delete_count := 0;
668: v_proc_name := 'POPULATE_GROUPS';
669: v_table_name := 'BIX_DM_UWQ_GROUP_SUM';
670: v_run_start_date := sysdate;
671:
672: --
673: --Delete information for the date range and re-compute.

Line 677: DELETE FROM bix_dm_uwq_group_sum

673: --Delete information for the date range and re-compute.
674: --
675: LOOP
676:
677: DELETE FROM bix_dm_uwq_group_sum
678: WHERE day BETWEEN trunc(p_start_date) AND trunc(p_end_date)
679: AND rownum <= v_delete_size;
680:
681: IF SQL%ROWCOUNT >= v_delete_size --this means we need to loop again

Line 706: INSERT INTO bix_dm_uwq_group_sum

702:
703: --
704: --Insert zero rows
705: --
706: INSERT INTO bix_dm_uwq_group_sum
707: (group_id, day,
708: DAY_LOGIN, DAY_DURATION, DAY1_LOGIN,
709: DAY1_DURATION, DAY2_LOGIN, DAY2_DURATION, DAY3_LOGIN, DAY3_DURATION,
710: DAY4_LOGIN, DAY4_DURATION, DAY5_LOGIN, DAY5_DURATION, DAY6_LOGIN,

Line 756: --Update BIX_DM_UWQ_GROUP_SUM table using the above values.

752: )
753: AND agent.day = v_insert_date;
754:
755: --
756: --Update BIX_DM_UWQ_GROUP_SUM table using the above values.
757: --
758: UPDATE bix_dm_uwq_group_sum
759: SET day_login = v_day_login,
760: day_duration = v_day_duration,

Line 758: UPDATE bix_dm_uwq_group_sum

754:
755: --
756: --Update BIX_DM_UWQ_GROUP_SUM table using the above values.
757: --
758: UPDATE bix_dm_uwq_group_sum
759: SET day_login = v_day_login,
760: day_duration = v_day_duration,
761: day1_login = v_day1_login,
762: day1_duration = v_day1_duration,

Line 799: v_message := 'Successfully populated bix_dm_uwq_group_sum';

795:
796: END LOOP; --groups cursor loop
797:
798: v_status := 'SUCCESS';
799: v_message := 'Successfully populated bix_dm_uwq_group_sum';
800: v_run_end_date := sysdate;
801: write_log(v_proc_name, v_message);
802: insert_log_table;
803: COMMIT;