DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on FND_GLOBAL

Line 512: , fnd_global.resp_appl_id

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

Line 513: , fnd_global.resp_id

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

Line 514: , fnd_global.user_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: );

Line 520: , fnd_global.resp_appl_id

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

Line 521: , fnd_global.resp_id

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

Line 522: , fnd_global.user_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: );

Line 647: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1, 80) || fnd_global.local_chr (10);

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);

Line 1412: WHERE user_id = fnd_global.user_id

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

Line 1642: , fnd_global.resp_appl_id

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

Line 1643: , fnd_global.resp_id

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

Line 1644: , fnd_global.user_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: );

Line 1650: , fnd_global.resp_appl_id

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

Line 1651: , fnd_global.resp_id

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

Line 1652: , fnd_global.user_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: );

Line 1729: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1, 80) || fnd_global.local_chr (10);

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);

Line 2556: , fnd_global.resp_appl_id

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

Line 2557: , fnd_global.resp_id

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

Line 2558: , fnd_global.user_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: );

Line 2564: , fnd_global.resp_appl_id

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

Line 2565: , fnd_global.resp_id

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

Line 2566: , fnd_global.user_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: );

Line 2606: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1, 80) || fnd_global.local_chr (10);

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);

Line 3117: WHERE user_id = fnd_global.user_id

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

Line 3288: , fnd_global.resp_appl_id

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

Line 3289: , fnd_global.resp_id

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

Line 3290: , fnd_global.user_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: );

Line 3296: , fnd_global.resp_appl_id

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

Line 3297: , fnd_global.resp_id

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

Line 3298: , fnd_global.user_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: );

Line 3340: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1, 80) || fnd_global.local_chr (10);

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);

Line 4200: , fnd_global.resp_appl_id

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

Line 4201: , fnd_global.resp_id

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

Line 4202: , fnd_global.user_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: );

Line 8700: g_user_id := fnd_global.user_id;

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');