APPS.WMS_CUSTAPI_CONC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 135

Procedure create_delete_api_calls(
   errbuf                 out NOCOPY varchar2
,  retcode                out NOCOPY number
,  p_hook_short_name_id   in  number
,  p_call_package      	  in  varchar2
,  p_call_procedure       in  varchar2
,  p_call_description     in  varchar2
,  p_effective_to_date 	  in  varchar2
,  p_mode                 in  varchar2
) is

  l_proc       varchar2(72) := 'CREATE_DELETE_API_CALLS :';

Line: 154

      trace(l_proc ||' Entering procedure create_delete_api_calls  '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);

Line: 162

      trace(l_proc ||' Before calling "wms_atf_reg_cust_apis.create_delete_api_calls"....', 1);

Line: 165

   wms_atf_reg_cust_apis.create_delete_api_call(
       p_hook_short_name_id  =>  p_hook_short_name_id
   ,   p_call_package        =>  p_call_package
   ,   p_call_procedure      =>  p_call_procedure
   ,   p_call_description    =>  p_call_description
   ,   p_effective_to_date   =>  FND_DATE.canonical_to_date(p_effective_to_date)
   ,   p_mode                =>  p_mode
   ,   x_retcode             =>  retcode
   ,   x_errbuf              =>  errbuf
   );

Line: 177

      trace(l_proc ||' After calling "wms_atf_reg_cust_apis.create_delete_api_calls"....', 1);

Line: 183

      trace(l_proc ||' Exiting procedure create_delete_api_call  '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);

Line: 185

end create_delete_api_calls;