326: IS
327: CURSOR c_synctask
328: IS
329: SELECT task_id
330: FROM jta_sync_task_mapping
331: WHERE task_sync_id = p_sync_id;
332:
333: l_task_id NUMBER;
334: BEGIN
511: IS
512: CURSOR c_task_sync
513: IS
514: SELECT task_id
515: FROM jta_sync_task_mapping
516: WHERE task_sync_id = p_sync_id;
517:
518: l_task_id NUMBER;
519: BEGIN
741: IF (p_operation = g_new)
742: THEN
743: IF x_task_sync_id IS NULL
744: THEN
745: SELECT jta_sync_task_mapping_s.nextval
746: INTO x_task_sync_id
747: FROM dual;
748: END IF;
749:
3484: RETURN BOOLEAN
3485: IS
3486: CURSOR c_mapping (b_syncid NUMBER) IS
3487: SELECT 1
3488: FROM jta_sync_task_mapping
3489: WHERE task_sync_id = b_syncid;
3490:
3491: l_dummy NUMBER;
3492: l_valid BOOLEAN := TRUE;