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.PAY_POPULATION_RANGES_PKG dependencies on PAY_POPULATION_RANGES

Line 1: package body pay_population_ranges_pkg as

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: --

Line 22: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.remove_existing_ranges');

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

Line 38: FROM PAY_POPULATION_RANGES POP

34: WHERE PML.SOURCE_TYPE = 'P'
35: AND PML.SOURCE_ID = p_payroll_action_id)
36: OR EXISTS (
37: SELECT NULL
38: FROM PAY_POPULATION_RANGES POP
39: WHERE POP.PAYROLL_ACTION_ID = p_payroll_action_id);
40: --
41: --
42: -- OK, we've found rows, need to remove them

Line 46: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.remove_existing_ranges');

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(

Line 51: 'pay_population_ranges_pkg.remove_existing_ranges');

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: --

Line 72: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.set_range_globals');

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);

Line 174: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.set_range_globals');

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: /*

Line 193: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.get_range_statement');

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 =

Line 289: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.get_range_statement');

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: /*

Line 303: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type

299: procedure do_randomisation(p_payroll_action_id in number,
300: p_chunk_number in number)
301: is
302: --
303: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type
304: index by binary_integer;
305: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type
306: index by binary_integer;
307: type t_person_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type

Line 305: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type

301: is
302: --
303: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type
304: index by binary_integer;
305: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type
306: index by binary_integer;
307: type t_person_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type
308: index by binary_integer;
309: --

Line 307: type t_person_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type

303: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type
304: index by binary_integer;
305: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type
306: index by binary_integer;
307: type t_person_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type
308: index by binary_integer;
309: --
310: l_pay_act_tab t_person_id_tab;
311: l_chunk_num_tab t_chunk_num_tab;

Line 319: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.do_randomisation');

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;

Line 353: pay_core_utils.assert_condition('pay_population_ranges_pkg.do_randomisation:1',

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);

Line 366: update pay_population_ranges

362: end loop;
363: --
364: --
365: forall i in 1..l_chunk_num_tab.count
366: update pay_population_ranges
367: set rand_chunk_number = l_rand_chunk_num_tab(i)
368: where payroll_action_id = l_pay_act_tab(i)
369: and chunk_number = l_chunk_num_tab(i);
370: --

Line 373: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.do_randomisation');

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: /*

Line 387: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.insert_chunk_statii');

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,

Line 400: FROM pay_population_ranges

396: CHUNK_NUMBER,
397: nvl(RAND_CHUNK_NUMBER, CHUNK_NUMBER),
398: 'U',
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: --

Line 403: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.insert_chunk_statii');

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: /*

Line 419: type t_person_id_tab IS TABLE OF pay_population_ranges.person_id%type

415: p_statement in varchar2)
416: is
417:
418: type t_curs_ref is ref cursor;
419: type t_person_id_tab IS TABLE OF pay_population_ranges.person_id%type
420: index by binary_integer;
421: type t_source_id_tab IS TABLE OF pay_population_ranges.source_id%type
422: index by binary_integer;
423: type t_source_type_tab IS TABLE OF pay_population_ranges.source_type%type

Line 421: type t_source_id_tab IS TABLE OF pay_population_ranges.source_id%type

417:
418: type t_curs_ref is ref cursor;
419: type t_person_id_tab IS TABLE OF pay_population_ranges.person_id%type
420: index by binary_integer;
421: type t_source_id_tab IS TABLE OF pay_population_ranges.source_id%type
422: index by binary_integer;
423: type t_source_type_tab IS TABLE OF pay_population_ranges.source_type%type
424: index by binary_integer;
425: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type

Line 423: type t_source_type_tab IS TABLE OF pay_population_ranges.source_type%type

419: type t_person_id_tab IS TABLE OF pay_population_ranges.person_id%type
420: index by binary_integer;
421: type t_source_id_tab IS TABLE OF pay_population_ranges.source_id%type
422: index by binary_integer;
423: type t_source_type_tab IS TABLE OF pay_population_ranges.source_type%type
424: index by binary_integer;
425: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type
426: index by binary_integer;
427: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type

Line 425: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type

421: type t_source_id_tab IS TABLE OF pay_population_ranges.source_id%type
422: index by binary_integer;
423: type t_source_type_tab IS TABLE OF pay_population_ranges.source_type%type
424: index by binary_integer;
425: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type
426: index by binary_integer;
427: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type
428: index by binary_integer;
429: type t_rge_stat_tab IS TABLE OF pay_population_ranges.range_status%type

Line 427: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type

423: type t_source_type_tab IS TABLE OF pay_population_ranges.source_type%type
424: index by binary_integer;
425: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type
426: index by binary_integer;
427: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type
428: index by binary_integer;
429: type t_rge_stat_tab IS TABLE OF pay_population_ranges.range_status%type
430: index by binary_integer;
431: --

Line 429: type t_rge_stat_tab IS TABLE OF pay_population_ranges.range_status%type

425: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type
426: index by binary_integer;
427: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type
428: index by binary_integer;
429: type t_rge_stat_tab IS TABLE OF pay_population_ranges.range_status%type
430: index by binary_integer;
431: --
432: l_pay_act_tab t_person_id_tab;
433: l_chunk_num_tab t_chunk_num_tab;

Line 442: l_end_person_id pay_population_ranges.person_id%type;

438: l_source_type_tab t_source_type_tab;
439: l_strt_person_id_tab t_person_id_tab;
440: l_end_person_id_tab t_person_id_tab;
441: --
442: l_end_person_id pay_population_ranges.person_id%type;
443: --
444: actioncur t_curs_ref;
445: chunk_number pay_population_ranges.chunk_number%type;
446: pactid number;

Line 445: chunk_number pay_population_ranges.chunk_number%type;

441: --
442: l_end_person_id pay_population_ranges.person_id%type;
443: --
444: actioncur t_curs_ref;
445: chunk_number pay_population_ranges.chunk_number%type;
446: pactid number;
447: --
448: begin
449: --

Line 450: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.insert_ranges');

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;

Line 500: insert into pay_population_ranges (

496: end if;
497: end loop;
498: --
499: forall i in 1..l_person_id_tab.COUNT
500: insert into pay_population_ranges (
501: payroll_action_id,
502: starting_person_id,
503: ending_person_id,
504: chunk_number,

Line 521: insert into pay_population_ranges (

517: l_source_type_tab(i));
518: --
519: else
520: l_end_person_id := l_person_id_tab(l_person_id_tab.count);
521: insert into pay_population_ranges (
522: payroll_action_id,
523: starting_person_id,
524: ending_person_id,
525: chunk_number,

Line 567: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.insert_ranges');

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: /*

Line 581: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.perform_range_creation');

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: );

Line 606: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.perform_range_creation');

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:

Line 620: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type

616: */
617: procedure reset_errored_ranges(p_payroll_action_id in number)
618: is
619: --
620: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type
621: index by binary_integer;
622: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type
623: index by binary_integer;
624: --

Line 622: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type

618: is
619: --
620: type t_pay_act_id_tab IS TABLE OF pay_population_ranges.payroll_action_id%type
621: index by binary_integer;
622: type t_chunk_num_tab IS TABLE OF pay_population_ranges.chunk_number%type
623: index by binary_integer;
624: --
625: l_pay_act_tab t_pay_act_id_tab;
626: l_chunk_num_tab t_chunk_num_tab;

Line 632: from pay_population_ranges

628: cursor get_err_chunks
629: is
630: select payroll_action_id,
631: nvl(rand_chunk_number, chunk_number)
632: from pay_population_ranges
633: where payroll_action_id = p_payroll_action_id
634: and range_status = 'E';
635: --
636: begin

Line 638: pay_proc_logging.PY_ENTRY('pay_population_ranges_pkg.reset_errored_ranges');

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

Line 670: update pay_population_ranges ppr

666: where aa.payroll_action_id = l_pay_act_tab(i)
667: and aa.chunk_number = l_chunk_num_tab(i);
668: --
669: forall i in 1..l_pay_act_tab.count
670: update pay_population_ranges ppr
671: set range_status = 'U'
672: where ppr.payroll_action_id = l_pay_act_tab(i)
673: and ppr.chunk_number = l_chunk_num_tab(i);
674: --

Line 695: pay_proc_logging.PY_EXIT('pay_population_ranges_pkg.reset_errored_ranges');

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;

Line 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;