APPS.OKS_COVERAGE_UTIL_PVT dependencies on OKS_COVERAGE_TIMES

Line 4: -- Purpose: Utility package for OKS Coverage Times

1: PACKAGE BODY OKS_COVERAGE_UTIL_PVT AS
2: /* $Header: OKSRCUTB.pls 120.4 2005/08/09 13:57:22 sasethi noship $ */
3:
4: -- Purpose: Utility package for OKS Coverage Times
5: --
6:
7: -- Global Constants
8: G_APP_NAME CONSTANT VARCHAR2(5) := 'OKS';

Line 33: from oks_coverage_times_gt

29: -- GT table.
30: SELECT
31: count(*)
32: into l_count
33: from oks_coverage_times_gt
34: where COV_TZE_LINE_ID = cov_timezone_id;
35:
36: -- If Count is greater then 0, return Y
37: IF l_count > 0 THEN

Line 90: * @param coverage_times_recs Actual Coverage Times records from OKS_COVERAGE_TIMES loaded

86: /**
87: * Procedure to process new Coverage Times into a PL/SQL record := new_coverage_times_rec
88: * and return back the record.
89: * @param flattened_st_end_limit_recs PL/SQL table structure of Flattened Start and End times
90: * @param coverage_times_recs Actual Coverage Times records from OKS_COVERAGE_TIMES loaded
91: * into this PL/SQL table structure
92: * @param new_coverage_times_rec New Coverage Times PL/SQL Record returned to the calling
93: * API (init_coverage_times_view)
94: */

Line 217: FROM OKS_COVERAGE_TIMES

213: CURSOR flattened_time_limits_cur IS
214: SELECT
215: to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) time,
216: to_char(to_date(start_hour||':'||start_minute, 'HH24:MI'), 'HH24:MI') concatenate_time
217: FROM OKS_COVERAGE_TIMES
218: WHERE
219: COV_TZE_LINE_ID = cov_timezone_id
220: UNION ALL
221: SELECT to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) time,

Line 223: FROM OKS_COVERAGE_TIMES

219: COV_TZE_LINE_ID = cov_timezone_id
220: UNION ALL
221: SELECT to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) time,
222: to_char(to_date(end_hour||':'||end_minute, 'HH24:MI'), 'HH24:MI') concatenate_time
223: FROM OKS_COVERAGE_TIMES
224: WHERE
225: COV_TZE_LINE_ID = cov_timezone_id
226: ORDER BY time;
227:

Line 286: OKS_COVERAGE_TIMES

282: to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) START_HOUR_MINUTE,
283: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE))END_HOUR_MINUTE
284: BULK COLLECT INTO coverage_times_recs
285: FROM
286: OKS_COVERAGE_TIMES
287: WHERE
288: COV_TZE_LINE_ID = cov_timezone_id
289: ORDER BY start_hour asc;
290:

Line 355: INSERT INTO OKS_COVERAGE_TIMES_GT VALUES new_coverage_times_recs(k);

351: END IF; -- IF flattened_time_limits_recs.COUNT > 0
352:
353: -- Bulk Insert
354: FORALL k IN new_coverage_times_recs.FIRST..new_coverage_times_recs.LAST
355: INSERT INTO OKS_COVERAGE_TIMES_GT VALUES new_coverage_times_recs(k);
356:
357: -- set return status as success
358: x_return_status := l_return_status;
359: