APPS.XDP_NOTIFICATIONS dependencies on XDP_FMC_AUD_TRAIL_DETS

Line 185: insert into XDP_FMC_AUD_TRAIL_DETS(

181: p_order_id => p_order_id,
182: p_parameter_name =>p_order_retry_params(lv_param_index).parameter_name,
183: p_parameter_value => p_order_retry_params(lv_param_index).param_retry_val);
184:
185: insert into XDP_FMC_AUD_TRAIL_DETS(
186: created_by,
187: creation_date,
188: last_updated_by,
189: last_update_date,

Line 221: insert into XDP_FMC_AUD_TRAIL_DETS(

217: p_wi_instance_id => p_workitem_instance_id,
218: p_parameter_name =>p_workitem_retry_params(lv_param_index).parameter_name,
219: p_parameter_value => p_workitem_retry_params(lv_param_index).param_retry_val);
220:
221: insert into XDP_FMC_AUD_TRAIL_DETS(
222: created_by,
223: creation_date,
224: last_updated_by,
225: last_update_date,

Line 257: insert into XDP_FMC_AUD_TRAIL_DETS(

253: p_fa_instance_id => p_fa_instance_id,
254: p_parameter_name =>p_fa_retry_params(lv_param_index).parameter_name,
255: p_parameter_value => p_fa_retry_params(lv_param_index).param_retry_val);
256:
257: insert into XDP_FMC_AUD_TRAIL_DETS(
258: created_by,
259: creation_date,
260: last_updated_by,
261: last_update_date,

Line 322: from XDP_FMC_AUD_TRAIL_DETS

318: order by fmc_id desc;
319:
320: CURSOR lc_last_params(l_fmc_id number) IS
321: select parameter_name,value,retry_value,parameter_type
322: from XDP_FMC_AUD_TRAIL_DETS
323: where fmc_id = l_fmc_id;
324: lv_fmc_id NUMBER := NULL;
325: lv_ord_index BINARY_INTEGER := 0;
326: lv_wi_index BINARY_INTEGER := 0;