[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_form_record_deleted CONSTANT VARCHAR2 (200)
:= oke_api.g_form_record_deleted;
g_record_logically_deleted CONSTANT VARCHAR2 (200)
:= oke_api.g_record_logically_deleted;
SELECT descriptive_flex_context_code, descriptive_flex_context_name,
enabled_flag, global_flag -- Global_flag is not null
FROM fnd_descr_flex_contexts_vl
WHERE (application_id = 777)
AND (descriptive_flexfield_name LIKE 'OKE_K_USER_ATTRIBUTES')
AND enabled_flag = 'Y' --enabled_flag is not null
ORDER BY DECODE (global_flag, 'Y', 1, 2), descriptive_flex_context_code;
SELECT end_user_column_name, enabled_flag, application_column_name,
DEFAULT_VALUE, required_flag, form_left_prompt,
flex_value_set_id
FROM fnd_descr_flex_col_usage_vl
WHERE (application_id = 777)
AND (descriptive_flexfield_name LIKE 'OKE_K_USER_ATTRIBUTES')
AND (descriptive_flex_context_code = p_desc_flex_ctx_code)
AND enabled_flag = 'Y';
SELECT validation_type
FROM fnd_flex_value_sets
WHERE flex_value_set_id = p_flex_value_set_id;
SELECT VALUE.flex_value
--,value.description
FROM fnd_flex_values_vl VALUE
WHERE VALUE.flex_value_set_id = p_flex_value_set_id
AND enabled_flag = 'Y'
AND TRUNC (SYSDATE) BETWEEN NVL (TRUNC (start_date_active),
TRUNC (SYSDATE)
)
AND NVL (TRUNC (end_date_active),
TRUNC (SYSDATE)
)
AND VALUE.flex_value = p_attr_value;
SELECT val_tab.application_table_name, val_tab.value_column_name,
val_tab.id_column_name, val_tab.additional_where_clause,
val_tab.meaning_column_name
FROM fnd_flex_validation_tables val_tab
WHERE val_tab.flex_value_set_id = p_flex_value_set_id;
l_select_stmt VARCHAR2 (2000);
l_select_stmt :=
' SELECT '
|| NVL (c2rec.id_column_name, NULL)
|| ' as Flex_value_id,'
|| NVL (c2rec.value_column_name, 'null')
|| ' as Flex_value,'
|| NVL (c2rec.meaning_column_name, 'null')
|| ' as Flex_meaning FROM '
|| c2rec.application_table_name;
l_select_stmt := l_select_stmt || ' WHERE';
l_select_stmt :=
l_select_stmt || ' ' || c2rec.additional_where_clause;
l_select_stmt :=
'SELECT FLEX_VALUE FROM ('
|| l_select_stmt
|| ') WHERE FLEX_VALUE_ID = :1';
DBMS_SQL.parse (value_cursor_id, l_select_stmt, DBMS_SQL.native);
SELECT 'X'
FROM okc_k_headers_all_b c, oke_k_headers e
WHERE e.k_header_id = p_k_header_id AND e.k_header_id = c.ID;
SELECT 'X'
FROM okc_k_lines_b c, oke_k_lines e
WHERE e.k_line_id = p_k_line_id
AND c.dnz_chr_id = p_k_header_id
AND e.k_line_id = c.ID;
SELECT 'x'
FROM oke_k_user_attributes
WHERE k_header_id = p_k_header_id
AND ( k_line_id = p_k_line_id
OR (k_line_id IS NULL AND p_k_line_id IS NULL)
)
AND user_attribute_context = p_context;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE ID = p_line_id;
x_k_user_attributes_rec.last_update_date := SYSDATE;
x_k_user_attributes_rec.last_updated_by := fnd_global.user_id;
x_k_user_attributes_rec.last_update_login := fnd_global.login_id;
INSERT INTO oke_k_user_attributes
(k_user_attribute_id,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
record_version_number,
k_header_id,
k_line_id,
user_attribute_context,
user_attribute01,
user_attribute02,
user_attribute03,
user_attribute04,
user_attribute05,
user_attribute06,
user_attribute07,
user_attribute08,
user_attribute09,
user_attribute10,
user_attribute11,
user_attribute12,
user_attribute13,
user_attribute14,
user_attribute15,
user_attribute16,
user_attribute17,
user_attribute18,
user_attribute19,
user_attribute20,
user_attribute21,
user_attribute22,
user_attribute23,
user_attribute24,
user_attribute25,
user_attribute26,
user_attribute27,
user_attribute28,
user_attribute29,
user_attribute30
)
VALUES (oke_k_user_attributes_s.NEXTVAL,
x_k_user_attributes_rec.creation_date,
x_k_user_attributes_rec.created_by,
x_k_user_attributes_rec.last_update_date,
x_k_user_attributes_rec.last_updated_by,
x_k_user_attributes_rec.last_update_login,
x_k_user_attributes_rec.record_version_number,
x_k_user_attributes_rec.k_header_id,
x_k_user_attributes_rec.k_line_id,
x_k_user_attributes_rec.user_attribute_context,
x_k_user_attributes_rec.user_attribute01,
x_k_user_attributes_rec.user_attribute02,
x_k_user_attributes_rec.user_attribute03,
x_k_user_attributes_rec.user_attribute04,
x_k_user_attributes_rec.user_attribute05,
x_k_user_attributes_rec.user_attribute06,
x_k_user_attributes_rec.user_attribute07,
x_k_user_attributes_rec.user_attribute08,
x_k_user_attributes_rec.user_attribute09,
x_k_user_attributes_rec.user_attribute10,
x_k_user_attributes_rec.user_attribute11,
x_k_user_attributes_rec.user_attribute12,
x_k_user_attributes_rec.user_attribute13,
x_k_user_attributes_rec.user_attribute14,
x_k_user_attributes_rec.user_attribute15,
x_k_user_attributes_rec.user_attribute16,
x_k_user_attributes_rec.user_attribute17,
x_k_user_attributes_rec.user_attribute18,
x_k_user_attributes_rec.user_attribute19,
x_k_user_attributes_rec.user_attribute20,
x_k_user_attributes_rec.user_attribute21,
x_k_user_attributes_rec.user_attribute22,
x_k_user_attributes_rec.user_attribute23,
x_k_user_attributes_rec.user_attribute24,
x_k_user_attributes_rec.user_attribute25,
x_k_user_attributes_rec.user_attribute26,
x_k_user_attributes_rec.user_attribute27,
x_k_user_attributes_rec.user_attribute28,
x_k_user_attributes_rec.user_attribute29,
x_k_user_attributes_rec.user_attribute30
)
RETURNING k_user_attribute_id
INTO x_k_user_attributes_rec.k_user_attribute_id;
PROCEDURE update_k_user_attributes (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2
DEFAULT oke_api.g_false,
p_k_user_attributes_rec IN k_user_attributes_rec_type,
x_k_user_attributes_rec OUT NOCOPY k_user_attributes_rec_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_K_USER_ATTRIBUTES';
SELECT *
INTO l_db_rec
FROM oke_k_user_attributes
WHERE k_user_attribute_id = p_k_user_attribute_id;
x_k_user_attributes_rec.last_update_date := SYSDATE;
x_k_user_attributes_rec.last_updated_by := fnd_global.user_id;
x_k_user_attributes_rec.last_update_login := fnd_global.login_id;
UPDATE oke_k_user_attributes
SET last_update_date = x_k_user_attributes_rec.last_update_date,
last_updated_by = x_k_user_attributes_rec.last_updated_by,
last_update_login = x_k_user_attributes_rec.last_update_login,
record_version_number =
x_k_user_attributes_rec.record_version_number,
user_attribute_context =
x_k_user_attributes_rec.user_attribute_context,
user_attribute01 = x_k_user_attributes_rec.user_attribute01,
user_attribute02 = x_k_user_attributes_rec.user_attribute02,
user_attribute03 = x_k_user_attributes_rec.user_attribute03,
user_attribute04 = x_k_user_attributes_rec.user_attribute04,
user_attribute05 = x_k_user_attributes_rec.user_attribute05,
user_attribute06 = x_k_user_attributes_rec.user_attribute06,
user_attribute07 = x_k_user_attributes_rec.user_attribute07,
user_attribute08 = x_k_user_attributes_rec.user_attribute08,
user_attribute09 = x_k_user_attributes_rec.user_attribute09,
user_attribute10 = x_k_user_attributes_rec.user_attribute10,
user_attribute11 = x_k_user_attributes_rec.user_attribute11,
user_attribute12 = x_k_user_attributes_rec.user_attribute12,
user_attribute13 = x_k_user_attributes_rec.user_attribute13,
user_attribute14 = x_k_user_attributes_rec.user_attribute14,
user_attribute15 = x_k_user_attributes_rec.user_attribute15,
user_attribute16 = x_k_user_attributes_rec.user_attribute16,
user_attribute17 = x_k_user_attributes_rec.user_attribute17,
user_attribute18 = x_k_user_attributes_rec.user_attribute18,
user_attribute19 = x_k_user_attributes_rec.user_attribute19,
user_attribute20 = x_k_user_attributes_rec.user_attribute20,
user_attribute21 = x_k_user_attributes_rec.user_attribute21,
user_attribute22 = x_k_user_attributes_rec.user_attribute22,
user_attribute23 = x_k_user_attributes_rec.user_attribute23,
user_attribute24 = x_k_user_attributes_rec.user_attribute24,
user_attribute25 = x_k_user_attributes_rec.user_attribute25,
user_attribute26 = x_k_user_attributes_rec.user_attribute26,
user_attribute27 = x_k_user_attributes_rec.user_attribute27,
user_attribute28 = x_k_user_attributes_rec.user_attribute28,
user_attribute29 = x_k_user_attributes_rec.user_attribute29,
user_attribute30 = x_k_user_attributes_rec.user_attribute30
WHERE k_user_attribute_id = x_k_user_attributes_rec.k_user_attribute_id;
END update_k_user_attributes;