[Home] [Help]
PACKAGE: APPS.PAY_PROC_ENVIRONMENT_PKG
Source
1 package pay_proc_environment_pkg 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;