[Home] [Help]
PACKAGE: APPS.PAY_SE_RULES
Source
1 PACKAGE PAY_SE_RULES AUTHID CURRENT_USER AS
2 /* $Header: pyserule.pkh 120.5.12010000.1 2008/07/27 23:38:12 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< PAY_SE_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 CURSOR csr_balance_info(p_action_context_id NUMBER
33 ,p_pa_category VARCHAR2
34 ,p_aap_category VARCHAR2) IS
35 SELECT pai.effective_date e1, pai1.effective_date ee1,
36 pai.action_information1 a1, pai1.action_information1 aa1,
37 pai.action_information2 a2, pai1.action_information2 aa2,
38 pai.action_information3 a3, pai1.action_information3 aa3,
39 DECODE(pai1.action_information5,NULL,pai.action_information4,
40 pai.action_information4||'('||pai1.action_information5||')') a4,
41 pai1.action_information4 aa4,
42 pai.action_information5 a5, pai1.action_information5 aa5,
43 pai.action_information6 a6, pai1.action_information6 aa6,
44 pai.action_information7 a7, pai1.action_information7 aa7,
45 pai.action_information8 a8, pai1.action_information8 aa8,
46 pai.action_information9 a9, pai1.action_information9 aa9,
47 pai.action_information10 a10, pai1.action_information10 aa10,
48 pai.action_information11 a11, pai1.action_information11 aa11,
49 pai.action_information12 a12, pai1.action_information12 aa12,
50 pai.action_information13 a13, pai1.action_information13 aa13,
51 pai.action_information14 a14, pai1.action_information14 aa14,
52 pai.action_information15 a15, pai1.action_information15 aa15,
53 pai.action_information16 a16, pai1.action_information16 aa16,
54 pai.action_information17 a17, pai1.action_information17 aa17,
55 pai.action_information18 a18, pai1.action_information18 aa18,
56 pai.action_information19 a19, pai1.action_information19 aa19,
57 pai.action_information20 a20, pai1.action_information20 aa20,
58 pai.action_information21 a21, pai1.action_information21 aa21,
59 pai.action_information22 a22, pai1.action_information22 aa22,
60 pai.action_information23 a23, pai1.action_information23 aa23,
61 pai.action_information24 a24, pai1.action_information24 aa24,
62 pai.action_information25 a25, pai1.action_information25 aa25,
63 pai.action_information26 a26, pai1.action_information26 aa26,
64 pai.action_information27 a27, pai1.action_information27 aa27,
65 pai.action_information28 a28, pai1.action_information28 aa28,
66 pai.action_information29 a29, pai1.action_information29 aa29,
67 pai.action_information30 a30, pai1.action_information30 aa30
68 FROM pay_action_information pai
69 ,pay_action_information pai1
70 ,pay_assignment_actions paa
71 WHERE pai.action_context_type = 'PA'
72 AND pai.action_information_category = p_pa_category
73 AND pai1.action_context_type = 'AAP'
74 AND pai1.action_information_category = p_aap_category
75 AND pai.action_information2 = pai1.action_information1
76 AND pai.action_context_id = paa.payroll_action_id
77 AND pai1.action_context_id = paa.assignment_action_id
78 AND paa.assignment_action_id in
79 (SELECT paa1.assignment_action_id
80 FROM pay_assignment_actions paa1
81 WHERE paa1.source_action_id = p_action_context_id
82 AND paa1.action_status = 'C'
83 UNION
84 SELECT p_action_context_id
85 FROM dual )
86 ORDER BY pai.action_information5,pai1.action_information5 ,a4;
87 --
88 PROCEDURE GET_MAIN_TAX_UNIT_ID
89 (p_assignment_id IN NUMBER
90 ,p_effective_date IN DATE
91 ,p_tax_unit_id OUT NOCOPY NUMBER );
92
93 PROCEDURE get_third_party_org_context
94 (p_asg_act_id IN NUMBER
95 ,p_ee_id IN NUMBER
96 ,p_third_party_id IN OUT NOCOPY NUMBER );
97
98 PROCEDURE add_custom_xml
99 (
100 p_assignment_action_id NUMBER,
101 p_action_information_category VARCHAR2,
102 p_document_type VARCHAR2
103 ) ;
104
105 PROCEDURE load_xml
106 (
107 p_node_type VARCHAR2,
108 p_context_code VARCHAR2,
109 p_node VARCHAR2,
110 p_data VARCHAR2
111 ) ;
112
113 FUNCTION flex_seg_enabled
114 (
115 p_context_code VARCHAR2,
116 p_application_column_name VARCHAR2
117 ) RETURN BOOLEAN ;
118
119 procedure get_source_text_context
120 (p_asg_act_id number
121 ,p_ee_id number
122 ,p_source_text in out nocopy varchar2);
123
124 PROCEDURE get_main_local_unit_id
125 (p_assignment_id IN NUMBER,
126 p_effective_date IN DATE ,
127 p_local_unit_id IN OUT NOCOPY VARCHAR2);
128
129 END PAY_SE_RULES ;