APPS.FUN_SEQ_UTILS dependencies on FUN_SEQ_ASSIGNMENTS_S

Line 1223: fun_seq_assignments_s.NEXTVAL,

1219: creation_date,
1220: created_by,
1221: last_update_login)
1222: VALUES (
1223: fun_seq_assignments_s.NEXTVAL,
1224: p_seq_context_id,
1225: p_seq_header_id,
1226: NULL, -- Link to Assignment Id,
1227: NULL, -- Priority

Line 1319: FROM fun_seq_assignments sa,

1315: --
1316: SELECT sa.assignment_id
1317: BULK COLLECT
1318: INTO l_assign_id_tbl
1319: FROM fun_seq_assignments sa,
1320: fun_seq_contexts sc
1321: WHERE sc.seq_context_id = sa.seq_context_id
1322: AND sc.name = p_context_name
1323: AND sa.use_status_code = 'NEW'

Line 1330: FROM fun_seq_assignments sa

1326: -- Delete Versions
1327: --
1328: FORALL i IN l_assign_id_tbl.FIRST..l_assign_id_tbl.LAST
1329: DELETE
1330: FROM fun_seq_assignments sa
1331: WHERE sa.assignment_id = l_assign_id_tbl(i);
1332: --
1333: -- Lock Sequence Header
1334: --

Line 1340: FROM fun_seq_assignments sa

1336: INTO l_seq_context_id
1337: FROM fun_seq_contexts sc
1338: WHERE sc.name = p_context_name
1339: AND NOT EXISTS (SELECT 1
1340: FROM fun_seq_assignments sa
1341: WHERE sa.seq_context_id = sc.seq_context_id
1342: AND sa.use_status_code <> 'NEW')
1343: FOR UPDATE NOWAIT;
1344: --