[Home] [Help]
PACKAGE: APPS.PAY_DK_RULES
Source
1 PACKAGE PAY_DK_RULES AUTHID CURRENT_USER AS
2 /* $Header: pydkrule.pkh 120.3.12010000.1 2008/07/27 22:27:12 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< PAY_DK_RULES >--------------------------------|
6 -- ----------------------------------------------------------------------------
7 /*
8 ------ cursor to get the balance details ------------------------------------
9 CURSOR csr_balance_info(p_action_context_id NUMBER
10 ,p_pa_category VARCHAR2
11 ,p_aap_category VARCHAR2) IS
12 SELECT pai.effective_date e1, pai1.effective_date ee1,
13 pai.action_information1 a1, pai1.action_information1 aa1,
14 pai.action_information2 a2, pai1.action_information2 aa2,
15 pai.action_information3 a3, pai1.action_information3 aa3,
16 DECODE(pai1.action_information5,NULL,pai.action_information4,
17 pai.action_information4||'('||pai1.action_information5||')') a4,
18 pai1.action_information4 aa4,
19 pai.action_information5 a5, pai1.action_information5 aa5,
20 pai.action_information6 a6, pai1.action_information6 aa6,
21 pai.action_information7 a7, pai1.action_information7 aa7,
22 pai.action_information8 a8, pai1.action_information8 aa8,
23 pai.action_information9 a9, pai1.action_information9 aa9,
24 pai.action_information10 a10, pai1.action_information10 aa10,
25 pai.action_information11 a11, pai1.action_information11 aa11,
26 pai.action_information12 a12, pai1.action_information12 aa12,
27 pai.action_information13 a13, pai1.action_information13 aa13,
28 pai.action_information14 a14, pai1.action_information14 aa14,
29 pai.action_information15 a15, pai1.action_information15 aa15,
30 pai.action_information16 a16, pai1.action_information16 aa16,
31 pai.action_information17 a17, pai1.action_information17 aa17,
32 pai.action_information18 a18, pai1.action_information18 aa18,
33 pai.action_information19 a19, pai1.action_information19 aa19,
34 pai.action_information20 a20, pai1.action_information20 aa20,
35 pai.action_information21 a21, pai1.action_information21 aa21,
36 pai.action_information22 a22, pai1.action_information22 aa22,
37 pai.action_information23 a23, pai1.action_information23 aa23,
38 pai.action_information24 a24, pai1.action_information24 aa24,
39 pai.action_information25 a25, pai1.action_information25 aa25,
40 pai.action_information26 a26, pai1.action_information26 aa26,
41 pai.action_information27 a27, pai1.action_information27 aa27,
42 pai.action_information28 a28, pai1.action_information28 aa28,
43 pai.action_information29 a29, pai1.action_information29 aa29,
44 pai.action_information30 a30, pai1.action_information30 aa30
45 FROM pay_action_information pai
46 ,pay_action_information pai1
47 ,pay_assignment_actions paa
48 WHERE pai.action_context_type = 'PA'
49 AND pai.action_information_category = p_pa_category
50 AND pai1.action_context_type = 'AAP'
51 AND ((pai1.action_context_id = p_action_context_id)
52 -- OR
53 -- pai1.action_context_id in ( SELECT paa.assignment_action_id
54 -- FROM pay_assignment_actions paa
55 -- WHERE paa.source_action_id = p_action_context_id
56 -- AND paa.assignment_id = pai1.assignment_id
57 -- )
58 )
59 and pai1.action_information_category = p_aap_category
60 and pai.action_information2 = pai1.action_information1
61 and pai.action_context_id = paa.payroll_action_id
62 and pai1.action_context_id = paa.assignment_action_id
63 ORDER BY pai.action_information5,pai1.action_information5 DESC;
64 */
65
66 -------------------- cursor to get all the assignment_action_id if run types is enabled -----------------
67
68 CURSOR csr_run_types(p_action_context_id NUMBER ) IS
69 SELECT assignment_action_id
70 FROM pay_assignment_actions
71 WHERE source_action_id = p_action_context_id
72 AND action_status = 'C'
73 UNION
74 SELECT p_action_context_id assignment_action_id
75 FROM dual;
76
77
78 ------ cursor to get the balance details ------------------------------------
79
80 CURSOR csr_balance_info(p_action_context_id NUMBER
81 ,p_pa_category VARCHAR2
82 ,p_aap_category VARCHAR2) IS
83 SELECT pai.effective_date e1, pai1.effective_date ee1,
84 pai.action_information1 a1, pai1.action_information1 aa1,
85 pai.action_information2 a2, pai1.action_information2 aa2,
86 pai.action_information3 a3, pai1.action_information3 aa3,
87 DECODE(pai1.action_information5,NULL,pai.action_information4,
88 pai.action_information4||'('||pai1.action_information5||')') a4,
89 pai1.action_information4 aa4,
90 pai.action_information5 a5, pai1.action_information5 aa5,
91 pai.action_information6 a6, pai1.action_information6 aa6,
92 pai.action_information7 a7, pai1.action_information7 aa7,
93 pai.action_information8 a8, pai1.action_information8 aa8,
94 pai.action_information9 a9, pai1.action_information9 aa9,
95 pai.action_information10 a10, pai1.action_information10 aa10,
96 pai.action_information11 a11, pai1.action_information11 aa11,
97 pai.action_information12 a12, pai1.action_information12 aa12,
98 pai.action_information13 a13, pai1.action_information13 aa13,
99 pai.action_information14 a14, pai1.action_information14 aa14,
100 pai.action_information15 a15, pai1.action_information15 aa15,
101 pai.action_information16 a16, pai1.action_information16 aa16,
102 pai.action_information17 a17, pai1.action_information17 aa17,
103 pai.action_information18 a18, pai1.action_information18 aa18,
104 pai.action_information19 a19, pai1.action_information19 aa19,
105 pai.action_information20 a20, pai1.action_information20 aa20,
106 pai.action_information21 a21, pai1.action_information21 aa21,
107 pai.action_information22 a22, pai1.action_information22 aa22,
108 pai.action_information23 a23, pai1.action_information23 aa23,
109 pai.action_information24 a24, pai1.action_information24 aa24,
110 pai.action_information25 a25, pai1.action_information25 aa25,
111 pai.action_information26 a26, pai1.action_information26 aa26,
112 pai.action_information27 a27, pai1.action_information27 aa27,
113 pai.action_information28 a28, pai1.action_information28 aa28,
114 pai.action_information29 a29, pai1.action_information29 aa29,
115 pai.action_information30 a30, pai1.action_information30 aa30
116 FROM pay_action_information pai
117 ,pay_action_information pai1
118 ,pay_assignment_actions paa
119 WHERE pai.action_context_type = 'PA'
120 AND pai.action_information_category = p_pa_category
121 AND pai1.action_context_type = 'AAP'
122 AND pai1.action_information_category = p_aap_category
123 AND pai.action_information2 = pai1.action_information1
124 AND pai.action_context_id = paa.payroll_action_id
125 AND pai1.action_context_id = paa.assignment_action_id
126 AND paa.assignment_action_id = p_action_context_id
127 ORDER BY pai.action_information5,pai1.action_information5 DESC;
128
129 -----------------------------------------
130
131 PROCEDURE get_third_party_org_context
132 (p_asg_act_id IN NUMBER
133 ,p_ee_id IN NUMBER
134 ,p_third_party_id IN OUT NOCOPY NUMBER );
135
136 -----------------------------------------
137 FUNCTION load_xml (p_node_type VARCHAR2,
138 p_context_code VARCHAR2,
139 p_node VARCHAR2,
140 p_data VARCHAR2) RETURN VARCHAR2;
141
142
143 -----------------------------------------
144 FUNCTION flex_seg_enabled(p_context_code VARCHAR2,
145 p_application_column_name VARCHAR2) RETURN BOOLEAN;
146
147 -----------------------------------------
148
149 PROCEDURE add_custom_xml
150 (p_assignment_action_id number,
151 p_action_information_category varchar2,
152 p_document_type varchar2) ;
153
154
155 -----------------------------------------
156
157 -- Added functions for Batch Printing of Payslips
158 --------------------------------------------------------------------------
159 -- Returns any of the values from SEGMENT1, SEGMENT2, .. ,SEGMENT30
160 --------------------------------------------------------------------------
161 FUNCTION get_payslip_sort_order1 RETURN VARCHAR2;
162
163 --------------------------------------------------------------------------
164 -- Returns any of the values ORGANIZATION_ID or ASSIGNMENT_NUMBER
165 --------------------------------------------------------------------------
166 FUNCTION get_payslip_sort_order2 RETURN VARCHAR2;
167
168 --------------------------------------------------------------------------
169 -- get_payslip_sort_order3
170 -- Returns any of the values LAST_NAME, FIRST_NAME or FULL_NAME
171 --------------------------------------------------------------------------
172 FUNCTION get_payslip_sort_order3 RETURN VARCHAR2;
173
174
175 END PAY_DK_RULES ;