eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_SEQ_UTILS dependencies on FUN_SEQ_VERSIONS

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 842: FROM fun_seq_versions

838: SELECT last_updated_by,
839: last_update_date
840: INTO db_luby,
841: db_ludate
842: FROM fun_seq_versions
843: WHERE seq_header_id = p_seq_header_id
844: AND version_name = p_version_rec.version_name;
845: --
846: -- Update Version Name

Line 856: INTO fun_seq_versions (

852:
853: EXCEPTION
854: WHEN no_data_found THEN
855: INSERT
856: INTO fun_seq_versions (
857: seq_version_id,
858: seq_header_id,
859: version_name,
860: header_name,

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 924: l_header_name fun_seq_versions.header_name%TYPE;

920: show_exception('fun_seq_utils.create_version');
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;

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 929: l_max_number fun_seq_versions.initial_value%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:
931: l_module CONSTANT VARCHAR2(100) DEFAULT
932: g_module || '.' || 'recreate_version';
933: BEGIN

Line 1048: -- Update Database Sequence column of fun_seq_versions

1044: --
1045: ad_ddl.do_ddl(l_fnd_user, 'FUN', ad_ddl.create_sequence, l_sql_stmt, l_db_sequence_name);
1046:
1047: --
1048: -- Update Database Sequence column of fun_seq_versions
1049: --
1050: UPDATE fun_seq_versions
1051: SET db_sequence_name = l_db_sequence_name
1052: WHERE seq_version_id = p_seq_version_id;

Line 1050: UPDATE fun_seq_versions

1046:
1047: --
1048: -- Update Database Sequence column of fun_seq_versions
1049: --
1050: UPDATE fun_seq_versions
1051: SET db_sequence_name = l_db_sequence_name
1052: WHERE seq_version_id = p_seq_version_id;
1053: EXCEPTION
1054: WHEN OTHERS THEN

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

Line 1449: l_max_number fun_seq_versions.initial_value%TYPE;

1445: app_exception.raise_exception;
1446: END get_active_version;
1447:
1448: FUNCTION get_max_number RETURN NUMBER IS
1449: l_max_number fun_seq_versions.initial_value%TYPE;
1450: BEGIN
1451: SELECT max(TO_NUMBER(tb.batch_number))
1452: INTO l_max_number
1453: FROM fun_trx_batches tb