1 package pqp_expreplod_pkg AUTHID CURRENT_USER AS
2 /* $Header: pqexrpld.pkh 120.0 2005/05/29 01:46:57 appldev noship $ */
3 /*
4 Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5 --
6 Name :This package defines the cursors needed to run Multi-Threaded Proc
7 --
8
9 */
10 PROCEDURE load_data
11 (
12 actid IN NUMBER,
13 p_effective_date IN DATE
14 );
15 PROCEDURE upd_payroll_actions (pactid IN NUMBER,
16 p_payroll_id IN NUMBER,
17 p_consolidation_set_id IN NUMBER,
18 p_effective_date IN DATE);
19 PROCEDURE run_preprocess (actid IN NUMBER,
20 p_effective_date IN DATE);
21
22 FUNCTION get_offset_date ( p_payroll_id IN NUMBER
23 ,p_consolidation_id IN NUMBER
24 ,p_effective_date IN DATE )
25 RETURN NUMBER ;
26
27 -- =============================================================================
28 -- Get_Tax_Start_Date :Used to get the Financial Tax Year
29 -- =============================================================================
30 FUNCTION Get_Tax_Start_Date
31 (p_legislation_code IN VARCHAR2
32 ,p_effective_date IN Date
33 ,p_dimension_type_id IN pay_balance_dimensions.balance_dimension_id%TYPE
34 ) RETURN DATE ;
35 -- =============================================================================
36 -- Get_Previous_Year_Tax_Date :Used to get the Previous tax year based on
37 -- Financial Tax year
38 -- =============================================================================
39 FUNCTION Get_Previous_Year_Tax_Date
40 (p_tax_year_start_date IN Date
41 ,p_effective_date IN Date ) RETURN DATE;
42 -- =============================================================================
43 -- Get_Previous_Quarter_Tax_Date :Used to get the Previous quater date based on
44 -- Financial Tax year
45 -- =============================================================================
46 FUNCTION Get_Previous_Quarter_Tax_Date
47 (p_tax_year_start_date IN Date
48 ,p_effective_date IN Date
49 ,p_count IN NUMBER) RETURN DATE;
50
51
52
53
54 END;
55