The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT OBJECT_ID
INTO l_object_id
FROM FND_OBJECTS
WHERE OBJ_NAME = p_object_name;
SELECT FUNCTION_ID
INTO l_function_id
FROM EGO_FUNCTIONS_B
WHERE INTERNAL_NAME = p_function_name;
SELECT ATTR_GROUP_ID
INTO l_attr_grp_id
FROM EGO_FND_DSC_FLX_CTX_EXT
WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_grp_internal_name
AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_grp_type;
SELECT ACTION_ID
INTO l_action_id
FROM EGO_ACTIONS_B
WHERE ACTION_NAME = p_action_name
AND ATTR_GROUP_ID = l_attr_grp_id
AND CLASSIFICATION_CODE = p_classification_code || '';
UPDATE EGO_ACTIONS_B
SET SEQUENCE = p_sequence
WHERE ACTION_ID = l_action_id;
SELECT ACTION_ID
INTO l_action_id
FROM EGO_ACTIONS_TL
WHERE ACTION_ID = l_action_id
AND LANGUAGE = USERENV('LANG');
UPDATE EGO_ACTIONS_TL
SET DESCRIPTION = p_description
WHERE ACTION_ID = l_action_id
AND LANGUAGE = USERENV('LANG');
INSERT INTO EGO_ACTIONS_TL
(
ACTION_ID,
DESCRIPTION,
LANGUAGE,
SOURCE_LANG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
)
SELECT
l_action_id,
p_description,
L.LANGUAGE_CODE,
USERENV('LANG'),
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
0
FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG in ('I', 'B')
AND NOT EXISTS
( SELECT NULL
FROM EGO_ACTIONS_TL T
WHERE T.ACTION_ID =l_action_id
AND T.LANGUAGE = L.LANGUAGE_CODE
);
SELECT EGO_ACTIONS_S.nextval
INTO l_action_id
FROM DUAL
WHERE ROWNUM = 1;
INSERT INTO EGO_ACTIONS_B
(
ACTION_ID,
OBJECT_ID,
CLASSIFICATION_CODE,
ATTR_GROUP_ID,
SEQUENCE,
ACTION_NAME,
FUNCTION_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
)
VALUES
(
l_action_id,
l_object_id,
p_classification_code || '',
l_attr_grp_id,
p_sequence,
p_action_name,
l_function_id,
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
0
);
INSERT INTO EGO_ACTIONS_TL
(
ACTION_ID,
DESCRIPTION,
LANGUAGE,
SOURCE_LANG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
)
SELECT
l_action_id,
p_description,
L.LANGUAGE_CODE,
USERENV('LANG'),
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
0
FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG in ('I', 'B')
AND NOT EXISTS
( SELECT NULL
FROM EGO_ACTIONS_TL T
WHERE T.ACTION_ID =l_action_id
AND T.LANGUAGE = L.LANGUAGE_CODE
);
SELECT OBJECT_ID
INTO l_object_id
FROM FND_OBJECTS
WHERE OBJ_NAME = p_object_name;
SELECT FUNCTION_ID
INTO l_function_id
FROM EGO_FUNCTIONS_B
WHERE INTERNAL_NAME = p_function_name;
SELECT ATTR_GROUP_ID
INTO l_attr_grp_id
FROM EGO_FND_DSC_FLX_CTX_EXT
WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_grp_internal_name
AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_grp_type;
SELECT ACTION_ID
INTO l_action_id
FROM EGO_ACTIONS_B
WHERE ACTION_NAME = p_action_name
AND ATTR_GROUP_ID = l_attr_grp_id
AND CLASSIFICATION_CODE = p_classification_code || '';
UPDATE EGO_ACTIONS_TL
SET DESCRIPTION = p_description,
SOURCE_LANG = USERENV('LANG'),
LAST_UPDATE_DATE = SYSDATE,
LAST_UPDATED_BY = DECODE(p_owner, 'SEED', 1, 0),
LAST_UPDATE_LOGIN = 0
WHERE ACTION_ID = l_action_id
AND LANGUAGE = USERENV('LANG');
SELECT DATA_LEVEL_ID
INTO l_data_level_id
FROM EGO_DATA_LEVEL_B
WHERE DATA_LEVEL_NAME = p_data_level;
SELECT ATTR_GROUP_ID
INTO l_attr_grp_id
FROM EGO_FND_DSC_FLX_CTX_EXT
WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_grp_internal_name
AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_grp_type;
SELECT ACTION_ID
INTO l_action_id
FROM EGO_ACTIONS_B
WHERE ACTION_NAME = p_action_name
AND ATTR_GROUP_ID = l_attr_grp_id
AND CLASSIFICATION_CODE = p_classification_code || ''
AND ROWNUM = 1;
SELECT VISIBILITY_FLAG
INTO l_visibility_flag
FROM EGO_ACTIONS_DL
WHERE ACTION_ID = l_action_id
AND DATA_LEVEL_ID = l_data_level_id;
UPDATE EGO_ACTIONS_DL
SET VISIBILITY_FLAG = p_visibility_flag
WHERE ACTION_ID = l_action_id
AND DATA_LEVEL_ID = l_data_level_id;
INSERT INTO EGO_ACTIONS_DL
(
ACTION_ID,
DATA_LEVEL_ID,
VISIBILITY_FLAG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
)
VALUES
(
l_action_id,
l_data_level_id,
p_visibility_flag,
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
0
);
l_update_login NUMBER;
SELECT APPLICATION_ID
INTO l_app_id
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = p_app_short_name;
SELECT ATTR_GROUP_ID
INTO l_attr_grp_id
FROM EGO_FND_DSC_FLX_CTX_EXT
WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_grp_internal_name
AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_grp_type;
SELECT ACTION_ID
INTO l_action_id
FROM EGO_ACTIONS_B
WHERE ACTION_NAME = p_action_name
AND ATTR_GROUP_ID = l_attr_grp_id
AND CLASSIFICATION_CODE = p_classification_code || ''
AND ROWNUM = 1;
SELECT LAST_UPDATE_LOGIN
INTO l_update_login
FROM EGO_ACTION_DISPLAYS_B
WHERE ACTION_ID = l_action_id;
UPDATE EGO_ACTION_DISPLAYS_B
SET EXECUTION_METHOD = p_exec_method,
EXECUTION_TRIGGER = p_exec_trigger,
DISPLAY_STYLE = p_display_style,
PROMPT_APPLICATION_ID = l_app_id,
PROMPT_MESSAGE_NAME = p_prompt_message_name,
VISIBILITY_FLAG = p_visibility_flag
WHERE ACTION_ID = l_action_id;
INSERT INTO EGO_ACTION_DISPLAYS_B
(
ACTION_ID,
EXECUTION_METHOD,
EXECUTION_TRIGGER,
DISPLAY_STYLE,
PROMPT_APPLICATION_ID,
PROMPT_MESSAGE_NAME,
VISIBILITY_FLAG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
)
VALUES
(
l_action_id,
p_exec_method,
p_exec_trigger,
p_display_style,
l_app_id,
p_prompt_message_name,
p_visibility_flag,
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
0
);
SELECT FUNCTION_ID
INTO l_function_id
FROM EGO_FUNCTIONS_B
WHERE INTERNAL_NAME = p_function_name;
SELECT ATTR_GROUP_ID
INTO l_attr_grp_id
FROM EGO_FND_DSC_FLX_CTX_EXT
WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_grp_internal_name
AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_grp_type;
SELECT ACTION_ID
INTO l_action_id
FROM EGO_ACTIONS_B
WHERE ACTION_NAME = p_action_name
AND ATTR_GROUP_ID = l_attr_grp_id
AND CLASSIFICATION_CODE = p_classification_code || ''
AND ROWNUM = 1;
SELECT FUNC_PARAM_ID
INTO l_param_id
FROM EGO_FUNC_PARAMS_B
WHERE INTERNAL_NAME = p_map_par_int_name
AND FUNCTION_ID = l_function_id;
SELECT APPLICATION_ID
INTO l_app_id
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = p_map_app_short_name;
SELECT MAPPED_TO_GROUP_PK2, MAPPED_TO_GROUP_PK3, MAPPED_ATTRIBUTE
INTO l_pk2, l_pk3, l_map_attr
FROM EGO_MAPPINGS_B
WHERE FUNCTION_ID = l_function_id
AND MAPPED_OBJ_PK1_VAL = l_action_id
AND FUNC_PARAM_ID = l_param_id
AND MAPPED_OBJ_TYPE = p_map_obj_type
AND MAPPED_TO_GROUP_TYPE = p_map_to_grp_type
AND NVL(MAPPED_TO_GROUP_PK2, '-1') = NVL(p_map_ext_attrs, '-1')
AND NVL(MAPPED_TO_GROUP_PK3, '-1') = NVL(p_map_context, '-1')
AND MAPPED_ATTRIBUTE = p_map_attr;
INSERT INTO EGO_MAPPINGS_B
(
FUNCTION_ID,
MAPPED_OBJ_TYPE,
MAPPED_OBJ_PK1_VAL,
FUNC_PARAM_ID,
MAPPED_TO_GROUP_TYPE,
MAPPED_TO_GROUP_PK1,
MAPPED_TO_GROUP_PK2,
MAPPED_TO_GROUP_PK3,
MAPPED_ATTRIBUTE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
)
VALUES
(
l_function_id,
p_map_obj_type,
l_action_id,
l_param_id,
p_map_to_grp_type,
l_app_id,
p_map_ext_attrs,
p_map_context,
p_map_attr,
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
DECODE(p_owner, 'SEED', 1, 0),
SYSDATE,
0
);
SELECT data_level, attr_group_id, enabled_flag, view_privilege_id, edit_privilege_id
FROM EGO_OBJ_AG_ASSOCS_B assoc
WHERE assoc.OBJECT_ID = p_object_id
AND assoc.CLASSIFICATION_CODE = p_src_template_code;
SELECT EGO_ASSOCS_S.NEXTVAL
FROM dual;
SELECT action_id FROM ego_actions_b
WHERE ATTR_GROUP_ID = p_attr_group_id
AND classification_code = p_src_template_code
AND OBJECT_ID = p_object_id;
SELECT b.OBJECT_ID, b.CLASSIFICATION_CODE, b.SEQUENCE, b.ACTION_NAME, b.FUNCTION_ID,b.SECURITY_PRIVILEGE_ID, b.ENABLE_KEY_ATTRIBUTES, tl.DESCRIPTION
FROM EGO_ACTIONS_tl tl, EGO_ACTIONS_B b
WHERE b.action_id = p_action_id AND b.action_id = tl.action_id AND tl.LANGUAGE = userenv('LANG');
SELECT ACTION_ID, EXECUTION_METHOD, DISPLAY_STYLE, PROMPT_APPLICATION_ID, PROMPT_MESSAGE_NAME, VISIBILITY_FLAG, PROMPT_FUNCTION_ID, VISIBILITY_FUNC_ID
FROM EGO_ACTION_DISPLAYS_B
WHERE ACTION_ID = p_action_id;
SELECT FUNCTION_ID, MAPPED_OBJ_TYPE, MAPPED_OBJ_PK1_VAL, FUNC_PARAM_ID, MAPPED_TO_GROUP_TYPE, MAPPED_TO_GROUP_PK1, MAPPED_TO_GROUP_PK2,
MAPPED_TO_GROUP_PK3, MAPPED_ATTRIBUTE, MAPPED_UOM_PARAMETER, VALUE_UOM_SOURCE, FIXED_UOM
FROM EGO_MAPPINGS_B
WHERE function_id = p_function_id
AND MAPPED_OBJ_PK1_VAL = p_action_id;
SELECT page_id, DATA_LEVEL_INT_NAME, internal_name,
display_name, SEQUENCE, description
FROM EGO_PAGES_V pages
WHERE pages.CLASSIFICATION_CODE = p_src_template_code
AND pages.object_id = p_object_id;
SELECT entries_view.association_id , entries_view.SEQUENCE, assoc.attr_group_id
FROM EGO_PAGE_ENTRIES_V entries_view, EGO_OBJ_AG_ASSOCS_B assoc
WHERE entries_view.OBJECT_ID = p_object_id
AND entries_view.CLASSIFICATION_CODE = p_src_template_code
AND assoc.association_id = entries_view.association_id
AND entries_view. page_id = p_page_id;
SELECT association_id INTO l_association_id
FROM EGO_OBJ_AG_ASSOCS_B assoc
WHERE assoc.OBJECT_ID = p_object_id
AND assoc.CLASSIFICATION_CODE = p_new_template_code
AND assoc.ATTR_GROUP_ID = c_get_page_entries_csr_rec.attr_group_id;
SELECT object_id
FROM FND_OBJECTS fo , okc_uda_templates_vl outv
WHERE fo.OBJ_NAME = decode(outv.template_category, 'CONTRACT', 'OKC_REP_CONTRACTS_UDA',
'DELIVERABLE', 'OKC_DELIVERABLE')
and outv.uda_template_id = p_src_uda_temp_id;
INSERT INTO OKC_UDA_DELIVERABLE_USAGES (DEL_USAGE_ID
,UDA_TEMPLATE_ID
,DEL_TYPE_CODE
,ATTR_GROUP_ID
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,OBJECT_VERSION_NUMBER
,SEQUENCE_NUM
) SELECT OKC_UDA_DEL_USAGES_S1.NEXTVAL
,p_new_uda_temp_id
,DEL_TYPE_CODE
,ATTR_GROUP_ID
,CREATED_BY
,sysdate
,LAST_UPDATED_BY
,sysdate
,LAST_UPDATE_LOGIN
,OBJECT_VERSION_NUMBER
,SEQUENCE_NUM
FROM OKC_UDA_DELIVERABLE_USAGES
WHERE UDA_TEMPLATE_ID = p_src_uda_temp_id;
SELECT Decode (Nvl(status_flag, 'N') , 'F', 'Y', 'N')
INTO l_status_flag
FROM okc_uda_templates_all
WHERE uda_template_id = p_uda_template_id;
PROCEDURE delete_temp_details(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_uda_temp_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_name VARCHAR2(50);
SELECT object_id
FROM FND_OBJECTS fo , okc_uda_templates_vl outv
WHERE fo.OBJ_NAME = decode(outv.template_category, 'CONTRACT', 'OKC_REP_CONTRACTS_UDA',
'DELIVERABLE', 'OKC_DELIVERABLE')
and outv.uda_template_id = p_uda_temp_id;
SELECT page_id
FROM EGO_PAGES_B epb
WHERE CLASSIFICATION_CODE = p_uda_temp_id
AND OBJECT_ID = p_object_id;
select ASSOCIATION_ID from EGO_OBJ_AG_ASSOCS_B
where object_id = p_object_id
and classification_code = p_uda_temp_id;
SELECT action_id, function_id FROM EGO_ACTIONS_B
WHERE object_id = p_object_id
AND classification_code = p_uda_temp_id;
l_api_name := 'delete_temp_details';
'100: Entered OKC_UDA_TEMPLATES_UTIL.delete_temp_uda_details');
DELETE FROM OKC_UDA_DELIVERABLE_USAGES
WHERE uda_template_id = p_uda_temp_id;
EGO_EXT_FWK_PUB.DELETE_PAGE
(
p_api_version => 1.0
,p_page_id => c_pages_rec.page_id
,p_init_msg_list => fnd_api.g_FALSE
,p_commit => fnd_api.g_FALSE
,x_return_status => x_return_status
,x_errorcode => l_errorcode
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
'EGO_EXT_FWK_PUB.DELETE_PAGE return status is: '
|| x_return_status);
ego_ext_fwk_pub.Delete_Association(
p_api_version => 1.0, -- IN NUMBER
p_association_id => association_ids_rec.association_id, -- IN NUMBER
p_init_msg_list => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
p_commit => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
p_force => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
x_return_status => x_return_status, -- OUT NOCOPY VARCHAR2
x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
x_msg_data => x_msg_data); -- OUT NOCOPY VARCHAR2
' ego_ext_fwk_pub.Delete_Association return status is: '
|| x_return_status);
ego_ext_fwk_pub.Delete_Action (
p_api_version => 1.0
,p_action_id => c_get_action_id_rec.action_id
,p_init_msg_list => fnd_api.g_FALSE
,p_commit => fnd_api.g_FALSE
,x_return_status => x_return_status
,x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
x_msg_data => x_msg_data);
' ego_ext_fwk_pub.Delete_Action return status is: '
|| x_return_status);
ego_ext_fwk_pub.Delete_Action_Display (
p_api_version => 1.0
,p_action_id => c_get_action_id_rec.action_id
,p_init_msg_list => fnd_api.g_FALSE
,p_commit => fnd_api.g_FALSE
,x_return_status => x_return_status
,x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
x_msg_data => x_msg_data);
' ego_ext_fwk_pub.Delete_Action_Display return status is: '
|| x_return_status);
ego_ext_fwk_pub.Delete_Func_Mapping (
p_api_version => 1.0
,p_function_id => c_get_action_id_rec.function_id
,p_mapped_obj_type => 'A' -- hardcoded to 'A'
,p_mapped_obj_pk1_value => c_get_action_id_rec.action_id
,p_init_msg_list => fnd_api.g_FALSE
,p_commit => fnd_api.g_FALSE
,x_return_status => x_return_status
,x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
x_msg_data => x_msg_data);
' ego_ext_fwk_pub.Delete_Action_Display return status is: '
|| x_return_status);
'Leaving delete_temp_details: FND_API.G_EXC_ERROR Exception');
'Leaving delete_temp_details: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
'Leaving delete_temp_details because of EXCEPTION: ' || sqlerrm);
END delete_temp_details;