DBA Data[Home] [Help]

APPS.FND_FORM_FUNCTIONS_PKG dependencies on FND_LOAD_UTIL

Line 780: select decode(X_PARAMETERS, fnd_load_util.null_value, null,

776: end;
777:
778: -- Bug2662933 Get possible null values before calling UPDATE_ROW.
779:
780: select decode(X_PARAMETERS, fnd_load_util.null_value, null,
781: null, X_PARAMETERS, X_PARAMETERS),
782: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,
783: null, X_WEB_HOST_NAME, X_WEB_HOST_NAME),
784: decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,

Line 782: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,

778: -- Bug2662933 Get possible null values before calling UPDATE_ROW.
779:
780: select decode(X_PARAMETERS, fnd_load_util.null_value, null,
781: null, X_PARAMETERS, X_PARAMETERS),
782: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,
783: null, X_WEB_HOST_NAME, X_WEB_HOST_NAME),
784: decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,
785: null, X_WEB_AGENT_NAME, X_WEB_AGENT_NAME),
786: decode(X_WEB_HTML_CALL, fnd_load_util.null_value, null,

Line 784: decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,

780: select decode(X_PARAMETERS, fnd_load_util.null_value, null,
781: null, X_PARAMETERS, X_PARAMETERS),
782: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,
783: null, X_WEB_HOST_NAME, X_WEB_HOST_NAME),
784: decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,
785: null, X_WEB_AGENT_NAME, X_WEB_AGENT_NAME),
786: decode(X_WEB_HTML_CALL, fnd_load_util.null_value, null,
787: null, X_WEB_HTML_CALL, X_WEB_HTML_CALL),
788: decode(X_WEB_ENCRYPT_PARAMETERS, fnd_load_util.null_value, null,

Line 786: decode(X_WEB_HTML_CALL, fnd_load_util.null_value, null,

782: decode(X_WEB_HOST_NAME, fnd_load_util.null_value, null,
783: null, X_WEB_HOST_NAME, X_WEB_HOST_NAME),
784: decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,
785: null, X_WEB_AGENT_NAME, X_WEB_AGENT_NAME),
786: decode(X_WEB_HTML_CALL, fnd_load_util.null_value, null,
787: null, X_WEB_HTML_CALL, X_WEB_HTML_CALL),
788: decode(X_WEB_ENCRYPT_PARAMETERS, fnd_load_util.null_value, null,
789: null, X_WEB_ENCRYPT_PARAMETERS, X_WEB_ENCRYPT_PARAMETERS),
790: decode(X_WEB_SECURED, fnd_load_util.null_value, null,

Line 788: decode(X_WEB_ENCRYPT_PARAMETERS, fnd_load_util.null_value, null,

784: decode(X_WEB_AGENT_NAME, fnd_load_util.null_value, null,
785: null, X_WEB_AGENT_NAME, X_WEB_AGENT_NAME),
786: decode(X_WEB_HTML_CALL, fnd_load_util.null_value, null,
787: null, X_WEB_HTML_CALL, X_WEB_HTML_CALL),
788: decode(X_WEB_ENCRYPT_PARAMETERS, fnd_load_util.null_value, null,
789: null, X_WEB_ENCRYPT_PARAMETERS, X_WEB_ENCRYPT_PARAMETERS),
790: decode(X_WEB_SECURED, fnd_load_util.null_value, null,
791: null, X_WEB_SECURED, X_WEB_SECURED),
792: decode(X_WEB_ICON, fnd_load_util.null_value, null,

Line 790: decode(X_WEB_SECURED, fnd_load_util.null_value, null,

786: decode(X_WEB_HTML_CALL, fnd_load_util.null_value, null,
787: null, X_WEB_HTML_CALL, X_WEB_HTML_CALL),
788: decode(X_WEB_ENCRYPT_PARAMETERS, fnd_load_util.null_value, null,
789: null, X_WEB_ENCRYPT_PARAMETERS, X_WEB_ENCRYPT_PARAMETERS),
790: decode(X_WEB_SECURED, fnd_load_util.null_value, null,
791: null, X_WEB_SECURED, X_WEB_SECURED),
792: decode(X_WEB_ICON, fnd_load_util.null_value, null,
793: null, X_WEB_ICON, X_WEB_ICON),
794: decode(X_REGION_CODE, fnd_load_util.null_value, null,

Line 792: decode(X_WEB_ICON, fnd_load_util.null_value, null,

788: decode(X_WEB_ENCRYPT_PARAMETERS, fnd_load_util.null_value, null,
789: null, X_WEB_ENCRYPT_PARAMETERS, X_WEB_ENCRYPT_PARAMETERS),
790: decode(X_WEB_SECURED, fnd_load_util.null_value, null,
791: null, X_WEB_SECURED, X_WEB_SECURED),
792: decode(X_WEB_ICON, fnd_load_util.null_value, null,
793: null, X_WEB_ICON, X_WEB_ICON),
794: decode(X_REGION_CODE, fnd_load_util.null_value, null,
795: null, X_REGION_CODE, X_REGION_CODE),
796: decode(X_JRAD_REF_PATH, fnd_load_util.null_value, null,

Line 794: decode(X_REGION_CODE, fnd_load_util.null_value, null,

790: decode(X_WEB_SECURED, fnd_load_util.null_value, null,
791: null, X_WEB_SECURED, X_WEB_SECURED),
792: decode(X_WEB_ICON, fnd_load_util.null_value, null,
793: null, X_WEB_ICON, X_WEB_ICON),
794: decode(X_REGION_CODE, fnd_load_util.null_value, null,
795: null, X_REGION_CODE, X_REGION_CODE),
796: decode(X_JRAD_REF_PATH, fnd_load_util.null_value, null,
797: null, X_JRAD_REF_PATH, X_JRAD_REF_PATH)
798: into l_parameters, l_web_host_name, l_web_agent_name,

Line 796: decode(X_JRAD_REF_PATH, fnd_load_util.null_value, null,

792: decode(X_WEB_ICON, fnd_load_util.null_value, null,
793: null, X_WEB_ICON, X_WEB_ICON),
794: decode(X_REGION_CODE, fnd_load_util.null_value, null,
795: null, X_REGION_CODE, X_REGION_CODE),
796: decode(X_JRAD_REF_PATH, fnd_load_util.null_value, null,
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

Line 804: fnd_load_util.null_value, null,

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,
806: X_FORM_NAME) into l_form_name from dual;
807:
808: if (l_form_name is not null) then

Line 821: fnd_load_util.null_value, null,

817: else frm_id := null;
818: end if;
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

Line 837: fnd_load_util.null_value, null,

833: else obj_id := null;
834: end if;
835:
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:

Line 854: f_luby := fnd_load_util.owner_id(x_owner);

850: else rapp_id := null;
851: end if;
852:
853: -- Translate owner to file_last_updated_by
854: f_luby := fnd_load_util.owner_id(x_owner);
855:
856: -- Translate char last_update_date to date
857: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
858:

Line 864: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

860: into fun_id, db_luby, db_ludate
861: from fnd_form_functions
862: where function_name = X_FUNCTION_NAME;
863:
864: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
865: db_ludate, X_CUSTOM_MODE)) then
866: fnd_form_functions_pkg.UPDATE_ROW (
867: X_FUNCTION_ID => fun_id,
868: X_WEB_HOST_NAME => l_WEB_HOST_NAME,

Line 1057: f_luby := fnd_load_util.owner_id(x_owner);

1053: db_luby number; -- entity owner in db
1054: db_ludate date; -- entity update date in db
1055: begin
1056: -- Translate owner to file_last_updated_by
1057: f_luby := fnd_load_util.owner_id(x_owner);
1058:
1059: -- Translate char last_update_date to date
1060: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
1061:

Line 1068: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

1064: from FND_FORM_FUNCTIONS_TL
1065: where FUNCTION_ID = X_FUNCTION_ID
1066: and userenv('LANG') = LANGUAGE;
1067:
1068: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1069: db_ludate, X_CUSTOM_MODE)) then
1070: update FND_FORM_FUNCTIONS_TL set
1071: USER_FUNCTION_NAME = X_USER_FUNCTION_NAME,
1072: DESCRIPTION = X_DESCRIPTION,