DBA Data[Home] [Help]

APPS.OKS_COVERAGE_MIGRATION dependencies on OKS_COVERAGE_TIMES_V

Line 16: x_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;

12:
13: x_ctzv_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
14: l_ctzv_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
15:
16: x_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
17: l_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
18:
19:
20: x_acmv_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;

Line 17: l_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;

13: x_ctzv_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
14: l_ctzv_tbl_in oks_ctz_pvt.OksCoverageTimezonesVTblType;
15:
16: x_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
17: l_cvtv_tbl_in OKS_CVT_PVT.oks_coverage_times_v_tbl_type;
18:
19:
20: x_acmv_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;
21: l_acmv_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;

Line 355: TYPE oks_coverage_times_v_rec_type IS RECORD (

351: x_clet_tbl_in klt_tbl_type;
352: l_clet_tbl_in klt_tbl_type;
353:
354:
355: TYPE oks_coverage_times_v_rec_type IS RECORD (
356: id NUMBER := OKC_API.G_MISS_NUM
357: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
358: ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
359: ,start_hour NUMBER := OKC_API.G_MISS_NUM

Line 363: ,monday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR

359: ,start_hour NUMBER := OKC_API.G_MISS_NUM
360: ,start_minute NUMBER := OKC_API.G_MISS_NUM
361: ,end_hour NUMBER := OKC_API.G_MISS_NUM
362: ,end_minute NUMBER := OKC_API.G_MISS_NUM
363: ,monday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
364: ,tuesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
365: ,wednesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
366: ,thursday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
367: ,friday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR

Line 364: ,tuesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR

360: ,start_minute NUMBER := OKC_API.G_MISS_NUM
361: ,end_hour NUMBER := OKC_API.G_MISS_NUM
362: ,end_minute NUMBER := OKC_API.G_MISS_NUM
363: ,monday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
364: ,tuesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
365: ,wednesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
366: ,thursday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
367: ,friday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
368: ,saturday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR

Line 365: ,wednesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR

361: ,end_hour NUMBER := OKC_API.G_MISS_NUM
362: ,end_minute NUMBER := OKC_API.G_MISS_NUM
363: ,monday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
364: ,tuesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
365: ,wednesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
366: ,thursday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
367: ,friday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
368: ,saturday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
369: ,sunday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR

Line 366: ,thursday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR

362: ,end_minute NUMBER := OKC_API.G_MISS_NUM
363: ,monday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
364: ,tuesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
365: ,wednesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
366: ,thursday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
367: ,friday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
368: ,saturday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
369: ,sunday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
370: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

Line 367: ,friday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR

363: ,monday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
364: ,tuesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
365: ,wednesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
366: ,thursday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
367: ,friday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
368: ,saturday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
369: ,sunday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
370: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
371: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 368: ,saturday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR

364: ,tuesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
365: ,wednesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
366: ,thursday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
367: ,friday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
368: ,saturday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
369: ,sunday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
370: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
371: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
372: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 369: ,sunday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR

365: ,wednesday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
366: ,thursday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
367: ,friday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
368: ,saturday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
369: ,sunday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
370: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
371: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
372: ,program_id NUMBER := OKC_API.G_MISS_NUM
373: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 373: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

369: ,sunday_yn VARCHAR2(3) := NULL--OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
370: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
371: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
372: ,program_id NUMBER := OKC_API.G_MISS_NUM
373: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
374: ,request_id NUMBER := OKC_API.G_MISS_NUM
375: ,created_by NUMBER := OKC_API.G_MISS_NUM
376: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
377: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 376: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

372: ,program_id NUMBER := OKC_API.G_MISS_NUM
373: ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
374: ,request_id NUMBER := OKC_API.G_MISS_NUM
375: ,created_by NUMBER := OKC_API.G_MISS_NUM
376: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
377: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
378: ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
379: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
380: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 378: ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

374: ,request_id NUMBER := OKC_API.G_MISS_NUM
375: ,created_by NUMBER := OKC_API.G_MISS_NUM
376: ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
377: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
378: ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
379: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
380: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
381: ,major_version NUMBER := OKC_API.G_MISS_NUM);
382:

Line 383: TYPE oks_coverage_times_v_tbl_type IS TABLE OF oks_coverage_times_v_rec_type INDEX BY BINARY_INTEGER;

379: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
380: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
381: ,major_version NUMBER := OKC_API.G_MISS_NUM);
382:
383: TYPE oks_coverage_times_v_tbl_type IS TABLE OF oks_coverage_times_v_rec_type INDEX BY BINARY_INTEGER;
384:
385: h_cvtv_tbl_in oks_coverage_times_v_tbl_type;
386: i_cvtv_tbl_in oks_coverage_times_v_tbl_type;
387:

Line 385: h_cvtv_tbl_in oks_coverage_times_v_tbl_type;

381: ,major_version NUMBER := OKC_API.G_MISS_NUM);
382:
383: TYPE oks_coverage_times_v_tbl_type IS TABLE OF oks_coverage_times_v_rec_type INDEX BY BINARY_INTEGER;
384:
385: h_cvtv_tbl_in oks_coverage_times_v_tbl_type;
386: i_cvtv_tbl_in oks_coverage_times_v_tbl_type;
387:
388: TYPE OksActionTimeTypesVRecType IS RECORD (
389: id NUMBER := OKC_API.G_MISS_NUM

Line 386: i_cvtv_tbl_in oks_coverage_times_v_tbl_type;

382:
383: TYPE oks_coverage_times_v_tbl_type IS TABLE OF oks_coverage_times_v_rec_type INDEX BY BINARY_INTEGER;
384:
385: h_cvtv_tbl_in oks_coverage_times_v_tbl_type;
386: i_cvtv_tbl_in oks_coverage_times_v_tbl_type;
387:
388: TYPE OksActionTimeTypesVRecType IS RECORD (
389: id NUMBER := OKC_API.G_MISS_NUM
390: ,cle_id NUMBER := OKC_API.G_MISS_NUM