DBA Data[Home] [Help]

APPS.ZX_MIGRATE_UTIL dependencies on FND_PRODUCT_INSTALLATIONS

Line 101: l_status fnd_product_installations.STATUS%type;

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

Line 102: l_db_status fnd_product_installations.DB_STATUS%type;

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

Line 121: FND_PRODUCT_INSTALLATIONS

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

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

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