DBA Data[Home] [Help]

APPS.QP_OA_DELAYED_REQUESTS_PVT SQL Statements

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

Line: 9

PROCEDURE insert_msg (l_request system.QP_FWK_DELAYED_REQ_REC_OBJECT,
                      l_return_status varchar2) as
 pragma AUTONOMOUS_TRANSACTION;
Line: 14

  INSERT INTO qp_fwk_delayed_requests(
   request_type,
   entity_id,
   entity_code,
   status,
   request_unique_key1,
   request_unique_key2,
   request_unique_key3,
   request_unique_key4,
   request_unique_key5,
   param1,
   param2,
   param3,
   param4,
   param5,
   param6,
   param7,
   param8,
   param9,
   param10,
   param11,
   param12,
   param13,
   param14,
   param15,
   param16,
   param17,
   param18,
   param19,
   param20,
   param21,
   param22,
   param23,
   param24,
   param25,
   long_param1)
  VALUES(
   l_request.request_type ,
   l_request.entity_id,
   l_request.entity_code,
   l_return_status,
   l_request.request_unique_key1,
   l_request.request_unique_key2,
   l_request.request_unique_key3,
   l_request.request_unique_key4,
   l_request.request_unique_key5,
   l_request.param1,
   l_request.param2,
   l_request.param3,
   l_request.param4,
   l_request.param5,
   l_request.param6,
   l_request.param7,
   l_request.param8,
   l_request.param9,
   l_request.param10,
   l_request.param11,
   l_request.param12,
   l_request.param13,
   l_request.param14,
   l_request.param15,
   l_request.param16,
   l_request.param17,
   l_request.param18,
   l_request.param19,
   l_request.param20,
   l_request.param21,
   l_request.param22,
   l_request.param23,
   l_request.param24,
   l_request.param25,
   l_request.long_param1);
Line: 89

END insert_msg;
Line: 172

   insert_msg(l_request,l_return_status);
Line: 174

   /*insert into del_request_test values(l_request.request_type,l_request.entity_id,
                                         l_request.entity_code, l_return_status);*/