APPS.PAY_TXR_INS dependencies on PAY_TAXABILITY_RULES

Line 103: -- Insert the row into: pay_taxability_rules

99: --
100: --
101: --
102: --
103: -- Insert the row into: pay_taxability_rules
104: --
105: hr_utility.trace('p_rec.jurisdiction_code '||p_rec.jurisdiction_code);
106: hr_utility.trace('p_rec.tax_type '||p_rec.tax_type);
107: hr_utility.trace('p_rec.tax_category '||p_rec.tax_category);

Line 113: insert into pay_taxability_rules

109: hr_utility.trace('p_rec.legislation_code '||p_rec.legislation_code);
110: hr_utility.trace('p_rec.status '||p_rec.status);
111: hr_utility.trace('p_rec.secondary_classification_id '||
112: to_char(p_rec.secondary_classification_id));
113: insert into pay_taxability_rules
114: (jurisdiction_code
115: ,tax_type
116: ,tax_category
117: ,classification_id

Line 136: from pay_taxability_rules

132: );
133: --
134: select count(*)
135: into num
136: from pay_taxability_rules
137: where jurisdiction_code = p_rec.jurisdiction_code;
138: --
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 207: from pay_taxability_rules_dates

203: ) is
204: --
205: Cursor C_Sel1 is
206: select taxability_rules_date_id
207: from pay_taxability_rules_dates
208: where legislation_code = p_rec.legislation_code
209: and sysdate between valid_date_from and
210: valid_date_to;
211:

Line 215: from pay_taxability_rules

211:
212: --
213: Cursor C_Sel2 is
214: Select null
215: from pay_taxability_rules
216: where jurisdiction_code =
217: pay_txr_ins.g_jurisdiction_code_i
218: or tax_type =
219: pay_txr_ins.g_tax_type_i

Line 231: ln_rules_nextval pay_taxability_rules_dates.taxability_rules_date_id%TYPE;

227: pay_txr_ins.g_taxability_rules_date_id_i;
228: --
229: l_proc varchar2(72) := g_package||'pre_insert';
230: l_exists varchar2(1);
231: ln_rules_nextval pay_taxability_rules_dates.taxability_rules_date_id%TYPE;
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --

Line 253: fnd_message.set_token('TABLE_NAME','pay_taxability_rules');

249: --
250: -- The primary key values are already in use.
251: --
252: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
253: fnd_message.set_token('TABLE_NAME','pay_taxability_rules');
254: fnd_message.raise_error;
255: End If;
256: Close C_Sel2;
257: --

Line 296: --There is no record available for this legislation code in the PAY_TAXABILITY_RULES_DATES.

292: Fetch C_Sel1 Into p_rec.taxability_rules_date_id;
293:
294: IF C_Sel1%NOTFOUND THEN
295:
296: --There is no record available for this legislation code in the PAY_TAXABILITY_RULES_DATES.
297: --So create a record there.
298:
299: select PAY_TAXABILITY_RULES_DATES_S.nextval
300: into ln_rules_nextval

Line 299: select PAY_TAXABILITY_RULES_DATES_S.nextval

295:
296: --There is no record available for this legislation code in the PAY_TAXABILITY_RULES_DATES.
297: --So create a record there.
298:
299: select PAY_TAXABILITY_RULES_DATES_S.nextval
300: into ln_rules_nextval
301: from sys.dual;
302:
303: insert into pay_taxability_rules_dates

Line 303: insert into pay_taxability_rules_dates

299: select PAY_TAXABILITY_RULES_DATES_S.nextval
300: into ln_rules_nextval
301: from sys.dual;
302:
303: insert into pay_taxability_rules_dates
304: (taxability_rules_date_id, valid_date_from, valid_date_to,
305: legislation_code
306: --last_update_date, last_updated_by, last_update_login, created_by, creation_date, object_version_number
307: ) values

Line 394: (p_module_name => 'PAY_TAXABILITY_RULES'

390: --
391: when hr_api.cannot_find_prog_unit then
392: --
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'PAY_TAXABILITY_RULES'
395: ,p_hook_type => 'AI');
396: --
397: end;
398: --