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.IEB_SERVICEPLAN_PVT dependencies on FND_GLOBAL

Line 42: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

38:
39: fnd_msg_pub.delete_msg();
40: x_return_status := fnd_api.g_ret_sts_success;
41: FND_MSG_PUB.initialize;
42: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
43: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
44: x_msg_data := '';
45: x_msg_count := 0;
46: l_temp_str := null;

Line 43: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

39: fnd_msg_pub.delete_msg();
40: x_return_status := fnd_api.g_ret_sts_success;
41: FND_MSG_PUB.initialize;
42: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
43: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
44: x_msg_data := '';
45: x_msg_count := 0;
46: l_temp_str := null;
47:

Line 81: FND_GLOBAL.USER_ID,

77: ' :12, '||
78: ' :13 '||
79: ') '
80: USING l_svc_plan_id,
81: FND_GLOBAL.USER_ID,
82: SYSDATE,
83: FND_GLOBAL.USER_ID,
84: SYSDATE,
85: FND_GLOBAL.LOGIN_ID,

Line 83: FND_GLOBAL.USER_ID,

79: ') '
80: USING l_svc_plan_id,
81: FND_GLOBAL.USER_ID,
82: SYSDATE,
83: FND_GLOBAL.USER_ID,
84: SYSDATE,
85: FND_GLOBAL.LOGIN_ID,
86: LTRIM(RTRIM(p_name)),
87: p_direction,

Line 85: FND_GLOBAL.LOGIN_ID,

81: FND_GLOBAL.USER_ID,
82: SYSDATE,
83: FND_GLOBAL.USER_ID,
84: SYSDATE,
85: FND_GLOBAL.LOGIN_ID,
86: LTRIM(RTRIM(p_name)),
87: p_direction,
88: l_temp_str,
89: LTRIM(RTRIM(p_desc)),

Line 110: FND_GLOBAL.USER_ID,

106: LANGUAGE,
107: SOURCE_LANG
108: ) select
109: SYSDATE,
110: FND_GLOBAL.USER_ID,
111: SYSDATE,
112: FND_GLOBAL.USER_ID,
113: l_svc_plan_id,
114: 0,

Line 112: FND_GLOBAL.USER_ID,

108: ) select
109: SYSDATE,
110: FND_GLOBAL.USER_ID,
111: SYSDATE,
112: FND_GLOBAL.USER_ID,
113: l_svc_plan_id,
114: 0,
115: LTRIM(RTRIM(p_desc)),
116: FND_GLOBAL.LOGIN_ID,

Line 116: FND_GLOBAL.LOGIN_ID,

112: FND_GLOBAL.USER_ID,
113: l_svc_plan_id,
114: 0,
115: LTRIM(RTRIM(p_desc)),
116: FND_GLOBAL.LOGIN_ID,
117: LTRIM(RTRIM(p_name)),
118: L.LANGUAGE_CODE,
119: userenv('LANG')
120: FROM FND_LANGUAGES L

Line 217: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

213:
214: fnd_msg_pub.delete_msg();
215: x_return_status := fnd_api.g_ret_sts_success;
216: FND_MSG_PUB.initialize;
217: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
218: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
219: x_msg_data := '';
220: x_msg_count := 0;
221: l_temp_str := null;

Line 218: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

214: fnd_msg_pub.delete_msg();
215: x_return_status := fnd_api.g_ret_sts_success;
216: FND_MSG_PUB.initialize;
217: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
218: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
219: x_msg_data := '';
220: x_msg_count := 0;
221: l_temp_str := null;
222:

Line 280: FND_GLOBAL.USER_ID,

276: ' :16, '||
277: ' :17 '||
278: ' ) '
279: USING l_osvccov_id,
280: FND_GLOBAL.USER_ID,
281: SYSDATE,
282: FND_GLOBAL.USER_ID,
283: SYSDATE,
284: FND_GLOBAL.LOGIN_ID,

Line 282: FND_GLOBAL.USER_ID,

278: ' ) '
279: USING l_osvccov_id,
280: FND_GLOBAL.USER_ID,
281: SYSDATE,
282: FND_GLOBAL.USER_ID,
283: SYSDATE,
284: FND_GLOBAL.LOGIN_ID,
285: rec_obj.schedule_type,
286: rec_obj.regular_schd_day,

Line 284: FND_GLOBAL.LOGIN_ID,

280: FND_GLOBAL.USER_ID,
281: SYSDATE,
282: FND_GLOBAL.USER_ID,
283: SYSDATE,
284: FND_GLOBAL.LOGIN_ID,
285: rec_obj.schedule_type,
286: rec_obj.regular_schd_day,
287: rec_obj.spec_schd_date,
288: rec_obj.start_time,

Line 379: FND_GLOBAL.USER_ID,

375: ' :20, '||
376: ' :21 '||
377: ' ) '
378: USING l_isvccov_id,
379: FND_GLOBAL.USER_ID,
380: SYSDATE,
381: FND_GLOBAL.USER_ID,
382: SYSDATE,
383: FND_GLOBAL.LOGIN_ID,

Line 381: FND_GLOBAL.USER_ID,

377: ' ) '
378: USING l_isvccov_id,
379: FND_GLOBAL.USER_ID,
380: SYSDATE,
381: FND_GLOBAL.USER_ID,
382: SYSDATE,
383: FND_GLOBAL.LOGIN_ID,
384: rec_obj.schedule_type,
385: rec_obj.regular_schd_day,

Line 383: FND_GLOBAL.LOGIN_ID,

379: FND_GLOBAL.USER_ID,
380: SYSDATE,
381: FND_GLOBAL.USER_ID,
382: SYSDATE,
383: FND_GLOBAL.LOGIN_ID,
384: rec_obj.schedule_type,
385: rec_obj.regular_schd_day,
386: rec_obj.spec_schd_date,
387: rec_obj.start_time,

Line 486: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

482:
483: fnd_msg_pub.delete_msg();
484: x_return_status := fnd_api.g_ret_sts_success;
485: FND_MSG_PUB.initialize;
486: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
487: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
488: x_msg_data := '';
489: x_msg_count := 0;
490: l_temp_str := null;

Line 487: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

483: fnd_msg_pub.delete_msg();
484: x_return_status := fnd_api.g_ret_sts_success;
485: FND_MSG_PUB.initialize;
486: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
487: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
488: x_msg_data := '';
489: x_msg_count := 0;
490: l_temp_str := null;
491: if ( rec_obj.direction = 'O') then

Line 510: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

506: END_TIME_HHMM = rec_obj.end_time,
507: MIN_AGENT = l_minagent,
508: QUOTA = l_quota,
509: SERVICE_LEVEL_ID = rec_obj.slevel_id,
510: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
511: LAST_UPDATE_DATE = SYSDATE,
512: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
513: where SVCPLN_SVCPLN_ID = rec_obj.splan_id
514: and SCHEDULE_TYPE = rec_obj.schedule_type

Line 512: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

508: QUOTA = l_quota,
509: SERVICE_LEVEL_ID = rec_obj.slevel_id,
510: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
511: LAST_UPDATE_DATE = SYSDATE,
512: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
513: where SVCPLN_SVCPLN_ID = rec_obj.splan_id
514: and SCHEDULE_TYPE = rec_obj.schedule_type
515: and REGULAR_SCHD_DAY = rec_obj.regular_schd_day;
516:

Line 525: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

521: END_TIME_HHMM = rec_obj.end_time,
522: MIN_AGENT = l_minagent,
523: QUOTA = l_quota,
524: SERVICE_LEVEL_ID = rec_obj.slevel_id,
525: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
526: LAST_UPDATE_DATE = SYSDATE,
527: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
528: where SVCPLN_SVCPLN_ID = rec_obj.splan_id
529: and SCHEDULE_TYPE = rec_obj.schedule_type

Line 527: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

523: QUOTA = l_quota,
524: SERVICE_LEVEL_ID = rec_obj.slevel_id,
525: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
526: LAST_UPDATE_DATE = SYSDATE,
527: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
528: where SVCPLN_SVCPLN_ID = rec_obj.splan_id
529: and SCHEDULE_TYPE = rec_obj.schedule_type
530: and SPEC_SCHD_DATE = rec_obj.spec_schd_date;
531: end if;

Line 564: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

560: MAX_WAIT_TIME = l_max_wait_time,
561: REROUTE_TIME = l_reroute_time,
562: REROUTE_WARNING_TIME = l_reroute_war_time,
563: SERVICE_LEVEL_ID = rec_obj.slevel_id,
564: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
565: LAST_UPDATE_DATE = SYSDATE,
566: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
567: where SVCPLN_SVCPLN_ID = rec_obj.splan_id
568: and SCHEDULE_TYPE = rec_obj.schedule_type

Line 566: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

562: REROUTE_WARNING_TIME = l_reroute_war_time,
563: SERVICE_LEVEL_ID = rec_obj.slevel_id,
564: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
565: LAST_UPDATE_DATE = SYSDATE,
566: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
567: where SVCPLN_SVCPLN_ID = rec_obj.splan_id
568: and SCHEDULE_TYPE = rec_obj.schedule_type
569: and REGULAR_SCHD_DAY = rec_obj.regular_schd_day;
570:

Line 583: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

579: MAX_WAIT_TIME = l_max_wait_time,
580: REROUTE_TIME = l_reroute_time,
581: REROUTE_WARNING_TIME = l_reroute_war_time,
582: SERVICE_LEVEL_ID = rec_obj.slevel_id,
583: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
584: LAST_UPDATE_DATE = SYSDATE,
585: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
586: where SVCPLN_SVCPLN_ID = rec_obj.splan_id
587: and SCHEDULE_TYPE = rec_obj.schedule_type

Line 585: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

581: REROUTE_WARNING_TIME = l_reroute_war_time,
582: SERVICE_LEVEL_ID = rec_obj.slevel_id,
583: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
584: LAST_UPDATE_DATE = SYSDATE,
585: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
586: where SVCPLN_SVCPLN_ID = rec_obj.splan_id
587: and SCHEDULE_TYPE = rec_obj.schedule_type
588: and SPEC_SCHD_DATE = rec_obj.spec_schd_date;
589: end if;

Line 652: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

648:
649: fnd_msg_pub.delete_msg();
650: x_return_status := fnd_api.g_ret_sts_success;
651: FND_MSG_PUB.initialize;
652: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
653: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
654: x_msg_data := '';
655: x_msg_count := 0;
656:

Line 653: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

649: fnd_msg_pub.delete_msg();
650: x_return_status := fnd_api.g_ret_sts_success;
651: FND_MSG_PUB.initialize;
652: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
653: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
654: x_msg_data := '';
655: x_msg_count := 0;
656:
657: select IEB_SVC_CAT_RULES_S1.nextval into l_wbscrule_id from dual;

Line 690: FND_GLOBAL.USER_ID,

686: ' :13 '||
687: ' ) '
688: USING l_wbscrule_id,
689: 'C',
690: FND_GLOBAL.USER_ID,
691: SYSDATE,
692: FND_GLOBAL.USER_ID,
693: SYSDATE,
694: FND_GLOBAL.LOGIN_ID,

Line 692: FND_GLOBAL.USER_ID,

688: USING l_wbscrule_id,
689: 'C',
690: FND_GLOBAL.USER_ID,
691: SYSDATE,
692: FND_GLOBAL.USER_ID,
693: SYSDATE,
694: FND_GLOBAL.LOGIN_ID,
695: p_classfn_name,
696: 'N',

Line 694: FND_GLOBAL.LOGIN_ID,

690: FND_GLOBAL.USER_ID,
691: SYSDATE,
692: FND_GLOBAL.USER_ID,
693: SYSDATE,
694: FND_GLOBAL.LOGIN_ID,
695: p_classfn_name,
696: 'N',
697: p_classfn_name,
698: p_svc_cat_id,

Line 777: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

773:
774: fnd_msg_pub.delete_msg();
775: x_return_status := fnd_api.g_ret_sts_success;
776: FND_MSG_PUB.initialize;
777: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
778: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
779: x_msg_data := '';
780: x_msg_count := 0;
781:

Line 778: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

774: fnd_msg_pub.delete_msg();
775: x_return_status := fnd_api.g_ret_sts_success;
776: FND_MSG_PUB.initialize;
777: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
778: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
779: x_msg_data := '';
780: x_msg_count := 0;
781:
782: select media_type into l_media_type

Line 839: FND_GLOBAL.USER_ID,

835: ' :17, '||
836: ' :18 '||
837: ' ) '
838: USING l_wbsc_id,
839: FND_GLOBAL.USER_ID,
840: SYSDATE,
841: FND_GLOBAL.USER_ID,
842: SYSDATE,
843: FND_GLOBAL.LOGIN_ID,

Line 841: FND_GLOBAL.USER_ID,

837: ' ) '
838: USING l_wbsc_id,
839: FND_GLOBAL.USER_ID,
840: SYSDATE,
841: FND_GLOBAL.USER_ID,
842: SYSDATE,
843: FND_GLOBAL.LOGIN_ID,
844: l_svr_cat_name,
845: p_name,

Line 843: FND_GLOBAL.LOGIN_ID,

839: FND_GLOBAL.USER_ID,
840: SYSDATE,
841: FND_GLOBAL.USER_ID,
842: SYSDATE,
843: FND_GLOBAL.LOGIN_ID,
844: l_svr_cat_name,
845: p_name,
846: 'Y',
847: l_media_type,

Line 935: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

931:
932: fnd_msg_pub.delete_msg();
933: x_return_status := fnd_api.g_ret_sts_success;
934: FND_MSG_PUB.initialize;
935: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
936: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
937: x_msg_data := '';
938: x_msg_count := 0;
939:

Line 936: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

932: fnd_msg_pub.delete_msg();
933: x_return_status := fnd_api.g_ret_sts_success;
934: FND_MSG_PUB.initialize;
935: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
936: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
937: x_msg_data := '';
938: x_msg_count := 0;
939:
940:

Line 994: FND_GLOBAL.USER_ID,

990: ' :16, '||
991: ' :17 '||
992: ' ) '
993: USING l_wbsc_id,
994: FND_GLOBAL.USER_ID,
995: SYSDATE,
996: FND_GLOBAL.USER_ID,
997: SYSDATE,
998: FND_GLOBAL.LOGIN_ID,

Line 996: FND_GLOBAL.USER_ID,

992: ' ) '
993: USING l_wbsc_id,
994: FND_GLOBAL.USER_ID,
995: SYSDATE,
996: FND_GLOBAL.USER_ID,
997: SYSDATE,
998: FND_GLOBAL.LOGIN_ID,
999: l_svr_cat_name,
1000: 'Y',

Line 998: FND_GLOBAL.LOGIN_ID,

994: FND_GLOBAL.USER_ID,
995: SYSDATE,
996: FND_GLOBAL.USER_ID,
997: SYSDATE,
998: FND_GLOBAL.LOGIN_ID,
999: l_svr_cat_name,
1000: 'Y',
1001: l_media_type,
1002: 0,

Line 1080: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1076:
1077: fnd_msg_pub.delete_msg();
1078: x_return_status := fnd_api.g_ret_sts_success;
1079: FND_MSG_PUB.initialize;
1080: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1081: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1082: x_msg_data := '';
1083: x_msg_count := 0;
1084:

Line 1081: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1077: fnd_msg_pub.delete_msg();
1078: x_return_status := fnd_api.g_ret_sts_success;
1079: FND_MSG_PUB.initialize;
1080: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1081: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1082: x_msg_data := '';
1083: x_msg_count := 0;
1084:
1085:

Line 1118: FND_GLOBAL.USER_ID,

1114: ' :8, '||
1115: ' :9'||
1116: ') '
1117: USING l_svc_plan_id,
1118: FND_GLOBAL.USER_ID,
1119: SYSDATE,
1120: FND_GLOBAL.USER_ID,
1121: SYSDATE,
1122: FND_GLOBAL.LOGIN_ID,

Line 1120: FND_GLOBAL.USER_ID,

1116: ') '
1117: USING l_svc_plan_id,
1118: FND_GLOBAL.USER_ID,
1119: SYSDATE,
1120: FND_GLOBAL.USER_ID,
1121: SYSDATE,
1122: FND_GLOBAL.LOGIN_ID,
1123: p_base_plan_id,
1124: 0,

Line 1122: FND_GLOBAL.LOGIN_ID,

1118: FND_GLOBAL.USER_ID,
1119: SYSDATE,
1120: FND_GLOBAL.USER_ID,
1121: SYSDATE,
1122: FND_GLOBAL.LOGIN_ID,
1123: p_base_plan_id,
1124: 0,
1125: 0;
1126:

Line 1192: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1188:
1189: fnd_msg_pub.delete_msg();
1190: x_return_status := fnd_api.g_ret_sts_success;
1191: FND_MSG_PUB.initialize;
1192: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1193: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1194: x_msg_data := '';
1195: x_msg_count := 0;
1196:

Line 1193: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1189: fnd_msg_pub.delete_msg();
1190: x_return_status := fnd_api.g_ret_sts_success;
1191: FND_MSG_PUB.initialize;
1192: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1193: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1194: x_msg_data := '';
1195: x_msg_count := 0;
1196:
1197:

Line 1224: FND_GLOBAL.USER_ID,

1220: ' :10 '||
1221: ') '
1222: USING l_map_id,
1223: p_plan_id,
1224: FND_GLOBAL.USER_ID,
1225: SYSDATE,
1226: FND_GLOBAL.USER_ID,
1227: SYSDATE,
1228: FND_GLOBAL.LOGIN_ID,

Line 1226: FND_GLOBAL.USER_ID,

1222: USING l_map_id,
1223: p_plan_id,
1224: FND_GLOBAL.USER_ID,
1225: SYSDATE,
1226: FND_GLOBAL.USER_ID,
1227: SYSDATE,
1228: FND_GLOBAL.LOGIN_ID,
1229: p_server_group_id,
1230: 0,

Line 1228: FND_GLOBAL.LOGIN_ID,

1224: FND_GLOBAL.USER_ID,
1225: SYSDATE,
1226: FND_GLOBAL.USER_ID,
1227: SYSDATE,
1228: FND_GLOBAL.LOGIN_ID,
1229: p_server_group_id,
1230: 0,
1231: 0 ;
1232:

Line 1297: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1293:
1294: fnd_msg_pub.delete_msg();
1295: x_return_status := fnd_api.g_ret_sts_success;
1296: FND_MSG_PUB.initialize;
1297: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1298: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1299: x_msg_data := '';
1300:
1301:

Line 1298: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1294: fnd_msg_pub.delete_msg();
1295: x_return_status := fnd_api.g_ret_sts_success;
1296: FND_MSG_PUB.initialize;
1297: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1298: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1299: x_msg_data := '';
1300:
1301:
1302: update IEB_WB_SVC_CATS set

Line 1304: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1300:
1301:
1302: update IEB_WB_SVC_CATS set
1303: svcpln_svcpln_id = p_reg_plan_id,
1304: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1305: LAST_UPDATE_DATE = SYSDATE,
1306: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1307: where MEDIA_TYPE_ID = p_media_type_id
1308: and svcpln_svcpln_id = p_base_plan_id;

Line 1306: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1302: update IEB_WB_SVC_CATS set
1303: svcpln_svcpln_id = p_reg_plan_id,
1304: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1305: LAST_UPDATE_DATE = SYSDATE,
1306: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1307: where MEDIA_TYPE_ID = p_media_type_id
1308: and svcpln_svcpln_id = p_base_plan_id;
1309:
1310:

Line 1371: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1367:
1368: fnd_msg_pub.delete_msg();
1369: x_return_status := fnd_api.g_ret_sts_success;
1370: FND_MSG_PUB.initialize;
1371: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1372: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1373: x_msg_data := '';
1374: x_msg_count := 0;
1375: l_temp_str := null;

Line 1372: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1368: fnd_msg_pub.delete_msg();
1369: x_return_status := fnd_api.g_ret_sts_success;
1370: FND_MSG_PUB.initialize;
1371: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1372: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1373: x_msg_data := '';
1374: x_msg_count := 0;
1375: l_temp_str := null;
1376:

Line 1418: FND_GLOBAL.USER_ID,

1414: ' :16, '||
1415: ' :17 '||
1416: ') '
1417: USING l_service_lvl_id,
1418: FND_GLOBAL.USER_ID,
1419: SYSDATE,
1420: FND_GLOBAL.USER_ID,
1421: SYSDATE,
1422: FND_GLOBAL.LOGIN_ID,

Line 1420: FND_GLOBAL.USER_ID,

1416: ') '
1417: USING l_service_lvl_id,
1418: FND_GLOBAL.USER_ID,
1419: SYSDATE,
1420: FND_GLOBAL.USER_ID,
1421: SYSDATE,
1422: FND_GLOBAL.LOGIN_ID,
1423: rec_obj.direction,
1424: l_temp_str,

Line 1422: FND_GLOBAL.LOGIN_ID,

1418: FND_GLOBAL.USER_ID,
1419: SYSDATE,
1420: FND_GLOBAL.USER_ID,
1421: SYSDATE,
1422: FND_GLOBAL.LOGIN_ID,
1423: rec_obj.direction,
1424: l_temp_str,
1425: rec_obj.hourly_quota,
1426: rec_obj.min_agents,

Line 1454: FND_GLOBAL.USER_ID,

1450: LANGUAGE,
1451: SOURCE_LANG
1452: ) select
1453: l_service_lvl_id,
1454: FND_GLOBAL.USER_ID,
1455: SYSDATE,
1456: FND_GLOBAL.USER_ID,
1457: SYSDATE,
1458: FND_GLOBAL.LOGIN_ID,

Line 1456: FND_GLOBAL.USER_ID,

1452: ) select
1453: l_service_lvl_id,
1454: FND_GLOBAL.USER_ID,
1455: SYSDATE,
1456: FND_GLOBAL.USER_ID,
1457: SYSDATE,
1458: FND_GLOBAL.LOGIN_ID,
1459: LTRIM(RTRIM(rec_obj.level_name)),
1460: LTRIM(RTRIM(rec_obj.level_description)),

Line 1458: FND_GLOBAL.LOGIN_ID,

1454: FND_GLOBAL.USER_ID,
1455: SYSDATE,
1456: FND_GLOBAL.USER_ID,
1457: SYSDATE,
1458: FND_GLOBAL.LOGIN_ID,
1459: LTRIM(RTRIM(rec_obj.level_name)),
1460: LTRIM(RTRIM(rec_obj.level_description)),
1461: 0,
1462: 0,

Line 1534: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1530:
1531: fnd_msg_pub.delete_msg();
1532: x_return_status := fnd_api.g_ret_sts_success;
1533: FND_MSG_PUB.initialize;
1534: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1535: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1536: x_msg_data := '';
1537:
1538: if (rec_obj.direction = 'I') then

Line 1535: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1531: fnd_msg_pub.delete_msg();
1532: x_return_status := fnd_api.g_ret_sts_success;
1533: FND_MSG_PUB.initialize;
1534: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1535: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1536: x_msg_data := '';
1537:
1538: if (rec_obj.direction = 'I') then
1539: -- dbms_output.put_line('inbound');

Line 1541: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1537:
1538: if (rec_obj.direction = 'I') then
1539: -- dbms_output.put_line('inbound');
1540: update IEB_SERVICE_LEVELS_B set
1541: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1542: LAST_UPDATE_DATE = SYSDATE,
1543: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1544: GOAL_PERCENT = rec_obj.goal_percent,
1545: GOAL_TIME = rec_obj.goal_time,

Line 1543: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1539: -- dbms_output.put_line('inbound');
1540: update IEB_SERVICE_LEVELS_B set
1541: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1542: LAST_UPDATE_DATE = SYSDATE,
1543: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1544: GOAL_PERCENT = rec_obj.goal_percent,
1545: GOAL_TIME = rec_obj.goal_time,
1546: MAX_WAIT_TIME = rec_obj.max_wait_time,
1547: MIN_AGENTS= rec_obj.min_agents

Line 1554: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1550:
1551: elsif (rec_obj.direction = 'O') then
1552: -- dbms_output.put_line('outbound');
1553: update IEB_SERVICE_LEVELS_B set
1554: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1555: LAST_UPDATE_DATE = SYSDATE,
1556: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1557: HOURLY_QUOTA = rec_obj.hourly_quota,
1558: MIN_AGENTS= rec_obj.min_agents

Line 1556: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1552: -- dbms_output.put_line('outbound');
1553: update IEB_SERVICE_LEVELS_B set
1554: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1555: LAST_UPDATE_DATE = SYSDATE,
1556: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1557: HOURLY_QUOTA = rec_obj.hourly_quota,
1558: MIN_AGENTS= rec_obj.min_agents
1559: where
1560: SERVICE_LEVEL_ID = rec_obj.service_level_id;

Line 1619: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1615: l_service_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
1616:
1617: BEGIN
1618:
1619: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1620: x_return_status := fnd_api.g_ret_sts_success;
1621: x_msg_count := 0;
1622: x_msg_data := '';
1623:

Line 1687: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1683:
1684:
1685: BEGIN
1686:
1687: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1688: x_return_status := fnd_api.g_ret_sts_success;
1689: x_msg_count := 0;
1690: x_msg_data := '';
1691:

Line 1786: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1782:
1783:
1784: BEGIN
1785:
1786: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1787: x_return_status := fnd_api.g_ret_sts_success;
1788: x_msg_count := 0;
1789: x_msg_data := '';
1790:

Line 1859: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1855:
1856:
1857: BEGIN
1858:
1859: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1860: x_return_status := fnd_api.g_ret_sts_success;
1861: x_msg_count := 0;
1862: x_msg_data := '';
1863:

Line 1918: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1914:
1915:
1916: BEGIN
1917:
1918: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1919: x_return_status := fnd_api.g_ret_sts_success;
1920: x_msg_count := 0;
1921: x_msg_data := '';
1922:

Line 1971: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

1967:
1968:
1969: BEGIN
1970:
1971: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1972: x_return_status := fnd_api.g_ret_sts_success;
1973: x_msg_count := 0;
1974: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1975: x_msg_data := '';

Line 1974: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

1970:
1971: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1972: x_return_status := fnd_api.g_ret_sts_success;
1973: x_msg_count := 0;
1974: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1975: x_msg_data := '';
1976:
1977: select MEDIA_TYPE_ID into l_media_type_id from IEB_SERVICE_PLANS where SVCPLN_ID = p_base_plan_id;
1978:

Line 1981: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1977: select MEDIA_TYPE_ID into l_media_type_id from IEB_SERVICE_PLANS where SVCPLN_ID = p_base_plan_id;
1978:
1979: update IEB_WB_SVC_CATS set
1980: svcpln_svcpln_id = p_base_plan_id,
1981: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1982: LAST_UPDATE_DATE = SYSDATE,
1983: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1984: where MEDIA_TYPE_ID = l_media_type_id
1985: and svcpln_svcpln_id = p_reg_plan_id;

Line 1983: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1979: update IEB_WB_SVC_CATS set
1980: svcpln_svcpln_id = p_base_plan_id,
1981: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1982: LAST_UPDATE_DATE = SYSDATE,
1983: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1984: where MEDIA_TYPE_ID = l_media_type_id
1985: and svcpln_svcpln_id = p_reg_plan_id;
1986:
1987:

Line 2062: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

2058:
2059:
2060: BEGIN
2061:
2062: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2063: x_return_status := fnd_api.g_ret_sts_success;
2064: x_msg_count := 0;
2065: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2066: x_msg_data := '';

Line 2065: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

2061:
2062: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2063: x_return_status := fnd_api.g_ret_sts_success;
2064: x_msg_count := 0;
2065: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2066: x_msg_data := '';
2067:
2068:
2069: EXECUTE immediate

Line 2080: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2076:
2077:
2078: update IEB_WB_SVC_CATS set
2079: svcpln_svcpln_id = p_base_plan_id,
2080: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2081: LAST_UPDATE_DATE = SYSDATE,
2082: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2083: where MEDIA_TYPE_ID = p_media_type_id
2084: and svcpln_svcpln_id = p_reg_plan_id;

Line 2082: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2078: update IEB_WB_SVC_CATS set
2079: svcpln_svcpln_id = p_base_plan_id,
2080: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2081: LAST_UPDATE_DATE = SYSDATE,
2082: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2083: where MEDIA_TYPE_ID = p_media_type_id
2084: and svcpln_svcpln_id = p_reg_plan_id;
2085:
2086:

Line 2118: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

2114:
2115:
2116: BEGIN
2117:
2118: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2119: x_return_status := fnd_api.g_ret_sts_success;
2120: x_msg_count := 0;
2121: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2122: x_msg_data := '';

Line 2121: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

2117:
2118: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2119: x_return_status := fnd_api.g_ret_sts_success;
2120: x_msg_count := 0;
2121: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2122: x_msg_data := '';
2123:
2124:
2125: