APPS.PER_ASSIGNMENTS_F1_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 378: FROM hr_soft_coding_keyflex

374: --
375:
376: CURSOR csr_chk_scl is
377: SELECT null
378: FROM hr_soft_coding_keyflex
379: where soft_coding_keyflex_id = p_scl_id
380: and (concatenated_segments <> p_scl_concat
381: or concatenated_segments is null);
382: --

Line 394: FROM hr_soft_coding_keyflex

390: PRAGMA AUTONOMOUS_TRANSACTION;
391: --
392: CURSOR csr_scl_lock is
393: SELECT null
394: FROM hr_soft_coding_keyflex
395: where soft_coding_keyflex_id = p_scl_id
396: for update nowait;
397: --
398: l_exists varchar2(30);

Line 435: update hr_soft_coding_keyflex

431: --
432: -- Lock obtained by this transaction, updating the concatenated
433: -- segment string should be performed.
434: --
435: update hr_soft_coding_keyflex
436: set concatenated_segments = p_scl_concat
437: where soft_coding_keyflex_id = p_scl_id
438: and (concatenated_segments <> p_scl_concat
439: or concatenated_segments is null);

Line 499: update hr_soft_coding_keyflex

495: open csr_chk_scl;
496: fetch csr_chk_scl into l_exists;
497: if csr_chk_scl%found then
498: close csr_chk_scl;
499: update hr_soft_coding_keyflex
500: set concatenated_segments = p_scl_concat
501: where soft_coding_keyflex_id = p_scl_id
502: and (concatenated_segments <> p_scl_concat
503: or concatenated_segments is null);

Line 532: -- field held on hr_soft_coding_keyflex table.

528: begin
529: if p_scl_id <> -1 then
530: --
531: -- This is an existing desc flex record, update concatenated_segments
532: -- field held on hr_soft_coding_keyflex table.
533: --
534: update hr_soft_coding_keyflex
535: set concatenated_segments = p_scl_concat
536: where soft_coding_keyflex_id = p_scl_id;

Line 534: update hr_soft_coding_keyflex

530: --
531: -- This is an existing desc flex record, update concatenated_segments
532: -- field held on hr_soft_coding_keyflex table.
533: --
534: update hr_soft_coding_keyflex
535: set concatenated_segments = p_scl_concat
536: where soft_coding_keyflex_id = p_scl_id;
537: --
538: if sql%rowcount = 0 then