[Home] [Help]
1: package body pay_population_ranges_pkg as
2: /* $Header: pycoppr.pkb 120.6.12010000.1 2008/07/27 22:22:50 appldev ship $ */
3: --
4: -- Setup Globals
5: --
18: is
19: l_dummy number;
20: begin
21: --
22: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.remove_existing_ranges');
23: --
24: SELECT 1
25: into l_dummy
26: FROM SYS.DUAL
42: -- OK, we've found rows, need to remove them
43: --
44: py_rollback_pkg.rollback_payroll_action(p_payroll_action_id,'ROLLBACK',TRUE);
45: --
46: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.remove_existing_ranges');
47: --
48: exception
49: when no_data_found then
50: pay_proc_logging.PY_EXIT(
47: --
48: exception
49: when no_data_found then
50: pay_proc_logging.PY_EXIT(
51: 'pay_population_ranges_pkg.remove_existing_ranges');
52: null;
53: --
54: end remove_existing_ranges;
55: --
68: l_chunk_shuffle pay_legislation_rules.rule_mode%type;
69: l_found boolean;
70: begin
71: --
72: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.set_range_globals');
73: --
74: pay_core_utils.get_action_parameter(p_para_name => 'RANGE_PERSON_ID',
75: p_para_value => l_range_person,
76: p_found => l_found);
170: else
171: g_chunk_shuffle := FALSE;
172: end if;
173: --
174: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.set_range_globals');
175: --
176: end set_range_globals;
177:
178: /*
189: sqlid number;
190: len number;
191: begin
192: --
193: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.get_range_statement');
194: --
195: action := pay_proc_environment_pkg.action_type;
196: --
197: if (pay_proc_environment_pkg.action_type =
285: end if;
286: --
287: hr_dynsql.pyrsql(sqlid,null,null,p_statement,len,action,p_payroll_action_id);
288: --
289: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.get_range_statement');
290: --
291: end get_range_statement;
292: --
293: /*
315: loop_count number;
316: --
317: begin
318: --
319: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.do_randomisation');
320: --
321: l_pay_act_tab.delete;
322: l_chunk_num_tab.delete;
323: l_rand_chunk_num_tab.delete;
349: --
350: end loop;
351: --
352: if (loop_count > p_chunk_number) then
353: pay_core_utils.assert_condition('pay_population_ranges_pkg.do_randomisation:1',
354: 1 = 2);
355: end if;
356: --
357: l_rand_chunk_num_tab(rand_num) := l_chunk_num_tab(i);
369: and chunk_number = l_chunk_num_tab(i);
370: --
371: commit;
372: --
373: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.do_randomisation');
374: --
375: end do_randomisation;
376: --
377: /*
383: procedure insert_chunk_statii(p_payroll_action_id in number)
384: is
385: begin
386: --
387: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.insert_chunk_statii');
388: --
389: INSERT into PAY_CHUNK_STATUS
390: (PAYROLL_ACTION_ID,
391: CHUNK_NUMBER,
399: 'U'
400: FROM pay_population_ranges
401: WHERE payroll_action_id = p_payroll_action_id;
402: --
403: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.insert_chunk_statii');
404: --
405: end insert_chunk_statii;
406: --
407: /*
446: pactid number;
447: --
448: begin
449: --
450: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.insert_ranges');
451: --
452: chunk_number := 0;
453: --
454: open actioncur for p_statement using p_payroll_action_id;
563: if (pay_proc_environment_pkg.chunk_method = 'ORIGINAL') then
564: insert_chunk_statii(p_payroll_action_id);
565: end if;
566: --
567: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.insert_ranges');
568: --
569: end insert_ranges;
570: --
571: /*
577: is
578: l_statement varchar2(4000);
579: begin
580: --
581: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.perform_range_creation');
582: --
583: set_range_globals(p_payroll_action_id,
584: pay_proc_environment_pkg.action_type
585: );
602: pay_proc_environment_pkg.update_pop_action_status(
603: p_payroll_action_id,
604: APS_POP_ACTIONS );
605: --
606: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.perform_range_creation');
607: --
608: end perform_range_creation;
609: --
610:
634: and range_status = 'E';
635: --
636: begin
637: --
638: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.reset_errored_ranges');
639: --
640: open get_err_chunks;
641: --
642: loop
691: pay_proc_environment_pkg.update_pop_action_status(
692: p_payroll_action_id,
693: APS_POP_ACTIONS );
694: --
695: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.reset_errored_ranges');
696: --
697: end;
698: --
699: end pay_population_ranges_pkg;
695: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.reset_errored_ranges');
696: --
697: end;
698: --
699: end pay_population_ranges_pkg;