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.CSF_GANTT_DATA_PKG dependencies on CSF_GANTT_DATA_PKG

Line 1: PACKAGE BODY CSF_GANTT_DATA_PKG AS

1: PACKAGE BODY CSF_GANTT_DATA_PKG AS
2: /*$Header: CSFGTPLB.pls 120.52.12010000.3 2008/11/21 06:49:29 ramchint ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_GANTT_DATA_PKG';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_GANTT_DATA_PKG';

1: PACKAGE BODY CSF_GANTT_DATA_PKG AS
2: /*$Header: CSFGTPLB.pls 120.52.12010000.3 2008/11/21 06:49:29 ramchint ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_GANTT_DATA_PKG';
5:
6: g_use_custom_chromatics BOOLEAN := FALSE;
7: g_label_on_task BOOLEAN := FALSE;
8: g_uom_minutes VARCHAR2(60) := NULL;

Line 2044: , 'csf_gantt_data_pkg') THEN

2040: SAVEPOINT drag_n_drop;
2041:
2042: -- Standard call to check for call compatibility
2043: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name
2044: , 'csf_gantt_data_pkg') THEN
2045: RAISE fnd_api.g_exc_unexpected_error;
2046: END IF;
2047:
2048: -- Initialize message list if p_init_msg_list is set to TRUE

Line 2249: fnd_msg_pub.add_exc_msg('csf_gantt_data_pkg', l_api_name);

2245: ROLLBACK TO drag_n_drop;
2246: x_return_status := fnd_api.g_ret_sts_unexp_error;
2247:
2248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2249: fnd_msg_pub.add_exc_msg('csf_gantt_data_pkg', l_api_name);
2250: END IF;
2251:
2252: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2253: END drag_n_drop;

Line 2397: CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME( TR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME,

2393: CURSOR C_Terr_Resource
2394: IS SELECT DISTINCT TR.RESOURCE_ID RESOURCE_ID,
2395: TR.RESOURCE_TYPE RESOURCE_TYPE,
2396: TR.RESOURCE_NAME RESOURCE_NAME,
2397: CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME( TR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME,
2398: TR.RESOURCE_ID||'-'||TR.RESOURCE_TYPE
2399: FROM CSF_SELECTED_RESOURCES_V TR
2400: ORDER BY UPPER(TR.RESOURCE_NAME);
2401:

Line 3378: l_planned_effort(i):=csf_gantt_data_pkg.convert_to_days(l_planned_effort(i),NVL(l_planned_effort_uom(i),g_uom_hours),g_uom_hours);

3374: IF l_actual_effort(i) IS NULL OR l_actual_effort(i) = 0
3375: THEN
3376: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0
3377: THEN
3378: l_planned_effort(i):=csf_gantt_data_pkg.convert_to_days(l_planned_effort(i),NVL(l_planned_effort_uom(i),g_uom_hours),g_uom_hours);
3379: END IF;
3380: IF l_default_effort IS NOT NULL AND l_default_effort > 0
3381: THEN
3382: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom,g_uom_hours),g_uom_hours);

Line 3382: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom,g_uom_hours),g_uom_hours);

3378: l_planned_effort(i):=csf_gantt_data_pkg.convert_to_days(l_planned_effort(i),NVL(l_planned_effort_uom(i),g_uom_hours),g_uom_hours);
3379: END IF;
3380: IF l_default_effort IS NOT NULL AND l_default_effort > 0
3381: THEN
3382: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom,g_uom_hours),g_uom_hours);
3383: END IF;
3384: real_end_date(i):=(l_actual_start_date(i) + NVL(l_planned_effort(i), NVL(l_csf_default_effort, 0)));
3385: ELSE
3386: l_actual_effort(i):=csf_gantt_data_pkg.convert_to_days(l_actual_effort(i),NVL(l_actual_effort_uom(i),g_uom_hours),g_uom_hours);

Line 3386: l_actual_effort(i):=csf_gantt_data_pkg.convert_to_days(l_actual_effort(i),NVL(l_actual_effort_uom(i),g_uom_hours),g_uom_hours);

3382: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom,g_uom_hours),g_uom_hours);
3383: END IF;
3384: real_end_date(i):=(l_actual_start_date(i) + NVL(l_planned_effort(i), NVL(l_csf_default_effort, 0)));
3385: ELSE
3386: l_actual_effort(i):=csf_gantt_data_pkg.convert_to_days(l_actual_effort(i),NVL(l_actual_effort_uom(i),g_uom_hours),g_uom_hours);
3387: real_end_date(i):=(l_actual_start_date(i) + NVL(l_actual_effort(i), 0));
3388: END IF;
3389: ELSE
3390: IF l_actual_end_date(i) <= l_actual_start_date(i)

Line 3396: l_planned_effort(i):=csf_gantt_data_pkg.convert_to_days(l_planned_effort(i),NVL(l_planned_effort_uom(i),g_uom_hours),g_uom_hours);

3392: IF l_actual_effort(i) IS NULL OR l_actual_effort(i) = 0
3393: THEN -- this is true then calculate the actual end_date based uppon the profile values.
3394: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0
3395: THEN
3396: l_planned_effort(i):=csf_gantt_data_pkg.convert_to_days(l_planned_effort(i),NVL(l_planned_effort_uom(i),g_uom_hours),g_uom_hours);
3397: END IF;
3398: IF l_default_effort IS NOT NULL AND l_default_effort > 0
3399: THEN
3400: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom,g_uom_hours),g_uom_hours);

Line 3400: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom,g_uom_hours),g_uom_hours);

3396: l_planned_effort(i):=csf_gantt_data_pkg.convert_to_days(l_planned_effort(i),NVL(l_planned_effort_uom(i),g_uom_hours),g_uom_hours);
3397: END IF;
3398: IF l_default_effort IS NOT NULL AND l_default_effort > 0
3399: THEN
3400: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom,g_uom_hours),g_uom_hours);
3401: END IF;
3402: real_end_date(i):=(l_actual_start_date(i) + NVL(l_planned_effort(i), NVL(l_csf_default_effort, 0)));
3403: ELSE -- if not null then actual effort to the actual_end_date
3404: l_actual_effort(i):=csf_gantt_data_pkg.convert_to_days(l_actual_effort(i),NVL(l_actual_effort_uom(i),g_uom_hours),g_uom_hours);

Line 3404: l_actual_effort(i):=csf_gantt_data_pkg.convert_to_days(l_actual_effort(i),NVL(l_actual_effort_uom(i),g_uom_hours),g_uom_hours);

3400: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom,g_uom_hours),g_uom_hours);
3401: END IF;
3402: real_end_date(i):=(l_actual_start_date(i) + NVL(l_planned_effort(i), NVL(l_csf_default_effort, 0)));
3403: ELSE -- if not null then actual effort to the actual_end_date
3404: l_actual_effort(i):=csf_gantt_data_pkg.convert_to_days(l_actual_effort(i),NVL(l_actual_effort_uom(i),g_uom_hours),g_uom_hours);
3405: real_end_date(i):=(l_actual_start_date(i) + NVL(l_actual_effort(i), 0));
3406: END IF; --end if for actual effort is nul or zero
3407: ELSE -- actual end date is not null, check if actual_end_date > actual_start_date
3408: IF l_actual_end_date(i) > l_actual_start_date(i)

Line 3434: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom, g_uom_hours),g_uom_hours);

3430: IF (l_planned_effort(i) IS NULL) OR(l_planned_effort(i) = 0)
3431: THEN
3432: IF l_default_effort IS NOT NULL AND l_default_effort > 0
3433: THEN
3434: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom, g_uom_hours),g_uom_hours);
3435: END IF;
3436: real_end_date(i):=(real_start_date(i) + NVL(l_csf_default_effort, 0));
3437: ELSE
3438: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0

Line 3440: l_planned_effort(i):=csf_gantt_data_pkg.convert_to_days(l_planned_effort(i),NVL(l_planned_effort_uom(i),g_uom_hours),g_uom_hours);

3436: real_end_date(i):=(real_start_date(i) + NVL(l_csf_default_effort, 0));
3437: ELSE
3438: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0
3439: THEN
3440: l_planned_effort(i):=csf_gantt_data_pkg.convert_to_days(l_planned_effort(i),NVL(l_planned_effort_uom(i),g_uom_hours),g_uom_hours);
3441: END IF;
3442: real_end_date(i):=(real_start_date(i) + NVL(l_planned_effort(i), 0));
3443: END IF;
3444: END IF;

Line 3450: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom,g_uom_hours),g_uom_hours);

3446: IF (l_planned_effort(i) IS NULL) OR(l_planned_effort(i) = 0)
3447: THEN
3448: IF l_default_effort IS NOT NULL AND l_default_effort > 0
3449: THEN
3450: l_csf_default_effort:=csf_gantt_data_pkg.convert_to_days(l_default_effort,NVL(l_default_effort_uom,g_uom_hours),g_uom_hours);
3451: END IF;
3452: real_end_date(i):=(real_start_date(i) + NVL(l_csf_default_effort, 0));
3453: ELSE -- declar variable l_planned_effort to get uom coverted into days for actual effort for
3454: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0

Line 3456: l_planned_effort(i):=csf_gantt_data_pkg.convert_to_days(l_planned_effort(i),NVL(l_planned_effort_uom(i),g_uom_hours),g_uom_hours);

3452: real_end_date(i):=(real_start_date(i) + NVL(l_csf_default_effort, 0));
3453: ELSE -- declar variable l_planned_effort to get uom coverted into days for actual effort for
3454: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0
3455: THEN
3456: l_planned_effort(i):=csf_gantt_data_pkg.convert_to_days(l_planned_effort(i),NVL(l_planned_effort_uom(i),g_uom_hours),g_uom_hours);
3457: END IF;
3458: real_end_date(i) :=(real_start_date(i) + NVL(l_planned_effort(i), 0));
3459: END IF;
3460: END IF; -- end if for scheduled_end_date is null

Line 4473: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'

4469:
4470: L_RESOURCE_QUERY := ' SELECT RR.RESOURCE_ID'
4471: ||',RR.RESOURCE_TYPE'
4472: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
4473: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
4474: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
4475: ||',POP.COST'
4476: ||' FROM '
4477: ||' CSF_R_REQUEST_TASKS RT,'

Line 4492: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'

4488:
4489: L_RESOURCE_QUERY_COST := ' SELECT RR.RESOURCE_ID'
4490: ||',RR.RESOURCE_TYPE'
4491: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
4492: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
4493: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
4494: ||',POP.COST'
4495: ||' FROM '
4496: ||' CSF_R_REQUEST_TASKS RT,'

Line 4527: ||' ,CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME '

4523:
4524: L_RESOURCE_QUERY_COST_DAY := ' SELECT RR.RESOURCE_ID '
4525: ||' ,RR.RESOURCE_TYPE '
4526: ||' ,CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME '
4527: ||' ,CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME '
4528: ||' ,RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY '
4529: ||' ,POP.COST '
4530: ||' FROM '
4531: ||' CSF_R_REQUEST_TASKS RT, '

Line 4579: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'

4575:
4576: L_RESOURCE_SINGLE_QUERY :=' SELECT RR.RESOURCE_ID'
4577: ||',RR.RESOURCE_TYPE'
4578: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
4579: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
4580: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
4581: ||',POP.COST'
4582: ||' FROM '
4583: ||' CSF_R_REQUEST_TASKS RT,'

Line 4913: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)

4909: IF l_actual_end_date(i) IS NULL THEN
4910: IF l_actual_effort(i) IS NULL OR l_actual_effort(i) = 0 THEN
4911: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0 THEN
4912: l_planned_effort(i) :=
4913: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)
4914: , NVL(l_planned_effort_uom(i), g_uom_hours), g_uom_hours);
4915: END IF;
4916:
4917: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN

Line 4919: csf_gantt_data_pkg.convert_to_days(l_default_effort

4915: END IF;
4916:
4917: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN
4918: l_csf_default_effort :=
4919: csf_gantt_data_pkg.convert_to_days(l_default_effort
4920: , NVL(l_default_effort_uom, g_uom_hours), g_uom_hours);
4921: END IF;
4922:
4923: oth_real_end_date(i) :=

Line 4929: csf_gantt_data_pkg.convert_to_days(l_actual_effort(i)

4925: l_actual_start_date(i) + NVL(l_planned_effort(i), NVL(l_csf_default_effort, 0))
4926: );
4927: ELSE
4928: l_actual_effort(i) :=
4929: csf_gantt_data_pkg.convert_to_days(l_actual_effort(i)
4930: , NVL(l_actual_effort_uom(i), g_uom_hours), g_uom_hours);
4931: oth_real_end_date(i) :=(l_actual_start_date(i) + NVL(l_actual_effort(i), 0));
4932: END IF;
4933: ELSE

Line 4939: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)

4935: IF l_actual_effort(i) IS NULL OR l_actual_effort(i) = 0 THEN
4936: -- this is true then calculate the actual end_date based uppon the profile values.
4937: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0 THEN
4938: l_planned_effort(i) :=
4939: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)
4940: , NVL(l_planned_effort_uom(i), g_uom_hours), g_uom_hours);
4941: END IF;
4942:
4943: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN

Line 4945: csf_gantt_data_pkg.convert_to_days(l_default_effort

4941: END IF;
4942:
4943: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN
4944: l_csf_default_effort :=
4945: csf_gantt_data_pkg.convert_to_days(l_default_effort
4946: , NVL(l_default_effort_uom, g_uom_hours), g_uom_hours);
4947: END IF;
4948:
4949: oth_real_end_date(i) :=

Line 4956: csf_gantt_data_pkg.convert_to_days(l_actual_effort(i)

4952: );
4953: ELSE
4954: -- if not null then actual effort to the actual_end_date
4955: l_actual_effort(i) :=
4956: csf_gantt_data_pkg.convert_to_days(l_actual_effort(i)
4957: , NVL(l_actual_effort_uom(i), g_uom_hours), g_uom_hours);
4958: oth_real_end_date(i) :=(l_actual_start_date(i) + NVL(l_actual_effort(i), 0));
4959: END IF; --end if for actual effort is nul or zero
4960: ELSE

Line 4986: csf_gantt_data_pkg.convert_to_days(l_default_effort

4982: IF oth_real_start_date(i) = oth_real_end_date(i) THEN
4983: IF (l_planned_effort(i) IS NULL) OR(l_planned_effort(i) = 0) THEN
4984: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN
4985: l_csf_default_effort :=
4986: csf_gantt_data_pkg.convert_to_days(l_default_effort
4987: , NVL(l_default_effort_uom, g_uom_hours), g_uom_hours);
4988: END IF;
4989:
4990: oth_real_end_date(i) :=(oth_real_start_date(i) + NVL(l_csf_default_effort, 0));

Line 4994: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)

4990: oth_real_end_date(i) :=(oth_real_start_date(i) + NVL(l_csf_default_effort, 0));
4991: ELSE
4992: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0 THEN
4993: l_planned_effort(i) :=
4994: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)
4995: , NVL(l_planned_effort_uom(i), g_uom_hours), g_uom_hours);
4996: END IF;
4997:
4998: oth_real_end_date(i) :=(oth_real_start_date(i) + NVL(l_planned_effort(i), 0));

Line 5006: csf_gantt_data_pkg.convert_to_days(l_default_effort

5002: -- scheduled_end_date is null then check for planned effort null
5003: IF (l_planned_effort(i) IS NULL) OR(l_planned_effort(i) = 0) THEN
5004: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN
5005: l_csf_default_effort :=
5006: csf_gantt_data_pkg.convert_to_days(l_default_effort
5007: , NVL(l_default_effort_uom, g_uom_hours), g_uom_hours);
5008: END IF;
5009:
5010: oth_real_end_date(i) :=(oth_real_start_date(i) + NVL(l_csf_default_effort, 0));

Line 5015: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)

5011: ELSE
5012: -- declar variable l_planned_effort to get uom coverted into days for actual effort for
5013: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0 THEN
5014: l_planned_effort(i) :=
5015: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)
5016: , NVL(l_planned_effort_uom(i), g_uom_hours), g_uom_hours);
5017: END IF;
5018:
5019: oth_real_end_date(i) :=(oth_real_start_date(i) + NVL(l_planned_effort(i), 0));

Line 5421: END csf_gantt_data_pkg;

5417: then
5418: g_tz_enabled := 'Y';
5419: end if;
5420:
5421: END csf_gantt_data_pkg;