APPS.FUN_SEQ_UTILS dependencies on FUN_SEQ_HEADERS_S

Line 686: l_seq_header_id fun_seq_headers.seq_header_id%TYPE;

682: p_owner IN VARCHAR2,
683: p_last_update_date IN VARCHAR2,
684: p_custom_mode IN VARCHAR2) IS
685:
686: l_seq_header_id fun_seq_headers.seq_header_id%TYPE;
687: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
688: BEGIN
689: --
690: -- Delete Existing Records if their status is New

Line 799: fun_seq_headers_s.NEXTVAL, -- Sequence Header Id

795: creation_date,
796: created_by,
797: last_update_login)
798: VALUES (
799: fun_seq_headers_s.NEXTVAL, -- Sequence Header Id
800: p_sequence_rec.header_name, -- Name
801: p_sequence_rec.gapless, -- Type (Gapless)
802: p_sequence_rec.description, -- Description
803: 'N', -- Obsolete Flag

Line 1258: l_seq_header_id fun_seq_headers.seq_header_id%TYPE;

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
1260: --
1261: -- Lock Sequence Versions
1262: --

Line 1282: FROM fun_seq_headers sh

1278: -- Lock Sequence Header
1279: --
1280: SELECT sh.seq_header_id
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

Line 1293: FROM fun_seq_headers sh

1289: --
1290: -- Delelete Sequence Header
1291: --
1292: DELETE
1293: FROM fun_seq_headers sh
1294: WHERE sh.seq_header_id = l_seq_header_id;
1295: EXCEPTION
1296: WHEN OTHERS THEN
1297: ROLLBACK;