The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select HOOK_PACKAGE, HOOK_API , EXECUTE_FLAG, PRODUCT_CODE
from JTF_HOOKS_DATA
Where package_name = 'JTM_COUNTERS_PUB' and
upper(api_name) = upper(p_api_name) and
processing_type = p_processing_type and
execute_flag = 'Y' and
hook_type = 'V';
PROCEDURE UPDATE_CTR_GRP_PRE(
P_Api_Version IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
p_ctr_grp_id IN NUMBER,
p_object_version_number IN NUMBER,
p_cascade_upd_to_instances IN VARCHAR2,
x_object_version_number OUT NOCOPY NUMBER
) IS
l_enable_flag varchar2(20);
FOR Csr1 in Get_hook_info('B', 'UPDATE_CTR_GRP') LOOP
/* user execute flag */
l_enable_flag := Csr1.EXECUTE_FLAG;
PROCEDURE UPDATE_CTR_GRP_POST(
P_Api_Version IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
p_ctr_grp_id IN NUMBER,
p_object_version_number IN NUMBER,
p_cascade_upd_to_instances IN VARCHAR2,
x_object_version_number OUT NOCOPY NUMBER
) IS
l_enable_flag varchar2(20);
FOR Csr1 in Get_hook_info('A', 'UPDATE_CTR_GRP') LOOP
/* user execute flag */
l_enable_flag := Csr1.EXECUTE_FLAG;
PROCEDURE UPDATE_COUNTER_PRE(
P_Api_Version IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
p_ctr_id IN NUMBER,
p_object_version_number IN NUMBER,
p_cascade_upd_to_instances IN VARCHAR2,
x_object_version_number OUT NOCOPY NUMBER
) IS
l_enable_flag varchar2(20);
FOR Csr1 in Get_hook_info('B', 'UPDATE_COUNTER') LOOP
/* user execute flag */
l_enable_flag := Csr1.EXECUTE_FLAG;
PROCEDURE UPDATE_COUNTER_POST(
P_Api_Version IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
p_ctr_id IN NUMBER,
p_object_version_number IN NUMBER,
p_cascade_upd_to_instances IN VARCHAR2,
x_object_version_number OUT NOCOPY NUMBER
) IS
l_enable_flag varchar2(20);
FOR Csr1 in Get_hook_info('A', 'UPDATE_COUNTER') LOOP
/* user execute flag */
l_enable_flag := Csr1.EXECUTE_FLAG;
PROCEDURE UPDATE_CTR_PROP_PRE(
P_Api_Version IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
p_ctr_prop_id IN NUMBER,
p_object_version_number IN NUMBER,
p_cascade_upd_to_instances IN VARCHAR2,
x_object_version_number OUT NOCOPY NUMBER
) IS
l_enable_flag varchar2(20);
FOR Csr1 in Get_hook_info('B', 'UPDATE_CTR_PROP') LOOP
/* user execute flag */
l_enable_flag := Csr1.EXECUTE_FLAG;
PROCEDURE UPDATE_CTR_PROP_POST(
P_Api_Version IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
p_ctr_prop_id IN NUMBER,
p_object_version_number IN NUMBER,
p_cascade_upd_to_instances IN VARCHAR2,
x_object_version_number OUT NOCOPY NUMBER
) IS
l_enable_flag varchar2(20);
FOR Csr1 in Get_hook_info('A', 'UPDATE_CTR_PROP') LOOP
/* user execute flag */
l_enable_flag := Csr1.EXECUTE_FLAG;
PROCEDURE DELETE_COUNTER_PRE(
P_Api_Version IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
p_ctr_id IN NUMBER
) IS
l_enable_flag varchar2(20);
FOR Csr1 in Get_hook_info('B', 'DELETE_COUNTER') LOOP
/* user execute flag */
l_enable_flag := Csr1.EXECUTE_FLAG;
PROCEDURE DELETE_CTR_PROP_PRE(
P_Api_Version IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
p_ctr_prop_id IN NUMBER
) IS
l_enable_flag varchar2(20);
FOR Csr1 in Get_hook_info('B', 'DELETE_CTR_PROP') LOOP
/* user execute flag */
l_enable_flag := Csr1.EXECUTE_FLAG;
PROCEDURE DELETE_COUNTER_INSTANCE_PRE (
p_api_version IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
p_SOURCE_OBJECT_ID IN NUMBER,
p_SOURCE_OBJECT_CODE IN VARCHAR2,
x_Return_status OUT NOCOPY VARCHAR2,
x_Msg_Count OUT NOCOPY NUMBER,
x_Msg_Data OUT NOCOPY VARCHAR2
) IS
l_enable_flag varchar2(20);
FOR Csr1 in Get_hook_info('B', 'DELETE_COUNTER_INSTANCE') LOOP
/* user execute flag */
l_enable_flag := Csr1.EXECUTE_FLAG;