APPS.FUN_SEQ_UTILS dependencies on FUN_SEQ_CONTEXTS_S

Line 687: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;

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

Line 1079: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;

1075: p_last_update_date IN VARCHAR2,
1076: p_custom_mode IN VARCHAR2,
1077: x_seq_context_id OUT NOCOPY NUMBER) IS
1078:
1079: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
1080: f_luby NUMBER; -- entity owner in file
1081: f_ludate DATE; -- entity update date in file
1082: db_luby NUMBER; -- entity owner in db
1083: db_ludate DATE; -- entity update date in db

Line 1139: fun_seq_contexts_s.NEXTVAL,

1135: creation_date,
1136: created_by,
1137: last_update_login)
1138: VALUES (
1139: fun_seq_contexts_s.NEXTVAL,
1140: p_context_rec.application_id,
1141: p_context_rec.table_name,
1142: p_context_rec.context_type,
1143: p_context_rec.context_value,

Line 1311: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;

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
1313: --
1314: -- Lock Assignments
1315: --

Line 1348: FROM fun_seq_contexts sc

1344: --
1345: -- Delelete Sequence Header
1346: --
1347: DELETE
1348: FROM fun_seq_contexts sc
1349: WHERE sc.seq_context_id = l_seq_context_id;
1350:
1351: EXCEPTION
1352: WHEN OTHERS THEN