APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on DUAL

Line 73: SELECT BIX_DM_COLLECT_LOG_S.NEXTVAL INTO l_bix_collect_log_seq FROM DUAL;

69: AS
70: l_bix_collect_log_seq NUMBER;
71: BEGIN
72:
73: SELECT BIX_DM_COLLECT_LOG_S.NEXTVAL INTO l_bix_collect_log_seq FROM DUAL;
74:
75: /* Insert status into log table */
76:
77: INSERT INTO BIX_DM_COLLECT_LOG

Line 278: select bix.bix_dm_dnis_s.nextval into l_dnis from dual;

274: end if;
275:
276: EXCEPTION
277: WHEN NO_DATA_FOUND THEN
278: select bix.bix_dm_dnis_s.nextval into l_dnis from dual;
279: insert into bix_dm_dnis (dnis_id,dnis,last_update_date,last_updated_by,
280: creation_date) values (l_dnis,p_dnis,sysdate,g_user_id,
281: sysdate);
282: commit;

Line 1213: FROM DUAL;

1209: LPAD(TO_CHAR(g_min_call_begin_date,'HH24:'),3,'0')||
1210: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_min_call_begin_date,'MI'))-29),0,'00:00',1,'30:00',-1,'00:00'),
1211: 'YYYY/MM/DDHH24:MI:SS')
1212: INTO g_min_call_begin_date
1213: FROM DUAL;
1214:
1215:
1216: /* Round the Max begin date to nearest higher time bucket. ex: if time is between 10:00 and 10:29
1217: round it to 10:29:59

Line 1226: FROM DUAL;

1222: LPAD(TO_CHAR(g_max_call_begin_date,'HH24:'),3,'0')||
1223: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_max_call_begin_date,'MI'))-29),0,'29:59',1,'59:59',-1,'29:59'),
1224: 'YYYY/MM/DDHH24:MI:SS')
1225: INTO g_max_call_begin_date
1226: FROM DUAL;
1227:
1228:
1229: BEGIN
1230:

Line 3093: SELECT BIX_DM_AGENT_SUM_S.NEXTVAL INTO l_bix_agent_seq FROM DUAL;

3089:
3090: for ag_row in agent_data LOOP
3091:
3092:
3093: SELECT BIX_DM_AGENT_SUM_S.NEXTVAL INTO l_bix_agent_seq FROM DUAL;
3094:
3095: INSERT INTO BIX_DM_AGENT_SUM
3096: (
3097: AGENT_SUMMARY_ID,

Line 3414: SELECT BIX_DM_GROUP_SUM_S.NEXTVAL INTO l_bix_group_seq FROM DUAL;

3410:
3411: for gr_row in group_data LOOP
3412:
3413:
3414: SELECT BIX_DM_GROUP_SUM_S.NEXTVAL INTO l_bix_group_seq FROM DUAL;
3415:
3416: INSERT INTO BIX_DM_GROUP_SUM
3417: (
3418: GROUP_SUMMARY_ID,

Line 3716: SELECT BIX_DM_CALL_SUM_S.NEXTVAL INTO l_bix_call_seq FROM DUAL;

3712:
3713: for call_row in call_data LOOP
3714:
3715:
3716: SELECT BIX_DM_CALL_SUM_S.NEXTVAL INTO l_bix_call_seq FROM DUAL;
3717:
3718: INSERT INTO BIX_DM_CALL_SUM
3719: (
3720: CALL_SUMMARY_ID,

Line 4435: FROM DUAL;

4431: LPAD(TO_CHAR(g_collect_start_date,'HH24:'),3,'0')||
4432: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_start_date,'MI'))-29),0,'00:00',1,'30:00',-1,'00:00'),
4433: 'YYYY/MM/DDHH24:MI:SS')
4434: INTO g_rounded_collect_start_date
4435: FROM DUAL;
4436:
4437:
4438: /* Round the Collection end date to nearest higher time bucket. ex: if time is between 10:00 and 10:29
4439: round it to 10:29:59

Line 4448: FROM DUAL;

4444: LPAD(TO_CHAR(g_collect_end_date,'HH24:'),3,'0')||
4445: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_end_date,'MI'))-29),0,'29:59',1,'59:59',-1,'29:59'),
4446: 'YYYY/MM/DDHH24:MI:SS')
4447: INTO g_rounded_collect_end_date
4448: FROM DUAL;
4449:
4450:
4451: /* Procedure collect calls from OLTP to the temporary table BIX_DM_INTERFACE: */
4452: GET_CALLS;

Line 4654: FROM DUAL;

4650: LPAD(TO_CHAR(g_collect_start_date,'HH24:'),3,'0')||
4651: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_start_date,'MI'))-29),0,'00:00',1,'30:00',-1,'00:00'),
4652: 'YYYY/MM/DDHH24:MI:SS')
4653: INTO g_rounded_collect_start_date
4654: FROM DUAL;
4655:
4656:
4657: /* Round the Collection end date to nearest higher time bucket. ex: if time is between 10:00 and 10:29
4658: round it to 10:29:59

Line 4667: FROM DUAL;

4663: LPAD(TO_CHAR(g_collect_end_date,'HH24:'),3,'0')||
4664: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_end_date,'MI'))-29),0,'29:59',1,'59:59',-1,'29:59'),
4665: 'YYYY/MM/DDHH24:MI:SS')
4666: INTO g_rounded_collect_end_date
4667: FROM DUAL;
4668:
4669: /* Get the commit size from the profile value. if the profile is not defined assume commit size as 100 */
4670:
4671: IF (FND_PROFILE.DEFINED('BIX_DM_DELETE_SIZE')) THEN