from调用from

 

1. 定义三个参数

 

 

 

编写 procedure 调用 from   （调用别的 from ）

 

  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;

 

要实现被别的 from 调用则需要在          ( 提供接口 )

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;

 

   

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27424626/viewspace-742071/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27424626/viewspace-742071/