[Home] [Help]
PACKAGE: APPS.PAY_NO_RULES
Source
1 PACKAGE PAY_NO_RULES AS
2 /* $Header: pynorule.pkh 120.0.12000000.3 2007/06/08 16:28:08 kseth noship $ */
3 --
4
5 -------------------- cursor to get all the assignment_action_id if run types is enabled -----------------
6
7 CURSOR csr_run_types(p_action_context_id NUMBER ) IS
8 SELECT assignment_action_id
9 FROM pay_assignment_actions
10 WHERE source_action_id = p_action_context_id
11 AND action_status = 'C'
12 UNION
13 SELECT p_action_context_id assignment_action_id
14 FROM dual;
15
16
17 ------ cursor to get the balance details ------------------------------------
18
19 CURSOR csr_balance_info(p_action_context_id NUMBER
20 ,p_pa_category VARCHAR2
21 ,p_aap_category VARCHAR2) IS
22 SELECT pai.effective_date e1, pai1.effective_date ee1,
23 pai.action_information1 a1, pai1.action_information1 aa1,
24 pai.action_information2 a2, pai1.action_information2 aa2,
25 pai.action_information3 a3, pai1.action_information3 aa3,
26 DECODE(pai1.action_information5,NULL,pai.action_information4,
27 pai.action_information4||'('||pai1.action_information5||')') a4,
28 pai1.action_information4 aa4,
29 pai.action_information5 a5, pai1.action_information5 aa5,
30 pai.action_information6 a6, pai1.action_information6 aa6,
31 pai.action_information7 a7, pai1.action_information7 aa7,
32 pai.action_information8 a8, pai1.action_information8 aa8,
33 pai.action_information9 a9, pai1.action_information9 aa9,
34 pai.action_information10 a10, pai1.action_information10 aa10,
35 pai.action_information11 a11, pai1.action_information11 aa11,
36 pai.action_information12 a12, pai1.action_information12 aa12,
37 pai.action_information13 a13, pai1.action_information13 aa13,
38 pai.action_information14 a14, pai1.action_information14 aa14,
39 pai.action_information15 a15, pai1.action_information15 aa15,
40 pai.action_information16 a16, pai1.action_information16 aa16,
41 pai.action_information17 a17, pai1.action_information17 aa17,
42 pai.action_information18 a18, pai1.action_information18 aa18,
43 pai.action_information19 a19, pai1.action_information19 aa19,
44 pai.action_information20 a20, pai1.action_information20 aa20,
45 pai.action_information21 a21, pai1.action_information21 aa21,
46 pai.action_information22 a22, pai1.action_information22 aa22,
47 pai.action_information23 a23, pai1.action_information23 aa23,
48 pai.action_information24 a24, pai1.action_information24 aa24,
49 pai.action_information25 a25, pai1.action_information25 aa25,
50 pai.action_information26 a26, pai1.action_information26 aa26,
51 pai.action_information27 a27, pai1.action_information27 aa27,
52 pai.action_information28 a28, pai1.action_information28 aa28,
53 pai.action_information29 a29, pai1.action_information29 aa29,
54 pai.action_information30 a30, pai1.action_information30 aa30
55 FROM pay_action_information pai
56 ,pay_action_information pai1
57 ,pay_assignment_actions paa
58 WHERE pai.action_context_type = 'PA'
59 AND pai.action_information_category = p_pa_category
60 AND pai1.action_context_type = 'AAP'
61 AND pai1.action_information_category = p_aap_category
62 AND pai.action_information2 = pai1.action_information1
63 AND pai.action_context_id = paa.payroll_action_id
64 AND pai1.action_context_id = paa.assignment_action_id
65 AND paa.assignment_action_id = p_action_context_id
66 ORDER BY pai.action_information5,pai1.action_information5 DESC;
67
68 -----------------------------------------
69
70 PROCEDURE get_main_tax_unit_id
71 (p_assignment_id IN NUMBER
72 ,p_effective_date IN DATE
73 ,p_tax_unit_id OUT NOCOPY NUMBER );
74 --
75 /*
76 PROCEDURE get_source_text_context(p_asg_act_id NUMBER
77 ,p_ee_id NUMBER
78 ,p_source_text IN OUT NOCOPY VARCHAR2);
79 */
80 --
81
82 -----------------------------------------------------------------------------
83 -- Procedure : get_third_party_org_context
84 -- It fetches the third party context of the Assignment Id.
85 -----------------------------------------------------------------------------
86
87 PROCEDURE get_third_party_org_context
88 (p_asg_act_id IN NUMBER
89 ,p_ee_id IN NUMBER
90 ,p_third_party_id IN OUT NOCOPY NUMBER );
91
92 --
93 PROCEDURE get_default_jurisdiction(p_asg_act_id NUMBER,
94 p_ee_id NUMBER,
95 p_jurisdiction IN OUT NOCOPY VARCHAR2);
96 --
97 /*
98 PROCEDURE get_source_context(p_asg_act_id IN NUMBER,
99 p_ee_id IN NUMBER,
100 p_source_id IN OUT NOCOPY VARCHAR2);
101 */
102 --
103 /*Test procedure for local unit id */
104 PROCEDURE get_main_local_unit_id(p_assignment_id IN NUMBER,
105 p_effective_date IN DATE,
106 p_local_unit_id OUT NOCOPY NUMBER);
107 --
108 -----------------------------------------
109 FUNCTION load_xml (p_node_type VARCHAR2,
110 p_context_code VARCHAR2,
111 p_node VARCHAR2,
112 p_data VARCHAR2) RETURN VARCHAR2;
113
114
115 -----------------------------------------
116 FUNCTION flex_seg_enabled(p_context_code VARCHAR2,
117 p_application_column_name VARCHAR2) RETURN BOOLEAN;
118
119 -----------------------------------------
120
121 PROCEDURE add_custom_xml
122 (p_assignment_action_id number,
123 p_action_information_category varchar2,
124 p_document_type varchar2) ;
125
126
127 -----------------------------------------
128 PROCEDURE get_source_text_context
129 (p_asg_act_id IN NUMBER,
130 p_ee_id IN NUMBER,
131 p_source_text IN OUT NOCOPY VARCHAR2);
132
133 --------------------------------------------
134
135 PROCEDURE get_source_text2_context
136 (p_asg_act_id IN NUMBER
137 ,p_ee_id IN NUMBER
138 ,p_source_text2 IN OUT NOCOPY VARCHAR2);
139
140 ---------------------------------------------
141 FUNCTION get_payslip_sort_order1 RETURN VARCHAR2 ;
142 ---------------------------------------------
143 FUNCTION get_payslip_sort_order2 RETURN VARCHAR2 ;
144 ---------------------------------------------
145 FUNCTION get_payslip_sort_order3 RETURN VARCHAR2 ;
146 ---------------------------------------------
147 END PAY_NO_RULES ;