The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT descriptive_flex_context_code
,end_user_column_name
,flex_value_set_id
,required_flag
,application_column_name
,seq_no
,form_left_prompt
FROM okc_ddf_contextcode_tmp
WHERE descriptive_flex_context_code = p_context_code
ORDER BY seq_no;
SELECT descriptive_flex_context_code
,dummy_col
,seq_no
,form_left_prompt
FROM okc_obj_ddf_ctxcode_tmp
WHERE descriptive_flex_context_code = p_context_code
ORDER BY seq_no;
SELECT 'x'
FROM OKC_RULE_GROUPS_B rgpv
WHERE rgpv.ID = p_rulv_rec.RGP_ID;
SELECT 'x'
FROM OKC_K_HEADERS_B chrv
WHERE chrv.ID = p_rulv_rec.DNZ_CHR_ID;
SELECT 'x'
FROM FND_DESCR_FLEX_CONTEXTS_VL dfc
-- WHERE dfc.application_id = 510 -- Application id for Contracts -- /striping/
WHERE dfc.application_id = appl_id -- Application id for Contracts
-- AND dfc.descriptive_flexfield_name = G_DESCRIPTIVE_FLEXFIELD_NAME -- /striping/
AND dfc.descriptive_flexfield_name = dff_name
AND dfc.descriptive_flex_context_code = p_rulv_rec.rule_information_category;
SELECT 'x'
FROM OKC_RULE_GROUPS_B rgpv,
OKC_RG_DEF_RULES rgrv
WHERE rgrv.RGD_CODE = rgpv.RGD_CODE
AND rgpv.ID = p_rulv_rec.rgp_id
AND rgrv.RDF_CODE = p_rulv_rec.rule_information_category;
SELECT VALIDATION_TYPE, FORMAT_TYPE, MAXIMUM_SIZE,
UPPERCASE_ONLY_FLAG, NUMERIC_MODE_ENABLED_FLAG,
NUMBER_PRECISION
FROM FND_FLEX_VALUE_SETS fvs
WHERE fvs.FLEX_VALUE_SET_ID = l_flex_value_set_id;
SELECT application_table_name, id_column_name, id_column_type,
ADDITIONAL_WHERE_CLAUSE
FROM FND_FLEX_VALIDATION_TABLES fvt
WHERE fvt.flex_value_set_id = l_flex_value_set_id;
SELECT /*+ first_rows */ 'x'
FROM FND_FLEX_VALUES fvl
WHERE fvl.flex_value_set_id = l_flex_value_set_id
AND rownum < 2 ;
SELECT /*+ first_rows */ 'x'
FROM FND_FLEX_VALUES fvl
WHERE fvl.flex_value_set_id = l_flex_value_set_id
AND fvl.flex_value = l_rule_information
AND rownum < 2 ;
SELECT END_USER_COLUMN_NAME, FLEX_VALUE_SET_ID, REQUIRED_FLAG
FROM FND_DESCR_FLEX_COLUMN_USAGES dfcu
WHERE dfcu.descriptive_flexfield_name = 'OKC Rule Developer DF'
AND dfcu.descriptive_flex_context_code = p_rule_cat
AND dfcu.application_column_name = p_attribute
AND dfcu.application_id =510;
sql_stmt := 'SELECT ''x'' ' ||
' FROM ' || l_fvt_rec.application_table_name ||
' WHERE ' || l_fvt_rec.id_column_name || ' = :col_val ' ||
' AND rownum < 2 ' ||
l_where_clause;
sql_stmt := 'SELECT ''x'' ' ||
' FROM FND_DESCR_FLEX_COLUMN_USAGES dfcu ' ||
-- ' WHERE dfcu.descriptive_flexfield_name = ' || -- /striping/
' WHERE dfcu.descriptive_flexfield_name = :dff_name ' ||
-- ''''||G_DESCRIPTIVE_FLEXFIELD_NAME||'''' || -- /striping/
' AND dfcu.descriptive_flex_context_code = :rule_cat ' ||
' AND dfcu.end_user_column_name = :attribute' ||
-- ' AND dfcu.APPLICATION_ID=510'; -- /striping/
SELECT decode(where_clause,'','','and '||where_clause) where_clause,
from_table
FROM JTF_OBJECTS_B jtot
WHERE jtot.object_code = jtot_object_code;
sql_stmt := 'SELECT ''x'' ' ||
' FROM ' || l_from_table ||
' WHERE ID1 = :col_val ' ||
' AND ID2 = :col_val2 '||
' AND rownum < 2 '|| l_where_clause;
SELECT decode(where_clause,'','','and '||where_clause) where_clause,
from_table
FROM JTF_OBJECTS_B jtot
WHERE jtot.object_code = l_jtot_object_code;
sql_stmt := 'SELECT name ' ||
' FROM ' || l_from_table ||
' WHERE ID1 = :col_val ' ||
' AND ID2 = :col_val2 ' || l_where_clause;
SELECT VALIDATION_TYPE, FORMAT_TYPE, MAXIMUM_SIZE,
UPPERCASE_ONLY_FLAG, NUMERIC_MODE_ENABLED_FLAG,
NUMBER_PRECISION
FROM FND_FLEX_VALUE_SETS fvs
WHERE fvs.FLEX_VALUE_SET_ID = l_flex_value_set_id;
SELECT application_table_name, id_column_name, id_column_type,
ADDITIONAL_WHERE_CLAUSE, value_column_name
FROM FND_FLEX_VALIDATION_TABLES fvt
WHERE fvt.flex_value_set_id = l_flex_value_set_id;
sql_stmt := 'SELECT ' ||l_fvt_rec.value_column_name||
' FROM ' || l_fvt_rec.application_table_name ||
' WHERE ' || l_fvt_rec.id_column_name || ' = :col_val ' ||
l_where_clause;
DELETE FROM OKC_RULES_TL T
WHERE NOT EXISTS (
SELECT NULL
FROM OKC_RULES_B B
WHERE B.ID = T.ID
);
UPDATE OKC_RULES_TL T SET (
COMMENTS,
TEXT) = (SELECT
B.COMMENTS,
B.TEXT
FROM OKC_RULES_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_RULES_TL SUBB, OKC_RULES_TL SUBT
WHERE SUBB.ID = SUBT.ID
AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
AND (SUBB.COMMENTS <> SUBT.COMMENTS
OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
OR ((SUBB.TEXT IS NOT NULL AND SUBT.TEXT IS NOT NULL) AND
(DBMS_LOB.COMPARE(SUBB.TEXT,SUBT.TEXT) <> 0))
));
INSERT INTO OKC_RULES_TL (
ID,
LANGUAGE,
SOURCE_LANG,
SFWT_FLAG,
COMMENTS,
TEXT,
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.COMMENTS,
B.TEXT,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN
FROM OKC_RULES_TL B, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B')
AND B.LANGUAGE = USERENV('LANG')
AND NOT EXISTS(
SELECT NULL
FROM OKC_RULES_TL T
WHERE T.ID = B.ID
AND T.LANGUAGE = L.LANGUAGE_CODE
);
DELETE FROM OKC_RULES_TLH T
WHERE NOT EXISTS (
SELECT NULL
FROM OKC_RULES_BH B
WHERE B.ID = T.ID
AND B.MAJOR_VERSION = T.MAJOR_VERSION
);
UPDATE OKC_RULES_TLH T SET (
COMMENTS,
TEXT) = (SELECT
B.COMMENTS,
B.TEXT
FROM OKC_RULES_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_RULES_TLH SUBB, OKC_RULES_TLH SUBT
WHERE SUBB.ID = SUBT.ID
AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
AND (SUBB.COMMENTS <> SUBT.COMMENTS
OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
OR ((SUBB.TEXT IS NOT NULL AND SUBT.TEXT IS NOT NULL) AND
(DBMS_LOB.COMPARE(SUBB.TEXT,SUBT.TEXT) <> 0))
));
INSERT INTO OKC_RULES_TLH (
ID,
LANGUAGE,
MAJOR_VERSION,
SOURCE_LANG,
SFWT_FLAG,
COMMENTS,
TEXT,
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.COMMENTS,
B.TEXT,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN
FROM OKC_RULES_TLH B, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B')
AND B.LANGUAGE = USERENV('LANG')
AND NOT EXISTS(
SELECT NULL
FROM OKC_RULES_TLH T
WHERE T.ID = B.ID
AND T.MAJOR_VERSION = B.MAJOR_VERSION
AND T.LANGUAGE = L.LANGUAGE_CODE
);
SELECT
ID,
RGP_ID,
OBJECT1_ID1,
OBJECT2_ID1,
OBJECT3_ID1,
OBJECT1_ID2,
OBJECT2_ID2,
OBJECT3_ID2,
JTOT_OBJECT1_CODE,
JTOT_OBJECT2_CODE,
JTOT_OBJECT3_CODE,
DNZ_CHR_ID,
STD_TEMPLATE_YN,
WARN_YN,
PRIORITY,
OBJECT_VERSION_NUMBER,
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,
RULE_INFORMATION_CATEGORY,
RULE_INFORMATION1,
RULE_INFORMATION2,
RULE_INFORMATION3,
RULE_INFORMATION4,
RULE_INFORMATION5,
RULE_INFORMATION6,
RULE_INFORMATION7,
RULE_INFORMATION8,
RULE_INFORMATION9,
RULE_INFORMATION10,
RULE_INFORMATION11,
RULE_INFORMATION12,
RULE_INFORMATION13,
RULE_INFORMATION14,
RULE_INFORMATION15,
TEMPLATE_YN,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
DISPLAY_SEQUENCE,
--Bug 3055393
comments
FROM Okc_Rules_B
WHERE okc_rules_b.id = p_id;
l_rul_rec.LAST_UPDATED_BY,
l_rul_rec.LAST_UPDATE_DATE,
l_rul_rec.LAST_UPDATE_LOGIN,
l_rul_rec.ATTRIBUTE_CATEGORY,
l_rul_rec.ATTRIBUTE1,
l_rul_rec.ATTRIBUTE2,
l_rul_rec.ATTRIBUTE3,
l_rul_rec.ATTRIBUTE4,
l_rul_rec.ATTRIBUTE5,
l_rul_rec.ATTRIBUTE6,
l_rul_rec.ATTRIBUTE7,
l_rul_rec.ATTRIBUTE8,
l_rul_rec.ATTRIBUTE9,
l_rul_rec.ATTRIBUTE10,
l_rul_rec.ATTRIBUTE11,
l_rul_rec.ATTRIBUTE12,
l_rul_rec.ATTRIBUTE13,
l_rul_rec.ATTRIBUTE14,
l_rul_rec.ATTRIBUTE15,
l_rul_rec.RULE_INFORMATION_CATEGORY,
l_rul_rec.RULE_INFORMATION1,
l_rul_rec.RULE_INFORMATION2,
l_rul_rec.RULE_INFORMATION3,
l_rul_rec.RULE_INFORMATION4,
l_rul_rec.RULE_INFORMATION5,
l_rul_rec.RULE_INFORMATION6,
l_rul_rec.RULE_INFORMATION7,
l_rul_rec.RULE_INFORMATION8,
l_rul_rec.RULE_INFORMATION9,
l_rul_rec.RULE_INFORMATION10,
l_rul_rec.RULE_INFORMATION11,
l_rul_rec.RULE_INFORMATION12,
l_rul_rec.RULE_INFORMATION13,
l_rul_rec.RULE_INFORMATION14,
l_rul_rec.RULE_INFORMATION15,
l_rul_rec.TEMPLATE_YN,
l_rul_rec.ans_set_jtot_object_code,
l_rul_rec.ans_set_jtot_object_id1,
l_rul_rec.ans_set_jtot_object_id2,
l_rul_rec.DISPLAY_SEQUENCE,
--Bug 3055393
l_rul_rec.comments ;
SELECT
ID,
LANGUAGE,
SOURCE_LANG,
SFWT_FLAG,
COMMENTS,
TEXT,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM Okc_Rules_Tl
WHERE okc_rules_tl.id = p_id
AND okc_rules_tl.language = p_language;
l_okc_rules_tl_rec.LAST_UPDATED_BY,
l_okc_rules_tl_rec.LAST_UPDATE_DATE,
l_okc_rules_tl_rec.LAST_UPDATE_LOGIN;
SELECT
ID,
OBJECT_VERSION_NUMBER,
--Bug 3055393 SFWT_FLAG,
OBJECT1_ID1,
OBJECT2_ID1,
OBJECT3_ID1,
OBJECT1_ID2,
OBJECT2_ID2,
OBJECT3_ID2,
JTOT_OBJECT1_CODE,
JTOT_OBJECT2_CODE,
JTOT_OBJECT3_CODE,
DNZ_CHR_ID,
RGP_ID,
PRIORITY,
STD_TEMPLATE_YN,
COMMENTS,
WARN_YN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
--Bug 3055393 TEXT,
RULE_INFORMATION_CATEGORY,
RULE_INFORMATION1,
RULE_INFORMATION2,
RULE_INFORMATION3,
RULE_INFORMATION4,
RULE_INFORMATION5,
RULE_INFORMATION6,
RULE_INFORMATION7,
RULE_INFORMATION8,
RULE_INFORMATION9,
RULE_INFORMATION10,
RULE_INFORMATION11,
RULE_INFORMATION12,
RULE_INFORMATION13,
RULE_INFORMATION14,
RULE_INFORMATION15,
TEMPLATE_YN,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
DISPLAY_SEQUENCE
FROM Okc_Rules_V
WHERE okc_rules_v.id = p_id;
l_rulv_rec.LAST_UPDATED_BY,
l_rulv_rec.LAST_UPDATE_DATE,
l_rulv_rec.LAST_UPDATE_LOGIN,
--Bug 3055393 l_rulv_rec.TEXT,
l_rulv_rec.RULE_INFORMATION_CATEGORY,
l_rulv_rec.RULE_INFORMATION1,
l_rulv_rec.RULE_INFORMATION2,
l_rulv_rec.RULE_INFORMATION3,
l_rulv_rec.RULE_INFORMATION4,
l_rulv_rec.RULE_INFORMATION5,
l_rulv_rec.RULE_INFORMATION6,
l_rulv_rec.RULE_INFORMATION7,
l_rulv_rec.RULE_INFORMATION8,
l_rulv_rec.RULE_INFORMATION9,
l_rulv_rec.RULE_INFORMATION10,
l_rulv_rec.RULE_INFORMATION11,
l_rulv_rec.RULE_INFORMATION12,
l_rulv_rec.RULE_INFORMATION13,
l_rulv_rec.RULE_INFORMATION14,
l_rulv_rec.RULE_INFORMATION15,
l_rulv_rec.TEMPLATE_YN,
l_rulv_rec.ans_set_jtot_object_code,
l_rulv_rec.ans_set_jtot_object_id1,
l_rulv_rec.ans_set_jtot_object_id2,
l_rulv_rec.DISPLAY_SEQUENCE ;
IF (l_rulv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
l_rulv_rec.last_updated_by := NULL;
IF (l_rulv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
l_rulv_rec.last_update_date := NULL;
IF (l_rulv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
l_rulv_rec.last_update_login := NULL;
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;
PROCEDURE insert_row(
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_rul_rec IN rul_rec_type,
x_rul_rec OUT NOCOPY rul_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
l_proc varchar2(72) := g_package||'insert_row';
INSERT INTO OKC_RULES_B(
id,
rgp_id,
object1_id1,
object2_id1,
object3_id1,
object1_id2,
object2_id2,
object3_id2,
jtot_object1_code,
jtot_object2_code,
jtot_object3_code,
dnz_chr_id,
std_template_yn,
warn_yn,
priority,
object_version_number,
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,
rule_information_category,
rule_information1,
rule_information2,
rule_information3,
rule_information4,
rule_information5,
rule_information6,
rule_information7,
rule_information8,
rule_information9,
rule_information10,
rule_information11,
rule_information12,
rule_information13,
rule_information14,
rule_information15,
template_yn,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
display_sequence,
--Bug 3055393
comments)
VALUES (
l_rul_rec.id,
l_rul_rec.rgp_id,
l_rul_rec.object1_id1,
l_rul_rec.object2_id1,
l_rul_rec.object3_id1,
l_rul_rec.object1_id2,
l_rul_rec.object2_id2,
l_rul_rec.object3_id2,
l_rul_rec.jtot_object1_code,
l_rul_rec.jtot_object2_code,
l_rul_rec.jtot_object3_code,
l_rul_rec.dnz_chr_id,
l_rul_rec.std_template_yn,
l_rul_rec.warn_yn,
l_rul_rec.priority,
l_rul_rec.object_version_number,
l_rul_rec.created_by,
l_rul_rec.creation_date,
l_rul_rec.last_updated_by,
l_rul_rec.last_update_date,
l_rul_rec.last_update_login,
l_rul_rec.attribute_category,
l_rul_rec.attribute1,
l_rul_rec.attribute2,
l_rul_rec.attribute3,
l_rul_rec.attribute4,
l_rul_rec.attribute5,
l_rul_rec.attribute6,
l_rul_rec.attribute7,
l_rul_rec.attribute8,
l_rul_rec.attribute9,
l_rul_rec.attribute10,
l_rul_rec.attribute11,
l_rul_rec.attribute12,
l_rul_rec.attribute13,
l_rul_rec.attribute14,
l_rul_rec.attribute15,
l_rul_rec.rule_information_category,
l_rul_rec.rule_information1,
l_rul_rec.rule_information2,
l_rul_rec.rule_information3,
l_rul_rec.rule_information4,
l_rul_rec.rule_information5,
l_rul_rec.rule_information6,
l_rul_rec.rule_information7,
l_rul_rec.rule_information8,
l_rul_rec.rule_information9,
l_rul_rec.rule_information10,
l_rul_rec.rule_information11,
l_rul_rec.rule_information12,
l_rul_rec.rule_information13,
l_rul_rec.rule_information14,
l_rul_rec.rule_information15,
l_rul_rec.template_yn,
l_rul_rec.ans_set_jtot_object_code,
l_rul_rec.ans_set_jtot_object_id1,
l_rul_rec.ans_set_jtot_object_id2,
l_rul_rec.display_sequence,
--Bug 3055393
l_rul_rec.comments);
END insert_row;
PROCEDURE insert_row(
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_okc_rules_tl_rec IN okc_rules_tl_rec_type,
x_okc_rules_tl_rec OUT NOCOPY okc_rules_tl_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
SELECT *
FROM FND_LANGUAGES
WHERE INSTALLED_FLAG IN ('I', 'B');
l_proc varchar2(72) := g_package||'insert_row';
INSERT INTO OKC_RULES_TL(
id,
language,
source_lang,
sfwt_flag,
comments,
text,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES (
l_okc_rules_tl_rec.id,
l_okc_rules_tl_rec.language,
l_okc_rules_tl_rec.source_lang,
l_okc_rules_tl_rec.sfwt_flag,
l_okc_rules_tl_rec.comments,
l_okc_rules_tl_rec.text,
l_okc_rules_tl_rec.created_by,
l_okc_rules_tl_rec.creation_date,
l_okc_rules_tl_rec.last_updated_by,
l_okc_rules_tl_rec.last_update_date,
l_okc_rules_tl_rec.last_update_login);
END insert_row;
PROCEDURE insert_row(
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_rulv_rec IN rulv_rec_type,
x_rulv_rec OUT NOCOPY rulv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
l_proc varchar2(72) := g_package||'insert_row';
l_rulv_rec.LAST_UPDATE_DATE := l_rulv_rec.creation_date;
l_rulv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
l_rulv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
insert_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_rul_rec,
lx_rul_rec
);
insert_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_okc_rules_tl_rec,
lx_okc_rules_tl_rec
);
END insert_row;
PROCEDURE insert_row(
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_rulv_tbl IN rulv_tbl_type,
x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
l_proc varchar2(72) := g_package||'insert_row';
insert_row (
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_rulv_rec => p_rulv_tbl(i),
x_rulv_rec => x_rulv_tbl(i));
END insert_row;
SELECT OBJECT_VERSION_NUMBER
FROM OKC_RULES_B
WHERE ID = p_rul_rec.id
AND OBJECT_VERSION_NUMBER = p_rul_rec.object_version_number
FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
SELECT OBJECT_VERSION_NUMBER
FROM OKC_RULES_B
WHERE ID = p_rul_rec.id;
l_proc varchar2(72) := g_package||'insert_row';
OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
SELECT *
FROM OKC_RULES_TL
WHERE ID = p_okc_rules_tl_rec.id
FOR UPDATE NOWAIT;
l_proc varchar2(72) := g_package||'insert_row';
OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
l_proc varchar2(72) := g_package||'insert_row';
l_proc varchar2(72) := g_package||'insert_row';
PROCEDURE update_row(
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_rul_rec IN rul_rec_type,
x_rul_rec OUT NOCOPY rul_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
l_proc varchar2(72) := g_package||'update_row';
IF (x_rul_rec.last_updated_by = OKC_API.G_MISS_NUM)
THEN
x_rul_rec.last_updated_by := l_rul_rec.last_updated_by;
IF (x_rul_rec.last_update_date = OKC_API.G_MISS_DATE)
THEN
x_rul_rec.last_update_date := l_rul_rec.last_update_date;
IF (x_rul_rec.last_update_login = OKC_API.G_MISS_NUM)
THEN
x_rul_rec.last_update_login := l_rul_rec.last_update_login;
UPDATE OKC_RULES_B
SET RGP_ID = l_def_rul_rec.rgp_id,
OBJECT1_ID1 = l_def_rul_rec.object1_id1,
OBJECT2_ID1 = l_def_rul_rec.object2_id1,
OBJECT3_ID1 = l_def_rul_rec.object3_id1,
OBJECT1_ID2 = l_def_rul_rec.object1_id2,
OBJECT2_ID2 = l_def_rul_rec.object2_id2,
OBJECT3_ID2 = l_def_rul_rec.object3_id2,
JTOT_OBJECT1_CODE = l_def_rul_rec.jtot_object1_code,
JTOT_OBJECT2_CODE = l_def_rul_rec.jtot_object2_code,
JTOT_OBJECT3_CODE = l_def_rul_rec.jtot_object3_code,
DNZ_CHR_ID = l_def_rul_rec.dnz_chr_id,
STD_TEMPLATE_YN = l_def_rul_rec.std_template_yn,
WARN_YN = l_def_rul_rec.warn_yn,
PRIORITY = l_def_rul_rec.priority,
OBJECT_VERSION_NUMBER = l_def_rul_rec.object_version_number,
CREATED_BY = l_def_rul_rec.created_by,
CREATION_DATE = l_def_rul_rec.creation_date,
LAST_UPDATED_BY = l_def_rul_rec.last_updated_by,
LAST_UPDATE_DATE = l_def_rul_rec.last_update_date,
LAST_UPDATE_LOGIN = l_def_rul_rec.last_update_login,
ATTRIBUTE_CATEGORY = l_def_rul_rec.attribute_category,
ATTRIBUTE1 = l_def_rul_rec.attribute1,
ATTRIBUTE2 = l_def_rul_rec.attribute2,
ATTRIBUTE3 = l_def_rul_rec.attribute3,
ATTRIBUTE4 = l_def_rul_rec.attribute4,
ATTRIBUTE5 = l_def_rul_rec.attribute5,
ATTRIBUTE6 = l_def_rul_rec.attribute6,
ATTRIBUTE7 = l_def_rul_rec.attribute7,
ATTRIBUTE8 = l_def_rul_rec.attribute8,
ATTRIBUTE9 = l_def_rul_rec.attribute9,
ATTRIBUTE10 = l_def_rul_rec.attribute10,
ATTRIBUTE11 = l_def_rul_rec.attribute11,
ATTRIBUTE12 = l_def_rul_rec.attribute12,
ATTRIBUTE13 = l_def_rul_rec.attribute13,
ATTRIBUTE14 = l_def_rul_rec.attribute14,
ATTRIBUTE15 = l_def_rul_rec.attribute15,
RULE_INFORMATION_CATEGORY = l_def_rul_rec.rule_information_category,
RULE_INFORMATION1 = l_def_rul_rec.rule_information1,
RULE_INFORMATION2 = l_def_rul_rec.rule_information2,
RULE_INFORMATION3 = l_def_rul_rec.rule_information3,
RULE_INFORMATION4 = l_def_rul_rec.rule_information4,
RULE_INFORMATION5 = l_def_rul_rec.rule_information5,
RULE_INFORMATION6 = l_def_rul_rec.rule_information6,
RULE_INFORMATION7 = l_def_rul_rec.rule_information7,
RULE_INFORMATION8 = l_def_rul_rec.rule_information8,
RULE_INFORMATION9 = l_def_rul_rec.rule_information9,
RULE_INFORMATION10 = l_def_rul_rec.rule_information10,
RULE_INFORMATION11 = l_def_rul_rec.rule_information11,
RULE_INFORMATION12 = l_def_rul_rec.rule_information12,
RULE_INFORMATION13 = l_def_rul_rec.rule_information13,
RULE_INFORMATION14 = l_def_rul_rec.rule_information14,
RULE_INFORMATION15 = l_def_rul_rec.rule_information15,
TEMPLATE_YN = l_def_rul_rec.template_yn,
ans_set_jtot_object_code = l_def_rul_rec.ans_set_jtot_object_code,
ans_set_jtot_object_id1 = l_def_rul_rec.ans_set_jtot_object_id1,
ans_set_jtot_object_id2 = l_def_rul_rec.ans_set_jtot_object_id2,
DISPLAY_SEQUENCE = l_def_rul_rec.display_sequence,
--Bug 3055393
comments = l_def_rul_rec.comments
WHERE ID = l_def_rul_rec.id;
END update_row;
PROCEDURE update_row(
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_okc_rules_tl_rec IN okc_rules_tl_rec_type,
x_okc_rules_tl_rec OUT NOCOPY okc_rules_tl_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
l_proc varchar2(72) := g_package||'update_row';
IF (x_okc_rules_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
THEN
x_okc_rules_tl_rec.last_updated_by := l_okc_rules_tl_rec.last_updated_by;
IF (x_okc_rules_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
THEN
x_okc_rules_tl_rec.last_update_date := l_okc_rules_tl_rec.last_update_date;
IF (x_okc_rules_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
THEN
x_okc_rules_tl_rec.last_update_login := l_okc_rules_tl_rec.last_update_login;
UPDATE OKC_RULES_TL
SET COMMENTS = l_def_okc_rules_tl_rec.comments,
TEXT = l_def_okc_rules_tl_rec.text,
CREATED_BY = l_def_okc_rules_tl_rec.created_by,
CREATION_DATE = l_def_okc_rules_tl_rec.creation_date,
LAST_UPDATED_BY = l_def_okc_rules_tl_rec.last_updated_by,
LAST_UPDATE_DATE = l_def_okc_rules_tl_rec.last_update_date,
LAST_UPDATE_LOGIN = l_def_okc_rules_tl_rec.last_update_login
WHERE ID = l_def_okc_rules_tl_rec.id
AND SOURCE_LANG = USERENV('LANG');
UPDATE OKC_RULES_TL
SET SFWT_FLAG = 'Y'
WHERE ID = l_def_okc_rules_tl_rec.id
AND SOURCE_LANG <> USERENV('LANG');
END update_row;
PROCEDURE update_row(
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_rulv_rec IN rulv_rec_type,
x_rulv_rec OUT NOCOPY rulv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
l_proc varchar2(72) := g_package||'update_row';
l_rulv_rec.LAST_UPDATE_DATE := SYSDATE;
l_rulv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
l_rulv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
IF (x_rulv_rec.last_updated_by = OKC_API.G_MISS_NUM)
THEN
x_rulv_rec.last_updated_by := l_rulv_rec.last_updated_by;
IF (x_rulv_rec.last_update_date = OKC_API.G_MISS_DATE)
THEN
x_rulv_rec.last_update_date := l_rulv_rec.last_update_date;
IF (x_rulv_rec.last_update_login = OKC_API.G_MISS_NUM)
THEN
x_rulv_rec.last_update_login := l_rulv_rec.last_update_login;
update_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_okc_rules_tl_rec,
lx_okc_rules_tl_rec
);
update_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_rul_rec,
lx_rul_rec
);
END update_row;
PROCEDURE update_row(
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_rulv_tbl IN rulv_tbl_type,
x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
l_proc varchar2(72) := g_package||'update_row';
update_row (
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_rulv_rec => p_rulv_tbl(i),
x_rulv_rec => x_rulv_tbl(i));
END update_row;
PROCEDURE delete_row(
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_rul_rec IN rul_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
l_proc varchar2(72) := g_package||'delete_row';
DELETE FROM OKC_RULES_B
WHERE ID = l_rul_rec.id;
END delete_row;
PROCEDURE delete_row(
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_okc_rules_tl_rec IN okc_rules_tl_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
l_proc varchar2(72) := g_package||'delete_row';
DELETE FROM OKC_RULES_TL
WHERE ID = l_okc_rules_tl_rec.id;
END delete_row;
PROCEDURE delete_row(
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_rulv_rec IN rulv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
l_proc varchar2(72) := g_package||'delete_row';
delete_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_okc_rules_tl_rec
);
delete_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_rul_rec
);
END delete_row;
PROCEDURE delete_row(
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_rulv_tbl IN rulv_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
l_proc varchar2(72) := g_package||'delete_row';
delete_row (
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_rulv_rec => p_rulv_tbl(i));
END delete_row;
PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_rulv_tbl rulv_tbl_type) IS
l_tabsize NUMBER := p_rulv_tbl.COUNT;
in_last_updated_by OKC_DATATYPES.NumberTabTyp;
in_last_update_date OKC_DATATYPES.DateTabTyp;
in_last_update_login OKC_DATATYPES.NumberTabTyp;
l_proc varchar2(72) := g_package||'INSERT_ROW_UPG';
in_last_updated_by (j) := p_rulv_tbl(i).last_updated_by;
in_last_update_date (j) := p_rulv_tbl(i).last_update_date;
in_last_update_login (j) := p_rulv_tbl(i).last_update_login;
INSERT
INTO OKC_RULES_B
(
id,
rgp_id,
object1_id1,
object2_id1,
object3_id1,
object1_id2,
object2_id2,
object3_id2,
jtot_object1_code,
jtot_object2_code,
jtot_object3_code,
dnz_chr_id,
std_template_yn,
warn_yn,
priority,
object_version_number,
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,
rule_information_category,
rule_information1,
rule_information2,
rule_information3,
rule_information4,
rule_information5,
rule_information6,
rule_information7,
rule_information8,
rule_information9,
rule_information10,
rule_information11,
rule_information12,
rule_information13,
rule_information14,
rule_information15,
template_yn,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
display_sequence,
--Bug 3055393
comments
)
VALUES (
in_id(i),
in_rgp_id(i),
in_object1_id1(i),
in_object2_id1(i),
in_object3_id1(i),
in_object1_id2(i),
in_object2_id2(i),
in_object3_id2(i),
in_jtot_object1_code(i),
in_jtot_object2_code(i),
in_jtot_object3_code(i),
in_dnz_chr_id(i),
in_std_template_yn(i),
in_warn_yn(i),
in_priority(i),
in_object_version_number(i),
in_created_by(i),
in_creation_date(i),
in_last_updated_by(i),
in_last_update_date(i),
in_last_update_login(i),
in_attribute_category(i),
in_attribute1(i),
in_attribute2(i),
in_attribute3(i),
in_attribute4(i),
in_attribute5(i),
in_attribute6(i),
in_attribute7(i),
in_attribute8(i),
in_attribute9(i),
in_attribute10(i),
in_attribute11(i),
in_attribute12(i),
in_attribute13(i),
in_attribute14(i),
in_attribute15(i),
in_rule_information_category(i),
in_rule_information1(i),
in_rule_information2(i),
in_rule_information3(i),
in_rule_information4(i),
in_rule_information5(i),
in_rule_information6(i),
in_rule_information7(i),
in_rule_information8(i),
in_rule_information9(i),
in_rule_information10(i),
in_rule_information11(i),
in_rule_information12(i),
in_rule_information13(i),
in_rule_information14(i),
in_rule_information15(i),
in_template_yn(i),
in_ans_set_jtot_object_code(i),
in_ans_set_jtot_object_id1(i),
in_ans_set_jtot_object_id2(i),
in_display_sequence(i),
--Bug 3055393
in_comments(i)
);
INSERT INTO OKC_RULES_TL(
id,
language,
source_lang,
sfwt_flag,
comments,
--text,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
VALUES (
in_id(i),
OKC_UTIL.g_language_code(lang_i),
l_source_lang,
in_sfwt_flag(i),
in_comments(i),
--in_text(i),
in_created_by(i),
in_creation_date(i),
in_last_updated_by(i),
in_last_update_date(i),
in_last_update_login(i)
);
END INSERT_ROW_UPG;
INSERT INTO okc_rules_bh
(
major_version,
id,
rgp_id,
object1_id1,
object2_id1,
object3_id1,
object1_id2,
object2_id2,
object3_id2,
jtot_object1_code,
jtot_object2_code,
jtot_object3_code,
dnz_chr_id,
std_template_yn,
warn_yn,
priority,
object_version_number,
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,
rule_information_category,
rule_information1,
rule_information2,
rule_information3,
rule_information4,
rule_information5,
rule_information6,
rule_information7,
rule_information8,
rule_information9,
rule_information10,
rule_information11,
rule_information12,
rule_information13,
rule_information14,
rule_information15,
template_yn,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
display_sequence,
--Bug 3055393
comments
)
SELECT
p_major_version,
id,
rgp_id,
object1_id1,
object2_id1,
object3_id1,
object1_id2,
object2_id2,
object3_id2,
jtot_object1_code,
jtot_object2_code,
jtot_object3_code,
dnz_chr_id,
std_template_yn,
warn_yn,
priority,
object_version_number,
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,
rule_information_category,
rule_information1,
rule_information2,
rule_information3,
rule_information4,
rule_information5,
rule_information6,
rule_information7,
rule_information8,
rule_information9,
rule_information10,
rule_information11,
rule_information12,
rule_information13,
rule_information14,
rule_information15,
template_yn,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
display_sequence,
--Bug 3055393
comments
FROM okc_rules_b
WHERE dnz_chr_id = p_chr_id;
INSERT INTO okc_rules_tlh
(
major_version,
id,
language,
source_lang,
sfwt_flag,
comments,
text,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
SELECT
p_major_version,
id,
language,
source_lang,
sfwt_flag,
comments,
text,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
FROM okc_rules_tl
WHERE id in (select id
from okc_rules_b
where dnz_chr_id = p_chr_id);
INSERT INTO okc_rules_tl
(
id,
language,
source_lang,
sfwt_flag,
comments,
text,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
SELECT
id,
language,
source_lang,
sfwt_flag,
comments,
text,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
FROM okc_rules_tlh
WHERE id in (SELECT id
FROM okc_rules_bh
WHERE dnz_chr_id = p_chr_id)
AND major_version = p_major_version;
INSERT INTO okc_rules_b
(
id,
rgp_id,
object1_id1,
object2_id1,
object3_id1,
object1_id2,
object2_id2,
object3_id2,
jtot_object1_code,
jtot_object2_code,
jtot_object3_code,
dnz_chr_id,
std_template_yn,
warn_yn,
priority,
object_version_number,
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,
rule_information_category,
rule_information1,
rule_information2,
rule_information3,
rule_information4,
rule_information5,
rule_information6,
rule_information7,
rule_information8,
rule_information9,
rule_information10,
rule_information11,
rule_information12,
rule_information13,
rule_information14,
rule_information15,
template_yn,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
display_sequence,
comments
)
SELECT
id,
rgp_id,
object1_id1,
object2_id1,
object3_id1,
object1_id2,
object2_id2,
object3_id2,
jtot_object1_code,
jtot_object2_code,
jtot_object3_code,
dnz_chr_id,
std_template_yn,
warn_yn,
priority,
object_version_number,
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,
rule_information_category,
rule_information1,
rule_information2,
rule_information3,
rule_information4,
rule_information5,
rule_information6,
rule_information7,
rule_information8,
rule_information9,
rule_information10,
rule_information11,
rule_information12,
rule_information13,
rule_information14,
rule_information15,
template_yn,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
display_sequence,
--Bug 3055393
comments
FROM okc_rules_bh
WHERE dnz_chr_id = p_chr_id
AND major_version = p_major_version;
SELECT 'Y'
FROM okc_ddf_contextcode_tmp
WHERE descriptive_flex_context_code = p_context_code;
INSERT INTO okc_ddf_contextcode_tmp
(descriptive_flex_context_code, end_user_column_name, flex_value_set_id,
required_flag, application_column_name, seq_no, form_left_prompt)
SELECT
descriptive_flex_context_code,
end_user_column_name,
flex_value_set_id,
required_flag,
application_column_name,
SUBSTR(application_column_name,17,2) seq_no,
form_left_prompt
FROM fnd_descr_flex_col_usage_vl dfcu
-- WHERE dfcu.descriptive_flexfield_name = l_desc_ff_name -- /striping/
WHERE dfcu.descriptive_flexfield_name = p_dff_name
AND application_column_name like l_app_col_name
-- AND dfcu.application_id =510 -- /striping/
AND dfcu.application_id = p_appl_id
AND dfcu.descriptive_flex_context_code IN
(
SELECT /*+ NO_UNNEST */ rdf_code
FROM OKC_K_HEADERS_B K ,
okc_subclass_rg_defs B,
okc_rg_def_rules A
WHERE A.rgd_code = B.rgd_code
AND B.scs_code = K.scs_code
AND k.id = p_rulv_rec.dnz_chr_id
)
AND NOT EXISTS
(SELECT 1 FROM okc_ddf_contextcode_tmp
WHERE descriptive_flex_context_code =
dfcu.descriptive_flex_context_code
AND application_column_name =
dfcu.application_column_name);
SELECT 'Y'
FROM okc_obj_ddf_ctxcode_tmp
WHERE descriptive_flex_context_code = p_context_code;
INSERT INTO okc_obj_ddf_ctxcode_tmp
(descriptive_flex_context_code, dummy_col, seq_no, form_left_prompt)
SELECT
descriptive_flex_context_code ,
'x',
SUBSTR(application_column_name,12,1) seq_no ,
form_left_prompt
FROM fnd_descr_flex_col_usage_vl dfcu
-- WHERE dfcu.descriptive_flexfield_name = l_desc_ff_name -- /striping/
WHERE dfcu.descriptive_flexfield_name = p_dff_name
AND application_column_name like l_app_col_name
-- AND dfcu.application_id =510 -- /striping/
AND dfcu.application_id = p_appl_id
AND dfcu.descriptive_flex_context_code IN
(
SELECT /*+ NO_UNNEST */ rdf_code
FROM OKC_K_HEADERS_B K ,
okc_subclass_rg_defs B,
okc_rg_def_rules A
WHERE A.rgd_code = B.rgd_code
AND B.scs_code = K.scs_code
AND k.id = p_rulv_rec.dnz_chr_id
)
AND NOT EXISTS
(SELECT 1 FROM okc_obj_ddf_ctxcode_tmp
WHERE descriptive_flex_context_code =
dfcu.descriptive_flex_context_code
AND seq_no = SUBSTR(application_column_name,12,1));