APPS.CCT_SERVERDATAINPUT_PUB dependencies on BIX_SERVER_IB

Line 778: INSERT INTO bix_server_ib

774: l_items_not_serv_within_LOS := (l_quota / 60.0) - p_items_serviced_count;
775: END IF;
776: -- 20000814 kcwong End
777:
778: INSERT INTO bix_server_ib
779: (server_ib_id, minute, site_id, media_item_type,
780: los_category_id, los_category_direction,
781: number_of_items_queued, number_of_items_serviced,
782: items_serviced_within_los, items_not_serviced_within_los,

Line 785: SELECT bix_server_ib_s.nextval, trunc (p_time, 'MI'), l_site_id,

781: number_of_items_queued, number_of_items_serviced,
782: items_serviced_within_los, items_not_serviced_within_los,
783: number_agents_working, minimum_number_of_agents_req,
784: items_left_to_be_serviced, items_serviced_today)
785: SELECT bix_server_ib_s.nextval, trunc (p_time, 'MI'), l_site_id,
786: l_media_type, l_los_id, p_direction,
787: p_items_queued_count, p_items_serviced_count,
788: l_items_serviced_within_LOS, l_items_not_serv_within_LOS,
789: p_number_agents_working, p_minimum_agents_required,