[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT 1
FROM gl_movemerge_accounts p
WHERE movemerge_request_id = mm_id
AND line_number = lineno
AND (rowid <> row_id OR row_id IS NULL));
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT 1
FROM gl_movemerge_accounts p
WHERE movemerge_request_id = mm_id
AND (rowid <> row_id OR row_id IS NULL)
AND nvl(source_segment1, ' ') = nvl(ss1, ' ')
AND nvl(source_segment2, ' ') = nvl(ss2, ' ')
AND nvl(source_segment3, ' ') = nvl(ss3, ' ')
AND nvl(source_segment4, ' ') = nvl(ss4, ' ')
AND nvl(source_segment5, ' ') = nvl(ss5, ' ')
AND nvl(source_segment6, ' ') = nvl(ss6, ' ')
AND nvl(source_segment7, ' ') = nvl(ss7, ' ')
AND nvl(source_segment8, ' ') = nvl(ss8, ' ')
AND nvl(source_segment9, ' ') = nvl(ss9, ' ')
AND nvl(source_segment10,' ') = nvl(ss10,' ')
AND nvl(source_segment11,' ') = nvl(ss11,' ')
AND nvl(source_segment12,' ') = nvl(ss12,' ')
AND nvl(source_segment13,' ') = nvl(ss13,' ')
AND nvl(source_segment14,' ') = nvl(ss14,' ')
AND nvl(source_segment15,' ') = nvl(ss15,' ')
AND nvl(source_segment16,' ') = nvl(ss16,' ')
AND nvl(source_segment17,' ') = nvl(ss17,' ')
AND nvl(source_segment18,' ') = nvl(ss18,' ')
AND nvl(source_segment19,' ') = nvl(ss19,' ')
AND nvl(source_segment20,' ') = nvl(ss20,' ')
AND nvl(source_segment21,' ') = nvl(ss21,' ')
AND nvl(source_segment22,' ') = nvl(ss22,' ')
AND nvl(source_segment23,' ') = nvl(ss23,' ')
AND nvl(source_segment24,' ') = nvl(ss24,' ')
AND nvl(source_segment25,' ') = nvl(ss25,' ')
AND nvl(source_segment26,' ') = nvl(ss26,' ')
AND nvl(source_segment27,' ') = nvl(ss27,' ')
AND nvl(source_segment28,' ') = nvl(ss28,' ')
AND nvl(source_segment29,' ') = nvl(ss29,' ')
AND nvl(source_segment30,' ') = nvl(ss30,' '));
PROCEDURE pre_insert (mm_id IN NUMBER,
lineno IN NUMBER,
row_id IN CHAR ) IS
BEGIN
line_number_is_unique(mm_id, lineno, row_id);
END pre_insert;