[Home] [Help]
797: null, X_JRAD_REF_PATH, X_JRAD_REF_PATH)
798: into l_parameters, l_web_host_name, l_web_agent_name,
799: l_web_html_call, l_web_encrypt_parameters, l_web_secured,
800: l_web_icon, l_region_code, L_JRAD_REF_PATH
801: from dual;
802:
803: select decode(X_FORM_NAME,
804: fnd_load_util.null_value, null,
805: null, X_FORM_NAME,
802:
803: select decode(X_FORM_NAME,
804: fnd_load_util.null_value, null,
805: null, X_FORM_NAME,
806: X_FORM_NAME) into l_form_name from dual;
807:
808: if (l_form_name is not null) then
809: begin
810: select form_id into frm_id
819:
820: select decode(X_OBJECT_NAME,
821: fnd_load_util.null_value, null,
822: null, X_OBJECT_NAME,
823: X_OBJECT_NAME) into l_object_name from dual;
824:
825: if (l_object_name is not null) then
826: begin
827: select object_id into obj_id
836: select decode(X_REGION_APPLICATION_NAME,
837: fnd_load_util.null_value, null,
838: null, X_REGION_APPLICATION_NAME,
839: X_REGION_APPLICATION_NAME)
840: into l_region_application_name from dual;
841:
842: if (l_region_application_name is not null) then
843: begin
844: select application_id into rapp_id
891:
892: exception
893: when NO_DATA_FOUND then
894:
895: select fnd_form_functions_s.nextval into fun_id from dual;
896:
897: fnd_form_functions_pkg.INSERT_ROW(
898: X_ROWID => row_id,
899: X_FUNCTION_ID => fun_id,
1515:
1516: -- Validate the function maintenance mode
1517: begin
1518: select 1 into valid_mode
1519: from dual
1520: where x_function_mode in (
1521: select lv.lookup_code
1522: from fnd_lookup_values lv
1523: where lv.lookup_type = 'APPS_MAINTENANCE_MODE_SUPPORT'