APPS.BIX_SUMMARY_PUB dependencies on BIX_SUM_GRP_CLS

Line 13: procedure POPULATE_BIX_SUM_GRP_CLS

9: BEGIN
10: FND_FILE.PUT_LINE(fnd_file.log,'Load Interactions Log - ' || p_msg || ': '|| p_proc_name);
11: END WRITE_LOG;
12:
13: procedure POPULATE_BIX_SUM_GRP_CLS
14: IS
15: CURSOR POP_BIX_SUM_GRP_CLS
16: IS
17: SELECT interaction_type,

Line 15: CURSOR POP_BIX_SUM_GRP_CLS

11: END WRITE_LOG;
12:
13: procedure POPULATE_BIX_SUM_GRP_CLS
14: IS
15: CURSOR POP_BIX_SUM_GRP_CLS
16: IS
17: SELECT interaction_type,
18: media_item_type,
19: interaction_center_id,

Line 53: DELETE FROM bix_sum_grp_cls

49:
50: ---dbms_output.put_line('g_Start_date : '|| g_start_date );
51: --dbms_output.put_line('g_end_date : '|| g_end_date );
52:
53: DELETE FROM bix_sum_grp_cls
54: WHERE hour BETWEEN g_start_date AND g_end_date;
55:
56: DELETE FROM bix_sum_agt_cls
57: WHERE hour BETWEEN g_start_date AND g_end_date;

Line 60: FOR call IN POP_BIX_SUM_GRP_CLS LOOP

56: DELETE FROM bix_sum_agt_cls
57: WHERE hour BETWEEN g_start_date AND g_end_date;
58:
59:
60: FOR call IN POP_BIX_SUM_GRP_CLS LOOP
61: INSERT INTO BIX_SUM_GRP_CLS
62: (
63: sum_grp_cls_id,
64: campaign_id,

Line 61: INSERT INTO BIX_SUM_GRP_CLS

57: WHERE hour BETWEEN g_start_date AND g_end_date;
58:
59:
60: FOR call IN POP_BIX_SUM_GRP_CLS LOOP
61: INSERT INTO BIX_SUM_GRP_CLS
62: (
63: sum_grp_cls_id,
64: campaign_id,
65: interaction_classification,

Line 91: BIX_SUM_GRP_CLS_S.nextval,

87: number_of_interactions
88: )
89: VALUES
90: (
91: BIX_SUM_GRP_CLS_S.nextval,
92: call.campaign_id,
93: call.interaction_classification,
94: call.media_item_type,
95: call.interaction_center_id,

Line 179: write_log('Error: '||sqlerrm,' POPULATE_BIX_SUM_GRP_CLS');

175: );
176: END LOOP;
177: exception
178: WHEN OTHERS THEN
179: write_log('Error: '||sqlerrm,' POPULATE_BIX_SUM_GRP_CLS');
180: rollback;
181: raise;
182: end;
183: END POPULATE_BIX_SUM_GRP_CLS;

Line 183: END POPULATE_BIX_SUM_GRP_CLS;

179: write_log('Error: '||sqlerrm,' POPULATE_BIX_SUM_GRP_CLS');
180: rollback;
181: raise;
182: end;
183: END POPULATE_BIX_SUM_GRP_CLS;
184:
185: procedure POPULATE_BIX_SUM_X
186: IS
187: BEGIN

Line 188: populate_bix_sum_grp_cls;

184:
185: procedure POPULATE_BIX_SUM_X
186: IS
187: BEGIN
188: populate_bix_sum_grp_cls;
189: exception
190: when others then
191: write_log('Error : '||sqlerrm,'POPULATE_BIX_SUM_X');
192: rollback;