DBA Data[Home] [Help]

APPS.PQP_RIW_WEBADI_UTILS dependencies on BNE_INTEGRATOR_UTILS

Line 1647: -- Function bne_integrator_utils.DELETE_INTEGRATOR

1643: ,p_INTERFACE_CODE IN VARCHAR2
1644: ,p_application_id IN NUMBER ) IS
1645:
1646: --$ get Integrator Code to delete entire integrator setup in one shot using
1647: -- Function bne_integrator_utils.DELETE_INTEGRATOR
1648: CURSOR csr_get_integrator_code is
1649: select integrator_code from bne_interfaces_b where interface_code
1650: = p_INTERFACE_CODE and application_id = p_application_id;
1651:

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

1655: cnt number;
1656:
1657: BEGIN
1658:
1659: --$ Use bne_integrator_utils.DELETE_INTEGRATOR to delete entire setup
1660: OPEN csr_get_integrator_code;
1661: fetch csr_get_integrator_code into l_intg_code;
1662: Close csr_get_integrator_code;
1663:

Line 1668: cnt := bne_integrator_utils.DELETE_INTEGRATOR

1664: l_param_list_code := l_intg_code || '_DP';
1665: DELETE FROM BNE_PARAM_LISTS_TL WHERE PARAM_LIST_CODE = l_param_list_code and application_id = p_application_id;
1666: DELETE FROM BNE_PARAM_LISTS_B WHERE PARAM_LIST_CODE = l_param_list_code and application_id = p_application_id;
1667:
1668: cnt := bne_integrator_utils.DELETE_INTEGRATOR
1669: ( P_INTEGRATOR_CODE => l_intg_code,
1670: P_APPLICATION_ID => p_application_id);
1671:
1672: --$ COMMENT MANUAL DELETION STEPS