APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_INTEGRATOR_UTILS

Line 1930: -- Function bne_integrator_utils.DELETE_INTEGRATOR

1926: ,p_INTERFACE_CODE IN VARCHAR2
1927: ,p_application_id IN NUMBER ) IS
1928:
1929: --$ get Integrator Code to delete entire integrator setup in one shot using
1930: -- Function bne_integrator_utils.DELETE_INTEGRATOR
1931: CURSOR csr_get_integrator_code is
1932: select integrator_code from bne_interfaces_b where interface_code
1933: = p_INTERFACE_CODE and application_id = p_application_id;
1934:

Line 1942: --$ Use bne_integrator_utils.DELETE_INTEGRATOR to delete entire setup

1938: cnt number;
1939:
1940: BEGIN
1941:
1942: --$ Use bne_integrator_utils.DELETE_INTEGRATOR to delete entire setup
1943: OPEN csr_get_integrator_code;
1944: fetch csr_get_integrator_code into l_intg_code;
1945: Close csr_get_integrator_code;
1946:

Line 1951: cnt := bne_integrator_utils.DELETE_INTEGRATOR

1947: l_param_list_code := l_intg_code || '_DP';
1948: DELETE FROM BNE_PARAM_LISTS_TL WHERE PARAM_LIST_CODE = l_param_list_code and application_id = p_application_id;
1949: DELETE FROM BNE_PARAM_LISTS_B WHERE PARAM_LIST_CODE = l_param_list_code and application_id = p_application_id;
1950:
1951: cnt := bne_integrator_utils.DELETE_INTEGRATOR
1952: ( P_INTEGRATOR_CODE => l_intg_code,
1953: P_APPLICATION_ID => p_application_id);
1954:
1955: --$ COMMENT MANUAL DELETION STEPS