APPS.FUN_SEQ_UTILS dependencies on FUN_SEQ_ASSIGNMENTS

Line 1171: l_assignment_id fun_seq_assignments.assignment_id%TYPE;

1167: p_owner IN VARCHAR2,
1168: p_last_update_date IN VARCHAR2,
1169: p_custom_mode IN VARCHAR2) IS
1170:
1171: l_assignment_id fun_seq_assignments.assignment_id%TYPE;
1172: f_luby NUMBER; -- entity owner in file
1173: f_ludate DATE; -- entity update date in file
1174: db_luby NUMBER; -- entity owner in db
1175: db_ludate DATE; -- entity update date in db

Line 1191: FROM fun_seq_assignments

1187: INTO
1188: l_assignment_id,
1189: db_luby,
1190: db_ludate
1191: FROM fun_seq_assignments
1192: WHERE seq_context_id = p_seq_context_id
1193: AND use_status_code <> 'OBSOLETE';
1194: --
1195: -- Create a record

Line 1200: INTO fun_seq_assignments (

1196: --
1197: EXCEPTION
1198: WHEN no_data_found THEN
1199: INSERT
1200: INTO fun_seq_assignments (
1201: assignment_id,
1202: seq_context_id,
1203: seq_header_id,
1204: link_to_assignment_id,

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 1308: fun_seq_assignments.assignment_id%TYPE INDEX BY BINARY_INTEGER;

1304: PROCEDURE delete_context (
1305: p_context_name IN VARCHAR2) IS
1306:
1307: TYPE assign_id_tbl_type IS TABLE OF
1308: fun_seq_assignments.assignment_id%TYPE INDEX BY BINARY_INTEGER;
1309:
1310: l_assign_id_tbl assign_id_tbl_type;
1311: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
1312: BEGIN

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: --