64: BEGIN
65:
66: select p.status
67: into x_status
68: from fnd_product_installations p
69: where p.application_id = (select a.application_id
70: from fnd_application a
71: where a.application_short_name = 'PJI'
72: )
133:
134: FUNCTION is_costing_licensed RETURN VARCHAR2
135: IS
136: x_pa_costing_installed VARCHAR2(2);
137: l_status fnd_product_installations.status%type;
138: BEGIN
139:
140: select status
141: into l_status
138: BEGIN
139:
140: select status
141: into l_status
142: from fnd_product_installations
143: where application_id = 275;
144:
145: if ( l_status = 'I') then
146: x_pa_costing_installed := 'Y';
164: where application_short_name = p_product_short_name;
165: x_application_id fnd_application.application_id%TYPE;
166:
167: Cursor get_installation_status is
168: select nvl(status,'N') from fnd_product_installations
169: where application_id = x_application_id;
170:
171: x_status fnd_product_installations.status%TYPE;
172:
167: Cursor get_installation_status is
168: select nvl(status,'N') from fnd_product_installations
169: where application_id = x_application_id;
170:
171: x_status fnd_product_installations.status%TYPE;
172:
173: Begin
174: IF p_product_short_name = 'IPA' then
175: if CRL_INSTALLED IS NULL then
279: BEGIN
280:
281: select p.status
282: into x_status
283: from fnd_product_installations p
284: where p.application_id = (select a.application_id
285: from fnd_application a
286: where a.application_short_name = 'ONT'
287: ) ;