APPS.ZX_MIGRATE_UTIL dependencies on FND_PRODUCT_INSTALLATIONS

Line 99: l_status fnd_product_installations.STATUS%type;

95:
96: FUNCTION IS_INSTALLED(p_product_code IN Varchar2)
97: RETURN VARCHAR2 IS
98:
99: l_status fnd_product_installations.STATUS%type;
100: l_db_status fnd_product_installations.DB_STATUS%type;
101: l_product_id Number;
102:
103: BEGIN

Line 100: l_db_status fnd_product_installations.DB_STATUS%type;

96: FUNCTION IS_INSTALLED(p_product_code IN Varchar2)
97: RETURN VARCHAR2 IS
98:
99: l_status fnd_product_installations.STATUS%type;
100: l_db_status fnd_product_installations.DB_STATUS%type;
101: l_product_id Number;
102:
103: BEGIN
104:

Line 119: FND_PRODUCT_INSTALLATIONS

115: BEGIN
116: SELECT STATUS, DB_STATUS
117: INTO l_status, l_db_status
118: FROM
119: FND_PRODUCT_INSTALLATIONS
120: WHERE
121: APPLICATION_ID = l_product_id;
122: EXCEPTION
123: WHEN OTHERS THEN

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

120: WHERE
121: APPLICATION_ID = l_product_id;
122: EXCEPTION
123: WHEN OTHERS THEN
124: arp_util_tax.debug('Error while getting status and db status value from FND_PRODUCT_INSTALLATIONS');
125: END;
126:
127: arp_util_tax.debug( ' IS_INSTALLED .. (-) ' );
128: