PROCEDURE call_form. IS

    BEGIN

                fnd_function.EXECUTE(function_name  => 'HTST4279CONRHIST',

                                   open_flag      => 'Y',

                        session_flag   => 'Y',

                        other_params   => 'USER_ID = "' || :QUERY_FIND.USER_ID ||

                                             '" REQ_DATE_FROM = "'                                                      || :QUERY_FIND.TRANSACTION_DATE_FROM ||

                                             '" REQ_DATE_TO = "' || :QUERY_FIND.TRANSACTION_DATE_TO || '"');

    END call_form;

fre-from 中：

IF :parameter.user_id IS NOT NULL AND

                       :parameter.req_date_from IS NOT NULL AND

                       :parameter.req_date_to IS NOT NULL THEN

                        select  user_name

                        into    :QUERY_FIND.REQUESTOR

                        from    fnd_user

                        where   user_id = :parameter.user_id;

                        COPY(NAME_IN('parameter.user_id'), 'QUERY_FIND.USER_ID');

                        COPY(NAME_IN('parameter.req_date_from'), 'QUERY_FIND.TRANSACTION_DATE_FROM');

                        COPY(NAME_IN('parameter.req_date_to'), 'QUERY_FIND.TRANSACTION_DATE_TO');

END IF;

when-new-from-instence 中：

IF :parameter.user_id IS NOT NULL AND

   :parameter.req_date_from IS NOT NULL AND

   :parameter.req_date_to IS NOT NULL THEN

                      query_find.btn_find;

 END IF;