[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE delete_module (x_module_id cn_modules.module_id%TYPE,
x_package_spec_id cn_objects.object_id%TYPE,
x_package_body_id cn_objects.object_id%TYPE,
p_org_id IN NUMBER) IS
BEGIN
DELETE FROM cn_source_all
WHERE (object_id = x_package_spec_id
OR object_id = x_package_body_id)
AND org_id = p_org_id ;
END delete_module;
SELECT text
INTO code.text
FROM cn_source_all
WHERE object_id = code.object_id
AND line_no = code.line
AND org_id = g_org_id;
UPDATE cn_source_all
SET text = code.text
WHERE object_id = code.object_id
AND line_no = code.line
AND org_id = g_org_id;
INSERT into cn_source_all (source_id, object_id, line_no, text, org_id)
VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,l_text1, g_org_id);
INSERT into cn_source_all (source_id, object_id, line_no, text, org_id)
VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,substr(l_text,l_pos), g_org_id);
INSERT into cn_source_all (source_id, object_id, line_no, text, org_id)
VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,substr(l_text,l_pos), g_org_id);
INSERT into cn_source (source_id, object_id, line_no, text, org_id)
VALUES (cn_source_s.NEXTVAL, code.object_id, code.line, code.text, g_org_id );
INSERT into cn_source (source_id, object_id, line_no, text, org_id)
VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,l_text1, g_org_id);
INSERT into cn_source (source_id, object_id, line_no, text, org_id)
VALUES (cn_source_s.NEXTVAL, code.object_id, code.line,DBMS_LOB.SUBSTR(l_clob_text,DBMS_LOB.GETLENGTH(code.text)-l_prev_pos,l_prev_pos), g_org_id);
INSERT into cn_source (source_id, object_id, line_no, text, org_id)
VALUES (cn_source_s.NEXTVAL, code.object_id, code.line, l_text1, g_org_id);
cn_utils.appindcr(code, 'cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, ' || parent_audit_id || ',');
cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, 0, ' || message || ');');
cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, SQLCODE,');
cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, SQLCODE,');
SELECT user INTO X_userid FROM sys.dual;
SELECT user INTO X_userid FROM sys.dual;
cn_utils.appendcr(code, 'SELECT TEXT ');
cn_utils.appendcr(code, 'SELECT TEXT ');
cn_utils.delete_module(module_id, package_spec_id, package_body_id, g_org_id);
SELECT user INTO X_userid FROM sys.dual;
SELECT user INTO X_userid FROM sys.dual;
cn_utils.delete_module(module_id, package_spec_id, package_body_id, g_org_id);
cn_utils.delete_module(module_id, package_spec_id, package_body_id, g_org_id);
SELECT user INTO X_userid FROM sys.dual;
SELECT user INTO X_userid FROM sys.dual;
SELECT cocv.name column_name, data_type, data_length, data_scale,
primary_key, nullable
FROM cn_obj_columns_v cocv
WHERE cocv.table_id = X_table_id
ORDER BY cocv.position;
SELECT cocv.name column_name
FROM cn_obj_columns_v cocv, cn_column_ind_maps ccim
WHERE cocv.column_id = ccim.column_id
AND ccim.index_id = X_index_id;
SELECT coiv.name, cotv.name, unique_flag
INTO X_name, X_table_name, X_unique_flag
FROM cn_obj_indexes_v coiv, cn_obj_tables_v cotv
WHERE cotv.table_id = coiv.table_id
AND coiv.index_id = X_index_id;
SELECT name, start_value, increment_value
INTO X_name, X_start_value, X_increment_value
FROM cn_obj_sequences_v cosv
WHERE cosv.sequence_id = X_sequence_id;
SELECT name, connect_to_username, connect_to_password, connect_to_host
INTO X_name, X_connect_to_username, X_connect_to_password, X_connect_to_host
FROM cn_obj_dblinks_v codv
WHERE codv.dblink_id = X_dblink_id;
SELECT statement_text
INTO X_statement_text
FROM cn_objects co
WHERE co.object_id = X_object_id;
SELECT statement_text, object_type, name, description
INTO X_statement_text, X_object_type, X_name, X_description
FROM cn_objects co
WHERE co.object_id = X_object_id;
SELECT cocv.name
FROM cn_obj_columns_v cocv, cn_column_trg_maps cctm
WHERE cocv.column_id = cctm.column_id
AND cctm.trigger_id = X_trigger_id;
cn_obj_triggers_v_pkg.select_row(row);
cn_utils.append(code, 'INSERT OF ');
cn_utils.append(code, 'UPDATE OF ');
cn_utils.append(code, 'DELETE OF ');
SELECT name INTO table_name
FROM cn_obj_tables_v
WHERE table_id = row.table_id;
SELECT object_type INTO X_object_type
FROM cn_objects co
WHERE co.object_id = X_object_id;
SELECT cn_process_audits_s.NEXTVAL
INTO x_process_audit_id
FROM sys.dual;
SELECT cn_objects_s.NEXTVAL
INTO x_object_id
FROM sys.dual;
SELECT cn_mod_obj_depends_s.NEXTVAL
INTO x_mod_obj_depends_id
FROM sys.dual;
SELECT name INTO X_name
FROM cn_objects
WHERE object_id = X_object_id
AND org_id = p_org_id;
SELECT repository_id INTO X_repository_id
FROM cn_modules
WHERE module_id = X_module_id
AND org_id = p_org_id;
SELECT event_id INTO X_event_id
FROM cn_modules
WHERE module_id = X_module_id
AND org_id = p_org_id;
SELECT object_id, description
INTO x_object_id, x_description
FROM cn_objects
WHERE name = x_name
AND object_type = x_object_type
AND org_id = p_org_id ;
SELECT MIN(period_id)
INTO l_next_period_id
FROM cn_period_statuses_all
WHERE period_id > x_period_id
AND period_status IN ('F', 'O')
AND org_id = p_org_id;