[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
CZ_DEBUG_PUB.insert_into_logs(v_msg_tbl);
PROCEDURE delete_configuration(p_config_model_tbl IN cz_api_pub.config_model_tbl_type)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
cz_cf_api.delete_configuration(p_config_model_tbl(i).config_hdr_id,
p_config_model_tbl(i).config_rev_nbr,
l_usage_exists,
l_error_message,
l_Return_value);
set_error_message(l_err_code,l_msg_count,l_msg_data,'delete config err');
END delete_configuration;
SELECT model_instantiation_type,
component_instance_type
INTO x_model_instantiation_type,
x_component_instance_type
FROM cz_config_hdrs
WHERE cz_config_hdrs.config_hdr_id = p_config_hdr_id
AND cz_config_hdrs.config_rev_nbr = p_config_rev_nbr;
SELECT config_item_id, inventory_item_id, organization_id
INTO x_config_item_id, x_inventory_item_id, x_organization_id
FROM cz_config_items
WHERE config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr
AND deleted_flag = '0'
AND inventory_item_id IS NOT NULL
START WITH (parent_config_item_id IS NULL OR parent_config_item_id = -1)
AND config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
CONNECT BY PRIOR inventory_item_id IS NULL
AND parent_config_item_id = PRIOR config_item_id
AND config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr;
SELECT config_hdr_id, config_rev_nbr
INTO x_container_hdr_id, x_container_rev_nbr
FROM cz_config_items
WHERE cz_config_items.instance_hdr_id = p_config_hdr_id
AND cz_config_items.instance_rev_nbr = p_config_rev_nbr
AND cz_config_items.deleted_flag = '0'
AND ROWNUM < 2;
UPDATE cz_config_items
SET config_delta = 0
WHERE config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr
/* Need to verify */
AND instance_hdr_id <> p_config_hdr_id;
UPDATE cz_config_items
SET line_type = NULL,
ext_activated_flag = Decode(l_prof_val, 'N', (Decode (component_instance_type, 'I', '1', '0')), '1')
WHERE config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr
AND instance_hdr_id <> p_config_hdr_id;
SELECT cz_config_hdrs_s.NEXTVAL INTO x_dummy_hdr_id FROM DUAL;
INSERT INTO cz_config_hdrs ( config_hdr_id
, config_rev_nbr
, name
, desc_text
, effective_usage_id
, deleted_flag
, config_delta_spec
, component_instance_type
, model_instantiation_type
, has_failures
)
VALUES ( x_dummy_hdr_id
, 1
, 'generate/add_to_config_tree'
, 'generate/add_to_config_tree'
, ANY_USAGE_ID
, '0'
, 0
, ROOT
, NETWORK
, 0
);
INSERT INTO cz_config_contents_v ( config_hdr_id
, config_rev_nbr
, config_input_id
, input_seq
, input_type_code
, input_num_val
, item_num_val
, config_item_id
, item_type_code
, instance_hdr_id
, instance_rev_nbr
, component_instance_type
, config_delta
)
VALUES ( x_dummy_hdr_id
, 1
, l_input_id_tbl(i)
, l_input_id_tbl(i)
, INPUTTTYPECODE
, l_inst_header_id_tbl(i)
, l_inst_header_id_tbl(i)
, -1 * l_input_id_tbl(i)
, -1
, x_dummy_hdr_id
, 1
, 'R'
, 0
);
PROCEDURE delete_dummy_config(p_dummy_hdr_id IN NUMBER)
IS
v_cfg_delete cz_db_settings.value%TYPE;
SELECT value INTO v_cfg_delete
FROM cz_db_settings
WHERE setting_id = 'BatchValConfigInputDelete';
v_cfg_delete := 'NO';
IF(v_cfg_delete <> 'YES')THEN
DELETE FROM cz_config_contents_v WHERE config_hdr_id = p_dummy_hdr_id
AND config_rev_nbr = 1;
DELETE FROM cz_config_hdrs WHERE config_hdr_id = p_dummy_hdr_id
AND config_rev_nbr = 1;
END delete_dummy_config;
SELECT constraint_type , message
FROM cz_config_messages
WHERE config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr;
l_selection_line_id NUMBER;
SELECT value
INTO l_trace_value
FROM cz_db_settings
WHERE cz_db_settings.setting_id = 'NetworkApiTrace';
insert into cz_db_logs (message,caller,logtime) values (l_trace_tbl(i),'CZNETAPI',sysdate);
l_trace_tbl.DELETE;
SELECT value
INTO l_trace_value
FROM cz_db_settings
WHERE cz_db_settings.setting_id = 'NetworkApiTrace';
insert into cz_db_logs (message,caller,logtime) values (l_trace_tbl(i),'CZNETAPI',sysdate);
l_trace_tbl.DELETE;
container_model_tbl.DELETE;
SELECT UPPER(value) INTO l_value FROM cz_db_settings WHERE UPPER(section_name) = 'CONFIG'
AND UPPER(setting_id) = 'OPTIMIZECONFIGTREE';
SELECT 1 BULK COLLECT INTO l_instance_number_tbl FROM cz_config_items
WHERE component_instance_type = 'I'
AND deleted_flag = '0'
AND config_hdr_id = l_main_config_hdr_id
AND config_rev_nbr = l_main_config_rev_nbr;
INSERT INTO cz_db_logs (message,caller,logtime)
VALUES ('copy Config Called :' || l_main_config_hdr_id || '>>'|| l_main_config_rev_nbr ,'CZNETAPI',sysdate);
UPDATE cz_config_hdrs SET effective_date = SYSDATE WHERE config_hdr_id = v_config_hdr_id
AND config_rev_nbr = v_config_rev_nbr;
UPDATE cz_config_hdrs SET baseline_rev_nbr = l_config_rev_nbr WHERE config_hdr_id = l_config_hdr_id
AND config_rev_nbr = (SELECT instance_rev_nbr FROM cz_config_items WHERE config_hdr_id =
v_config_hdr_id AND config_rev_nbr = v_config_rev_nbr AND
component_instance_type = 'I');
DELETE FROM cz_config_items a WHERE discontinued_flag = '1'
AND config_hdr_id = v_config_hdr_id
AND config_rev_nbr = v_config_rev_nbr
AND not exists (SELECT 1 from cz_config_items
WHERE parent_config_item_id = a.config_item_id
AND config_hdr_id = v_config_hdr_id
AND config_rev_nbr = v_config_rev_nbr
AND discontinued_flag = '0');
config_messages.DELETE;
delete_dummy_config ( l_dummy_config_hdr_id );
delete_dummy_config ( l_dummy_config_hdr_id );
CZ_DEBUG_PUB.insert_into_logs(v_msg_tbl);
delete_configuration(x_config_model_tbl);
x_config_model_tbl.DELETE;
delete_configuration(x_config_model_tbl);
x_config_model_tbl.DELETE;
delete_configuration(x_config_model_tbl);
x_config_model_tbl.DELETE;
delete_configuration(x_config_model_tbl);
x_config_model_tbl.DELETE;
delete_configuration(x_config_model_tbl);
x_config_model_tbl.DELETE;
delete_configuration(x_config_model_tbl);
x_config_model_tbl.DELETE;
delete_configuration(x_config_model_tbl);
x_config_model_tbl.DELETE;
delete_configuration(x_config_model_tbl);
x_config_model_tbl.DELETE;
delete_configuration(x_config_model_tbl);
x_config_model_tbl.DELETE;
delete_configuration(x_config_model_tbl);
x_config_model_tbl.DELETE;
delete_configuration(x_config_model_tbl);
x_config_model_tbl.DELETE;
l_con_config_tbl.DELETE;
config_input_list.DELETE;
config_messages.DELETE;
delete_dummy_config ( l_dummy_config_hdr_id );
delete_dummy_config ( l_dummy_config_hdr_id );
SELECT model_type INTO l_model_type
FROM cz_devl_projects
WHERE devl_project_id = p_model_id
AND deleted_flag = NO_FLAG;
SELECT reference_id
FROM cz_ps_nodes
WHERE devl_project_id = l_model_id
AND ps_node_type = PS_NODE_TYPE_REFERENCE
AND deleted_flag = NO_FLAG;
SELECT to_number(substr(orig_sys_ref, instr(orig_sys_ref, ':', -1, 1)+1))
INTO l_inventory_item_id
FROM cz_ps_nodes
WHERE ps_node_id = l_reference_id
AND ib_trackable = YES_FLAG
AND deleted_flag = NO_FLAG;
SELECT DECODE(config_model_type, NETWORK_CONTAINER_MODEL, FND_API.G_TRUE, FND_API.G_FALSE)
INTO x_return_value
FROM mtl_system_items_b
WHERE inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id;
SELECT component_instance_type INTO l_component_instance_type
FROM cz_config_items
WHERE config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr
AND config_item_id = p_config_item_id
AND deleted_flag = NO_FLAG;
SELECT component_instance_type,config_delta,ext_activated_flag
FROM cz_config_items
WHERE config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr
AND deleted_flag = NO_FLAG
START WITH config_item_id = p_config_item_id
AND config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr
AND deleted_flag = NO_FLAG
CONNECT BY PRIOR parent_config_item_id = config_item_id
AND config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr
AND deleted_flag = NO_FLAG;
SELECT config_item_id BULK COLLECT INTO x_child_config_tbl
FROM cz_config_items
WHERE config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
AND deleted_flag = NO_FLAG
START WITH config_item_id = p_config_item_id
AND config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
AND deleted_flag = NO_FLAG
CONNECT BY PRIOR config_item_id = parent_config_item_id
AND config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
AND deleted_flag = NO_FLAG;
UPDATE cz_config_items
SET ext_activated_flag = NO_FLAG
WHERE ext_activated_flag = l_ext_activated_flag
AND config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr
AND config_item_id IN
(SELECT config_item_id
FROM cz_config_items
WHERE config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr
AND deleted_flag = NO_FLAG
START WITH config_item_id = p_config_item_id
AND config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr
AND deleted_flag = NO_FLAG
CONNECT BY PRIOR config_item_id = parent_config_item_id
AND config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr
AND deleted_flag = NO_FLAG);
PROCEDURE VALIDATE(config_input_list IN CZ_CF_API.CFG_INPUT_LIST, -- input selections
init_message IN VARCHAR2, -- additional XML
config_messages IN OUT NOCOPY CZ_CF_API.CFG_OUTPUT_PIECES, -- table of output XML messages
validation_status IN OUT NOCOPY NUMBER, -- status return
URL IN VARCHAR2 DEFAULT FND_PROFILE.Value('CZ_UIMGR_URL'),
p_validation_type IN VARCHAR2 DEFAULT CZ_API_PUB.VALIDATE_ORDER
)
IS
BEGIN
cz_cf_api.validate( config_input_list,
init_message,
config_messages,
validation_status,
URL,
p_validation_type);
SELECT config_delta INTO l_delta
FROM cz_config_items
WHERE config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
AND config_item_id = p_config_item_id;