APPS.XDP_NOTIFICATIONS SQL Statements

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

Line: 55

Procedure Get_WI_Update_URL(
        p_workitem_instance_id IN NUMBER,
        p_order_id             IN NUMBER,
        p_itemtype             IN VARCHAR2,
        p_itemkey              IN VARCHAR2,
        x_url                 OUT NOCOPY VARCHAR2)
IS
l_click_here VARCHAR2(30);

Line: 75

      FND_MESSAGE.SET_TOKEN('TO_UPDATE_WI_PARAM',l_text);

Line: 81

END Get_WI_Update_URL;

Line: 130

  SAVEPOINT FMC_UPDATE;

Line: 131

  select XDP_FMC_ID_S.NextVal
	into lv_fmc_id from dual;

Line: 135

    select fe_id into lv_fe_id
    from xdp_fa_runtime_list
    where fa_instance_id = p_fa_instance_id;

Line: 148

  INSERT INTO XDP_FMC_AUDIT_TRAILS(
	 created_by,
	 creation_date,
	 last_updated_by,
	 last_update_date,
	 last_update_login,
  	 fmc_id,
	 workitem_instance_id,
     fmc_response_code,
	 wf_item_type,
	 wf_item_key,
	 fe_name,
     sw_generic)
   VALUES(
	 FND_GLOBAL.USER_ID,
	 sysdate,
	 FND_GLOBAL.USER_ID,
	 sysdate,
	 FND_GLOBAL.LOGIN_ID,
	 lv_fmc_id,
	 p_workitem_instance_id,
	 p_response,
	 p_workflow_item_type,
	 p_workflow_itemkey,
	 lv_fe_name,
	 lv_sw_generic
	);

Line: 185

	 insert into XDP_FMC_AUD_TRAIL_DETS(
	 	created_by,
	 	creation_date,
	 	last_updated_by,
	 	last_update_date,
	 	last_update_login,
		fmc_id,
 		parameter_name,
		parameter_type,
		value,
		retry_value)
	 values (
	 	FND_GLOBAL.USER_ID,
	 	sysdate,
	 	FND_GLOBAL.USER_ID,
	 	sysdate,
	 	FND_GLOBAL.LOGIN_ID,
		lv_fmc_id,
		p_order_retry_params(lv_param_index).parameter_name,
		'ORDER',
		p_order_retry_params(lv_param_index).param_previous_val,
		p_order_retry_params(lv_param_index).param_retry_val);

Line: 221

	 insert into XDP_FMC_AUD_TRAIL_DETS(
	 	created_by,
	 	creation_date,
	 	last_updated_by,
	 	last_update_date,
	 	last_update_login,
		fmc_id,
 		parameter_name,
		parameter_type,
		value,
		retry_value)
	 values (
	 	FND_GLOBAL.USER_ID,
	 	sysdate,
	 	FND_GLOBAL.USER_ID,
	 	sysdate,
	 	FND_GLOBAL.LOGIN_ID,
		lv_fmc_id,
		p_workitem_retry_params(lv_param_index).parameter_name,
		'WORKITEM',
		p_workitem_retry_params(lv_param_index).param_previous_val,
		p_workitem_retry_params(lv_param_index).param_retry_val);

Line: 257

	 insert into XDP_FMC_AUD_TRAIL_DETS(
	 	created_by,
	 	creation_date,
	 	last_updated_by,
	 	last_update_date,
	 	last_update_login,
		fmc_id,
 		parameter_name,
		parameter_type,
		value,
		retry_value)
	 values (
	 	FND_GLOBAL.USER_ID,
	 	sysdate,
	 	FND_GLOBAL.USER_ID,
	 	sysdate,
	 	FND_GLOBAL.LOGIN_ID,
		lv_fmc_id,
		p_fa_retry_params(lv_param_index).parameter_name,
		'FA',
		p_fa_retry_params(lv_param_index).param_previous_val,
		p_fa_retry_params(lv_param_index).param_retry_val);

Line: 288

	ROLLBACK  TO SAVEPOINT FMC_UPDATE;

Line: 314

	select fmc_id,fmc_response_code
	from xdp_fmc_audit_trails
	where
	  workitem_instance_id = p_workitem_instance_id
	order by fmc_id desc;

Line: 321

	select parameter_name,value,retry_value,parameter_type
	from XDP_FMC_AUD_TRAIL_DETS
	where fmc_id = l_fmc_id;

Line: 339

	select fwt.order_id,
		line_item_name,
		DECODE(olm.workitem_id,NULL,NULL,line_item_name),
		olm.line_item_action_code,
		olm.version
	into
		p_order_id,
		p_service_name,
		p_workitem_name,
		p_action_code,
		p_service_version
	from
		XDP_FULFILL_WORKLIST fwt,
		xdp_order_line_items olm
	where
		fwt.workitem_instance_id = p_workitem_instance_id and
		fwt.line_item_id = olm.line_item_id;