174: l_conf_counter NUMBER;
175: BEGIN
176: SELECT nvl(task_confirmation_counter, 0)
177: INTO l_conf_counter
178: FROM jtf_tasks_b
179: WHERE task_id = p_task_id;
180:
181: RETURN l_conf_counter;
182: EXCEPTION
758: p_task_confirmation_counter
759: , jtf_task_utl.g_miss_number, task_confirmation_counter
760: , p_task_confirmation_counter
761: ) task_confirmation_counter
762: FROM jtf_tasks_b
763: WHERE task_id = p_task_id;
764:
765: tasks c_task%ROWTYPE;
766:
786: RAISE fnd_api.g_exc_unexpected_error;
787: END IF;
788:
789:
790: Update jtf_tasks_b set
791: task_confirmation_status = tasks.task_confirmation_status,
792: task_confirmation_counter = tasks.task_confirmation_counter
793: where task_id=p_task_id;
794: