eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_BENEFIT_ACTIONS

Line 561: -- This is procedure to delete all orphan child records of BEN_BENEFIT_ACTIONS

557: -- ----------------------------------------------------------------------------
558: -- |-------------------------< delete_benefit_actions >--------------------------|
559: -- ----------------------------------------------------------------------------
560: --
561: -- This is procedure to delete all orphan child records of BEN_BENEFIT_ACTIONS
562: -- and then records of BEN_BENEFIT_ACTIONS itself where deleted person_id is directly
563: -- referenced.
564: -- Hierarchy to use
565: --

Line 562: -- and then records of BEN_BENEFIT_ACTIONS itself where deleted person_id is directly

558: -- |-------------------------< delete_benefit_actions >--------------------------|
559: -- ----------------------------------------------------------------------------
560: --
561: -- This is procedure to delete all orphan child records of BEN_BENEFIT_ACTIONS
562: -- and then records of BEN_BENEFIT_ACTIONS itself where deleted person_id is directly
563: -- referenced.
564: -- Hierarchy to use
565: --
566: -- BEN_BENEFIT_ACTIONS

Line 566: -- BEN_BENEFIT_ACTIONS

562: -- and then records of BEN_BENEFIT_ACTIONS itself where deleted person_id is directly
563: -- referenced.
564: -- Hierarchy to use
565: --
566: -- BEN_BENEFIT_ACTIONS
567: -- BEN_BATCH_ACTN_ITEM_INFO
568: -- BEN_BATCH_BNFT_CERT_INFO
569: -- BEN_BATCH_COMMU_INFO
570: -- BEN_BATCH_DPNT_INFO

Line 588: FROM ben_benefit_actions a

584: --
585: cursor c1 is
586: SELECT /*+ PARALLEL(A) */
587: DISTINCT benefit_action_id
588: FROM ben_benefit_actions a
589: WHERE a.person_id IS NOT NULL
590: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
591: FROM per_all_people_f per);
592: --

Line 669: DELETE FROM ben_benefit_actions

665: --
666: ben_batch_utils.write(p_text => 'BEN_REPORTING : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
667: --
668: FORALL i IN 1..l_data.COUNT
669: DELETE FROM ben_benefit_actions
670: WHERE benefit_action_id = l_data(i);
671: --
672: ben_batch_utils.write(p_text => 'BEN_BENEFIT_ACTIONS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
673: --

Line 672: ben_batch_utils.write(p_text => 'BEN_BENEFIT_ACTIONS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

668: FORALL i IN 1..l_data.COUNT
669: DELETE FROM ben_benefit_actions
670: WHERE benefit_action_id = l_data(i);
671: --
672: ben_batch_utils.write(p_text => 'BEN_BENEFIT_ACTIONS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
673: --
674: EXIT WHEN c1%NOTFOUND;
675: --
676: end loop;

Line 1175: ben_benefit_actions_api.create_perf_benefit_actions

1171: l_parent_request_id := fnd_global.conc_request_id;
1172: --
1173: -- Create a new benefit_action row.
1174: --
1175: ben_benefit_actions_api.create_perf_benefit_actions
1176: (p_validate => FALSE
1177: ,p_benefit_action_id => l_benefit_action_id
1178: ,p_process_date => l_effective_date
1179: ,p_mode_cd => 'S'