The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* The following delete and update statements are commented out */
/* as a quick workaround to fix the time-consuming table handler issue */
/* Eventually we'll need to turn them into a separate fix_language procedure */
/*
DELETE FROM OKC_TIMEVALUES_TL T
WHERE NOT EXISTS (
SELECT NULL
FROM OKC_TIMEVALUES_B B
WHERE B.ID = T.ID
);
/* Also it takes a lot of time doing this redundant update*/
/* UPDATE OKC_TIMEVALUES_TL T SET (
DESCRIPTION,
SHORT_DESCRIPTION,
COMMENTS,
NAME) = (SELECT
B.DESCRIPTION,
B.SHORT_DESCRIPTION,
B.COMMENTS,
B.NAME
FROM OKC_TIMEVALUES_TL B
WHERE B.ID = T.ID
AND B.LANGUAGE = T.SOURCE_LANG)
WHERE (
T.ID,
T.LANGUAGE)
IN (SELECT
SUBT.ID,
SUBT.LANGUAGE
FROM OKC_TIMEVALUES_TL SUBB, OKC_TIMEVALUES_TL SUBT
WHERE SUBB.ID = SUBT.ID
AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
OR SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
OR SUBB.COMMENTS <> SUBT.COMMENTS
OR SUBB.NAME <> SUBT.NAME
OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
OR (SUBB.SHORT_DESCRIPTION IS NULL AND SUBT.SHORT_DESCRIPTION IS NOT NULL)
OR (SUBB.SHORT_DESCRIPTION IS NOT NULL AND SUBT.SHORT_DESCRIPTION IS NULL)
OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
)); */
INSERT INTO OKC_TIMEVALUES_TL (
ID,
LANGUAGE,
SOURCE_LANG,
SFWT_FLAG,
DESCRIPTION,
SHORT_DESCRIPTION,
COMMENTS,
NAME,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN)
SELECT
B.ID,
L.LANGUAGE_CODE,
B.SOURCE_LANG,
B.SFWT_FLAG,
B.DESCRIPTION,
B.SHORT_DESCRIPTION,
B.COMMENTS,
B.NAME,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN
FROM OKC_TIMEVALUES_TL B, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B')
AND B.LANGUAGE = USERENV('LANG')
AND NOT EXISTS(
SELECT NULL
FROM OKC_TIMEVALUES_TL T
WHERE T.ID = B.ID
AND T.LANGUAGE = L.LANGUAGE_CODE
);
DELETE FROM OKC_TIMEVALUES_TLH T
WHERE NOT EXISTS (
SELECT NULL
FROM OKC_TIMEVALUES_BH B
WHERE B.ID = T.ID
AND B.MAJOR_VERSION = T.MAJOR_VERSION
);
UPDATE OKC_TIMEVALUES_TLH T SET (
DESCRIPTION,
SHORT_DESCRIPTION,
COMMENTS,
NAME) = (SELECT
B.DESCRIPTION,
B.SHORT_DESCRIPTION,
B.COMMENTS,
B.NAME
FROM OKC_TIMEVALUES_TLH B
WHERE B.ID = T.ID
AND B.MAJOR_VERSION = T.MAJOR_VERSION
AND B.LANGUAGE = T.SOURCE_LANG)
WHERE (
T.ID,
T.MAJOR_VERSION,
T.LANGUAGE)
IN (SELECT
SUBT.ID,
SUBT.MAJOR_VERSION,
SUBT.LANGUAGE
FROM OKC_TIMEVALUES_TLH SUBB, OKC_TIMEVALUES_TLH SUBT
WHERE SUBB.ID = SUBT.ID
AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
OR SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
OR SUBB.COMMENTS <> SUBT.COMMENTS
OR SUBB.NAME <> SUBT.NAME
OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
OR (SUBB.SHORT_DESCRIPTION IS NULL AND SUBT.SHORT_DESCRIPTION IS NOT NULL)
OR (SUBB.SHORT_DESCRIPTION IS NOT NULL AND SUBT.SHORT_DESCRIPTION IS NULL)
OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
));
INSERT INTO OKC_TIMEVALUES_TLH (
ID,
LANGUAGE,
MAJOR_VERSION,
SOURCE_LANG,
SFWT_FLAG,
DESCRIPTION,
SHORT_DESCRIPTION,
COMMENTS,
NAME,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN)
SELECT
B.ID,
L.LANGUAGE_CODE,
B.MAJOR_VERSION,
B.SOURCE_LANG,
B.SFWT_FLAG,
B.DESCRIPTION,
B.SHORT_DESCRIPTION,
B.COMMENTS,
B.NAME,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN
FROM OKC_TIMEVALUES_TLH B, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B')
AND B.LANGUAGE = USERENV('LANG')
AND NOT EXISTS(
SELECT NULL
FROM OKC_TIMEVALUES_TLH T
WHERE T.ID = B.ID
AND T.MAJOR_VERSION = B.MAJOR_VERSION
AND T.LANGUAGE = L.LANGUAGE_CODE
);
PROCEDURE DELETE_TIMEVALUES_N_TASKS(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_chr_id IN NUMBER ,
p_tve_id IN NUMBER) IS
CURSOR tve_csr(p_tve_id IN NUMBER) is
--Bug 3122962
SELECT TVE_TYPE, TVE_ID_OFFSET,TVE_ID_STARTED,TVE_ID_ENDED FROM OKC_TIMEVALUES
WHERE id = p_tve_id;
l_api_name CONSTANT VARCHAR2(30) := 'delete_timevalues_n_tasks';
OKC_TIME_PVT.DELETE_TPA_RELTV(
p_api_version ,
p_init_msg_list ,
x_return_status ,
x_msg_count ,
x_msg_data ,
p_talv_evt_rec) ;
OKC_TIME_PVT.DELETE_TPG_NAMED(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgnv_rec);
OKC_TIME_PVT.DELETE_TPA_VALUE(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tavv_rec);
OKC_TIME_PVT.DELETE_TPG_DELIMITED(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgdv_ext_rec);
OKC_TIME_PVT.DELETE_CYCLE(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_cylv_ext_rec);
OKC_TIME_PVT.DELETE_IA_STARTEND(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_ext_rec);
OKC_TIME_PVT.DELETE_IG_STARTEND(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_igsv_ext_rec);
OKC_TIME_RES_PUB.Delete_Res_Time_N_Tasks(
p_tve_id,
sysdate,
p_api_version,
p_init_msg_list,
x_return_status);
END DELETE_TIMEVALUES_N_TASKS;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
okc_tal_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_talv_rec,
x_talv_rec);
PROCEDURE UPDATE_TPA_RELTV(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_talv_rec IN talv_rec_type,
x_talv_rec OUT NOCOPY talv_rec_type) IS
BEGIN
okc_tal_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_talv_rec,
x_talv_rec);
END UPDATE_TPA_RELTV;
PROCEDURE DELETE_TPA_RELTV(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_talv_rec IN talv_rec_type) IS
BEGIN
okc_tal_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_talv_rec);
END DELETE_TPA_RELTV;
okc_tal_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_talv_rec,
x_talv_rec);
PROCEDURE UPDATE_TPA_RELTV(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_talv_evt_rec IN talv_event_rec_type,
x_talv_evt_rec OUT NOCOPY talv_event_rec_type) IS
p_talv_rec talv_rec_type;
OKC_TIME_pub.update_tpg_named(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgnv_rec,
x_tgnv_rec);
okc_tal_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_talv_rec,
x_talv_rec);
END UPDATE_TPA_RELTV;
PROCEDURE DELETE_TPA_RELTV(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_talv_evt_rec IN talv_event_rec_type) IS
p_talv_rec talv_rec_type;
OKC_TIME_pub.delete_tpg_named(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgnv_rec);
okc_tal_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_talv_rec);
END DELETE_TPA_RELTV;
okc_tav_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tavv_rec,
x_tavv_rec);
PROCEDURE UPDATE_TPA_VALUE(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tavv_rec IN tavv_rec_type,
x_tavv_rec OUT NOCOPY tavv_rec_type) IS
BEGIN
okc_tav_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tavv_rec,
x_tavv_rec);
END UPDATE_TPA_VALUE;
PROCEDURE DELETE_TPA_VALUE(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tavv_rec IN tavv_rec_type) IS
BEGIN
okc_tav_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tavv_rec);
END DELETE_TPA_VALUE;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
okc_tgd_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgdv_rec,
x_tgdv_rec);
PROCEDURE UPDATE_TPG_DELIMITED(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tgdv_ext_rec IN tgdv_extended_rec_type,
x_tgdv_ext_rec OUT NOCOPY tgdv_extended_rec_type) IS
p_tgdv_rec tgdv_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'update_tpg_delimited';
SELECT tve_id_limited, dnz_chr_id
FROM okc_timevalues
WHERE id = p_id
and tve_type = 'TGD';
SELECT id, start_date, end_date
FROM okc_time_ia_startend_val_v
WHERE id = p_id;
OKC_TIME_pub.delete_ia_startend(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_ext_rec);
OKC_TIME_pub.update_ia_startend(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_ext_rec,
x_isev_ext_rec);
okc_tgd_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgdv_rec,
x_tgdv_rec);
END UPDATE_TPG_DELIMITED;
PROCEDURE DELETE_TPG_DELIMITED(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tgdv_ext_rec IN tgdv_extended_rec_type) IS
p_tgdv_rec tgdv_rec_type;
SELECT id, tve_id_limited
FROM okc_timevalues
WHERE id = p_id
AND tve_type = 'TGD';
OKC_TIME_pub.delete_ia_startend(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_ext_rec);
okc_tgd_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgdv_rec);
END DELETE_TPG_DELIMITED;
okc_tgn_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgnv_rec,
x_tgnv_rec);
PROCEDURE UPDATE_TPG_NAMED(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tgnv_rec IN tgnv_rec_type,
x_tgnv_rec OUT NOCOPY tgnv_rec_type) IS
BEGIN
okc_tgn_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgnv_rec,
x_tgnv_rec);
END UPDATE_TPG_NAMED;
PROCEDURE DELETE_TPG_NAMED(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tgnv_rec IN tgnv_rec_type) IS
BEGIN
okc_tgn_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgnv_rec);
END DELETE_TPG_NAMED;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
okc_ise_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_rec,
x_isev_rec);
PROCEDURE UPDATE_IA_STARTEND(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_isev_ext_rec IN isev_extended_rec_type,
x_isev_ext_rec OUT NOCOPY isev_extended_rec_type) IS
p_tavv_rec tavv_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'update_ia_startend';
SELECT start_date
FROM okc_time_ia_startend_val_v
WHERE id = p_id ;
okc_ise_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_rec,
x_isev_rec);
OKC_TIME_pub.update_tpa_value(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tavv_rec,
x_tavv_rec);
END UPDATE_IA_STARTEND;
PROCEDURE DELETE_IA_STARTEND(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_isev_ext_rec IN isev_extended_rec_type) IS
p_isev_rec isev_rec_type;
SELECT tve_id_started
FROM okc_timevalues
WHERE id = p_id
AND tve_type = 'ISE';
l_api_name CONSTANT VARCHAR2(30) := 'delete_ia_startend';
OKC_TIME_pub.delete_tpa_value(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tavv_rec);
okc_ise_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_rec);
END DELETE_IA_STARTEND;
okc_ise_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_rec,
x_isev_rec);
PROCEDURE UPDATE_IA_STARTEND(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_isev_rel_rec IN isev_reltv_rec_type,
x_isev_rel_rec OUT NOCOPY isev_reltv_rec_type) IS
p_talv_rec talv_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'update_ia_startend';
okc_ise_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_rec,
x_isev_rec);
OKC_TIME_pub.update_tpa_reltv(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_talv_rec,
x_talv_rec);
END UPDATE_IA_STARTEND;
PROCEDURE DELETE_IA_STARTEND(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_isev_rel_rec IN isev_reltv_rec_type) IS
p_isev_rec isev_rec_type;
SELECT tve_id_started
FROM okc_timevalues
WHERE id = p_id
AND tve_type = 'ISE';
l_api_name CONSTANT VARCHAR2(30) := 'delete_ia_startend';
OKC_TIME_pub.delete_tpa_reltv(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_talv_rec);
okc_ise_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_rec);
END DELETE_IA_STARTEND;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
okc_igs_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_igsv_rec,
x_igsv_rec);
PROCEDURE UPDATE_IG_STARTEND(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_igsv_ext_rec IN igsv_extended_rec_type,
x_igsv_ext_rec OUT NOCOPY igsv_extended_rec_type) IS
p_tgdv_ext_rec tgdv_extended_rec_type;
okc_igs_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_igsv_rec,
x_igsv_rec);
OKC_TIME_pub.update_tpg_delimited(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgdv_ext_rec,
x_tgdv_ext_rec);
OKC_TIME_pub.update_tpg_delimited(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgdv_ext_rec,
x_tgdv_ext_rec);
END UPDATE_IG_STARTEND;
PROCEDURE DELETE_IG_STARTEND(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_igsv_ext_rec IN igsv_extended_rec_type) IS
p_igsv_rec igsv_rec_type;
okc_igs_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_igsv_rec);
OKC_TIME_pub.delete_tpg_delimited(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgdv_ext_rec);
OKC_TIME_pub.delete_tpg_delimited(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tgdv_ext_rec);
END DELETE_IG_STARTEND;
okc_spn_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_spnv_rec,
x_spnv_rec);
PROCEDURE UPDATE_SPAN(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_spnv_rec IN spnv_rec_type,
x_spnv_rec OUT NOCOPY spnv_rec_type) IS
BEGIN
okc_spn_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_spnv_rec,
x_spnv_rec);
END UPDATE_SPAN;
PROCEDURE DELETE_SPAN(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_spnv_rec IN spnv_rec_type) IS
BEGIN
okc_spn_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_spnv_rec);
END DELETE_SPAN;
okc_tcu_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tcuv_rec,
x_tcuv_rec);
PROCEDURE UPDATE_TIME_CODE_UNITS(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tcuv_rec IN tcuv_rec_type,
x_tcuv_rec OUT NOCOPY tcuv_rec_type) IS
BEGIN
okc_tcu_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tcuv_rec,
x_tcuv_rec);
END UPDATE_TIME_CODE_UNITS;
PROCEDURE DELETE_TIME_CODE_UNITS(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_tcuv_rec IN tcuv_rec_type) IS
BEGIN
okc_tcu_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_tcuv_rec);
END DELETE_TIME_CODE_UNITS;
okc_rtv_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rtvv_rec,
x_rtvv_rec);
PROCEDURE UPDATE_RESOLVED_TIMEVALUES(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rtvv_rec IN rtvv_rec_type,
x_rtvv_rec OUT NOCOPY rtvv_rec_type) IS
BEGIN
okc_rtv_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rtvv_rec,
x_rtvv_rec);
END UPDATE_RESOLVED_TIMEVALUES;
PROCEDURE DELETE_RESOLVED_TIMEVALUES(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rtvv_rec IN rtvv_rec_type) IS
BEGIN
okc_rtv_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_rtvv_rec);
END DELETE_RESOLVED_TIMEVALUES;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
okc_cyl_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_cylv_rec,
x_cylv_rec);
UPDATE OKC_TIMEVALUES
SET SPN_ID = x_cylv_ext_rec.spn_id
WHERE TVE_TYPE = 'CYL'
AND id = x_cylv_ext_rec.id;
PROCEDURE UPDATE_CYCLE(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_cylv_ext_rec IN cylv_extended_rec_type,
x_cylv_ext_rec OUT NOCOPY cylv_extended_rec_type) IS
p_cylv_rec cylv_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'update_cycle';
SELECT tve_id_limited, dnz_chr_id
FROM okc_timevalues
WHERE id = p_id
AND tve_type = 'CYL';
SELECT id, start_date, end_date
FROM okc_time_ia_startend_val_v
WHERE id = p_id;
OKC_TIME_pub.delete_ia_startend(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_ext_rec);
OKC_TIME_pub.update_ia_startend(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_ext_rec,
x_isev_ext_rec);
okc_cyl_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_cylv_rec,
x_cylv_rec);
OKC_TIME_pub.update_span(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_spnv_rec,
x_spnv_rec);
END UPDATE_CYCLE;
PROCEDURE DELETE_CYCLE(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_cylv_ext_rec IN cylv_extended_rec_type) IS
p_cylv_rec cylv_rec_type;
SELECT id, tve_id_limited, spn_id
FROM okc_timevalues
WHERE id = p_id
AND tve_type = 'CYL';
OKC_TIME_pub.delete_ia_startend(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_isev_ext_rec);
OKC_TIME_pub.delete_span(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_spnv_rec);
okc_cyl_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_cylv_rec);
END DELETE_CYCLE;
PROCEDURE INSERT_IGS_ROW_UPG(p_igsv_ext_tbl IN igsv_ext_tbl_type) IS
l_tabsize NUMBER := p_igsv_ext_tbl.COUNT;
in_last_updated_by OKC_DATATYPES.NumberTabTyp;
in_last_update_date OKC_DATATYPES.DateTabTyp;
in_last_update_login OKC_DATATYPES.NumberTabTyp;
in_last_updated_by (j) := p_igsv_ext_tbl(i).last_updated_by;
in_last_update_date (j) := p_igsv_ext_tbl(i).last_update_date;
in_last_update_login (j) := p_igsv_ext_tbl(i).last_update_login;
in_last_updated_by (j) := p_igsv_ext_tbl(i).last_updated_by;
in_last_update_date (j) := p_igsv_ext_tbl(i).last_update_date;
in_last_update_login (j) := p_igsv_ext_tbl(i).last_update_login;
in_last_updated_by (j) := p_igsv_ext_tbl(i).last_updated_by;
in_last_update_date (j) := p_igsv_ext_tbl(i).last_update_date;
in_last_update_login (j) := p_igsv_ext_tbl(i).last_update_login;
INSERT
INTO OKC_TIMEVALUES
(
id,
spn_id,
tve_id_offset,
tve_id_generated_by,
tve_id_started,
tve_id_ended,
tve_id_limited,
cnh_id,
dnz_chr_id,
tve_type,
tze_id,
object_version_number,
created_by,
creation_date,
last_updated_by,
last_update_date,
uom_code,
duration,
operator,
before_after,
datetime,
month,
day,
hour,
minute,
second,
interval_yn,
last_update_login,
nth,
day_of_week,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
--Bug 3122962
name,
description,
short_description,
comments
)
VALUES (
DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
--Bug 3122962
DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
);
INSERT INTO OKC_TIMEVALUES_TL(
id,
language,
source_lang,
sfwt_flag,
description,
short_description,
comments,
name,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
VALUES (
DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
OKC_UTIL.g_language_code(lang_i),
l_source_lang,
DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
);
END INSERT_IGS_ROW_UPG;
PROCEDURE INSERT_TGD_ROW_UPG(p_tgdv_ext_tbl IN tgdv_ext_tbl_type) IS
l_tabsize NUMBER := p_tgdv_ext_tbl.COUNT;
in_last_updated_by OKC_DATATYPES.NumberTabTyp;
in_last_update_date OKC_DATATYPES.DateTabTyp;
in_last_update_login OKC_DATATYPES.NumberTabTyp;
in_last_updated_by (j) := p_tgdv_ext_tbl(i).last_updated_by;
in_last_update_date (j) := p_tgdv_ext_tbl(i).last_update_date;
in_last_update_login (j) := p_tgdv_ext_tbl(i).last_update_login;
INSERT
INTO OKC_TIMEVALUES
(
id,
spn_id,
tve_id_offset,
tve_id_generated_by,
tve_id_started,
tve_id_ended,
tve_id_limited,
cnh_id,
dnz_chr_id,
tve_type,
tze_id,
object_version_number,
created_by,
creation_date,
last_updated_by,
last_update_date,
uom_code,
duration,
operator,
before_after,
datetime,
month,
day,
hour,
minute,
second,
interval_yn,
last_update_login,
nth,
day_of_week,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
--Bug 3122962
name,
description,
short_description,
comments
)
VALUES (
DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
--Bug 3122962
DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
);
INSERT INTO OKC_TIMEVALUES_TL(
id,
language,
source_lang,
sfwt_flag,
description,
short_description,
comments,
name,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
VALUES (
DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
OKC_UTIL.g_language_code(lang_i),
l_source_lang,
DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
);
END INSERT_TGD_ROW_UPG;
PROCEDURE INSERT_ISE_ROW_UPG(p_isev_ext_tbl IN isev_ext_tbl_type) IS
l_tabsize NUMBER := p_isev_ext_tbl.COUNT;
in_last_updated_by OKC_DATATYPES.NumberTabTyp;
in_last_update_date OKC_DATATYPES.DateTabTyp;
in_last_update_login OKC_DATATYPES.NumberTabTyp;
in_last_updated_by (j) := p_isev_ext_tbl(i).last_updated_by;
in_last_update_date (j) := p_isev_ext_tbl(i).last_update_date;
in_last_update_login (j) := p_isev_ext_tbl(i).last_update_login;
in_last_updated_by (j) := p_isev_ext_tbl(i).last_updated_by;
in_last_update_date (j) := p_isev_ext_tbl(i).last_update_date;
in_last_update_login (j) := p_isev_ext_tbl(i).last_update_login;
INSERT
INTO OKC_TIMEVALUES
(
id,
spn_id,
tve_id_offset,
tve_id_generated_by,
tve_id_started,
tve_id_ended,
tve_id_limited,
cnh_id,
dnz_chr_id,
tve_type,
tze_id,
object_version_number,
created_by,
creation_date,
last_updated_by,
last_update_date,
uom_code,
duration,
operator,
before_after,
datetime,
month,
day,
hour,
minute,
second,
interval_yn,
last_update_login,
nth,
day_of_week,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
--Bug 3122962
name,
description,
short_description,
comments
)
VALUES (
DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
--Bug 3122962
DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
);
INSERT INTO OKC_TIMEVALUES_TL(
id,
language,
source_lang,
sfwt_flag,
description,
short_description,
comments,
name,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
VALUES (
DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
OKC_UTIL.g_language_code(lang_i),
l_source_lang,
DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
);
END INSERT_ISE_ROW_UPG;
PROCEDURE INSERT_ISE_ROW_UPG(p_isev_rel_tbl IN isev_rel_tbl_type) IS
l_tabsize NUMBER := p_isev_rel_tbl.COUNT;
in_last_updated_by OKC_DATATYPES.NumberTabTyp;
in_last_update_date OKC_DATATYPES.DateTabTyp;
in_last_update_login OKC_DATATYPES.NumberTabTyp;
in_last_updated_by (j) := p_isev_rel_tbl(i).last_updated_by;
in_last_update_date (j) := p_isev_rel_tbl(i).last_update_date;
in_last_update_login (j) := p_isev_rel_tbl(i).last_update_login;
in_last_updated_by (j) := p_isev_rel_tbl(i).last_updated_by;
in_last_update_date (j) := p_isev_rel_tbl(i).last_update_date;
in_last_update_login (j) := p_isev_rel_tbl(i).last_update_login;
INSERT
INTO OKC_TIMEVALUES
(
id,
spn_id,
tve_id_offset,
tve_id_generated_by,
tve_id_started,
tve_id_ended,
tve_id_limited,
cnh_id,
dnz_chr_id,
tve_type,
tze_id,
object_version_number,
created_by,
creation_date,
last_updated_by,
last_update_date,
uom_code,
duration,
operator,
before_after,
datetime,
month,
day,
hour,
minute,
second,
interval_yn,
last_update_login,
nth,
day_of_week,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
--Bug 3122962
name,
description,
short_description,
comments
)
VALUES (
DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
--Bug 3122962
DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
);
INSERT INTO OKC_TIMEVALUES_TL(
id,
language,
source_lang,
sfwt_flag,
description,
short_description,
comments,
name,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
VALUES (
DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
OKC_UTIL.g_language_code(lang_i),
l_source_lang,
DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
);
END INSERT_ise_ROW_UPG;