[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
DELETE FROM okl_ls_rt_fctr_sets_tl t
WHERE NOT EXISTS(SELECT NULL
FROM OKL_LS_RT_FTR_SETS_ALL_B b
WHERE b.id = t.id);
UPDATE okl_ls_rt_fctr_sets_tl t
SET(description) = (SELECT
-- LANGUAGE,
-- B.LANGUAGE,
b.description
FROM okl_ls_rt_fctr_sets_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 okl_ls_rt_fctr_sets_tl subb ,okl_ls_rt_fctr_sets_tl subt
WHERE subb.id = subt.id AND subb.language = subt.language AND ( -- SUBB.LANGUAGE <> SUBT.LANGUAGE OR
subb.description <> subt.description OR (subb.language IS NOT NULL
AND subt.language IS NULL)
OR (subb.description IS NULL AND subt.description IS NOT NULL)));
INSERT INTO okl_ls_rt_fctr_sets_tl
(id
,language
,source_lang
,sfwt_flag
,description
,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.CREATED_BY
,b.CREATION_DATE
,b.LAST_UPDATED_BY
,b.LAST_UPDATE_DATE
,b.LAST_UPDATE_LOGIN
FROM okl_ls_rt_fctr_sets_tl b
,fnd_languages l
WHERE l.installed_flag IN('I', 'B')
AND b.language = userenv('LANG')
AND NOT EXISTS(SELECT NULL
FROM okl_ls_rt_fctr_sets_tl t
WHERE t.id = b.id AND t.language = l.language_code);
SELECT id
,object_version_number
,sfwt_flag
,try_id
,pdt_id
,rate
,frq_code
,arrears_yn
,start_date
,end_date
,name
,description
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,sts_code
,org_id
,currency_code
,lrs_type_code
,end_of_term_id
,orig_rate_set_id
INTO l_lrtv_rec.id
,l_lrtv_rec.object_version_number
,l_lrtv_rec.sfwt_flag
,l_lrtv_rec.try_id
,l_lrtv_rec.pdt_id
,l_lrtv_rec.rate
,l_lrtv_rec.frq_code
,l_lrtv_rec.arrears_yn
,l_lrtv_rec.start_date
,l_lrtv_rec.end_date
,l_lrtv_rec.name
,l_lrtv_rec.description
,l_lrtv_rec.created_by
,l_lrtv_rec.creation_date
,l_lrtv_rec.last_updated_by
,l_lrtv_rec.last_update_date
,l_lrtv_rec.last_update_login
,l_lrtv_rec.attribute_category
,l_lrtv_rec.attribute1
,l_lrtv_rec.attribute2
,l_lrtv_rec.attribute3
,l_lrtv_rec.attribute4
,l_lrtv_rec.attribute5
,l_lrtv_rec.attribute6
,l_lrtv_rec.attribute7
,l_lrtv_rec.attribute8
,l_lrtv_rec.attribute9
,l_lrtv_rec.attribute10
,l_lrtv_rec.attribute11
,l_lrtv_rec.attribute12
,l_lrtv_rec.attribute13
,l_lrtv_rec.attribute14
,l_lrtv_rec.attribute15
,l_lrtv_rec.sts_code
,l_lrtv_rec.org_id
,l_lrtv_rec.currency_code
,l_lrtv_rec.lrs_type_code
,l_lrtv_rec.end_of_term_id
,l_lrtv_rec.orig_rate_set_id
FROM okl_ls_rt_fctr_sets_v lrtv
WHERE lrtv.id = p_id;
IF (l_lrtv_rec.last_updated_by = g_miss_num) THEN
l_lrtv_rec.last_updated_by := NULL;
IF (l_lrtv_rec.last_update_date = g_miss_date) THEN
l_lrtv_rec.last_update_date := NULL;
IF (l_lrtv_rec.last_update_login = g_miss_num) THEN
l_lrtv_rec.last_update_login := NULL;
SELECT 'x'
FROM fnd_lookups
WHERE lookup_type = 'OKL_YES_NO' AND lookup_code = p_arrears_yn;
SELECT 'x'
FROM fnd_lookups
WHERE lookup_type = 'OKL_FREQUENCY' AND lookup_code = p_frq_code;
SELECT 'x'
FROM fnd_lookups
WHERE lookup_type = 'OKL_LRS_TYPES' AND lookup_code = p_type_code;
SELECT 'x'
FROM fnd_lookups
WHERE lookup_type = 'OKL_PRC_STATUS' AND lookup_code = p_sts_code;
SELECT 'X'
FROM okl_fe_eo_terms_v
WHERE end_of_term_id = p_end_of_term_id;
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;
PROCEDURE insert_row(x_return_status OUT NOCOPY varchar2
,p_lrt_rec IN lrt_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'insert_row (B)';
INSERT INTO okl_ls_rt_fctr_sets_b
(id
,object_version_number
,name
,arrears_yn
,start_date
,end_date
,pdt_id
,rate
,try_id
,frq_code
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,sts_code
,org_id
,currency_code
,lrs_type_code
,end_of_term_id
,orig_rate_set_id)
VALUES (l_lrt_rec.id
,l_lrt_rec.object_version_number
,l_lrt_rec.name
,l_lrt_rec.arrears_yn
,l_lrt_rec.start_date
,l_lrt_rec.end_date
,l_lrt_rec.pdt_id
,l_lrt_rec.rate
,l_lrt_rec.try_id
,l_lrt_rec.frq_code
,l_lrt_rec.created_by
,l_lrt_rec.creation_date
,l_lrt_rec.last_updated_by
,l_lrt_rec.last_update_date
,l_lrt_rec.last_update_login
,l_lrt_rec.attribute_category
,l_lrt_rec.attribute1
,l_lrt_rec.attribute2
,l_lrt_rec.attribute3
,l_lrt_rec.attribute4
,l_lrt_rec.attribute5
,l_lrt_rec.attribute6
,l_lrt_rec.attribute7
,l_lrt_rec.attribute8
,l_lrt_rec.attribute9
,l_lrt_rec.attribute10
,l_lrt_rec.attribute11
,l_lrt_rec.attribute12
,l_lrt_rec.attribute13
,l_lrt_rec.attribute14
,l_lrt_rec.attribute15
,l_lrt_rec.sts_code
,l_lrt_rec.org_id
,l_lrt_rec.currency_code
,l_lrt_rec.lrs_type_code
,l_lrt_rec.end_of_term_id
,l_lrt_rec.orig_rate_set_id);
END insert_row;
PROCEDURE insert_row(x_return_status OUT NOCOPY varchar2
,p_lrttl_rec IN lrttl_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'insert_row (TL)';
SELECT language_code
FROM fnd_languages
WHERE installed_flag IN('I', 'B');
INSERT INTO okl_ls_rt_fctr_sets_tl
(id
,language
,source_lang
,sfwt_flag
,description
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login)
VALUES (p_lrttl_rec.id
,l_lang_rec.language_code
,userenv('LANG')
,l_sfwt_flag
,p_lrttl_rec.description
,p_lrttl_rec.created_by
,p_lrttl_rec.creation_date
,p_lrttl_rec.last_updated_by
,p_lrttl_rec.last_update_date
,p_lrttl_rec.last_update_login);
END insert_row;
PROCEDURE insert_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrtv_rec IN lrtv_rec_type
,x_lrtv_rec OUT NOCOPY lrtv_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'insert_row (REC)';
l_lrtv_rec.last_update_date := sysdate;
l_lrtv_rec.last_updated_by := fnd_global.user_id;
l_lrtv_rec.last_update_login := fnd_global.login_id;
insert_row(x_return_status => l_return_status
,p_lrt_rec => l_lrt_rec);
insert_row(x_return_status => l_return_status
,p_lrttl_rec => l_lrttl_rec);
END insert_row;
PROCEDURE insert_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrtv_tbl IN lrtv_tbl_type
,x_lrtv_tbl OUT NOCOPY lrtv_tbl_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'insert_row (TBL)';
insert_row(p_api_version => g_api_version
,p_init_msg_list => g_false
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_lrtv_rec => p_lrtv_tbl(i)
,x_lrtv_rec => x_lrtv_tbl(i));
END insert_row;
SELECT object_version_number
FROM okl_ls_rt_fctr_sets_b
WHERE id = p_lrt_rec.id
AND object_version_number = p_lrt_rec.object_version_number
FOR UPDATE OF object_version_number NOWAIT;
SELECT object_version_number
FROM okl_ls_rt_fctr_sets_b
WHERE id = p_lrt_rec.id;
okc_api.set_message(g_fnd_app, g_form_record_deleted);
okc_api.set_message(g_app_name, g_record_logically_deleted);
SELECT *
FROM okl_ls_rt_fctr_sets_tl
WHERE id = p_lrttl_rec.id
FOR UPDATE NOWAIT;
okl_api.set_message(g_fnd_app, g_form_record_deleted);
PROCEDURE update_row(x_return_status OUT NOCOPY varchar2
,p_lrt_rec IN lrt_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'update_row (B)';
UPDATE okl_ls_rt_fctr_sets_b
SET object_version_number = p_lrt_rec.object_version_number + 1
,name = p_lrt_rec.name
,arrears_yn = p_lrt_rec.arrears_yn
,start_date = p_lrt_rec.start_date
,end_date = p_lrt_rec.end_date
,pdt_id = p_lrt_rec.pdt_id
,rate = p_lrt_rec.rate
,try_id = p_lrt_rec.try_id
,frq_code = p_lrt_rec.frq_code
,created_by = p_lrt_rec.created_by
,creation_date = p_lrt_rec.creation_date
,last_updated_by = p_lrt_rec.last_updated_by
,last_update_date = p_lrt_rec.last_update_date
,last_update_login = p_lrt_rec.last_update_login
,attribute_category = p_lrt_rec.attribute_category
,attribute1 = p_lrt_rec.attribute1
,attribute2 = p_lrt_rec.attribute2
,attribute3 = p_lrt_rec.attribute3
,attribute4 = p_lrt_rec.attribute4
,attribute5 = p_lrt_rec.attribute5
,attribute6 = p_lrt_rec.attribute6
,attribute7 = p_lrt_rec.attribute7
,attribute8 = p_lrt_rec.attribute8
,attribute9 = p_lrt_rec.attribute9
,attribute10 = p_lrt_rec.attribute10
,attribute11 = p_lrt_rec.attribute11
,attribute12 = p_lrt_rec.attribute12
,attribute13 = p_lrt_rec.attribute13
,attribute14 = p_lrt_rec.attribute14
,attribute15 = p_lrt_rec.attribute15
,sts_code = p_lrt_rec.sts_code
,org_id = p_lrt_rec.org_id
,currency_code = p_lrt_rec.currency_code
,lrs_type_code = p_lrt_rec.lrs_type_code
,end_of_term_id = p_lrt_rec.end_of_term_id
,orig_rate_set_id = p_lrt_rec.orig_rate_set_id
WHERE id = p_lrt_rec.id;
END update_row;
PROCEDURE update_row(x_return_status OUT NOCOPY varchar2
,p_lrttl_rec IN lrttl_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'update_row (TL)';
SELECT 'Y'
FROM fnd_languages
WHERE installed_flag IN('I', 'B') AND language_code = userenv('LANG');
SELECT 'Y'
FROM okl_ls_rt_fctr_sets_tl
WHERE id = p_lrttl_rec.id AND language = userenv('LANG');
INSERT INTO okl_ls_rt_fctr_sets_tl
(id
,language
,source_lang
,sfwt_flag
,description
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login)
VALUES (p_lrttl_rec.id
,userenv('LANG')
,userenv('LANG')
,'N'
,p_lrttl_rec.description
,p_lrttl_rec.created_by
,p_lrttl_rec.creation_date
,p_lrttl_rec.last_updated_by
,p_lrttl_rec.last_update_date
,p_lrttl_rec.last_update_login);
UPDATE okl_ls_rt_fctr_sets_tl
SET description = p_lrttl_rec.description
,source_lang = userenv('LANG')
,created_by = p_lrttl_rec.created_by
,creation_date = p_lrttl_rec.creation_date
,last_updated_by = p_lrttl_rec.last_updated_by
,last_update_date = p_lrttl_rec.last_update_date
,last_update_login = p_lrttl_rec.last_update_login
WHERE id = p_lrttl_rec.id;
UPDATE okl_ls_rt_fctr_sets_tl
SET sfwt_flag = 'Y'
WHERE id = p_lrttl_rec.id AND source_lang <> language;
UPDATE okl_ls_rt_fctr_sets_tl
SET sfwt_flag = 'N'
WHERE id = p_lrttl_rec.id AND source_lang = language;
END update_row;
PROCEDURE update_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrtv_rec IN lrtv_rec_type
,x_lrtv_rec OUT NOCOPY lrtv_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'update_row (REC)';
SELECT id
FROM okl_ls_rt_fctr_ents
WHERE lrt_id = p_lrt_id;
l_lrtv_rec.last_update_date := sysdate;
l_lrtv_rec.last_updated_by := fnd_global.user_id;
l_lrtv_rec.last_update_login := fnd_global.login_id;
update_row(x_return_status => l_return_status
,p_lrt_rec => l_lrt_rec);
update_row(x_return_status => l_return_status
,p_lrttl_rec => l_lrttl_rec);
END update_row;
PROCEDURE update_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrtv_tbl IN lrtv_tbl_type
,x_lrtv_tbl OUT NOCOPY lrtv_tbl_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'update_row (TBL)';
update_row(p_api_version => g_api_version
,p_init_msg_list => g_false
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_lrtv_rec => p_lrtv_tbl(i)
,x_lrtv_rec => x_lrtv_tbl(i));
END update_row;
PROCEDURE delete_row(p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrt_rec IN lrt_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'delete_row (B)';
DELETE FROM okl_ls_rt_fctr_ents
WHERE lrt_id = p_lrt_rec.id;
DELETE FROM okl_ls_rt_fctr_sets_b
WHERE id = p_lrt_rec.id;
END delete_row;
PROCEDURE delete_row(p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrttl_rec IN lrttl_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'delete_row (TL)';
DELETE FROM okl_ls_rt_fctr_sets_tl
WHERE id = p_lrttl_rec.id;
END delete_row;
PROCEDURE delete_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrtv_rec IN lrtv_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'delete_row (REC)';
delete_row(p_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,l_lrttl_rec);
delete_row(p_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,l_lrt_rec);
END delete_row;
PROCEDURE delete_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrtv_tbl IN lrtv_tbl_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'delete_row (TBL)';
delete_row(p_api_version => g_api_version
,p_init_msg_list => g_false
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_lrtv_rec => p_lrtv_tbl(i));
END delete_row;