APPS.FUN_SEQ_UTILS dependencies on FUN_SEQ_VERSIONS_S

Line 822: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;

818: p_owner IN VARCHAR2,
819: p_last_update_date IN VARCHAR2,
820: p_custom_mode IN VARCHAR2) IS
821:
822: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;
823:
824: l_module CONSTANT VARCHAR2(100) DEFAULT g_module || '.' || 'create_version';
825: f_luby NUMBER; -- entity owner in file
826: f_ludate DATE; -- entity update date in file

Line 873: fun_seq_versions_s.NEXTVAL, -- Sequence Version Id

869: creation_date,
870: created_by,
871: last_update_login)
872: VALUES(
873: fun_seq_versions_s.NEXTVAL, -- Sequence Version Id
874: p_seq_header_id,
875: p_version_rec.version_name,
876: p_header_name,
877: p_version_rec.initial_value,

Line 925: l_seq_header_id fun_seq_versions.seq_header_id%TYPE;

921: END create_version;
922:
923: PROCEDURE recreate_version IS
924: l_header_name fun_seq_versions.header_name%TYPE;
925: l_seq_header_id fun_seq_versions.seq_header_id%TYPE;
926: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;
927: l_obs_version_rec version_rec_type;
928: l_new_version_rec version_rec_type;
929: l_max_number fun_seq_versions.initial_value%TYPE;

Line 926: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;

922:
923: PROCEDURE recreate_version IS
924: l_header_name fun_seq_versions.header_name%TYPE;
925: l_seq_header_id fun_seq_versions.seq_header_id%TYPE;
926: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;
927: l_obs_version_rec version_rec_type;
928: l_new_version_rec version_rec_type;
929: l_max_number fun_seq_versions.initial_value%TYPE;
930:

Line 1255: fun_seq_versions.seq_version_id%TYPE INDEX BY BINARY_INTEGER;

1251: PROCEDURE delete_sequence (
1252: p_header_name IN VARCHAR2) IS
1253:
1254: TYPE seq_version_id_tbl_type IS TABLE OF
1255: fun_seq_versions.seq_version_id%TYPE INDEX BY BINARY_INTEGER;
1256:
1257: l_seq_ver_id_tbl seq_version_id_tbl_type;
1258: l_seq_header_id fun_seq_headers.seq_header_id%TYPE;
1259: BEGIN

Line 1266: FROM fun_seq_versions sv

1262: --
1263: SELECT sv.seq_version_id
1264: BULK COLLECT
1265: INTO l_seq_ver_id_tbl
1266: FROM fun_seq_versions sv
1267: WHERE sv.header_name = p_header_name
1268: AND sv.use_status_code = 'NEW'
1269: FOR UPDATE NOWAIT;
1270: --

Line 1275: FROM fun_seq_versions sv

1271: -- Delete Versions
1272: --
1273: FORALL i IN l_seq_ver_id_tbl.FIRST..l_seq_ver_id_tbl.LAST
1274: DELETE
1275: FROM fun_seq_versions sv
1276: WHERE sv.seq_version_id = l_seq_ver_id_tbl(i);
1277: --
1278: -- Lock Sequence Header
1279: --

Line 1285: FROM fun_seq_versions sv

1281: INTO l_seq_header_id
1282: FROM fun_seq_headers sh
1283: WHERE sh.header_name = p_header_name
1284: AND NOT EXISTS (SELECT 1
1285: FROM fun_seq_versions sv
1286: WHERE sv.seq_header_id = sh.seq_header_id
1287: AND sv.use_status_code <> 'NEW')
1288: FOR UPDATE NOWAIT;
1289: --

Line 1359: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;

1355:
1356: PROCEDURE obsolete_version (
1357: p_seq_version_id IN NUMBER) IS
1358:
1359: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;
1360: l_module CONSTANT VARCHAR2(100) DEFAULT
1361: g_module || '.' || 'obsolete_version';
1362: BEGIN
1363:

Line 1366: FROM fun_seq_versions sv

1362: BEGIN
1363:
1364: SELECT sv.seq_version_id
1365: INTO l_seq_version_id
1366: FROM fun_seq_versions sv
1367: WHERE sv.seq_version_id = p_seq_version_id
1368: FOR UPDATE NOWAIT;
1369:
1370: UPDATE fun_seq_versions sv

Line 1370: UPDATE fun_seq_versions sv

1366: FROM fun_seq_versions sv
1367: WHERE sv.seq_version_id = p_seq_version_id
1368: FOR UPDATE NOWAIT;
1369:
1370: UPDATE fun_seq_versions sv
1371: SET use_status_code = 'OBSOLETE'
1372: WHERE sv.seq_version_id = l_seq_version_id;
1373:
1374: EXCEPTION

Line 1425: FROM fun_seq_versions sv

1421: x_version_rec.initial_value,
1422: x_version_rec.current_value,
1423: x_version_rec.start_date,
1424: x_version_rec.end_date
1425: FROM fun_seq_versions sv
1426: WHERE sv.header_name = p_header_name
1427: AND sv.use_status_code IN ('USED','NEW');
1428: EXCEPTION
1429: WHEN NO_DATA_FOUND THEN