eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CLASSIC_UPGRADE dependencies on FND_PRODUCT_INSTALLATIONS

Line 2631: l_installed fnd_product_installations.status%type;

2627: l_usr_id number;
2628: l_resp_id number;
2629: l_resp_appl_id number;
2630: l_request_id number := null;
2631: l_installed fnd_product_installations.status%type;
2632: cursor csr_ota_installed is
2633: select fpi.status
2634: from fnd_product_installations fpi
2635: where fpi.application_id = OTA_APPLICATION_ID;

Line 2634: from fnd_product_installations fpi

2630: l_request_id number := null;
2631: l_installed fnd_product_installations.status%type;
2632: cursor csr_ota_installed is
2633: select fpi.status
2634: from fnd_product_installations fpi
2635: where fpi.application_id = OTA_APPLICATION_ID;
2636:
2637: cursor csr_get_resp_details is
2638: select frp.application_id, frp.responsibility_id

Line 2692: l_installed fnd_product_installations.status%type;

2688: procedure validate_proc_for_hr_upg(do_upg out nocopy varchar2) is
2689: OTA_APPLICATION_ID constant number := 810;
2690: OTA_STATUS_INSTALLED constant varchar2(2) := 'I';
2691:
2692: l_installed fnd_product_installations.status%type;
2693: cursor csr_ota_installed is
2694: select fpi.status
2695: from fnd_product_installations fpi
2696: where fpi.application_id = OTA_APPLICATION_ID;

Line 2695: from fnd_product_installations fpi

2691:
2692: l_installed fnd_product_installations.status%type;
2693: cursor csr_ota_installed is
2694: select fpi.status
2695: from fnd_product_installations fpi
2696: where fpi.application_id = OTA_APPLICATION_ID;
2697:
2698: l_do_submit varchar2(10) := 'FALSE';
2699: