DBA Data[Home] [Help]

APPS.XDP_MACROS SQL Statements

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

Line: 870

	INSERT INTO XDP_FE_CMD_AUD_TRAILS (
               created_by,
               creation_date,
               last_updated_by,
               last_update_date,
               last_update_login,
               fa_instance_id,
               fe_command_seq,
               fulfillment_element_name,
               fulfillment_element_type,
               sw_generic,
               command_sent,
               command_sent_date,
               response,
	       response_long,
               response_date,
               provisioning_procedure)
	VALUES (
	       FND_GLOBAL.USER_ID,
	       sysdate,
	       FND_GLOBAL.USER_ID,
	       sysdate,
	       FND_GLOBAL.LOGIN_ID,
               pv_FAInstanceID,
               XDP_FE_CMD_AUD_TRAILS_S.NEXTVAL,
               pv_FEName,
               pv_FeType,
               pv_SWGeneric,
               CommandSent,
               sysdate,
	       l_Response,
               Response,
               sysdate,
               pv_ProcName);
Line: 905

	INSERT INTO XDP_FE_CMD_AUD_TRAILS (
               created_by,
               creation_date,
               last_updated_by,
               last_update_date,
               last_update_login,
               fa_instance_id,
               fe_command_seq,
               fulfillment_element_name,
               fulfillment_element_type,
               sw_generic,
               command_sent,
               command_sent_date,
               response,
	       response_long,
               response_date,
               provisioning_procedure)
	VALUES (
	       FND_GLOBAL.USER_ID,
	       sysdate,
	       FND_GLOBAL.USER_ID,
	       sysdate,
	       FND_GLOBAL.LOGIN_ID,
               pv_FAInstanceID,
               XDP_FE_CMD_AUD_TRAILS_S.NEXTVAL,
               pv_FEName,
               pv_FeType,
               pv_SWGeneric,
               CommandSent,
               sysdate,
	       l_Response,
	       pv_ResponseLob,
               sysdate,
               pv_ProcName);
Line: 1042

  xdp_macros.g_ConnectCommands.delete;