69: hr_utility.set_location('Entering:'|| l_proc, 10);
70: --
71: -- Ensure that all the mandatory parameter are not null
72: --
73: hr_api.mandatory_arg_error
74: (p_api_name => l_proc
75: ,p_argument => 'jurisdiction_code'
76: ,p_argument_value => p_jurisdiction_code
77: );
75: ,p_argument => 'jurisdiction_code'
76: ,p_argument_value => p_jurisdiction_code
77: );
78: /*
79: hr_api.mandatory_arg_error
80: (p_api_name => l_proc
81: ,p_argument => 'tax_type'
82: ,p_argument_value => p_tax_type
83: );
80: (p_api_name => l_proc
81: ,p_argument => 'tax_type'
82: ,p_argument_value => p_tax_type
83: );
84: hr_api.mandatory_arg_error
85: (p_api_name => l_proc
86: ,p_argument => 'tax_category'
87: ,p_argument_value => p_tax_category
88: );
85: (p_api_name => l_proc
86: ,p_argument => 'tax_category'
87: ,p_argument_value => p_tax_category
88: );
89: hr_api.mandatory_arg_error
90: (p_api_name => l_proc
91: ,p_argument => 'classification_id'
92: ,p_argument_value => p_classification_id
93: );
91: ,p_argument => 'classification_id'
92: ,p_argument_value => p_classification_id
93: );
94: */
95: hr_api.mandatory_arg_error
96: (p_api_name => l_proc
97: ,p_argument => 'taxability_rules_date_id'
98: ,p_argument_value => p_taxability_rules_date_id
99: );
126: close csr_sec_grp;
127: --
128: -- Set the security_group_id in CLIENT_INFO
129: --
130: hr_api.set_security_group_id
131: (p_security_group_id => l_security_group_id
132: );
133: --
134: -- Set the sessions legislation context in HR_SESSION_DATA
132: );
133: --
134: -- Set the sessions legislation context in HR_SESSION_DATA
135: --
136: hr_api.set_legislation_context(l_legislation_code);
137: end if;
138: --
139: hr_utility.set_location(' Leaving:'|| l_proc, 20);
140: --
185: hr_utility.set_location('Entering:'|| l_proc, 10);
186: --
187: -- Ensure that all the mandatory parameter are not null
188: --
189: hr_api.mandatory_arg_error
190: (p_api_name => l_proc
191: ,p_argument => 'jurisdiction_code'
192: ,p_argument_value => p_jurisdiction_code
193: );
191: ,p_argument => 'jurisdiction_code'
192: ,p_argument_value => p_jurisdiction_code
193: );
194: /*
195: hr_api.mandatory_arg_error
196: (p_api_name => l_proc
197: ,p_argument => 'tax_type'
198: ,p_argument_value => p_tax_type
199: );
196: (p_api_name => l_proc
197: ,p_argument => 'tax_type'
198: ,p_argument_value => p_tax_type
199: );
200: hr_api.mandatory_arg_error
201: (p_api_name => l_proc
202: ,p_argument => 'tax_category'
203: ,p_argument_value => p_tax_category
204: );
201: (p_api_name => l_proc
202: ,p_argument => 'tax_category'
203: ,p_argument_value => p_tax_category
204: );
205: hr_api.mandatory_arg_error
206: (p_api_name => l_proc
207: ,p_argument => 'classification_id'
208: ,p_argument_value => p_classification_id
209: );
207: ,p_argument => 'classification_id'
208: ,p_argument_value => p_classification_id
209: );
210: */
211: hr_api.mandatory_arg_error
212: (p_api_name => l_proc
213: ,p_argument => 'taxability_rules_date_id'
214: ,p_argument_value => p_taxability_rules_date_id
215: );
213: ,p_argument => 'taxability_rules_date_id'
214: ,p_argument_value => p_taxability_rules_date_id
215: );
216: --
217: if (( nvl(pay_txr_bus.g_jurisdiction_code, hr_api.g_varchar2)
218: = p_jurisdiction_code)
219: and ( nvl(pay_txr_bus.g_tax_type, hr_api.g_varchar2)
220: = nvl(p_tax_type, hr_api.g_varchar2))
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
215: );
216: --
217: if (( nvl(pay_txr_bus.g_jurisdiction_code, hr_api.g_varchar2)
218: = p_jurisdiction_code)
219: and ( nvl(pay_txr_bus.g_tax_type, hr_api.g_varchar2)
220: = nvl(p_tax_type, hr_api.g_varchar2))
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
216: --
217: if (( nvl(pay_txr_bus.g_jurisdiction_code, hr_api.g_varchar2)
218: = p_jurisdiction_code)
219: and ( nvl(pay_txr_bus.g_tax_type, hr_api.g_varchar2)
220: = nvl(p_tax_type, hr_api.g_varchar2))
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
217: if (( nvl(pay_txr_bus.g_jurisdiction_code, hr_api.g_varchar2)
218: = p_jurisdiction_code)
219: and ( nvl(pay_txr_bus.g_tax_type, hr_api.g_varchar2)
220: = nvl(p_tax_type, hr_api.g_varchar2))
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)
218: = p_jurisdiction_code)
219: and ( nvl(pay_txr_bus.g_tax_type, hr_api.g_varchar2)
220: = nvl(p_tax_type, hr_api.g_varchar2))
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)
226: = nvl(p_secondary_classification_id, hr_api.g_number))
219: and ( nvl(pay_txr_bus.g_tax_type, hr_api.g_varchar2)
220: = nvl(p_tax_type, hr_api.g_varchar2))
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)
226: = nvl(p_secondary_classification_id, hr_api.g_number))
227: and ( nvl(pay_txr_bus.g_taxability_rules_date_id, hr_api.g_number)
220: = nvl(p_tax_type, hr_api.g_varchar2))
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)
226: = nvl(p_secondary_classification_id, hr_api.g_number))
227: and ( nvl(pay_txr_bus.g_taxability_rules_date_id, hr_api.g_number)
228: = p_taxability_rules_date_id)) then
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)
226: = nvl(p_secondary_classification_id, hr_api.g_number))
227: and ( nvl(pay_txr_bus.g_taxability_rules_date_id, hr_api.g_number)
228: = p_taxability_rules_date_id)) then
229: --
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)
226: = nvl(p_secondary_classification_id, hr_api.g_number))
227: and ( nvl(pay_txr_bus.g_taxability_rules_date_id, hr_api.g_number)
228: = p_taxability_rules_date_id)) then
229: --
230: -- The legislation code has already been found with a previous
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)
226: = nvl(p_secondary_classification_id, hr_api.g_number))
227: and ( nvl(pay_txr_bus.g_taxability_rules_date_id, hr_api.g_number)
228: = p_taxability_rules_date_id)) then
229: --
230: -- The legislation code has already been found with a previous
231: -- call to this function. Just return the value in the global