[Home] [Help]
PACKAGE: APPS.PAY_FI_RULES
Source
1 PACKAGE PAY_FI_RULES AUTHID CURRENT_USER AS
2 /* $Header: pyfirule.pkh 120.1.12000000.1 2007/01/17 19:29:23 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< PAY_FI_RULES >--------------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API fetches the Legal Employer Id of the Local Unit of the
11 -- Assignment Id
12 -- In Parameters:
13 -- Name Reqd Type Description
14 -- p_assignment_id Yes Number Assignment id
15 -- p_effective_date Yes date Effective date of record
16 --
17 -- Post Success:
18 -- When the Legal Employer Id of the Local Unit of the Assignment Id is
19 -- fetched the following parameters are set:
20 --
21 -- Name Type Description
22 -- p_tax_unit_id Number Tax Unit Id
23 --
24 -- Post Failure:
25 -- Does not set the value for p_tax_unit_id .
26 --
27 -- Access Status:
28 -- Public.
29 --
30 -- {End Of Comments}
31 --
32
33
34
35 CURSOR csr_balance_info(p_action_context_id NUMBER
36 ,p_pa_category VARCHAR2
37 ,p_aap_category VARCHAR2) IS
38 SELECT pai.effective_date e1, pai1.effective_date ee1,
39 pai.action_information1 a1, pai1.action_information1 aa1,
40 pai.action_information2 a2, pai1.action_information2 aa2,
41 pai.action_information3 a3, pai1.action_information3 aa3,
42 DECODE(pai1.action_information5,NULL,pai.action_information4,
43 pai.action_information4||'('||pai1.action_information5||')') a4,
44 pai1.action_information4 aa4,
45 pai.action_information5 a5, pai1.action_information5 aa5,
46 pai.action_information6 a6, pai1.action_information6 aa6,
47 pai.action_information7 a7, pai1.action_information7 aa7,
48 pai.action_information8 a8, pai1.action_information8 aa8,
49 pai.action_information9 a9, pai1.action_information9 aa9,
50 pai.action_information10 a10, pai1.action_information10 aa10,
51 pai.action_information11 a11, pai1.action_information11 aa11,
52 pai.action_information12 a12, pai1.action_information12 aa12,
53 pai.action_information13 a13, pai1.action_information13 aa13,
54 pai.action_information14 a14, pai1.action_information14 aa14,
55 pai.action_information15 a15, pai1.action_information15 aa15,
56 pai.action_information16 a16, pai1.action_information16 aa16,
57 pai.action_information17 a17, pai1.action_information17 aa17,
58 pai.action_information18 a18, pai1.action_information18 aa18,
59 pai.action_information19 a19, pai1.action_information19 aa19,
60 pai.action_information20 a20, pai1.action_information20 aa20,
61 pai.action_information21 a21, pai1.action_information21 aa21,
62 pai.action_information22 a22, pai1.action_information22 aa22,
63 pai.action_information23 a23, pai1.action_information23 aa23,
64 pai.action_information24 a24, pai1.action_information24 aa24,
65 pai.action_information25 a25, pai1.action_information25 aa25,
66 pai.action_information26 a26, pai1.action_information26 aa26,
67 pai.action_information27 a27, pai1.action_information27 aa27,
68 pai.action_information28 a28, pai1.action_information28 aa28,
69 pai.action_information29 a29, pai1.action_information29 aa29,
70 pai.action_information30 a30, pai1.action_information30 aa30
71 FROM pay_action_information pai
72 ,pay_action_information pai1
73 ,pay_assignment_actions paa
74 WHERE pai.action_context_type = 'PA'
75 AND pai.action_information_category = p_pa_category
76 AND pai1.action_context_type = 'AAP'
77 AND pai1.action_information_category = p_aap_category
78 AND pai.action_information2 = pai1.action_information1
79 AND pai.action_context_id = paa.payroll_action_id
80 AND pai1.action_context_id = paa.assignment_action_id
81 AND paa.assignment_action_id in
82 (SELECT paa1.assignment_action_id
83 FROM pay_assignment_actions paa1
84 WHERE paa1.source_action_id = p_action_context_id
85 AND paa1.action_status = 'C'
86 UNION
87 SELECT p_action_context_id
88 FROM dual )
89 ORDER BY pai.action_information5,pai1.action_information5 DESC;
90
91 PROCEDURE get_main_tax_unit_id
92 (p_assignment_id IN NUMBER
93 ,p_effective_date IN DATE
94 ,p_tax_unit_id OUT NOCOPY NUMBER );
95
96 PROCEDURE get_third_party_org_context
97 (p_asg_act_id IN NUMBER
98 ,p_ee_id IN NUMBER
99 ,p_third_party_id IN OUT NOCOPY NUMBER );
100
101 PROCEDURE get_source_text_context
102 (p_asg_act_id IN NUMBER,
103 p_ee_id IN NUMBER,
104 p_source_text IN OUT NOCOPY VARCHAR2);
105
106 PROCEDURE get_source_text2_context
107 (p_asg_act_id IN NUMBER,
108 p_ee_id IN NUMBER,
109 p_source_text2 IN OUT NOCOPY VARCHAR2);
110
111 PROCEDURE get_main_local_unit_id
112 (p_assignment_id IN NUMBER,
113 p_effective_date IN DATE ,
114 p_local_unit_id IN OUT NOCOPY VARCHAR2);
115
116
117 PROCEDURE add_custom_xml
118 (p_assignment_action_id NUMBER,
119 p_action_information_category VARCHAR2,
120 p_document_type VARCHAR2) ;
121
122 PROCEDURE load_xml
123 (
124 p_node_type VARCHAR2,
125 p_context_code VARCHAR2,
126 p_node VARCHAR2,
127 p_data VARCHAR2) ;
128
129 FUNCTION flex_seg_enabled
130 (p_context_code VARCHAR2,
131 p_application_column_name VARCHAR2) RETURN BOOLEAN ;
132
133 END PAY_FI_RULES ;