61: l_resp_appl_id NUMBER;
62: l_security_group_id NUMBER;
63:
64: BEGIN
65: SELECT fnd_profile.VALUE('ICX_FORMS_LAUNCHER')
66: INTO l_protocol_port
67: FROM dual;
68:
69: SELECT fnd_profile.VALUE('ICX_OA_HTML')
65: SELECT fnd_profile.VALUE('ICX_FORMS_LAUNCHER')
66: INTO l_protocol_port
67: FROM dual;
68:
69: SELECT fnd_profile.VALUE('ICX_OA_HTML')
70: INTO l_virtual_path
71: FROM dual;
72:
73: SELECT function_id
75: FROM fnd_form_functions
76: WHERE function_name = 'XLA_LINESINQ_FSAH_DRILLDOWN';
77:
78:
79: select SUBSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),1,INSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),'/',1,3))
80: into l_protocol_port_value
81: from dual;
82:
83: SELECT distinct