APPS.QP_JAVA_ENGINE SQL Statements

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

Line: 13

  | PROCEDURE insert_profs2_AT
  | This procedure insert profile name/value pairs into interface table
  | qp_int_prof_t using AUTONOMONOUS TRANSACTION
  +----------------------------------------------------------------------
*/
PROCEDURE Insert_Profs2_AT(
              p_request_id IN NUMBER,
              x_status_code                 OUT NOCOPY VARCHAR2,
              x_status_text                 OUT NOCOPY VARCHAR2)
AS
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 24

 l_routine VARCHAR2(240):='Routine:QP_JAVA_ENGINE.INSERT_PROFS2_AT';

Line: 27

select PROFILE_OPTION_NAME
from FND_PROFILE_OPTIONS
where (APPLICATION_ID = 661 or
       PROFILE_OPTION_NAME = 'ORG_ID') and
 START_DATE_ACTIVE <=sysdate and
 nvl(END_DATE_ACTIVE,sysdate) >= sysdate and
 (APP_ENABLED_FLAG <> 'N' or
  RESP_ENABLED_FLAG <>'N' or
  USER_ENABLED_FLAG <>'N');

Line: 49

  G_PROFILE_NAMES.delete;

Line: 74

INSERT INTO QP_INT_PROFS_T
( REQUEST_ID,
  PROFILE_OPTION_NAME,
 PROFILE_OPTION_VALUE)
VALUES ( p_request_id,
         --l_profile_names(i),
         --FND_PROFILE.value(l_profile_names(i))
         G_PROFILE_NAMES(i),
         G_PROFILE_VALUES(i)
            );

Line: 165

  /*TEMP_TABLE_INSERT_FLAG,PUBLIC_API_CALL_FLAG from p_control_rec not passed*/
  p_control_pattern := p_control_rec.PRICING_EVENT||G_PATN_SEPERATOR;

Line: 241

  Insert_Profs2_AT(request_id, l_return_status,l_status_text);