[Home] [Help]
251: x_return_status := fnd_api.g_ret_sts_success;
252: SAVEPOINT delete_sales_methodology_pvt;
253:
254: -- Delete the sales stage mapping for the sales methdology first
255: DELETE FROM AS_SALES_METH_STAGE_MAP
256: WHERE SALES_METHODOLOGY_ID = P_SALES_METHODOLOGY_ID;
257:
258: -- call table handler to insert into jtf_tasks_temp_groups
259: as_sales_methodology_pkg.delete_row (p_sales_methodology_id);
314: X_MSG_COUNT OUT NOCOPY NUMBER,
315: X_MSG_DATA OUT NOCOPY VARCHAR2
316: )
317: IS
318: CURSOR C IS SELECT ROWID FROM AS_SALES_METH_STAGE_MAP
319: WHERE SALES_METHODOLOGY_ID = P_SALES_METHODOLOGY_ID
320: AND SALES_STAGE_ID = P_SALES_STAGE_ID;
321:
322: l_api_name VARCHAR2(30) := 'ADD_SALES_STAGE_MAP';
325: x_return_status := fnd_api.g_ret_sts_success;
326: SAVEPOINT add_sales_stage_map_pvt;
327:
328: -- Try updating the AS_SALES_METH_MAP table.
329: UPDATE as_sales_meth_stage_map SET
330: task_template_group_id = p_task_template_group_id,
331: max_win_probability = p_max_win_probability,
332: min_win_probability = p_min_win_probability,
333: template_id = p_sales_supplement_template,
341: sales_stage_id = p_sales_stage_id;
342:
343: -- if the row was not found for update, insert it.
344: IF (SQL%NOTFOUND) THEN
345: INSERT INTO as_sales_meth_stage_map (
346: sales_methodology_id,
347: sales_stage_id,
348: task_template_group_id,
349: max_win_probability,
434: x_return_status := fnd_api.g_ret_sts_success;
435: SAVEPOINT delete_sm_stage_map_pvt;
436:
437: -- Try updating the AS_SALES_METH_MAP table.
438: DELETE FROM as_sales_meth_stage_map
439: WHERE
440: sales_methodology_id = p_sales_methodology_id
441: AND
442: sales_stage_id = p_sales_stage_id;