508: IF l_debug THEN
509: debug(' Territory Id :'||l_territory , 'get_tooltip_data_gantt', fnd_log.level_statement);
510: END IF;
511: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
512: , fnd_global.resp_appl_id
513: , fnd_global.resp_id
514: , fnd_global.user_id
515: , l_territory
516: , p_resource_type
509: debug(' Territory Id :'||l_territory , 'get_tooltip_data_gantt', fnd_log.level_statement);
510: END IF;
511: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
512: , fnd_global.resp_appl_id
513: , fnd_global.resp_id
514: , fnd_global.user_id
515: , l_territory
516: , p_resource_type
517: , p_resource_id
510: END IF;
511: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
512: , fnd_global.resp_appl_id
513: , fnd_global.resp_id
514: , fnd_global.user_id
515: , l_territory
516: , p_resource_type
517: , p_resource_id
518: );
516: , p_resource_type
517: , p_resource_id
518: );
519: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
520: , fnd_global.resp_appl_id
521: , fnd_global.resp_id
522: , fnd_global.user_id
523: , l_territory
524: , p_resource_type
517: , p_resource_id
518: );
519: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
520: , fnd_global.resp_appl_id
521: , fnd_global.resp_id
522: , fnd_global.user_id
523: , l_territory
524: , p_resource_type
525: , p_resource_id
518: );
519: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
520: , fnd_global.resp_appl_id
521: , fnd_global.resp_id
522: , fnd_global.user_id
523: , l_territory
524: , p_resource_type
525: , p_resource_id
526: );
643: l_rec.incident_customer_name := null;
644:
645: for i in 1..l_lines
646: loop
647: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1, 80) || fnd_global.local_chr (10);
648: l_task_rec.party_name := substrb(l_task_rec.party_name,81);
649: IF l_debug THEN
650: debug(' Incident Customer name : '||l_rec.incident_customer_name , 'get_tooltip_data_gantt', fnd_log.level_statement);
651: debug(' Party Name : '||l_task_rec.party_name , 'get_tooltip_data_gantt', fnd_log.level_statement);
1408:
1409: CURSOR c_cust_tooltip is
1410: SELECT field_name
1411: FROM csf_gantt_chart_setup
1412: WHERE user_id = fnd_global.user_id
1413: AND setup_type = 'TOOLTIP'
1414: ORDER BY seq_no;
1415:
1416: CURSOR c_cust_default_tooltip is
1638: fetch c_terr into l_territory;
1639: close c_terr;
1640:
1641: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
1642: , fnd_global.resp_appl_id
1643: , fnd_global.resp_id
1644: , fnd_global.user_id
1645: , l_territory
1646: , p_resource_type
1639: close c_terr;
1640:
1641: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
1642: , fnd_global.resp_appl_id
1643: , fnd_global.resp_id
1644: , fnd_global.user_id
1645: , l_territory
1646: , p_resource_type
1647: , p_resource_id
1640:
1641: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
1642: , fnd_global.resp_appl_id
1643: , fnd_global.resp_id
1644: , fnd_global.user_id
1645: , l_territory
1646: , p_resource_type
1647: , p_resource_id
1648: );
1646: , p_resource_type
1647: , p_resource_id
1648: );
1649: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
1650: , fnd_global.resp_appl_id
1651: , fnd_global.resp_id
1652: , fnd_global.user_id
1653: , l_territory
1654: , p_resource_type
1647: , p_resource_id
1648: );
1649: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
1650: , fnd_global.resp_appl_id
1651: , fnd_global.resp_id
1652: , fnd_global.user_id
1653: , l_territory
1654: , p_resource_type
1655: , p_resource_id
1648: );
1649: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
1650: , fnd_global.resp_appl_id
1651: , fnd_global.resp_id
1652: , fnd_global.user_id
1653: , l_territory
1654: , p_resource_type
1655: , p_resource_id
1656: );
1725: l_rec.incident_customer_name := null;
1726:
1727: for i in 1..l_lines
1728: loop
1729: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1, 80) || fnd_global.local_chr (10);
1730: l_task_rec.party_name := substrb(l_task_rec.party_name,81);
1731: end loop;
1732:
1733: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1);
2552: open c_terr;
2553: fetch c_terr into l_territory;
2554: close c_terr;
2555: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
2556: , fnd_global.resp_appl_id
2557: , fnd_global.resp_id
2558: , fnd_global.user_id
2559: , l_territory
2560: , p_resource_type
2553: fetch c_terr into l_territory;
2554: close c_terr;
2555: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
2556: , fnd_global.resp_appl_id
2557: , fnd_global.resp_id
2558: , fnd_global.user_id
2559: , l_territory
2560: , p_resource_type
2561: , p_resource_id
2554: close c_terr;
2555: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
2556: , fnd_global.resp_appl_id
2557: , fnd_global.resp_id
2558: , fnd_global.user_id
2559: , l_territory
2560: , p_resource_type
2561: , p_resource_id
2562: );
2560: , p_resource_type
2561: , p_resource_id
2562: );
2563: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
2564: , fnd_global.resp_appl_id
2565: , fnd_global.resp_id
2566: , fnd_global.user_id
2567: , l_territory
2568: , p_resource_type
2561: , p_resource_id
2562: );
2563: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
2564: , fnd_global.resp_appl_id
2565: , fnd_global.resp_id
2566: , fnd_global.user_id
2567: , l_territory
2568: , p_resource_type
2569: , p_resource_id
2562: );
2563: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
2564: , fnd_global.resp_appl_id
2565: , fnd_global.resp_id
2566: , fnd_global.user_id
2567: , l_territory
2568: , p_resource_type
2569: , p_resource_id
2570: );
2602: l_rec.incident_customer_name := null;
2603:
2604: for i in 1..l_lines
2605: loop
2606: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1, 80) || fnd_global.local_chr (10);
2607: l_task_rec.party_name := substrb(l_task_rec.party_name,81);
2608: end loop;
2609:
2610: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1);
3113:
3114: CURSOR c_cust_tooltip is
3115: SELECT field_name
3116: FROM csf_gantt_chart_setup
3117: WHERE user_id = fnd_global.user_id
3118: AND setup_type = 'TOOLTIP'
3119: ORDER BY seq_no;
3120:
3121: -- task and task assignment data
3284: open c_terr;
3285: fetch c_terr into l_territory;
3286: close c_terr;
3287: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
3288: , fnd_global.resp_appl_id
3289: , fnd_global.resp_id
3290: , fnd_global.user_id
3291: , l_territory
3292: , p_resource_type
3285: fetch c_terr into l_territory;
3286: close c_terr;
3287: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
3288: , fnd_global.resp_appl_id
3289: , fnd_global.resp_id
3290: , fnd_global.user_id
3291: , l_territory
3292: , p_resource_type
3293: , p_resource_id
3286: close c_terr;
3287: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
3288: , fnd_global.resp_appl_id
3289: , fnd_global.resp_id
3290: , fnd_global.user_id
3291: , l_territory
3292: , p_resource_type
3293: , p_resource_id
3294: );
3292: , p_resource_type
3293: , p_resource_id
3294: );
3295: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
3296: , fnd_global.resp_appl_id
3297: , fnd_global.resp_id
3298: , fnd_global.user_id
3299: , l_territory
3300: , p_resource_type
3293: , p_resource_id
3294: );
3295: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
3296: , fnd_global.resp_appl_id
3297: , fnd_global.resp_id
3298: , fnd_global.user_id
3299: , l_territory
3300: , p_resource_type
3301: , p_resource_id
3294: );
3295: g_commute := csr_scheduler_pub.get_sch_parameter_value( 'spCommutesPosition'
3296: , fnd_global.resp_appl_id
3297: , fnd_global.resp_id
3298: , fnd_global.user_id
3299: , l_territory
3300: , p_resource_type
3301: , p_resource_id
3302: );
3336: l_rec.incident_customer_name := null;
3337:
3338: for i in 1..l_lines
3339: loop
3340: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1, 80) || fnd_global.local_chr (10);
3341: l_task_rec.party_name := substrb(l_task_rec.party_name,81);
3342: end loop;
3343:
3344: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1);
4196: open c_terr;
4197: fetch c_terr into l_territory;
4198: close c_terr;
4199: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
4200: , fnd_global.resp_appl_id
4201: , fnd_global.resp_id
4202: , fnd_global.user_id
4203: , l_territory
4204: , p_resource_type
4197: fetch c_terr into l_territory;
4198: close c_terr;
4199: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
4200: , fnd_global.resp_appl_id
4201: , fnd_global.resp_id
4202: , fnd_global.user_id
4203: , l_territory
4204: , p_resource_type
4205: , p_resource_id
4198: close c_terr;
4199: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
4200: , fnd_global.resp_appl_id
4201: , fnd_global.resp_id
4202: , fnd_global.user_id
4203: , l_territory
4204: , p_resource_type
4205: , p_resource_id
4206: );
8696:
8697: IF g_use_custom_chromatics THEN
8698: g_get_custom_color;
8699: END IF;
8700: g_user_id := fnd_global.user_id;
8701: g_uom_minutes := fnd_profile.value_specific('CSF_UOM_MINUTES', g_user_id);
8702: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);
8703: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
8704: l_language := USERENV('LANG');