APPS.IEC_REPORTS_UTIL_PVT dependencies on IEC_REP_CAMPAIGN_DETAILS

Line 463: from iec_rep_campaign_details

459: l_sh_idle_time,
460: l_sh_wait_time,
461: l_sh_talk_time,
462: l_sh_wrapup_time
463: from iec_rep_campaign_details
464: where dial_server_id = P_DIAL_SERVER_ID
465: and campaign_schedule_id = P_CAMPAIGN_SCHEDULE_ID;
466:
467: -- dbms_output.put_line( 'After Select...<'|| l_mx_idle_time||'> <'||l_mx_login_time);

Line 574: update iec_rep_campaign_details

570:
571: if P_OUTCOME_ID <> -999999
572: then
573:
574: update iec_rep_campaign_details
575: set
576: agent_outcome_id = P_OUTCOME_ID,
577: agent_result_id = P_RESULT_ID,
578: dialing_mode = l_dialing_method,

Line 621: update iec_rep_campaign_details

617: end if;
618: -- Do not udpate num_voice_detected, calls_offered and predictive_calls_offered
619: -- They are updated by UPDATE_CPN_AGENT_STATS
620:
621: update iec_rep_campaign_details
622: set total_login_time = nvl( l_mx_login_time, 0 ) + l_login_time,
623: total_activity_time = nvl( l_mx_activity_time, 0 )+ l_activity_time,
624: total_idle_time = nvl( l_mx_idle_time, 0 ) + P_TOTAL_IDLE_TIME,
625: total_wait_time = nvl( l_mx_wait_time, 0 ) + P_TOTAL_WAIT_TIME,

Line 710: from iec_rep_campaign_details

706: l_mx_voice_detected,
707: l_mx_calls_offered,
708: l_mx_pred_calls_offered
709:
710: from iec_rep_campaign_details
711: where ( dial_server_id = P_DIAL_SERVER_ID OR dial_server_id = 0 )
712: and campaign_schedule_id = P_CAMPAIGN_SCHEDULE_ID;
713:
714: if( l_mx_login_agent is null AND

Line 724: insert into iec_rep_campaign_details (

720: l_mx_voice_detected is null)
721: then
722: l_mx_total_dials := P_PREVIEW_DIALS + P_TIMED_PREVIEW_DIALS + P_PROGRESSIVE_DIALS + P_PREDICTIVE_DIALS + P_MANUAL_DIALS;
723:
724: insert into iec_rep_campaign_details (
725: campaign_rep_id,
726: created_by,
727: creation_date,
728: last_updated_by,

Line 782: iec_rep_campaign_details_s.nextval,

778: num_voice_detected
779: )
780: values
781: (
782: iec_rep_campaign_details_s.nextval,
783: NVL(FND_GLOBAL.user_id,-1),
784: sysdate,
785: NVL(FND_GLOBAL.conc_login_id,-1),
786: sysdate,

Line 858: update iec_rep_campaign_details

854: l_mx_predictive_dials := l_mx_predictive_dials + P_PREDICTIVE_DIALS;
855:
856: l_mx_total_dials := l_mx_preview_dials + l_mx_progressive_dials + l_mx_manual_dials + l_mx_predictive_dials + l_mx_timed_preview_dials;
857:
858: update iec_rep_campaign_details
859: set num_login_agent = P_NUM_LOGIN_AGENTS,
860: max_login_agent = l_mx_login_agent,
861: cpn_num_login_agent = P_NUM_CPN_LOGIN_AGENTS,
862: cpn_max_login_agent = l_mx_cpn_login_agent,

Line 1039: from iec_rep_campaign_details

1035: begin
1036: select campaign_rep_id
1037: into
1038: l_rec_present
1039: from iec_rep_campaign_details
1040: where dial_server_id = P_DIAL_SERVER_ID
1041: and campaign_schedule_id = P_CAMPAIGN_SCHEDULE_ID
1042: and predictive_outcome_id = P_PREDICTIVE_OUTCOME_ID
1043: and predictive_result_id = P_PREDICTIVE_RESULT_ID

Line 1046: update iec_rep_campaign_details

1042: and predictive_outcome_id = P_PREDICTIVE_OUTCOME_ID
1043: and predictive_result_id = P_PREDICTIVE_RESULT_ID
1044: and nvl(agent_outcome_id, -999999 ) < 0;
1045:
1046: update iec_rep_campaign_details
1047: set predictive_outcome_id = P_PREDICTIVE_OUTCOME_ID,
1048: predictive_result_id = P_PREDICTIVE_RESULT_ID,
1049: dialing_mode = l_dialing_method,
1050: predictive_result_count = nvl( predictive_result_count, 0 ) + l_result_count,

Line 1067: from iec_rep_campaign_details

1063: begin
1064: select campaign_rep_id
1065: into
1066: l_rec_present
1067: from iec_rep_campaign_details
1068: where dial_server_id = P_DIAL_SERVER_ID
1069: and campaign_schedule_id = P_CAMPAIGN_SCHEDULE_ID
1070: and nvl(predictive_outcome_id, -999999 ) = -999999
1071: and nvl(predictive_result_id, -999999) = -999999

Line 1074: update iec_rep_campaign_details

1070: and nvl(predictive_outcome_id, -999999 ) = -999999
1071: and nvl(predictive_result_id, -999999) = -999999
1072: and nvl(agent_outcome_id, -999999 ) < 0;
1073:
1074: update iec_rep_campaign_details
1075: set predictive_outcome_id = P_PREDICTIVE_OUTCOME_ID,
1076: predictive_result_id = P_PREDICTIVE_RESULT_ID,
1077: dialing_mode = l_dialing_method,
1078: predictive_result_count = nvl( predictive_result_count, 0 ) + l_result_count,

Line 1140: from iec_rep_campaign_details

1136: l_sh_idle_time,
1137: l_sh_wait_time,
1138: l_sh_talk_time,
1139: l_sh_wrapup_time
1140: from iec_rep_campaign_details
1141: where dial_server_id = P_DIAL_SERVER_ID
1142: and campaign_schedule_id = P_CAMPAIGN_SCHEDULE_ID;
1143:
1144: update iec_rep_campaign_details

Line 1144: update iec_rep_campaign_details

1140: from iec_rep_campaign_details
1141: where dial_server_id = P_DIAL_SERVER_ID
1142: and campaign_schedule_id = P_CAMPAIGN_SCHEDULE_ID;
1143:
1144: update iec_rep_campaign_details
1145: set total_login_time = l_mx_login_time,
1146: total_activity_time = l_mx_activity_time,
1147: total_idle_time = l_mx_idle_time,
1148: total_wait_time = l_mx_wait_time,

Line 1185: insert into iec_rep_campaign_details (

1181: AS
1182:
1183: BEGIN
1184:
1185: insert into iec_rep_campaign_details (
1186: campaign_rep_id,
1187: created_by,
1188: creation_date,
1189: last_updated_by,

Line 1242: iec_rep_campaign_details_s.nextval,

1238: MESSAGE_PLAYED_COUNT
1239: )
1240: values
1241: (
1242: iec_rep_campaign_details_s.nextval,
1243: NVL(FND_GLOBAL.user_id,-1),
1244: sysdate,
1245: NVL(FND_GLOBAL.conc_login_id,-1),
1246: sysdate,

Line 1315: insert into iec_rep_campaign_details (

1311: ,P_DIALING_METHOD IN VARCHAR2
1312: )
1313: AS
1314: BEGIN
1315: insert into iec_rep_campaign_details (
1316: campaign_rep_id,
1317: created_by,
1318: creation_date,
1319: last_updated_by,

Line 1372: iec_rep_campaign_details_s.nextval,

1368: MESSAGE_PLAYED_COUNT
1369: )
1370: values
1371: (
1372: iec_rep_campaign_details_s.nextval,
1373: NVL(FND_GLOBAL.user_id,-1),
1374: sysdate,
1375: NVL(FND_GLOBAL.conc_login_id,-1),
1376: sysdate,