PACKAGE: APPS.PAY_PROC_ENVIRONMENT_PKG

Source

1 package pay_proc_environment_pkg AUTHID CURRENT_USER as
2 /* $Header: pycopenv.pkh 120.5.12010000.1 2008/07/27 22:22:48 appldev ship $ */
3 
4 /*
5 
6 Action Types
7 
8 */
9       PYG_AT_RET constant varchar2(1) := 'O';
10       PYG_AT_ARC constant varchar2(1) := 'X';
11       PYG_AT_RUN constant varchar2(1) := 'R';
12       PYG_AT_ADV constant varchar2(1) := 'F';
13       PYG_AT_RTA constant varchar2(1) := 'G';
14       PYG_AT_RTE constant varchar2(1) := 'L';
15       PYG_AT_RCS constant varchar2(1) := 'S';
16       PYG_AT_PUR constant varchar2(1) := 'Z';  -- Purge.
17       PYG_AT_ADE constant varchar2(1) := 'W';
18       PYG_AT_BEE constant varchar2(3) := 'BEE';  -- BEE Process
19       PYG_AT_ECS constant varchar2(3) := 'EC';  -- Estimate Costing  Process
20       PYG_AT_BAL constant varchar2(1) := 'B';
21       PYG_AT_PAY constant varchar2(1) := 'P';
22       PYG_AT_MAG constant varchar2(1) := 'M';
23       PYG_AT_CHQ constant varchar2(1) := 'H';
24       PYG_AT_CSH constant varchar2(1) := 'A';
25       PYG_AT_COS constant varchar2(1) := 'C';
26       PYG_AT_PST constant varchar2(2) := 'PP';
27       PYG_AT_PRU constant varchar2(3) := 'PRU'; -- Payment Roll up
28       PYG_AT_TGL constant varchar2(1) := 'T';
29       PYG_AT_REV constant varchar2(1) := 'V';   -- Reversal
30 
31       /* Environment Info */
32       chunk_size   number;
33       chunk_method pay_legislation_rules.rule_mode%type;
34       logging_category pay_action_parameters.parameter_value%type;
35       logging_level    number;
36       g_user_id number;
37       g_login_id number;
38       process_env_type boolean;
39 
40       /* Payroll Action Info */
41       action_type         pay_payroll_actions.action_type%type;
42       payroll_id          pay_payroll_actions.payroll_id%type;
43       retro_definition_id pay_payroll_actions.retro_definition_id%type;
44       pactid              pay_payroll_actions.payroll_action_id%type;
45       bgid                pay_payroll_actions.business_group_id%type;
46       legc                per_business_groups.legislation_code%TYPE;
47 --
48 /*
49    update_pop_action_status
50 
51    This procedure updates the action population then issues a commit.
52 */
53 procedure update_pop_action_status(p_payroll_action_id in number,
54                                    p_status in varchar2);
55 
56 /*
57    initialise_proc_env
58 
59    This procedure initialises the processing environment after some of
60    the above globals are set.
61 */
62 procedure initialise_proc_env;
63 /*
64    deinitialise_proc_env
65 
66    This procedure deinitialises the processing environment.
67 */
68 procedure deinitialise_proc_env;
69 --
70 /*
71    get_pactid
72 
73    Returns the environment pactid
74 
75    This looks like a strange procedure, but its need to workaround
76    and RDBMS issue on referening PL/SQL variables in SQL statements
77 */
78 function get_pactid return number;
79 --
80 end pay_proc_environment_pkg;