The following lines contain the word 'select', 'insert', 'update' or 'delete':
update IEU_UWQ_SVR_MPS_MMAPS b
set b.LAST_UPDATED_BY = user_id,
b.LAST_UPDATE_DATE = SYSDATE,
b.LAST_UPDATE_LOGIN = 0,
b.MEDIA_TYPE_ID = P_MEDIA_TYPE_ID,
b.SVR_TYPE_ID = P_SVR_TYPE_ID,
b.MEDIA_TYPE_MAP = P_MEDIA_TYPE_MAP
where b.SVR_MPS_MMAP_ID = P_SVR_MPS_MMAP_ID;
insert into IEU_UWQ_SVR_MPS_MMAPS (
SVR_MPS_MMAP_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
MEDIA_TYPE_ID,
SVR_TYPE_ID,
MEDIA_TYPE_MAP )
values( to_number(P_SVR_MPS_MMAP_ID),
user_id,
SYSDATE,
user_id,
SYSDATE,
0,
to_number(P_MEDIA_TYPE_ID),
to_number(P_SVR_TYPE_ID),
P_MEDIA_TYPE_MAP);
update IEU_UWQ_CLI_MED_PLUGINS b
set b.LAST_UPDATED_BY = user_id,
b.LAST_UPDATE_DATE = SYSDATE,
b.LAST_UPDATE_LOGIN = 0,
b.MEDIA_TYPE_ID = P_MEDIA_TYPE_ID,
b.CLI_PLUGIN_CLASS = P_CLI_PLUGIN_CLASS,
b.APPLICATION_ID = P_APPLICATION_ID
where b.CLI_PLUGIN_ID = P_CLI_PLUGIN_ID;
insert into IEU_UWQ_CLI_MED_PLUGINS (
CLI_PLUGIN_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
MEDIA_TYPE_ID,
CLI_PLUGIN_CLASS,
APPLICATION_ID )
values( to_number(P_CLI_PLUGIN_ID),
user_id,
SYSDATE,
user_id,
SYSDATE,
0,
to_number(P_MEDIA_TYPE_ID),
P_CLI_PLUGIN_CLASS,
P_APPLICATION_ID );
update IEU_UWQ_SVR_MPS_PLUGINS b
set b.LAST_UPDATED_BY = user_id,
b.LAST_UPDATE_DATE = SYSDATE,
b.LAST_UPDATE_LOGIN = 0,
b.SVR_TYPE_ID = P_SVR_TYPE_ID,
b.SVR_PLUGIN_CLASS = P_SVR_PLUGIN_CLASS,
b.APPLICATION_ID = P_APPLICATION_ID
where b.SVR_MPS_PLUGIN_ID = P_SVR_MPS_PLUGIN_ID;
insert into IEU_UWQ_SVR_MPS_PLUGINS (
SVR_MPS_PLUGIN_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
SVR_TYPE_ID,
SVR_PLUGIN_CLASS,
APPLICATION_ID )
values( to_number(P_SVR_MPS_PLUGIN_ID),
user_id,
SYSDATE,
user_id,
SYSDATE,
0,
to_number(P_SVR_TYPE_ID),
P_SVR_PLUGIN_CLASS,
P_APPLICATION_ID );
update IEU_UWQ_SEL_ENUMERATORS b
set b.LAST_UPDATED_BY = user_id,
b.LAST_UPDATE_DATE = SYSDATE,
b.LAST_UPDATE_LOGIN = 0,
b.ENUM_PROC = P_ENUM_PROC,
b.REFRESH_PROC = P_REFRESH_PROC,
b.ENUM_TYPE_UUID = P_ENUM_TYPE_UUID
where b.SEL_ENUM_ID = P_SEL_ENUM_ID;
insert into IEU_UWQ_SEL_ENUMERATORS (
SEL_ENUM_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ENUM_PROC,
REFRESH_PROC,
ENUM_TYPE_UUID )
values( to_number(P_SEL_ENUM_ID),
user_id,
SYSDATE,
user_id,
SYSDATE,
0,
P_ENUM_PROC,
P_REFRESH_PROC,
P_ENUM_TYPE_UUID);
select
application_id
into
l_app_id
from
fnd_application
where
application_short_name = P_APPLICATION_SHORT_NAME;
select
application_id
into
l_cur_app_id
from
IEU_UWQ_SEL_ENUMERATORS e
where
e.SEL_ENUM_ID = P_SEL_ENUM_ID;
update IEU_UWQ_SEL_ENUMERATORS e
set
e.LAST_UPDATED_BY = l_user_id,
e.LAST_UPDATE_DATE = SYSDATE,
e.LAST_UPDATE_LOGIN = 0,
e.enum_proc = P_ENUM_PROC,
e.enum_type_uuid = P_ENUM_TYPE_UUID,
e.refresh_proc = P_REFRESH_PROC,
e.application_id = l_app_id,
e.work_q_label_lu_type = P_WORK_Q_LABEL_LU_TYPE,
e.work_q_label_lu_code = P_WORK_Q_LABEL_LU_CODE,
e.work_q_enable_profile_option = P_WORK_Q_ENABLE_PROFILE_OPTION,
e.work_q_view_for_primary_node = P_WORK_Q_VIEW_FOR_PRIMARY_NODE,
e.work_q_view_extra_where = P_WORK_Q_VIEW_EXTRA_WHERE,
e.work_q_order_profile_option = P_WORK_Q_ORDER_PROFILE_OPTION,
e.work_q_order_system_default = P_WORK_Q_ORDER_SYSTEM_DEFAULT,
e.media_type_id = P_MEDIA_TYPE_ID,
e.default_res_cat_id = P_DEFAULT_RES_CAT_ID,
e.res_cat_profile_opt = P_RES_CAT_PROFILE_OPT,
e.not_for_mywork_flag = P_NOT_FOR_MYWORK_FLAG,
e.not_valid_flag = P_NOT_VALID_FLAG,
e.action_proc = P_ACTION_PROC,
e.action_proc_type_code = P_ACTION_PROC_TYPE_CODE,
e.action_object_code = P_ACTION_OBJECT_CODE,
e.work_q_register_type = P_WORK_Q_REGISTER_TYPE,
e.work_panel_registered_flag = P_WORK_PANEL_REGISTERED_FLAG
where
e.SEL_ENUM_ID = P_SEL_ENUM_ID;
update IEU_UWQ_SEL_ENUMERATORS e
set
e.LAST_UPDATED_BY = l_user_id,
e.LAST_UPDATE_DATE = SYSDATE,
e.LAST_UPDATE_LOGIN = 0,
e.enum_proc = P_ENUM_PROC,
e.enum_type_uuid = P_ENUM_TYPE_UUID,
e.refresh_proc = P_REFRESH_PROC,
e.application_id = l_app_id,
e.work_q_label_lu_type = P_WORK_Q_LABEL_LU_TYPE,
e.work_q_label_lu_code = P_WORK_Q_LABEL_LU_CODE,
e.work_q_enable_profile_option = P_WORK_Q_ENABLE_PROFILE_OPTION,
e.work_q_view_for_primary_node = P_WORK_Q_VIEW_FOR_PRIMARY_NODE,
e.work_q_view_extra_where = P_WORK_Q_VIEW_EXTRA_WHERE,
e.work_q_order_profile_option = P_WORK_Q_ORDER_PROFILE_OPTION,
e.work_q_order_system_default = P_WORK_Q_ORDER_SYSTEM_DEFAULT,
e.media_type_id = P_MEDIA_TYPE_ID,
e.default_res_cat_id = P_DEFAULT_RES_CAT_ID,
e.res_cat_profile_opt = P_RES_CAT_PROFILE_OPT,
e.not_for_mywork_flag = P_NOT_FOR_MYWORK_FLAG,
e.not_valid_flag = P_NOT_VALID_FLAG,
e.action_proc = P_ACTION_PROC,
e.action_proc_type_code = P_ACTION_PROC_TYPE_CODE,
e.action_object_code = P_ACTION_OBJECT_CODE,
e.work_q_register_type = P_WORK_Q_REGISTER_TYPE,
e.work_panel_registered_flag = P_WORK_PANEL_REGISTERED_FLAG
where
e.SEL_ENUM_ID = P_SEL_ENUM_ID;
insert into IEU_UWQ_SEL_ENUMERATORS (
SEL_ENUM_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ENUM_TYPE_UUID,
ENUM_PROC,
REFRESH_PROC,
OBJECT_VERSION_NUMBER,
APPLICATION_ID,
WORK_Q_LABEL_LU_TYPE,
WORK_Q_LABEL_LU_CODE,
WORK_Q_ENABLE_PROFILE_OPTION,
WORK_Q_ORDER_PROFILE_OPTION,
WORK_Q_ORDER_SYSTEM_DEFAULT,
WORK_Q_VIEW_FOR_PRIMARY_NODE,
WORK_Q_VIEW_EXTRA_WHERE,
MEDIA_TYPE_ID,
DEFAULT_RES_CAT_ID,
RES_CAT_PROFILE_OPT,
NOT_FOR_MYWORK_FLAG,
NOT_VALID_FLAG,
ACTION_PROC,
ACTION_PROC_TYPE_CODE,
ACTION_OBJECT_CODE,
WORK_Q_REGISTER_TYPE,
WORK_PANEL_REGISTERED_FLAG
)
values (
to_number(P_SEL_ENUM_ID),
l_user_id,
SYSDATE,
l_user_id,
SYSDATE,
0,
P_ENUM_TYPE_UUID,
P_ENUM_PROC,
P_REFRESH_PROC,
0,
l_app_id,
P_WORK_Q_LABEL_LU_TYPE,
P_WORK_Q_LABEL_LU_CODE,
P_WORK_Q_ENABLE_PROFILE_OPTION,
P_WORK_Q_ORDER_PROFILE_OPTION,
to_number(P_WORK_Q_ORDER_SYSTEM_DEFAULT),
P_WORK_Q_VIEW_FOR_PRIMARY_NODE,
P_WORK_Q_VIEW_EXTRA_WHERE,
to_number(P_MEDIA_TYPE_ID),
to_number(P_DEFAULT_RES_CAT_ID),
P_RES_CAT_PROFILE_OPT,
P_NOT_FOR_MYWORK_FLAG,
P_NOT_VALID_FLAG,
P_ACTION_PROC,
P_ACTION_PROC_TYPE_CODE,
P_ACTION_OBJECT_CODE,
P_WORK_Q_REGISTER_TYPE,
P_WORK_PANEL_REGISTERED_FLAG );
update IEU_UWQ_NODE_DS m
set
m.LAST_UPDATED_BY = l_user_id,
m.LAST_UPDATE_DATE = SYSDATE,
m.LAST_UPDATE_LOGIN = 0,
m.DATASOURCE_NAME = P_DATASOURCE_NAME
where
(m.enum_type_uuid = P_ENUM_TYPE_UUID) and
(m.node_ds_id = P_NODE_DS_ID);
insert into IEU_UWQ_NODE_DS (
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ENUM_TYPE_UUID,
NODE_DS_ID,
DATASOURCE_NAME
)
values (
0,
l_user_id,
SYSDATE,
l_user_id,
SYSDATE,
0,
P_ENUM_TYPE_UUID,
to_number(P_NODE_DS_ID),
P_DATASOURCE_NAME
);
update IEU_UWQ_RES_CAT_ENM_MAPS m
set
m.LAST_UPDATED_BY = l_user_id,
m.LAST_UPDATE_DATE = SYSDATE,
m.LAST_UPDATE_LOGIN = 0
where
(m.enum_type_uuid = P_ENUM_TYPE_UUID) and
(m.res_cat_id = P_RES_CAT_ID);
insert into IEU_UWQ_RES_CAT_ENM_MAPS (
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ENUM_TYPE_UUID,
RES_CAT_ID
)
values (
0,
l_user_id,
SYSDATE,
l_user_id,
SYSDATE,
0,
P_ENUM_TYPE_UUID,
to_number(P_RES_CAT_ID)
);
UPDATE IEU_CLI_PROV_PLUGINS cliprov
SET
cliprov.LAST_UPDATED_BY = user_id,
cliprov.LAST_UPDATE_DATE = SYSDATE,
cliprov.LAST_UPDATE_LOGIN = 0,
cliprov.PLUGIN_CLASS_NAME = P_PLUGIN_CLASS_NAME,
cliprov.IS_ACTIVE_FLAG = P_IS_ACTIVE_FLAG,
cliprov.APPLICATION_ID = P_APPLICATION_ID
WHERE cliprov.PLUGIN_ID = P_PLUGIN_ID;
INSERT INTO IEU_CLI_PROV_PLUGINS (
PLUGIN_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
PLUGIN_CLASS_NAME,
IS_ACTIVE_FLAG,
APPLICATION_ID
)
VALUES (
to_number(P_PLUGIN_ID),
user_id,
SYSDATE,
user_id,
SYSDATE,
0,
P_PLUGIN_CLASS_NAME,
P_IS_ACTIVE_FLAG,
to_number(P_APPLICATION_ID)
);
UPDATE IEU_CLI_PROV_PLUGIN_MED_MAPS clipmmap
SET
clipmmap.LAST_UPDATED_BY = user_id,
clipmmap.LAST_UPDATE_DATE = SYSDATE,
clipmmap.LAST_UPDATE_LOGIN = 0,
clipmmap.PLUGIN_ID = P_PLUGIN_ID,
clipmmap.MEDIA_TYPE_ID = P_MEDIA_TYPE_ID,
clipmmap.CONDITIONAL_FUNC = P_CONDITIONAL_FUNC
WHERE clipmmap.PLUGIN_MED_MAP_ID = P_PLUGIN_MED_MAP_ID;
INSERT INTO IEU_CLI_PROV_PLUGIN_MED_MAPS (
PLUGIN_MED_MAP_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
PLUGIN_ID,
MEDIA_TYPE_ID,
CONDITIONAL_FUNC )
VALUES (
to_number(P_PLUGIN_MED_MAP_ID),
user_id,
SYSDATE,
user_id,
SYSDATE,
0,
to_number(P_PLUGIN_ID),
to_number(P_MEDIA_TYPE_ID),
P_CONDITIONAL_FUNC
);
update IEU_WP_SECTIONS_TL
set source_lang = userenv('LANG'),
object_version_number = object_version_number + 1,
section_label = p_section_label,
section_description = p_section_description,
last_update_date = sysdate,
last_updated_by = user_id,
last_update_login = 0
where (section_id = to_number(p_section_id))
and (userenv('LANG') IN (LANGUAGE, SOURCE_LANG));
update IEU_WP_SECTIONS_B
set object_version_number = object_version_number + 1,
last_updated_by = user_id,
last_update_date = sysdate,
last_update_login = 0,
section_code = p_section_code
where section_id = to_number(p_section_id);
update IEU_WP_SECTIONS_TL
set object_version_number = object_version_number + 1,
last_updated_by = user_id,
last_update_date = sysdate,
last_update_login = 0,
section_label = p_section_label,
section_description = p_section_description,
source_lang = userenv('LANG')
where section_id = to_number(p_section_id)
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
insert into ieu_wp_sections_b
(section_id,
object_version_number,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
section_code)
values ( to_number(p_section_id),
1,
user_id,
sysdate,
user_id,
sysdate,
0,
p_section_code);
insert into ieu_wp_sections_tl
(section_id,
object_version_number,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
section_label,
section_description,
language,
source_lang)
select to_number(p_section_id),
1,
user_id,
sysdate,
user_id,
sysdate,
0,
p_section_label,
p_section_description,
l.language_code,
userenv('LANG')
from fnd_languages l
where l.installed_flag in ('I', 'B')
and not exists
(select null from ieu_wp_sections_tl t
where t.section_id = to_number(p_section_id)
and t.language = l.language_code);
P_LAST_UPDATE_DATE IN VARCHAR2,
P_OWNER IN VARCHAR2
)is
user_id number := FND_GLOBAL.USER_ID;
update ieu_wp_action_params
set LAST_UPDATED_BY = user_id,
LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
LAST_UPDATE_LOGIN = 0,
WP_ACTION_DEF_ID = P_MACTION_DEF_ID,
PARAM_ID = P_ACTION_PARAM_ID,
NOT_VALID_FLAG = P_NOT_VALID_FLAG,
OBJECT_VERSION_NUMBER = nvl(object_version_number,0) +1
where action_param_map_id = P_ACTION_PARAM_MAP_ID;
insert into ieu_wp_action_params
( action_param_map_id ,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
PARAM_ID,
WP_ACTION_DEF_ID,
NOT_VALID_FLAG,
OBJECT_VERSION_NUMBER)
values( P_ACTION_PARAM_MAP_ID,
--created_id,
user_id,
SYSDATE,
user_id,
decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
FND_GLOBAL.LOGIN_ID,
P_ACTION_PARAM_ID,
P_MACTION_DEF_ID,
P_NOT_VALID_FLAG,
1);
P_LAST_UPDATE_DATE IN VARCHAR2,
P_OWNER IN VARCHAR2
)is
user_id number := FND_GLOBAL.USER_ID;
update IEU_UWQ_NONMEDIA_ACTIONS
set LAST_UPDATED_BY = user_id,
LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
LAST_UPDATE_LOGIN = 0,
ACTION_OBJECT_CODE = P_ACTION_OBJECT_CODE,
MACTION_DEF_ID = P_MEDIA_MACTION_DEF_ID,
APPLICATION_ID = P_APPLICATION_ID,
SOURCE_FOR_TASK_FLAG = P_SOURCE_FOR_TASK_FLAG,
RESPONSIBILITY_ID = P_RESPONSIBILITY_ID,
OBJECT_VERSION_NUMBER = nvl(object_version_number,0) +1
where nonmedia_action_id = P_NONMEDIA_ACTION_ID;
insert into IEU_UWQ_NONMEDIA_ACTIONS (
NONMEDIA_ACTION_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ACTION_OBJECT_CODE,
MACTION_DEF_ID,
APPLICATION_ID,
SOURCE_FOR_TASK_FLAG,
RESPONSIBILITY_ID,
OBJECT_VERSION_NUMBER)
values( P_NONMEDIA_ACTION_ID,
--created_id,
user_id,
SYSDATE,
user_id,
decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
FND_GLOBAL.LOGIN_ID,
P_ACTION_OBJECT_CODE,
P_MEDIA_MACTION_DEF_ID,
P_APPLICATION_ID,
P_SOURCE_FOR_TASK_FLAG,
P_RESPONSIBILITY_ID,
1);
P_LAST_UPDATE_DATE IN VARCHAR2,
P_OWNER IN VARCHAR2
)is
x_return_status VARCHAR2(2000);
l_last_updated_by ieu_wp_action_maps.last_updated_by%type;
IEU_WP_ACTION_PVT.UpdateParamProps(x_return_status ,x_msg_count ,x_msg_data, P_APPLICATION_ID );
select last_updated_by into l_last_updated_by
from ieu_wp_action_maps
where wp_action_map_id = P_WP_ACTION_MAP_ID;
if (l_last_updated_by = user_id) then
update ieu_wp_action_maps
set
LAST_UPDATED_BY = user_id,
LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
LAST_UPDATE_LOGIN = 0,
APPLICATION_ID = P_APPLICATION_ID,
OBJECT_VERSION_NUMBER = nvl(object_version_number,0) +1,
action_param_set_id = P_ACTION_PARAM_SET_ID,
RESPONSIBILITY_ID = P_RESPONSIBILITY_ID,
action_map_type_code = P_ACTION_MAP_TYPE_CODE,
action_map_code = P_ACTION_MAP_CODE,
action_map_sequence = P_ACTION_MAP_SEQUENCE,
PANEL_SEC_CAT_CODE = P_PANEL_SEC_CAT_CODE,
NOT_VALID_FLAG = P_NOT_VALID_FLAG,
DEV_DATA_FLAG = P_DEV_DATA_FLAG
where wp_action_map_id = P_WP_ACTION_MAP_ID;
update ieu_wp_action_maps
set
LAST_UPDATED_BY = user_id,
LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
LAST_UPDATE_LOGIN = 0,
APPLICATION_ID = P_APPLICATION_ID,
OBJECT_VERSION_NUMBER = nvl(object_version_number,0) +1,
action_param_set_id = P_ACTION_PARAM_SET_ID,
RESPONSIBILITY_ID = P_RESPONSIBILITY_ID,
action_map_type_code = P_ACTION_MAP_TYPE_CODE,
action_map_code = P_ACTION_MAP_CODE,
--action_map_sequence = P_ACTION_MAP_SEQUENCE,
PANEL_SEC_CAT_CODE = P_PANEL_SEC_CAT_CODE,
--NOT_VALID_FLAG = P_NOT_VALID_FLAG,
DEV_DATA_FLAG = P_DEV_DATA_FLAG
where wp_action_map_id = P_WP_ACTION_MAP_ID;
select max(action_map_sequence) into l_temp_map_sequence
from ieu_wp_action_maps
where application_id = P_APPLICATION_ID
and action_map_type_code = P_ACTION_MAP_TYPE_CODE
and action_map_code = P_ACTION_MAP_CODE;
insert into ieu_wp_action_maps
( wp_action_map_id ,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
action_param_set_id,
RESPONSIBILITY_ID,
APPLICATION_ID,
action_map_type_code,
action_map_code,
action_map_sequence,
PANEL_SEC_CAT_CODE,
NOT_VALID_FLAG,
DEV_DATA_FLAG,
OBJECT_VERSION_NUMBER)
values
( P_WP_ACTION_MAP_ID,
--created_id,
user_id,
SYSDATE,
user_id,
decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
FND_GLOBAL.LOGIN_ID,
P_ACTION_PARAM_SET_ID,
P_RESPONSIBILITY_ID,
P_APPLICATION_ID,
P_ACTION_MAP_TYPE_CODE,
P_ACTION_MAP_CODE,
l_temp_map_sequence,
P_PANEL_SEC_CAT_CODE,
P_NOT_VALID_FLAG,
P_DEV_DATA_FLAG,
1
);
select MACTION_DEF_TYPE_FLAG into l_def_flag
from ieu_uwq_maction_defs_b
where
maction_def_id in
(select wp_action_def_id
from ieu_wp_act_param_sets_b
where action_param_set_id = P_ACTION_PARAM_SET_ID);
update ieu_wp_node_section_maps
set LAST_UPDATED_BY = user_id,
LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
LAST_UPDATE_LOGIN = 0,
OBJECT_VERSION_NUMBER = nvl(object_version_number,0) +1
where
enum_type_uuid = P_ACTION_MAP_CODE
and section_id = l_section_id;
select IEU_WP_NODE_SECTION_MAPS_S1.NEXTVAL into l_wp_node_section_map_id from sys.dual;
insert into ieu_wp_node_section_maps
( wp_node_section_map_id ,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
APPLICATION_ID,
enum_type_uuid,
section_id,
section_map_sequence,
OBJECT_VERSION_NUMBER)
values
( l_wp_node_section_map_id,
--created_id,
user_id,
sysdate,
user_id,
decode(P_LAST_UPDATE_DATE, null,SYSDATE,to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD')),
FND_GLOBAL.LOGIN_ID,
P_APPLICATION_ID,
P_ACTION_MAP_CODE,
l_section_id,
l_sequence,
1);