APPS.OKC_TIME_RES_PVT dependencies on OKX_TIMEZONES_V

Line 96: from okx_timezones_v

92: x_tze_name OUT NOCOPY VARCHAR2,
93: x_return_status OUT NOCOPY VARCHAR2) IS
94: CURSOR okc_timezone_csr is
95: SELECT global_timezone_name
96: from okx_timezones_v
97: where timezone_id = p_tze_id;
98: l_okc_timezone_rec okc_timezone_csr%ROWTYPE;
99: item_not_found_error EXCEPTION;
100: l_row_notfound BOOLEAN := TRUE;

Line 371: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;

367: l_okc_tal_rec okc_tal_csr%ROWTYPE;
368: l_okc_tgn_rec okc_tgn_csr%ROWTYPE;
369: l_date date;
370: l_end_date date := NULL; -- bug#2337567 -- default value
371: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;
372: x_task_id NUMBER;
373: l_tze_id NUMBER;
374: l_tve_id NUMBER;
375: x_msg_count NUMBER;

Line 743: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;

739: l_start_date date := OKC_API.G_MISS_DATE;
740: l_end_date date := OKC_API.G_MISS_DATE;
741: l_date date := OKC_API.G_MISS_DATE;
742: x_task_id NUMBER;
743: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;
744: CURSOR okc_tgd_csr (p_tve_id IN NUMBER)
745: IS
746: SELECT month, day, nth, day_of_week, hour, minute, second, tze_id
747: FROM OKC_TIMEVALUES

Line 1002: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;

998: l_rule_df_name varchar2(40);
999: l_col_val_table OKC_TIME_UTIL_PUB.t_col_vals;
1000: l_no_of_cols number;
1001: l_tze_id number;
1002: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;
1003: p_isev_ext_rec OKC_TIME_PUB.isev_ext_rec_type;
1004: x_isev_ext_rec OKC_TIME_PUB.isev_ext_rec_type;
1005: l_pending_further_resolving VARCHAR2(1) := 'X';
1006: l_over_further_resolving VARCHAR2(1) := 'X';

Line 1342: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;

1338: l_col_val_table OKC_TIME_UTIL_PUB.t_col_vals;
1339: l_no_of_cols number;
1340: l_tze_id number;
1341: x_task_id NUMBER;
1342: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;
1343: l_resolved_until_date DATE;
1344: l_cutoff_date DATE := NULL;
1345: l_end_date DATE;
1346: l_start_date DATE;

Line 1805: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;

1801: l_tve_rec tve_id_csr%ROWTYPE;
1802: x_msg_count NUMBER;
1803: x_msg_data VARCHAR2(2000);
1804: x_task_id NUMBER;
1805: l_tze_name OKX_TIMEZONES_V.global_timezone_name%TYPE;
1806: l_row_not_found BOOLEAN := TRUE;
1807: l_cutoff_date DATE := NULL;
1808: BEGIN
1809: x_return_status := OKC_API.G_RET_STS_SUCCESS;