APPS.FUN_SEQ_UTILS dependencies on FUN_SEQ_HEADERS

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 763: FROM fun_seq_headers

759: last_update_date
760: INTO x_seq_header_id,
761: db_luby,
762: db_ludate
763: FROM fun_seq_headers
764: WHERE header_name = p_sequence_rec.header_name;
765:
766: --
767: -- Update Description if allowed

Line 771: UPDATE fun_seq_headers

767: -- Update Description if allowed
768: --
769: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
770: db_ludate, p_custom_mode)) THEN
771: UPDATE fun_seq_headers
772: SET description = p_sequence_rec.description,
773: last_updated_by = f_luby,
774: last_update_date = f_ludate,
775: last_update_login = 0

Line 786: INTO fun_seq_headers (

782: --
783: EXCEPTION
784: WHEN no_data_found THEN
785: INSERT
786: INTO fun_seq_headers (
787: seq_header_id,
788: header_name,
789: gapless_flag,
790: description,

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;