1 PACKAGE PAY_GB_TAX_CREDIT_PKG AUTHID CURRENT_USER AS
2 /* $Header: pygbtaxc.pkh 120.0.12000000.1 2007/01/17 20:29:56 appldev noship $ */
3 FUNCTION Get_Element_Link_Id(
4 p_assignment_id in NUMBER
5 ) RETURN NUMBER;
6
7 PROCEDURE Check_Start_date(p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
8 p_element_entry_id in PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE,
9 p_start_date in DATE,
10 p_element_name in VARCHAR2 default 'Tax Credit',
11 p_message out nocopy VARCHAR2);
12
13 PROCEDURE Check_End_or_Stop_Date(p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
14 p_element_entry_id in PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE,
15 p_end_date in DATE,
16 p_start_date in DATE,
17 p_element_name in PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
18 p_message out nocopy VARCHAR2);
19
20 PROCEDURE Check_Delete_Possible(
21 p_datetrack_mode in VARCHAR2,
22 p_effective_date in DATE,
23 p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
24 p_start_date in DATE,
25 p_end_date in DATE,
26 p_message out nocopy VARCHAR2);
27
28 Procedure Check_Daily_Rate(
29 p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
30 p_start_date in DATE,
31 p_message out nocopy VARCHAR2
32 );
33
34 PROCEDURE Fetch_Balances(
35 p_assignment_id in PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE,
36 p_element_entry_id in PAY_RUN_RESULTS.SOURCE_ID%TYPE,
37 p_itd_balance OUT NOCOPY NUMBER,
38 p_ptd_balance OUT NOCOPY NUMBER
39 );
40
41 PROCEDURE Create_Tax_Credit(
42 p_effective_date in DATE
43 ,p_business_group_id in NUMBER
44 ,p_assignment_id in NUMBER
45 ,p_element_link_id in NUMBER
46 ,p_reference in VARCHAR2
47 ,p_start_date in VARCHAR2
48 ,p_end_date in VARCHAR2
49 ,p_daily_amount in VARCHAR2
50 ,p_total_amount in VARCHAR2
51 ,p_stop_date in VARCHAR2
52 ,p_reference_ipv_id in NUMBER
53 ,p_start_date_ipv_id in NUMBER
54 ,p_end_date_ipv_id in NUMBER
55 ,p_daily_amount_ipv_id in NUMBER
56 ,p_total_amount_ipv_id in NUMBER
57 ,p_stop_date_ipv_id in NUMBER
58 ,p_from in DATE
59 ,p_to in DATE
60 ,p_effective_start_date out nocopy DATE
61 ,p_effective_end_date out nocopy DATE
62 ,p_element_entry_id out nocopy NUMBER
63 ,p_object_version_number out nocopy NUMBER);
64
65 PROCEDURE Delete_Tax_Credit(
66 p_datetrack_mode in VARCHAR2
67 ,p_element_entry_id in NUMBER
68 ,p_effective_date in DATE
69 ,p_object_version_number in NUMBER);
70
71 PROCEDURE Update_Tax_Credit(
72 p_datetrack_update_mode in varchar2
73 ,p_effective_date in date
74 ,p_business_group_id in number
75 ,p_element_entry_id in number
76 ,p_object_version_number in out nocopy number
77 ,p_reference in VARCHAR2
78 ,p_start_date in VARCHAR2
79 ,p_end_date in VARCHAR2
80 ,p_daily_amount in VARCHAR2
81 ,p_total_amount in VARCHAR2
82 ,p_stop_date in VARCHAR2
83 ,p_reference_ipv_id in NUMBER
84 ,p_start_date_ipv_id in NUMBER
85 ,p_end_date_ipv_id in NUMBER
86 ,p_daily_amount_ipv_id in NUMBER
87 ,p_total_amount_ipv_id in NUMBER
88 ,p_stop_date_ipv_id in NUMBER
89 ,p_effective_start_date out nocopy date
90 ,p_effective_end_date out nocopy date);
91
92 END PAY_GB_TAX_CREDIT_PKG;
[Home] [Help]