1: PACKAGE BODY ben_benbatch_persons AS
2: /* $Header: benbatpe.pkb 120.8.12010000.2 2008/08/05 14:31:02 ubhat ship $ */
3: --------------------------------------------------------------------------------
4: /*
5: +==============================================================================+
159: control person selection rule error logging
160: 28-May-08 krupani 115.70 Bug 6718304 - Relevant changes done in CWB where clause
161: */
162: --------------------------------------------------------------------------------
163: g_package VARCHAR2(80) := 'ben_benbatch_persons';
164: TYPE g_number_table_type IS TABLE OF NUMBER
165: INDEX BY BINARY_INTEGER;
166: --
167: FUNCTION check_selection_rule(
310: l_start_person_action_id NUMBER;
311: l_end_person_action_id NUMBER;
312: --
313: l_person_id_fetch NUMBER;
314: l_person_id_process ben_benbatch_persons.g_number_table_type;
315: l_person_action_id_table ben_benbatch_persons.g_number_table_type;
316: l_to_chunk_loop NUMBER := 0;
317: --
318: -- Local variables
311: l_end_person_action_id NUMBER;
312: --
313: l_person_id_fetch NUMBER;
314: l_person_id_process ben_benbatch_persons.g_number_table_type;
315: l_person_action_id_table ben_benbatch_persons.g_number_table_type;
316: l_to_chunk_loop NUMBER := 0;
317: --
318: -- Local variables
319: --
1035: c_person_life cur_type;
1036: --
1037: --
1038: l_person_id_fetch NUMBER;
1039: l_person_id_process ben_benbatch_persons.g_number_table_type;
1040: l_person_action_id_table ben_benbatch_persons.g_number_table_type;
1041: l_to_chunk_loop NUMBER := 0;
1042: --
1043: --
1036: --
1037: --
1038: l_person_id_fetch NUMBER;
1039: l_person_id_process ben_benbatch_persons.g_number_table_type;
1040: l_person_action_id_table ben_benbatch_persons.g_number_table_type;
1041: l_to_chunk_loop NUMBER := 0;
1042: --
1043: --
1044: -- Local variables
2200: -- hr_utility.set_location('Leaving '||l_package,10);
2201: --
2202: END create_restart_person_actions;
2203: --
2204: END ben_benbatch_persons;