DBA Data[Home] [Help]

APPS.HXT_TIME_DETAIL dependencies on HXT_TIM_COL_UTIL

Line 967: g_det_session_date := hxt_tim_col_util.return_session_date;

963: -- Bug 7359347
964: -- Setting the session date to pass as input to the below cursor.
965: IF g_det_session_date IS NULL
966: THEN
967: g_det_session_date := hxt_tim_col_util.return_session_date;
968: END IF;
969:
970: OPEN weekly_total_to_date(g_det_session_date);
971:

Line 1081: g_det_session_date := hxt_tim_col_util.return_session_date;

1077: -- Bug 7359347
1078: -- Setting the session date to be passed to the cursor below.
1079: IF g_det_session_date IS NULL
1080: THEN
1081: g_det_session_date := hxt_tim_col_util.return_session_date;
1082: END IF;
1083:
1084: OPEN weekly_total_to_date(g_det_session_date);
1085:

Line 1235: g_det_session_date := hxt_tim_col_util.return_session_date;

1231: -- Bug 7359347
1232: -- Getting the session date to pass to the cursor.
1233: IF g_det_session_date IS NULL
1234: THEN
1235: g_det_session_date := hxt_tim_col_util.return_session_date;
1236: END IF;
1237:
1238: OPEN daily_total(g_det_session_date);
1239:

Line 1354: g_det_session_date := hxt_tim_col_util.return_session_date;

1350: -- Bug 7359347
1351: -- Setting session date.
1352: IF g_det_session_date IS NULL
1353: THEN
1354: g_det_session_date := hxt_tim_col_util.return_session_date;
1355: END IF;
1356:
1357: OPEN overtime_cur(g_det_session_date);
1358:

Line 1572: g_det_session_date := hxt_tim_col_util.return_session_date;

1568: -- Bug 7359347
1569: -- Setting session date.
1570: IF g_det_session_date IS NULL
1571: THEN
1572: g_det_session_date := hxt_tim_col_util.return_session_date;
1573: END IF;
1574:
1575: OPEN weekly_total_to_date(g_det_session_date);
1576:

Line 1765: g_det_session_date := hxt_tim_col_util.return_session_date;

1761: -- Bug 7359347
1762: -- Setting session date.
1763: IF g_det_session_date IS NULL
1764: THEN
1765: g_det_session_date := hxt_tim_col_util.return_session_date;
1766: END IF;
1767:
1768: OPEN current_dtl (p_hours_short,g_det_session_date);
1769:

Line 2015: g_det_session_date := hxt_tim_col_util.return_session_date;

2011: -- Bug 7359347
2012: -- Setting session date.
2013: IF g_det_session_date IS NULL
2014: THEN
2015: g_det_session_date := hxt_tim_col_util.return_session_date;
2016: END IF;
2017:
2018:
2019: IF g_ep_type NOT IN ('SPECIAL', 'WEEKLY')

Line 3263: g_det_session_date := hxt_tim_col_util.return_session_date;

3259: -- Bug 7359347
3260: -- Setting session date
3261: IF g_det_session_date IS NULL
3262: THEN
3263: g_det_session_date := hxt_tim_col_util.return_session_date;
3264: END IF;
3265:
3266: -- Bug 8888600
3267: sdp_adjusted.DELETE;

Line 4433: g_det_session_date := hxt_tim_col_util.return_session_date;

4429: -- Bug 7359347
4430: -- Setting session date
4431: IF g_det_session_date IS NULL
4432: THEN
4433: g_det_session_date := hxt_tim_col_util.return_session_date;
4434: END IF;
4435:
4436:
4437: i := 0;

Line 4623: g_det_session_date := hxt_tim_col_util.return_session_date;

4619: -- Bug 7359347
4620: -- Setting session date.
4621: IF g_det_session_date IS NULL
4622: THEN
4623: g_det_session_date := hxt_tim_col_util.return_session_date;
4624: END IF;
4625:
4626:
4627:

Line 5150: g_det_session_date := hxt_tim_col_util.return_session_date;

5146: -- Bug 7359347
5147: -- Setting session date
5148: IF g_det_session_date IS NULL
5149: THEN
5150: g_det_session_date := hxt_tim_col_util.return_session_date;
5151: END IF;
5152:
5153: IF NVL(FND_PROFILE.VALUE('HXT_HOLIDAY_EXPLOSION'),'EX') <> 'EX'
5154: -- Bug 16345397

Line 6127: g_det_session_date := hxt_tim_col_util.return_session_date;

6123: -- Bug 7359347
6124: -- Setting session date and changing view to table below.
6125: IF g_det_session_date IS NULL
6126: THEN
6127: g_det_session_date := hxt_tim_col_util.return_session_date;
6128: END IF;
6129:
6130: /*
6131: DELETE FROM hxt_det_hours_worked

Line 8411: g_det_session_date := hxt_tim_col_util.return_session_date;

8407: -- Bug 7359347
8408: -- Setting session date.
8409: IF g_det_session_date IS NULL
8410: THEN
8411: g_det_session_date := hxt_tim_col_util.return_session_date;
8412: END IF;
8413:
8414:
8415:

Line 13907: g_det_session_date := hxt_tim_col_util.return_session_date;

13903: -- Bug 7359347
13904: -- Setting session date.
13905: IF g_det_session_date IS NULL
13906: THEN
13907: g_det_session_date := hxt_tim_col_util.return_session_date;
13908: END IF;
13909:
13910:
13911: FOR zero_rec IN zero_hrs_cur (a_tim_id, a_date_worked,g_det_session_date)

Line 14063: g_det_session_date := hxt_tim_col_util.return_session_date;

14059: -- Bug 7359347
14060: -- Setting session date
14061: IF g_det_session_date IS NULL
14062: THEN
14063: g_det_session_date := hxt_tim_col_util.return_session_date;
14064: END IF;
14065:
14066:
14067: FOR elem_rec IN c_distinct_elements (g_id,g_det_session_date)

Line 15143: g_det_session_date := hxt_tim_col_util.return_session_date;

15139: -- Bug 7359347
15140: -- Setting session date.
15141: IF g_det_session_date IS NULL
15142: THEN
15143: g_det_session_date := hxt_tim_col_util.return_session_date;
15144: END IF;
15145:
15146:
15147: <>

Line 15259: g_det_session_date := hxt_tim_col_util.return_session_date;

15255: BEGIN
15256: -- Setting session date.
15257: IF g_det_session_date IS NULL
15258: THEN
15259: g_det_session_date := hxt_tim_col_util.return_session_date;
15260: END IF;
15261:
15262: OPEN csr_work_hrs(p_date_worked, p_tim_id,g_det_session_date);
15263: FETCH csr_work_hrs INTO l_worked_hours;

Line 15363: g_det_session_date := hxt_tim_col_util.return_session_date;

15359: -- Bug 7359347
15360: -- Setting session date
15361: IF g_det_session_date IS NULL
15362: THEN
15363: g_det_session_date := hxt_tim_col_util.return_session_date;
15364: END IF;
15365:
15366:
15367: