APPS.OKE_K_USER_ATTRIBUTES_PUB dependencies on OKE_K_USER_ATTRIBUTES

Line 1: PACKAGE BODY oke_k_user_attributes_pub AS

1: PACKAGE BODY oke_k_user_attributes_pub AS
2: /* $Header: OKEPUATB.pls 120.0.12020000.2 2013/02/22 06:55:15 ansraj noship $ */
3: g_api_type CONSTANT VARCHAR2 (4) := '_PUB';
4: -- GLOBAL MESSAGE CONSTANTS
5: g_fnd_app CONSTANT VARCHAR2 (200)

Line 64: AND (descriptive_flexfield_name LIKE 'OKE_K_USER_ATTRIBUTES')

60: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
61: enabled_flag, global_flag -- Global_flag is not null
62: FROM fnd_descr_flex_contexts_vl
63: WHERE (application_id = 777)
64: AND (descriptive_flexfield_name LIKE 'OKE_K_USER_ATTRIBUTES')
65: AND enabled_flag = 'Y' --enabled_flag is not null
66: ORDER BY DECODE (global_flag, 'Y', 1, 2), descriptive_flex_context_code;
67:
68: CURSOR cur_desc_context_col_usg (p_desc_flex_ctx_code VARCHAR2)

Line 75: AND (descriptive_flexfield_name LIKE 'OKE_K_USER_ATTRIBUTES')

71: DEFAULT_VALUE, required_flag, form_left_prompt,
72: flex_value_set_id
73: FROM fnd_descr_flex_col_usage_vl
74: WHERE (application_id = 777)
75: AND (descriptive_flexfield_name LIKE 'OKE_K_USER_ATTRIBUTES')
76: AND (descriptive_flex_context_code = p_desc_flex_ctx_code)
77: AND enabled_flag = 'Y';
78:
79: FUNCTION get_attribute_value (

Line 573: FROM oke_k_user_attributes

569: IS
570: CURSOR c_exists
571: IS
572: SELECT 'x'
573: FROM oke_k_user_attributes
574: WHERE k_header_id = p_k_header_id
575: AND ( k_line_id = p_k_line_id
576: OR (k_line_id IS NULL AND p_k_line_id IS NULL)
577: )

Line 1063: INSERT INTO oke_k_user_attributes

1059: );
1060:
1061: -- BY now we would have checked for mandatory fields are populated or not
1062: -- We validate all referencial checks in the validate record.
1063: INSERT INTO oke_k_user_attributes
1064: (k_user_attribute_id,
1065: creation_date,
1066: created_by,
1067: last_update_date,

Line 1105: VALUES (oke_k_user_attributes_s.NEXTVAL,

1101: user_attribute28,
1102: user_attribute29,
1103: user_attribute30
1104: )
1105: VALUES (oke_k_user_attributes_s.NEXTVAL,
1106: x_k_user_attributes_rec.creation_date,
1107: x_k_user_attributes_rec.created_by,
1108: x_k_user_attributes_rec.last_update_date,
1109: x_k_user_attributes_rec.last_updated_by,

Line 1219: l_db_rec oke_k_user_attributes%ROWTYPE;

1215: p_k_user_attribute_id IN NUMBER,
1216: x_k_user_attributes_rec OUT NOCOPY k_user_attributes_rec_type
1217: )
1218: IS
1219: l_db_rec oke_k_user_attributes%ROWTYPE;
1220: BEGIN
1221: BEGIN
1222: SELECT *
1223: INTO l_db_rec

Line 1224: FROM oke_k_user_attributes

1220: BEGIN
1221: BEGIN
1222: SELECT *
1223: INTO l_db_rec
1224: FROM oke_k_user_attributes
1225: WHERE k_user_attribute_id = p_k_user_attribute_id;
1226: EXCEPTION
1227: WHEN NO_DATA_FOUND
1228: THEN

Line 1626: UPDATE oke_k_user_attributes

1622: x_k_user_attributes_rec.last_updated_by := fnd_global.user_id;
1623: x_k_user_attributes_rec.last_update_login := fnd_global.login_id;
1624:
1625: -- Do update.
1626: UPDATE oke_k_user_attributes
1627: SET last_update_date = x_k_user_attributes_rec.last_update_date,
1628: last_updated_by = x_k_user_attributes_rec.last_updated_by,
1629: last_update_login = x_k_user_attributes_rec.last_update_login,
1630: record_version_number =

Line 1741: END oke_k_user_attributes_pub;

1737: (context_col_usg_rec.end_user_column_name).flex_value_set_id :=
1738: context_col_usg_rec.flex_value_set_id;
1739: END LOOP;
1740: END LOOP;
1741: END oke_k_user_attributes_pub;