1 package pay_population_ranges_pkg AUTHID CURRENT_USER as
2 /* $Header: pycoppr.pkh 120.0 2005/05/29 01:59:57 appldev noship $ */
3
4 --
5 -- Dynamic SQL generation Types
6 --
7 -- Cross refernce the C code defintions with the PL/SQL
8 --
9 PY_ALLASG constant number := 1;
10 PY_SPCINC constant number := 2;
11 PY_SPCEXC constant number := 3;
12 PY_RUNRGE constant number := 4;
13 PY_RESRGE constant number := 5;
14 PY_NONRGE constant number := 6;
15 PY_PURRGE constant number := 7; -- Purge.
16 PY_RETRGE constant number := 8; -- RetroPay By Element
17 PY_RETASG constant number := 9;
18 SQL_ALLASG constant number := PY_ALLASG; /* all assignments for payroll */
19 SQL_SPCINC constant number := PY_SPCINC; /* specific assignment inclusions */
20 SQL_SPCEXC constant number := PY_SPCEXC; /* all assignments - specific
21 exclusions */
22 SQL_RUNRGE constant number := PY_RUNRGE; /* payroll run range rows */
23 SQL_RESRGE constant number := PY_RESRGE; /* restricted payroll action range
24 rows */
25 SQL_NONRGE constant number := PY_NONRGE; /* unrestricted payroll action range
26 rows */
27 SQL_PURRGE constant number := PY_PURRGE; /* range row for Purge */
28 SQL_RETRGE constant number := PY_RETRGE; /* range row for retropay by element
29 with retro defn */
30 SQL_RETASG constant number := PY_RETASG; /* assignments for retropay by
31 element with retro defn */
32
33 --
34 -- Population Status
35 --
36 APS_POP_RANGES constant varchar2(2) := 'R';/* populating range table */
37 APS_POP_ACTIONS constant varchar2(2) := 'P';/* populating assignment actions */
38 APS_POP_ERROR constant varchar2(2) := 'E';/* error in one or more chunks */
39 APS_POP_POSTINS constant varchar2(2) := 'A';/* post insert of AA */
40 APS_COMPLETE constant varchar2(2) := 'C';/* have completed population */
41
42 /*
43 perform_range_creation
44
45 This procedure generates the population ranges then executes a commit
46 */
47 procedure perform_range_creation (p_payroll_action_id in number);
48
49 /*
50 reset_errored_ranges
51
52 This procedure resets errored population ranges, ready to be reloaded
53 the issues a commit
54 */
55
56 procedure reset_errored_ranges(p_payroll_action_id in number);
57
58 end pay_population_ranges_pkg;