APPS.BIX_SERVER_PUB dependencies on BIX_SERVER_SUM_CP

Line 3: procedure POPULATE_BIX_SERVER_SUM_CP

1: package body BIX_SERVER_PUB AS
2: /* $Header: BIXSERSB.pls 115.6 2003/01/10 02:46:55 achanda ship $: */
3: procedure POPULATE_BIX_SERVER_SUM_CP
4: IS
5: CURSOR POP_BIX_SERVER_SUM_CP
6: IS
7: SELECT SUM(busy_counts) busy_counts,

Line 5: CURSOR POP_BIX_SERVER_SUM_CP

1: package body BIX_SERVER_PUB AS
2: /* $Header: BIXSERSB.pls 115.6 2003/01/10 02:46:55 achanda ship $: */
3: procedure POPULATE_BIX_SERVER_SUM_CP
4: IS
5: CURSOR POP_BIX_SERVER_SUM_CP
6: IS
7: SELECT SUM(busy_counts) busy_counts,
8: SUM(connect_counts) connect_counts,
9: SUM(answering_machine_counts) answering_machine_counts,

Line 40: FOR recs in POP_BIX_SERVER_SUM_CP LOOP

36: FROM BIX_SERVER_CP
37: GROUP BY site_id, campaign_id, list_id, to_char(minute, 'DD-Mon-YY HH');
38: BEGIN
39:
40: FOR recs in POP_BIX_SERVER_SUM_CP LOOP
41:
42: INSERT INTO BIX_SERVER_SUM_CP
43: (
44: server_sum_cp_id,

Line 42: INSERT INTO BIX_SERVER_SUM_CP

38: BEGIN
39:
40: FOR recs in POP_BIX_SERVER_SUM_CP LOOP
41:
42: INSERT INTO BIX_SERVER_SUM_CP
43: (
44: server_sum_cp_id,
45: site,
46: campaign_id,

Line 75: bix_server_sum_cp_s.nextval,

71: number_records_remaining,
72: number_records_start_of_day,
73: number_records_to_be_released)
74: VALUES(
75: bix_server_sum_cp_s.nextval,
76: recs.site_id,
77: recs.campaign_id,
78: recs.list_id,
79: recs.hour,

Line 106: END POPULATE_BIX_SERVER_SUM_CP;

102: recs.number_records_remaining,
103: recs.number_records_start_of_day,
104: recs.num_recs_to_be_released_next_1);
105: END LOOP;
106: END POPULATE_BIX_SERVER_SUM_CP;
107: procedure POPULATE_BIX_SERVER_X
108: IS
109: BEGIN
110: populate_bix_server_sum_cp;

Line 110: populate_bix_server_sum_cp;

106: END POPULATE_BIX_SERVER_SUM_CP;
107: procedure POPULATE_BIX_SERVER_X
108: IS
109: BEGIN
110: populate_bix_server_sum_cp;
111: exception
112: when others then null;
113: END POPULATE_BIX_SERVER_X;
114: