APPS.PER_ASSIGNMENTS_F1_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 342: FROM hr_soft_coding_keyflex

338: --
339:
340: CURSOR csr_chk_scl is
341: SELECT null
342: FROM hr_soft_coding_keyflex
343: where soft_coding_keyflex_id = p_scl_id
344: and (concatenated_segments <> p_scl_concat
345: or concatenated_segments is null);
346: --

Line 358: FROM hr_soft_coding_keyflex

354: PRAGMA AUTONOMOUS_TRANSACTION;
355: --
356: CURSOR csr_scl_lock is
357: SELECT null
358: FROM hr_soft_coding_keyflex
359: where soft_coding_keyflex_id = p_scl_id
360: for update nowait;
361: --
362: l_exists varchar2(30);

Line 399: update hr_soft_coding_keyflex

395: --
396: -- Lock obtained by this transaction, updating the concatenated
397: -- segment string should be performed.
398: --
399: update hr_soft_coding_keyflex
400: set concatenated_segments = p_scl_concat
401: where soft_coding_keyflex_id = p_scl_id
402: and (concatenated_segments <> p_scl_concat
403: or concatenated_segments is null);

Line 479: -- field held on hr_soft_coding_keyflex table.

475: begin
476: if p_scl_id <> -1 then
477: --
478: -- This is an existing desc flex record, update concatenated_segments
479: -- field held on hr_soft_coding_keyflex table.
480: --
481: update hr_soft_coding_keyflex
482: set concatenated_segments = p_scl_concat
483: where soft_coding_keyflex_id = p_scl_id;

Line 481: update hr_soft_coding_keyflex

477: --
478: -- This is an existing desc flex record, update concatenated_segments
479: -- field held on hr_soft_coding_keyflex table.
480: --
481: update hr_soft_coding_keyflex
482: set concatenated_segments = p_scl_concat
483: where soft_coding_keyflex_id = p_scl_id;
484: --
485: if sql%rowcount = 0 then