APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on BEN_PERSON_ACTIONS

Line 444: FROM ben_person_actions ben

440: , ben.person_action_id
441: , ben.object_version_number
442: , ben.ler_id
443: , ben.non_person_cd
444: FROM ben_person_actions ben
445: WHERE ben.benefit_action_id = v_benefit_action_id
446: AND ben.action_status_cd <> 'P'
447: AND ben.person_action_id BETWEEN v_start_person_action_id AND v_end_person_action_id
448: ORDER BY ben.person_action_id;

Line 632: FROM ben_person_actions act

628: CURSOR c_actions (v_benefit_action_id IN NUMBER)
629: IS
630: SELECT COUNT (*) amount
631: , action_status_cd
632: FROM ben_person_actions act
633: WHERE act.benefit_action_id = v_benefit_action_id
634: AND act.action_status_cd IN ('P', 'E', 'U')
635: GROUP BY action_status_cd;
636:

Line 1346: INSERT INTO ben_person_actions

1342: g_proc := 'insert_person_actions';
1343: write('Time before inserting person actions '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
1344: FORALL l_count IN 1 .. p_per_actn_id_array.COUNT
1345: --
1346: INSERT INTO ben_person_actions
1347: (person_action_id
1348: , person_id
1349: , ler_id
1350: , benefit_action_id

Line 3845: ben_person_actions_api.update_person_actions

3841: write_h ('||Person Action id ' || p_person_action_id);
3842: write_h ('||p_object_version_number ' || p_object_version_number);
3843: write_h ('||p_effective_date ' || p_effective_date);
3844: write_h ('================================================================');
3845: ben_person_actions_api.update_person_actions
3846: (p_person_action_id => p_person_action_id
3847: , p_action_status_cd => 'P'
3848: , p_object_version_number => p_object_version_number
3849: , p_effective_date => p_effective_date

Line 3868: ben_person_actions_api.update_person_actions

3864: ben_batch_utils.rpt_error (p_proc => g_proc, p_last_actn => g_actn, p_rpt_flag => TRUE);
3865:
3866: IF p_person_action_id IS NOT NULL
3867: THEN
3868: ben_person_actions_api.update_person_actions
3869: (p_person_action_id => p_person_action_id
3870: , p_action_status_cd => 'E'
3871: , p_object_version_number => p_object_version_number
3872: , p_effective_date => p_effective_date

Line 4351: SELECT ben_person_actions_s.NEXTVAL

4347: l_person_ids.EXTEND (1);
4348: l_per_in_ler_ids.EXTEND (1);
4349: l_is_placeholder.EXTEND (1);
4350:
4351: SELECT ben_person_actions_s.NEXTVAL
4352: INTO l_person_action_ids (l_num_rows)
4353: FROM DUAL;
4354:
4355: l_person_ids (l_num_rows) := pl_rec.person_id;

Line 4448: SELECT ben_person_actions_s.NEXTVAL

4444: l_per_in_ler_ids.EXTEND (1);
4445: l_is_placeholder.EXTEND (1);
4446:
4447:
4448: SELECT ben_person_actions_s.NEXTVAL
4449: INTO l_person_action_ids (l_num_rows)
4450: FROM DUAL;
4451:
4452: l_person_ids (l_num_rows) := ps_rec.person_id;