The following lines contain the word 'select', 'insert', 'update' or 'delete':
| 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;
l_routine VARCHAR2(240):='Routine:QP_JAVA_ENGINE.INSERT_PROFS2_AT';
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');
G_PROFILE_NAMES.delete;
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)
);
/*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;
Insert_Profs2_AT(request_id, l_return_status,l_status_text);