APPS.ZX_FC_MIGRATE_PKG dependencies on FND_MODULE_INSTALLATIONS

Line 4615: p_application_id IN fnd_module_installations.APPLICATION_ID%TYPE,

4611: +===========================================================================*/
4612:
4613:
4614: FUNCTION Is_Country_Installed(
4615: p_application_id IN fnd_module_installations.APPLICATION_ID%TYPE,
4616: p_module_short_name IN fnd_module_installations.MODULE_SHORT_NAME%TYPE
4617: )
4618: RETURN BOOLEAN IS
4619:

Line 4616: p_module_short_name IN fnd_module_installations.MODULE_SHORT_NAME%TYPE

4612:
4613:
4614: FUNCTION Is_Country_Installed(
4615: p_application_id IN fnd_module_installations.APPLICATION_ID%TYPE,
4616: p_module_short_name IN fnd_module_installations.MODULE_SHORT_NAME%TYPE
4617: )
4618: RETURN BOOLEAN IS
4619:
4620: l_status FND_PRODUCT_INSTALLATIONS.STATUS%TYPE;

Line 4631: FND_MODULE_INSTALLATIONS

4627: BEGIN
4628: SELECT STATUS, DB_STATUS
4629: into l_status, l_db_status
4630: FROM
4631: FND_MODULE_INSTALLATIONS
4632: WHERE
4633: APPLICATION_ID = p_application_id AND
4634: MODULE_SHORT_NAME = p_module_short_name;
4635: EXCEPTION

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

4633: APPLICATION_ID = p_application_id AND
4634: MODULE_SHORT_NAME = p_module_short_name;
4635: EXCEPTION
4636: WHEN OTHERS THEN
4637: arp_util_tax.debug('Error while getting status and db status value from fnd_module_installations');
4638: END;
4639:
4640: IF (nvl(l_status,'N') in ('I','S') or
4641: nvl(l_db_status,'N') in ('I','S')) THEN