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.120.12020000.2 2012/07/25 14:47:29 knathsh 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.120.12020000.2 2012/07/25 14:47:29 knathsh 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 4632: , 'csf_gantt_data_pkg') THEN

4628: SAVEPOINT drag_n_drop;
4629:
4630: -- Standard call to check for call compatibility
4631: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name
4632: , 'csf_gantt_data_pkg') THEN
4633: RAISE fnd_api.g_exc_unexpected_error;
4634: END IF;
4635:
4636: -- Initialize message list if p_init_msg_list is set to TRUE

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

4909: ROLLBACK TO drag_n_drop;
4910: x_return_status := fnd_api.g_ret_sts_unexp_error;
4911:
4912: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4913: fnd_msg_pub.add_exc_msg('csf_gantt_data_pkg', l_api_name);
4914: END IF;
4915:
4916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4917: END drag_n_drop;

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

5086: FROM (
5087: SELECT DISTINCT TR.RESOURCE_ID RESOURCE_ID ,
5088: TR.RESOURCE_TYPE RESOURCE_TYPE ,
5089: TR.RESOURCE_NAME RESOURCE_NAME ,
5090: CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME( TR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME,
5091: TR.RESOURCE_ID
5092: ||'-'
5093: ||TR.RESOURCE_TYPE RES_KEY,
5094: TERR.NAME,

Line 5120: CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RES.RESOURCE_TYPE) RESOURCE_TYPE_NAME,

5116: SELECT DISTINCT
5117: RES.RESOURCE_ID RESOURCE_ID,
5118: RES.RESOURCE_TYPE RESOURCE_TYPE,
5119: RES.RESOURCE_NAME RESOURCE_NAME,
5120: CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RES.RESOURCE_TYPE) RESOURCE_TYPE_NAME,
5121: RES.RESOURCE_ID || '-' || RES.RESOURCE_TYPE RES_KEY,
5122: TERR.NAME,
5123: JRS.PHONE
5124: FROM CSF_DC_RESOURCES_V RES,

Line 6325: 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);

6321: IF l_actual_effort(i) IS NULL OR l_actual_effort(i) = 0
6322: THEN
6323: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0
6324: THEN
6325: 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);
6326: END IF;
6327: IF l_default_effort IS NOT NULL AND l_default_effort > 0
6328: THEN
6329: 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 6329: 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);

6325: 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);
6326: END IF;
6327: IF l_default_effort IS NOT NULL AND l_default_effort > 0
6328: THEN
6329: 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);
6330: END IF;
6331: real_end_date(i):=(l_actual_start_date(i) + NVL(l_planned_effort(i), NVL(l_csf_default_effort, 0)));
6332: ELSE
6333: 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 6333: 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);

6329: 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);
6330: END IF;
6331: real_end_date(i):=(l_actual_start_date(i) + NVL(l_planned_effort(i), NVL(l_csf_default_effort, 0)));
6332: ELSE
6333: 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);
6334: real_end_date(i):=(l_actual_start_date(i) + NVL(l_actual_effort(i), 0));
6335: END IF;
6336: ELSE
6337: IF l_actual_end_date(i) <= l_actual_start_date(i)

Line 6343: 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);

6339: IF l_actual_effort(i) IS NULL OR l_actual_effort(i) = 0
6340: THEN -- this is true then calculate the actual end_date based uppon the profile values.
6341: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0
6342: THEN
6343: 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);
6344: END IF;
6345: IF l_default_effort IS NOT NULL AND l_default_effort > 0
6346: THEN
6347: 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 6347: 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);

6343: 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);
6344: END IF;
6345: IF l_default_effort IS NOT NULL AND l_default_effort > 0
6346: THEN
6347: 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);
6348: END IF;
6349: real_end_date(i):=(l_actual_start_date(i) + NVL(l_planned_effort(i), NVL(l_csf_default_effort, 0)));
6350: ELSE -- if not null then actual effort to the actual_end_date
6351: 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 6351: 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);

6347: 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);
6348: END IF;
6349: real_end_date(i):=(l_actual_start_date(i) + NVL(l_planned_effort(i), NVL(l_csf_default_effort, 0)));
6350: ELSE -- if not null then actual effort to the actual_end_date
6351: 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);
6352: l_real_end_date :=(l_actual_start_date(i) + NVL(l_actual_effort(i), 0));
6353: l_real_actual_start_date :=l_actual_start_date(i) + 1/1440;
6354: if l_real_end_date < l_real_actual_start_date
6355: then

Line 6388: 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);

6384: IF (l_planned_effort(i) IS NULL) OR(l_planned_effort(i) = 0)
6385: THEN
6386: IF l_default_effort IS NOT NULL AND l_default_effort > 0
6387: THEN
6388: 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);
6389: END IF;
6390: real_end_date(i):=(real_start_date(i) + NVL(l_csf_default_effort, 0));
6391: ELSE
6392: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0

Line 6394: 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);

6390: real_end_date(i):=(real_start_date(i) + NVL(l_csf_default_effort, 0));
6391: ELSE
6392: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0
6393: THEN
6394: 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);
6395: END IF;
6396: l_real_sched_end_date :=(real_start_date(i) + NVL(l_actual_effort(i), 0));
6397: l_real_sched_start_date :=real_start_date(i) + 1/1440;
6398: if l_real_sched_end_date < l_real_sched_start_date

Line 6412: 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);

6408: IF (l_planned_effort(i) IS NULL) OR(l_planned_effort(i) = 0)
6409: THEN
6410: IF l_default_effort IS NOT NULL AND l_default_effort > 0
6411: THEN
6412: 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);
6413: END IF;
6414: real_end_date(i):=(real_start_date(i) + NVL(l_csf_default_effort, 0));
6415: ELSE -- declar variable l_planned_effort to get uom coverted into days for actual effort for
6416: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0

Line 6418: 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);

6414: real_end_date(i):=(real_start_date(i) + NVL(l_csf_default_effort, 0));
6415: ELSE -- declar variable l_planned_effort to get uom coverted into days for actual effort for
6416: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0
6417: THEN
6418: 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);
6419: END IF;
6420: real_end_date(i) :=(real_start_date(i) + NVL(l_planned_effort(i), 0));
6421: END IF;
6422: END IF; -- end if for scheduled_end_date is null

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

7568:
7569: L_RESOURCE_QUERY := ' SELECT RR.RESOURCE_ID'
7570: ||',RR.RESOURCE_TYPE'
7571: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
7572: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
7573: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
7574: ||',POP.COST'
7575: ||' FROM '
7576: ||' CSF_R_REQUEST_TASKS RT,'

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

7587:
7588: L_RESOURCE_QUERY_COST := ' SELECT RR.RESOURCE_ID'
7589: ||',RR.RESOURCE_TYPE'
7590: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
7591: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
7592: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
7593: ||',POP.COST'
7594: ||' FROM '
7595: ||' CSF_R_REQUEST_TASKS RT,'

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

7622:
7623: L_RESOURCE_QUERY_COST_DAY := ' SELECT RR.RESOURCE_ID '
7624: ||' ,RR.RESOURCE_TYPE '
7625: ||' ,CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME '
7626: ||' ,CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME '
7627: ||' ,RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY '
7628: ||' ,POP.COST '
7629: ||' FROM '
7630: ||' CSF_R_REQUEST_TASKS RT, '

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

7674:
7675: L_RESOURCE_SINGLE_QUERY :=' SELECT RR.RESOURCE_ID'
7676: ||',RR.RESOURCE_TYPE'
7677: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
7678: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
7679: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
7680: ||',POP.COST'
7681: ||' FROM '
7682: ||' CSF_R_REQUEST_TASKS RT,'

Line 8107: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)

8103: IF l_actual_end_date(i) IS NULL THEN
8104: IF l_actual_effort(i) IS NULL OR l_actual_effort(i) = 0 THEN
8105: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0 THEN
8106: l_planned_effort(i) :=
8107: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)
8108: , NVL(l_planned_effort_uom(i), g_uom_hours), g_uom_hours);
8109: END IF;
8110:
8111: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN

Line 8113: csf_gantt_data_pkg.convert_to_days(l_default_effort

8109: END IF;
8110:
8111: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN
8112: l_csf_default_effort :=
8113: csf_gantt_data_pkg.convert_to_days(l_default_effort
8114: , NVL(l_default_effort_uom, g_uom_hours), g_uom_hours);
8115: END IF;
8116:
8117: oth_real_end_date(i) :=

Line 8123: csf_gantt_data_pkg.convert_to_days(l_actual_effort(i)

8119: l_actual_start_date(i) + NVL(l_planned_effort(i), NVL(l_csf_default_effort, 0))
8120: );
8121: ELSE
8122: l_actual_effort(i) :=
8123: csf_gantt_data_pkg.convert_to_days(l_actual_effort(i)
8124: , NVL(l_actual_effort_uom(i), g_uom_hours), g_uom_hours);
8125: oth_real_end_date(i) :=(l_actual_start_date(i) + NVL(l_actual_effort(i), 0));
8126: END IF;
8127: ELSE

Line 8133: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)

8129: IF l_actual_effort(i) IS NULL OR l_actual_effort(i) = 0 THEN
8130: -- this is true then calculate the actual end_date based uppon the profile values.
8131: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0 THEN
8132: l_planned_effort(i) :=
8133: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)
8134: , NVL(l_planned_effort_uom(i), g_uom_hours), g_uom_hours);
8135: END IF;
8136:
8137: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN

Line 8139: csf_gantt_data_pkg.convert_to_days(l_default_effort

8135: END IF;
8136:
8137: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN
8138: l_csf_default_effort :=
8139: csf_gantt_data_pkg.convert_to_days(l_default_effort
8140: , NVL(l_default_effort_uom, g_uom_hours), g_uom_hours);
8141: END IF;
8142:
8143: oth_real_end_date(i) :=

Line 8150: csf_gantt_data_pkg.convert_to_days(l_actual_effort(i)

8146: );
8147: ELSE
8148: -- if not null then actual effort to the actual_end_date
8149: l_actual_effort(i) :=
8150: csf_gantt_data_pkg.convert_to_days(l_actual_effort(i)
8151: , NVL(l_actual_effort_uom(i), g_uom_hours), g_uom_hours);
8152: oth_real_end_date(i) :=(l_actual_start_date(i) + NVL(l_actual_effort(i), 0));
8153: END IF; --end if for actual effort is nul or zero
8154: ELSE

Line 8180: csf_gantt_data_pkg.convert_to_days(l_default_effort

8176: IF oth_real_start_date(i) = oth_real_end_date(i) THEN
8177: IF (l_planned_effort(i) IS NULL) OR(l_planned_effort(i) = 0) THEN
8178: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN
8179: l_csf_default_effort :=
8180: csf_gantt_data_pkg.convert_to_days(l_default_effort
8181: , NVL(l_default_effort_uom, g_uom_hours), g_uom_hours);
8182: END IF;
8183:
8184: oth_real_end_date(i) :=(oth_real_start_date(i) + NVL(l_csf_default_effort, 0));

Line 8188: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)

8184: oth_real_end_date(i) :=(oth_real_start_date(i) + NVL(l_csf_default_effort, 0));
8185: ELSE
8186: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0 THEN
8187: l_planned_effort(i) :=
8188: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)
8189: , NVL(l_planned_effort_uom(i), g_uom_hours), g_uom_hours);
8190: END IF;
8191:
8192: oth_real_end_date(i) :=(oth_real_start_date(i) + NVL(l_planned_effort(i), 0));

Line 8200: csf_gantt_data_pkg.convert_to_days(l_default_effort

8196: -- scheduled_end_date is null then check for planned effort null
8197: IF (l_planned_effort(i) IS NULL) OR(l_planned_effort(i) = 0) THEN
8198: IF l_default_effort IS NOT NULL AND l_default_effort > 0 THEN
8199: l_csf_default_effort :=
8200: csf_gantt_data_pkg.convert_to_days(l_default_effort
8201: , NVL(l_default_effort_uom, g_uom_hours), g_uom_hours);
8202: END IF;
8203:
8204: oth_real_end_date(i) :=(oth_real_start_date(i) + NVL(l_csf_default_effort, 0));

Line 8209: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)

8205: ELSE
8206: -- declar variable l_planned_effort to get uom coverted into days for actual effort for
8207: IF l_planned_effort(i) IS NOT NULL AND l_planned_effort(i) > 0 THEN
8208: l_planned_effort(i) :=
8209: csf_gantt_data_pkg.convert_to_days(l_planned_effort(i)
8210: , NVL(l_planned_effort_uom(i), g_uom_hours), g_uom_hours);
8211: END IF;
8212:
8213: oth_real_end_date(i) :=(oth_real_start_date(i) + NVL(l_planned_effort(i), 0));

Line 8718: END CSF_GANTT_DATA_PKG;

8714: then
8715: g_tz_enabled := 'Y';
8716: end if;
8717:
8718: END CSF_GANTT_DATA_PKG;