DBA Data[Home] [Help]

APPS.OKS_COVERAGE_MIGRATION dependencies on OKS_ACTION_TIMES_V

Line 20: x_acmv_tbl_in OKS_ACM_PVT.oks_action_times_v_tbl_type;

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;
22:
23: l_ctz_rec NUMBER :=0;
24: l_cvt_rec NUMBER :=0;

Line 21: l_acmv_tbl_in OKS_ACM_PVT.oks_action_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;
22:
23: l_ctz_rec NUMBER :=0;
24: l_cvt_rec NUMBER :=0;
25: l_act_ctr NUMBER :=0;

Line 195: TYPE oks_action_times_v_rec_type IS RECORD (

191: i_ctzv_tbl_in OksCoverageTimezonesVTblType;
192:
193:
194:
195: TYPE oks_action_times_v_rec_type IS RECORD (
196: id NUMBER := OKC_API.G_MISS_NUM
197: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
198: ,cle_id NUMBER := OKC_API.G_MISS_NUM
199: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

Line 200: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR

196: id NUMBER := OKC_API.G_MISS_NUM
197: ,cov_action_type_id NUMBER := OKC_API.G_MISS_NUM
198: ,cle_id NUMBER := OKC_API.G_MISS_NUM
199: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
200: ,uom_code OKS_ACTION_TIMES_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
201: ,sun_duration NUMBER := OKC_API.G_MISS_NUM
202: ,mon_duration NUMBER := OKC_API.G_MISS_NUM
203: ,tue_duration NUMBER := OKC_API.G_MISS_NUM
204: ,wed_duration NUMBER := OKC_API.G_MISS_NUM

Line 211: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

207: ,sat_duration NUMBER := OKC_API.G_MISS_NUM
208: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
209: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
210: ,program_id NUMBER := OKC_API.G_MISS_NUM
211: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
212: ,request_id NUMBER := OKC_API.G_MISS_NUM
213: ,created_by NUMBER := OKC_API.G_MISS_NUM
214: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
215: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 214: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

210: ,program_id NUMBER := OKC_API.G_MISS_NUM
211: ,program_update_date OKS_ACTION_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
212: ,request_id NUMBER := OKC_API.G_MISS_NUM
213: ,created_by NUMBER := OKC_API.G_MISS_NUM
214: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
215: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
216: ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
217: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
218: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 216: ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

212: ,request_id NUMBER := OKC_API.G_MISS_NUM
213: ,created_by NUMBER := OKC_API.G_MISS_NUM
214: ,creation_date OKS_ACTION_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
215: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
216: ,last_update_date OKS_ACTION_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
217: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
218: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
219: ,major_version NUMBER := OKC_API.G_MISS_NUM);
220:

Line 221: TYPE oks_action_times_v_tbl_type IS TABLE OF oks_action_times_v_rec_type INDEX BY BINARY_INTEGER;

217: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
218: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
219: ,major_version NUMBER := OKC_API.G_MISS_NUM);
220:
221: TYPE oks_action_times_v_tbl_type IS TABLE OF oks_action_times_v_rec_type INDEX BY BINARY_INTEGER;
222:
223: h_acmv_tbl_in oks_action_times_v_tbl_type;
224: i_acmv_tbl_in oks_action_times_v_tbl_type;
225:

Line 223: h_acmv_tbl_in oks_action_times_v_tbl_type;

219: ,major_version NUMBER := OKC_API.G_MISS_NUM);
220:
221: TYPE oks_action_times_v_tbl_type IS TABLE OF oks_action_times_v_rec_type INDEX BY BINARY_INTEGER;
222:
223: h_acmv_tbl_in oks_action_times_v_tbl_type;
224: i_acmv_tbl_in oks_action_times_v_tbl_type;
225:
226:
227:

Line 224: i_acmv_tbl_in oks_action_times_v_tbl_type;

220:
221: TYPE oks_action_times_v_tbl_type IS TABLE OF oks_action_times_v_rec_type INDEX BY BINARY_INTEGER;
222:
223: h_acmv_tbl_in oks_action_times_v_tbl_type;
224: i_acmv_tbl_in oks_action_times_v_tbl_type;
225:
226:
227:
228: TYPE klnv_rec_type IS RECORD (