APPS.ZX_FC_MIGRATE_PKG dependencies on FND_MODULE_INSTALLATIONS

Line 4399: p_application_id IN fnd_module_installations.APPLICATION_ID%TYPE,

4395: +===========================================================================*/
4396:
4397:
4398: FUNCTION Is_Country_Installed(
4399: p_application_id IN fnd_module_installations.APPLICATION_ID%TYPE,
4400: p_module_short_name IN fnd_module_installations.MODULE_SHORT_NAME%TYPE
4401: )
4402: RETURN BOOLEAN IS
4403:

Line 4400: p_module_short_name IN fnd_module_installations.MODULE_SHORT_NAME%TYPE

4396:
4397:
4398: FUNCTION Is_Country_Installed(
4399: p_application_id IN fnd_module_installations.APPLICATION_ID%TYPE,
4400: p_module_short_name IN fnd_module_installations.MODULE_SHORT_NAME%TYPE
4401: )
4402: RETURN BOOLEAN IS
4403:
4404: l_status FND_PRODUCT_INSTALLATIONS.STATUS%TYPE;

Line 4415: FND_MODULE_INSTALLATIONS

4411: BEGIN
4412: SELECT STATUS, DB_STATUS
4413: into l_status, l_db_status
4414: FROM
4415: FND_MODULE_INSTALLATIONS
4416: WHERE
4417: APPLICATION_ID = p_application_id AND
4418: MODULE_SHORT_NAME = p_module_short_name;
4419: EXCEPTION

Line 4421: arp_util_tax.debug('Error while getting status and db status value from fnd_module_installations');

4417: APPLICATION_ID = p_application_id AND
4418: MODULE_SHORT_NAME = p_module_short_name;
4419: EXCEPTION
4420: WHEN OTHERS THEN
4421: arp_util_tax.debug('Error while getting status and db status value from fnd_module_installations');
4422: END;
4423:
4424: IF (nvl(l_status,'N') in ('I','S') or
4425: nvl(l_db_status,'N') in ('I','S')) THEN