APPS.FUN_SEQ_UTILS dependencies on FUN_SEQ_CONTEXTS

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 1099: FROM fun_seq_contexts

1095: INTO
1096: x_seq_context_id,
1097: db_luby,
1098: db_ludate
1099: FROM fun_seq_contexts
1100: WHERE application_id = p_context_rec.application_id
1101: AND table_name = p_context_rec.table_name
1102: AND context_type = p_context_rec.context_type
1103: AND context_value = p_context_rec.context_value

Line 1111: UPDATE fun_seq_contexts

1107: -- Update Sequencing Context Name
1108: --
1109: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1110: db_ludate, p_custom_mode)) THEN
1111: UPDATE fun_seq_contexts
1112: SET name = p_context_rec.NAME
1113: WHERE seq_context_id = x_seq_context_id
1114: AND inactive_date IS NULL;
1115: END IF;

Line 1120: INTO fun_seq_contexts (

1116:
1117: EXCEPTION
1118: WHEN no_data_found THEN
1119: INSERT
1120: INTO fun_seq_contexts (
1121: seq_context_id,
1122: application_id,
1123: table_name,
1124: context_type,

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 1320: fun_seq_contexts sc

1316: SELECT sa.assignment_id
1317: BULK COLLECT
1318: INTO l_assign_id_tbl
1319: FROM fun_seq_assignments sa,
1320: fun_seq_contexts sc
1321: WHERE sc.seq_context_id = sa.seq_context_id
1322: AND sc.name = p_context_name
1323: AND sa.use_status_code = 'NEW'
1324: FOR UPDATE NOWAIT;

Line 1337: FROM fun_seq_contexts sc

1333: -- Lock Sequence Header
1334: --
1335: SELECT sc.seq_context_id
1336: INTO l_seq_context_id
1337: FROM fun_seq_contexts sc
1338: WHERE sc.name = p_context_name
1339: AND NOT EXISTS (SELECT 1
1340: FROM fun_seq_assignments sa
1341: WHERE sa.seq_context_id = sc.seq_context_id

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