eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEC_REPORTS_UTIL_PVT dependencies on FND_GLOBAL

Line 73: NVL(FND_GLOBAL.user_id,-1),

69: P_CPN_SCHEDULE_ID,
70: P_STATUS,
71: P_STATUS_REASON,
72: l_start_time,
73: NVL(FND_GLOBAL.user_id,-1),
74: sysdate,
75: NVL(FND_GLOBAL.conc_login_id,-1),
76: sysdate,
77: NVL(FND_GLOBAL.conc_login_id,-1),

Line 75: NVL(FND_GLOBAL.conc_login_id,-1),

71: P_STATUS_REASON,
72: l_start_time,
73: NVL(FND_GLOBAL.user_id,-1),
74: sysdate,
75: NVL(FND_GLOBAL.conc_login_id,-1),
76: sysdate,
77: NVL(FND_GLOBAL.conc_login_id,-1),
78: 0,
79: 0

Line 77: NVL(FND_GLOBAL.conc_login_id,-1),

73: NVL(FND_GLOBAL.user_id,-1),
74: sysdate,
75: NVL(FND_GLOBAL.conc_login_id,-1),
76: sysdate,
77: NVL(FND_GLOBAL.conc_login_id,-1),
78: 0,
79: 0
80: );
81: -- end if;

Line 167: -- last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),

163: -- result_id = P_RESULT_ID,
164: -- result_count = nvl( result_count, 0 ) + l_result_count,
165: -- positive_response_flag = P_POSITIVE_RESPONSE_FLAG,
166: -- contact_flag = P_CONTACT_FLAG,
167: -- last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),
168: -- last_update_date = sysdate
169: -- where resource_id = P_RESOURCE_ID
170: -- and dial_server_id = P_DIAL_SERVER_ID
171: -- and campaign_schedule_id = P_CAMPAIGN_SCHEDULE_ID

Line 209: NVL(FND_GLOBAL.user_id,-1),

205: login_agent_count
206: )
207: values(
208: iec_rep_agent_cpn_details_s.nextval,
209: NVL(FND_GLOBAL.user_id,-1),
210: sysdate,
211: NVL(FND_GLOBAL.conc_login_id,-1),
212: sysdate,
213: NVL(FND_GLOBAL.conc_login_id,-1),

Line 211: NVL(FND_GLOBAL.conc_login_id,-1),

207: values(
208: iec_rep_agent_cpn_details_s.nextval,
209: NVL(FND_GLOBAL.user_id,-1),
210: sysdate,
211: NVL(FND_GLOBAL.conc_login_id,-1),
212: sysdate,
213: NVL(FND_GLOBAL.conc_login_id,-1),
214: P_RESOURCE_ID,
215: P_DIAL_SERVER_ID,

Line 213: NVL(FND_GLOBAL.conc_login_id,-1),

209: NVL(FND_GLOBAL.user_id,-1),
210: sysdate,
211: NVL(FND_GLOBAL.conc_login_id,-1),
212: sysdate,
213: NVL(FND_GLOBAL.conc_login_id,-1),
214: P_RESOURCE_ID,
215: P_DIAL_SERVER_ID,
216: P_CAMPAIGN_ID,
217: P_CAMPAIGN_SCHEDULE_ID,

Line 584: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),

580: FTC_ABANDONMENT_COUNT = nvl(FTC_ABANDONMENT_COUNT, 0) + P_FTC_ABANDON_COUNT,
581: MESSAGE_PLAYED_COUNT = nvl(MESSAGE_PLAYED_COUNT, 0) + P_MESSAGE_PLAYED_COUNT,
582: positive_response_flag = P_POSITIVE_RESPONSE_FLAG,
583: contact_flag = P_CONTACT_FLAG,
584: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),
585: last_update_date = sysdate
586: where dial_server_id = P_DIAL_SERVER_ID
587: and campaign_schedule_id = P_CAMPAIGN_SCHEDULE_ID
588: and (

Line 637: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),

633: shortest_wait_time = l_sh_wait_time,
634: shortest_talk_time = l_sh_talk_time,
635: shortest_wrapup_time = l_sh_wrapup_time,
636: dialing_mode = l_dialing_method,
637: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),
638: last_update_date = sysdate
639: where dial_server_id = P_DIAL_SERVER_ID
640: and campaign_schedule_id = P_CAMPAIGN_SCHEDULE_ID;
641:

Line 783: NVL(FND_GLOBAL.user_id,-1),

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,
787: NVL(FND_GLOBAL.conc_login_id,-1),

Line 785: NVL(FND_GLOBAL.conc_login_id,-1),

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,
787: NVL(FND_GLOBAL.conc_login_id,-1),
788: P_CAMPAIGN_ID,
789: P_CAMPAIGN_SCHEDULE_ID,

Line 787: NVL(FND_GLOBAL.conc_login_id,-1),

783: NVL(FND_GLOBAL.user_id,-1),
784: sysdate,
785: NVL(FND_GLOBAL.conc_login_id,-1),
786: sysdate,
787: NVL(FND_GLOBAL.conc_login_id,-1),
788: P_CAMPAIGN_ID,
789: P_CAMPAIGN_SCHEDULE_ID,
790: P_DIAL_SERVER_ID,
791: 'UNKN',

Line 879: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),

875: num_agents_in_wrapup = P_NUM_AGENTS_IN_WRAPUP,
876: num_agents_available = P_NUM_AGENTS_AVAILABLE,
877: num_agents_idle = P_NUM_AGENTS_IDLE,
878: num_agents_on_break = P_NUM_AGENTS_ON_BREAK,
879: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),
880: last_update_date = sysdate
881: where ( dial_server_id = P_DIAL_SERVER_ID OR dial_server_id = 0 )
882: and campaign_schedule_id = P_CAMPAIGN_SCHEDULE_ID;
883: end if;

Line 937: NVL(FND_GLOBAL.user_id,-1),

933: contact_flag
934: )
935: values(
936: iec_rep_cpn_dial_stats_s.nextval,
937: NVL(FND_GLOBAL.user_id,-1),
938: sysdate,
939: NVL(FND_GLOBAL.conc_login_id,-1),
940: sysdate,
941: NVL(FND_GLOBAL.conc_login_id,-1),

Line 939: NVL(FND_GLOBAL.conc_login_id,-1),

935: values(
936: iec_rep_cpn_dial_stats_s.nextval,
937: NVL(FND_GLOBAL.user_id,-1),
938: sysdate,
939: NVL(FND_GLOBAL.conc_login_id,-1),
940: sysdate,
941: NVL(FND_GLOBAL.conc_login_id,-1),
942: P_CAMPAIGN_ID,
943: P_CAMPAIGN_SCHEDULE_ID,

Line 941: NVL(FND_GLOBAL.conc_login_id,-1),

937: NVL(FND_GLOBAL.user_id,-1),
938: sysdate,
939: NVL(FND_GLOBAL.conc_login_id,-1),
940: sysdate,
941: NVL(FND_GLOBAL.conc_login_id,-1),
942: P_CAMPAIGN_ID,
943: P_CAMPAIGN_SCHEDULE_ID,
944: P_DIAL_SERVER_ID,
945: sysdate,

Line 1056: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),

1052: MESSAGE_PLAYED_COUNT = nvl(MESSAGE_PLAYED_COUNT, 0) + P_MESSAGE_PLAYED_COUNT,
1053: positive_response_flag = P_POSITIVE_RESPONSE_FLAG,
1054: contact_flag = P_CONTACT_FLAG,
1055: total_dials = l_TOTAL_DIALS,
1056: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),
1057: last_update_date = sysdate
1058: where campaign_rep_id = l_rec_present;
1059:
1060: exception

Line 1084: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),

1080: MESSAGE_PLAYED_COUNT = nvl(MESSAGE_PLAYED_COUNT, 0) + P_MESSAGE_PLAYED_COUNT,
1081: positive_response_flag = P_POSITIVE_RESPONSE_FLAG,
1082: contact_flag = P_CONTACT_FLAG,
1083: total_dials = l_TOTAL_DIALS,
1084: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),
1085: last_update_date = sysdate
1086: where campaign_rep_id = l_rec_present;
1087:
1088: exception

Line 1162: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),

1158: shortest_wrapup_time = l_sh_wrapup_time,
1159: calls_offered = l_mx_calls_offered,
1160: predictive_calls_offered = l_mx_pred_calls_offered,
1161: dialing_mode = l_dialing_method,
1162: last_updated_by = NVL(FND_GLOBAL.conc_login_id,-1),
1163: last_update_date = sysdate
1164: where dial_server_id = P_DIAL_SERVER_ID
1165: and campaign_schedule_id = P_CAMPAIGN_SCHEDULE_ID;
1166:

Line 1243: NVL(FND_GLOBAL.user_id,-1),

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,
1247: NVL(FND_GLOBAL.conc_login_id,-1),

Line 1245: NVL(FND_GLOBAL.conc_login_id,-1),

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,
1247: NVL(FND_GLOBAL.conc_login_id,-1),
1248: P_CAMPAIGN_ID,
1249: P_CAMPAIGN_SCHEDULE_ID,

Line 1247: NVL(FND_GLOBAL.conc_login_id,-1),

1243: NVL(FND_GLOBAL.user_id,-1),
1244: sysdate,
1245: NVL(FND_GLOBAL.conc_login_id,-1),
1246: sysdate,
1247: NVL(FND_GLOBAL.conc_login_id,-1),
1248: P_CAMPAIGN_ID,
1249: P_CAMPAIGN_SCHEDULE_ID,
1250: P_DIAL_SERVER_ID,
1251: 'UNKN',

Line 1373: NVL(FND_GLOBAL.user_id,-1),

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,
1377: NVL(FND_GLOBAL.conc_login_id,-1),

Line 1375: NVL(FND_GLOBAL.conc_login_id,-1),

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,
1377: NVL(FND_GLOBAL.conc_login_id,-1),
1378: P_CAMPAIGN_ID,
1379: P_CAMPAIGN_SCHEDULE_ID,

Line 1377: NVL(FND_GLOBAL.conc_login_id,-1),

1373: NVL(FND_GLOBAL.user_id,-1),
1374: sysdate,
1375: NVL(FND_GLOBAL.conc_login_id,-1),
1376: sysdate,
1377: NVL(FND_GLOBAL.conc_login_id,-1),
1378: P_CAMPAIGN_ID,
1379: P_CAMPAIGN_SCHEDULE_ID,
1380: P_DIAL_SERVER_ID,
1381: P_DIALING_Method,