APPS.HR_SESSION_UTILITIES dependencies on FND_PRODUCT_INSTALLATIONS

Line 174: l_hr_installation_status fnd_product_installations.status%TYPE;

170: -- ----------------------------------------------------------------------------
171: FUNCTION Get_Installation_Status (p_application_id IN NUMBER)
172: RETURN VARCHAR2
173: IS
174: l_hr_installation_status fnd_product_installations.status%TYPE;
175: -- Cursor to extract the status of the application installation
176: CURSOR csr_hr_installation_status(p_application_id number)
177: IS
178: select fpi.status

Line 179: from fnd_product_installations fpi

175: -- Cursor to extract the status of the application installation
176: CURSOR csr_hr_installation_status(p_application_id number)
177: IS
178: select fpi.status
179: from fnd_product_installations fpi
180: where fpi.application_id = p_application_id;
181: --
182: l_proc VARCHAR2 (72) := g_package || ' Get_Installation_Status';
183: BEGIN

Line 282: l_hr_installation_status fnd_product_installations.status%TYPE

278: l_web_username varchar2(80) default null;
279:
280: l_cookie owa_cookie.cookie;
281: l_person_id per_people_f.person_id%type;
282: l_hr_installation_status fnd_product_installations.status%TYPE
283: DEFAULT NULL;
284: --
285: --
286: l_proc VARCHAR2 (72) ;