DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on CSF_UTIL_PVT

Line 796: l_distance := csf_util_pvt.get_miss_num;

792: p_res_id => p_unsorted_res_tbl(i).resource_id
793: , p_res_type => p_unsorted_res_tbl(i).resource_type
794: , p_date => p_start
795: );
796: l_distance := csf_util_pvt.get_miss_num;
797:
798: -- Fetch the Geometry corresponding to the Address
799: IF l_address.geometry IS NOT NULL THEN
800: csf_locus_pub.verify_locus(p_api_version => 1.0

Line 1146: IF csf_util_pvt.g_timing_activated THEN

1142: END IF;
1143:
1144: x_return_status := fnd_api.g_ret_sts_success;
1145:
1146: IF csf_util_pvt.g_timing_activated THEN
1147: csf_util_pvt.add_timer(105, 'Get resources to schedule (init)', 0, NULL);
1148: END IF;
1149:
1150: l_contracts_flag := NVL(p_contracts_flag, 'N');

Line 1147: csf_util_pvt.add_timer(105, 'Get resources to schedule (init)', 0, NULL);

1143:
1144: x_return_status := fnd_api.g_ret_sts_success;
1145:
1146: IF csf_util_pvt.g_timing_activated THEN
1147: csf_util_pvt.add_timer(105, 'Get resources to schedule (init)', 0, NULL);
1148: END IF;
1149:
1150: l_contracts_flag := NVL(p_contracts_flag, 'N');
1151: l_ib_flag := NVL(p_ib_flag, 'N');

Line 1191: IF csf_util_pvt.g_timing_activated THEN

1187:
1188: -- Convert the given Task ID or the Qualifier Table to SR Task Record
1189: IF l_contracts_flag = 'Y' OR l_ib_flag = 'Y' OR l_territory_flag = 'Y' THEN
1190: IF p_res_qualifier_tbl.COUNT > 0 THEN
1191: IF csf_util_pvt.g_timing_activated THEN
1192: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 0, NULL);
1193: END IF;
1194: l_sr_task_rec := get_qualified_task_rec(p_res_qualifier_tbl);
1195: IF csf_util_pvt.g_timing_activated THEN

Line 1192: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 0, NULL);

1188: -- Convert the given Task ID or the Qualifier Table to SR Task Record
1189: IF l_contracts_flag = 'Y' OR l_ib_flag = 'Y' OR l_territory_flag = 'Y' THEN
1190: IF p_res_qualifier_tbl.COUNT > 0 THEN
1191: IF csf_util_pvt.g_timing_activated THEN
1192: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 0, NULL);
1193: END IF;
1194: l_sr_task_rec := get_qualified_task_rec(p_res_qualifier_tbl);
1195: IF csf_util_pvt.g_timing_activated THEN
1196: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 1, NULL);

Line 1195: IF csf_util_pvt.g_timing_activated THEN

1191: IF csf_util_pvt.g_timing_activated THEN
1192: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 0, NULL);
1193: END IF;
1194: l_sr_task_rec := get_qualified_task_rec(p_res_qualifier_tbl);
1195: IF csf_util_pvt.g_timing_activated THEN
1196: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 1, NULL);
1197: END IF;
1198: ELSE
1199: IF csf_util_pvt.g_timing_activated THEN

Line 1196: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 1, NULL);

1192: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 0, NULL);
1193: END IF;
1194: l_sr_task_rec := get_qualified_task_rec(p_res_qualifier_tbl);
1195: IF csf_util_pvt.g_timing_activated THEN
1196: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 1, NULL);
1197: END IF;
1198: ELSE
1199: IF csf_util_pvt.g_timing_activated THEN
1200: csf_util_pvt.add_timer(107, 'get territory qualifiers for task', 0, NULL);

Line 1199: IF csf_util_pvt.g_timing_activated THEN

1195: IF csf_util_pvt.g_timing_activated THEN
1196: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 1, NULL);
1197: END IF;
1198: ELSE
1199: IF csf_util_pvt.g_timing_activated THEN
1200: csf_util_pvt.add_timer(107, 'get territory qualifiers for task', 0, NULL);
1201: END IF;
1202: l_sr_task_rec := get_qualified_task_rec(get_res_qualifier_table(p_task_id));
1203: IF csf_util_pvt.g_timing_activated THEN

Line 1200: csf_util_pvt.add_timer(107, 'get territory qualifiers for task', 0, NULL);

1196: csf_util_pvt.add_timer(106, 'convert territory qualifiers to record', 1, NULL);
1197: END IF;
1198: ELSE
1199: IF csf_util_pvt.g_timing_activated THEN
1200: csf_util_pvt.add_timer(107, 'get territory qualifiers for task', 0, NULL);
1201: END IF;
1202: l_sr_task_rec := get_qualified_task_rec(get_res_qualifier_table(p_task_id));
1203: IF csf_util_pvt.g_timing_activated THEN
1204: csf_util_pvt.add_timer(107, 'get territory qualifiers for task', 1, NULL);

Line 1203: IF csf_util_pvt.g_timing_activated THEN

1199: IF csf_util_pvt.g_timing_activated THEN
1200: csf_util_pvt.add_timer(107, 'get territory qualifiers for task', 0, NULL);
1201: END IF;
1202: l_sr_task_rec := get_qualified_task_rec(get_res_qualifier_table(p_task_id));
1203: IF csf_util_pvt.g_timing_activated THEN
1204: csf_util_pvt.add_timer(107, 'get territory qualifiers for task', 1, NULL);
1205: END IF;
1206: END IF;
1207: l_sr_task_rec.task_id := p_task_id;

Line 1204: csf_util_pvt.add_timer(107, 'get territory qualifiers for task', 1, NULL);

1200: csf_util_pvt.add_timer(107, 'get territory qualifiers for task', 0, NULL);
1201: END IF;
1202: l_sr_task_rec := get_qualified_task_rec(get_res_qualifier_table(p_task_id));
1203: IF csf_util_pvt.g_timing_activated THEN
1204: csf_util_pvt.add_timer(107, 'get territory qualifiers for task', 1, NULL);
1205: END IF;
1206: END IF;
1207: l_sr_task_rec.task_id := p_task_id;
1208: l_sr_task_rec.service_request_id := p_incident_id;

Line 1211: IF csf_util_pvt.g_timing_activated THEN

1207: l_sr_task_rec.task_id := p_task_id;
1208: l_sr_task_rec.service_request_id := p_incident_id;
1209: END IF;
1210:
1211: IF csf_util_pvt.g_timing_activated THEN
1212: csf_util_pvt.add_timer(105, 'get resources to schedule (init)', 1, NULL);
1213: END IF;
1214:
1215: l_continue_search := TRUE;

Line 1212: csf_util_pvt.add_timer(105, 'get resources to schedule (init)', 1, NULL);

1208: l_sr_task_rec.service_request_id := p_incident_id;
1209: END IF;
1210:
1211: IF csf_util_pvt.g_timing_activated THEN
1212: csf_util_pvt.add_timer(105, 'get resources to schedule (init)', 1, NULL);
1213: END IF;
1214:
1215: l_continue_search := TRUE;
1216:

Line 1219: IF csf_util_pvt.g_timing_activated THEN

1215: l_continue_search := TRUE;
1216:
1217: -- Retrieve the Resources defined in Contracts / IB
1218: IF l_contracts_flag = 'Y' OR l_ib_flag = 'Y' THEN
1219: IF csf_util_pvt.g_timing_activated THEN
1220: csf_util_pvt.add_timer(108, 'Get contract/IB resources', 0, NULL);
1221: END IF;
1222:
1223: IF l_contracts_flag = 'Y' THEN

Line 1220: csf_util_pvt.add_timer(108, 'Get contract/IB resources', 0, NULL);

1216:
1217: -- Retrieve the Resources defined in Contracts / IB
1218: IF l_contracts_flag = 'Y' OR l_ib_flag = 'Y' THEN
1219: IF csf_util_pvt.g_timing_activated THEN
1220: csf_util_pvt.add_timer(108, 'Get contract/IB resources', 0, NULL);
1221: END IF;
1222:
1223: IF l_contracts_flag = 'Y' THEN
1224: -- Added by lokumar for bug#7340932

Line 1274: IF csf_util_pvt.g_timing_activated THEN

1270: -- Since JTF Assignment Manager doesnt return End Windows properly,
1271: -- setting them to the given Plan Window.
1272: set_generic_planwindow(l_contracts_ib_res_tbl, p_start, p_end);
1273:
1274: IF csf_util_pvt.g_timing_activated THEN
1275: csf_util_pvt.add_timer(108, 'get contract/IB resources', 1, NULL);
1276: END IF;
1277: END IF;
1278:

Line 1275: csf_util_pvt.add_timer(108, 'get contract/IB resources', 1, NULL);

1271: -- setting them to the given Plan Window.
1272: set_generic_planwindow(l_contracts_ib_res_tbl, p_start, p_end);
1273:
1274: IF csf_util_pvt.g_timing_activated THEN
1275: csf_util_pvt.add_timer(108, 'get contract/IB resources', 1, NULL);
1276: END IF;
1277: END IF;
1278:
1279: -- Retrieve Resources from Territory

Line 1281: IF csf_util_pvt.g_timing_activated THEN

1277: END IF;
1278:
1279: -- Retrieve Resources from Territory
1280: IF l_territory_flag = 'Y' AND l_continue_search THEN
1281: IF csf_util_pvt.g_timing_activated THEN
1282: csf_util_pvt.add_timer(109, 'get territory resources', 0, NULL);
1283: END IF;
1284:
1285: l_stic := l_stic + 4;

Line 1282: csf_util_pvt.add_timer(109, 'get territory resources', 0, NULL);

1278:
1279: -- Retrieve Resources from Territory
1280: IF l_territory_flag = 'Y' AND l_continue_search THEN
1281: IF csf_util_pvt.g_timing_activated THEN
1282: csf_util_pvt.add_timer(109, 'get territory resources', 0, NULL);
1283: END IF;
1284:
1285: l_stic := l_stic + 4;
1286:

Line 1321: IF csf_util_pvt.g_timing_activated THEN

1317: -- Since JTF Assignment Manager doesnt return End Windows properly,
1318: -- setting them to the given Plan Window.
1319: set_generic_planwindow(l_territory_res_tbl, p_start, p_end);
1320:
1321: IF csf_util_pvt.g_timing_activated THEN
1322: csf_util_pvt.add_timer(109, 'get territory resources', 1, NULL);
1323: END IF;
1324: END IF;
1325:

Line 1322: csf_util_pvt.add_timer(109, 'get territory resources', 1, NULL);

1318: -- setting them to the given Plan Window.
1319: set_generic_planwindow(l_territory_res_tbl, p_start, p_end);
1320:
1321: IF csf_util_pvt.g_timing_activated THEN
1322: csf_util_pvt.add_timer(109, 'get territory resources', 1, NULL);
1323: END IF;
1324: END IF;
1325:
1326: -- Retrieve the Skilled Resources for the Task

Line 1378: IF csf_util_pvt.g_timing_activated THEN

1374: END IF;
1375:
1376: IF p_scheduling_mode <> 'A' THEN
1377: -- Sort the Resources by their distance to the Task.
1378: IF csf_util_pvt.g_timing_activated THEN
1379: csf_util_pvt.add_timer(113, 'sort resources list', 0, NULL);
1380: END IF;
1381:
1382: IF x_res_tbl.COUNT > 1 AND NVL(p_sort_flag, 'Y') = 'Y' THEN

Line 1379: csf_util_pvt.add_timer(113, 'sort resources list', 0, NULL);

1375:
1376: IF p_scheduling_mode <> 'A' THEN
1377: -- Sort the Resources by their distance to the Task.
1378: IF csf_util_pvt.g_timing_activated THEN
1379: csf_util_pvt.add_timer(113, 'sort resources list', 0, NULL);
1380: END IF;
1381:
1382: IF x_res_tbl.COUNT > 1 AND NVL(p_sort_flag, 'Y') = 'Y' THEN
1383: x_res_tbl := sort_resource_by_distance(x_res_tbl, p_task_id, p_start, p_end);

Line 1386: IF csf_util_pvt.g_timing_activated THEN

1382: IF x_res_tbl.COUNT > 1 AND NVL(p_sort_flag, 'Y') = 'Y' THEN
1383: x_res_tbl := sort_resource_by_distance(x_res_tbl, p_task_id, p_start, p_end);
1384: END IF;
1385:
1386: IF csf_util_pvt.g_timing_activated THEN
1387: csf_util_pvt.add_timer(113, 'sort resources list', 1, NULL);
1388: END IF;
1389:
1390: END IF;

Line 1387: csf_util_pvt.add_timer(113, 'sort resources list', 1, NULL);

1383: x_res_tbl := sort_resource_by_distance(x_res_tbl, p_task_id, p_start, p_end);
1384: END IF;
1385:
1386: IF csf_util_pvt.g_timing_activated THEN
1387: csf_util_pvt.add_timer(113, 'sort resources list', 1, NULL);
1388: END IF;
1389:
1390: END IF;
1391:

Line 1394: IF csf_util_pvt.g_timing_activated THEN

1390: END IF;
1391:
1392:
1393: -- The number of Resources are restricted from the Sorted List.
1394: IF csf_util_pvt.g_timing_activated THEN
1395: csf_util_pvt.add_timer(114, 'reduce sorted resources list', 0, NULL);
1396: END IF;
1397:
1398: x_res_tbl := reduce_resource_list(x_res_tbl, p_start, p_end);

Line 1395: csf_util_pvt.add_timer(114, 'reduce sorted resources list', 0, NULL);

1391:
1392:
1393: -- The number of Resources are restricted from the Sorted List.
1394: IF csf_util_pvt.g_timing_activated THEN
1395: csf_util_pvt.add_timer(114, 'reduce sorted resources list', 0, NULL);
1396: END IF;
1397:
1398: x_res_tbl := reduce_resource_list(x_res_tbl, p_start, p_end);
1399:

Line 1400: IF csf_util_pvt.g_timing_activated THEN

1396: END IF;
1397:
1398: x_res_tbl := reduce_resource_list(x_res_tbl, p_start, p_end);
1399:
1400: IF csf_util_pvt.g_timing_activated THEN
1401: csf_util_pvt.add_timer(114, 'reduce sorted resources list', 1, NULL);
1402: END IF;
1403: EXCEPTION
1404: WHEN e_no_res THEN

Line 1401: csf_util_pvt.add_timer(114, 'reduce sorted resources list', 1, NULL);

1397:
1398: x_res_tbl := reduce_resource_list(x_res_tbl, p_start, p_end);
1399:
1400: IF csf_util_pvt.g_timing_activated THEN
1401: csf_util_pvt.add_timer(114, 'reduce sorted resources list', 1, NULL);
1402: END IF;
1403: EXCEPTION
1404: WHEN e_no_res THEN
1405: x_return_status := fnd_api.g_ret_sts_error;