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 243: ln_rules_nextval pay_taxability_rules_dates.taxability_rules_date_id%TYPE;

239: l_proc varchar2(72) := g_package||'pre_insert';
240: l_exists varchar2(1);
241: l_ele_class_exists varchar2(1);
242: l_sec_ele_class_exists varchar2(1);
243: ln_rules_nextval pay_taxability_rules_dates.taxability_rules_date_id%TYPE;
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: --

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

306: --
307: -- The primary key values are already in use.
308: --
309: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
310: fnd_message.set_token('TABLE_NAME','pay_taxability_rules');
311: fnd_message.raise_error;
312: End If;
313: Close C_Sel2;
314: --

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

349: Fetch C_Sel1 Into p_rec.taxability_rules_date_id;
350:
351: IF C_Sel1%NOTFOUND THEN
352:
353: --There is no record available for this legislation code in the PAY_TAXABILITY_RULES_DATES.
354: --So create a record there.
355:
356: select PAY_TAXABILITY_RULES_DATES_S.nextval
357: into ln_rules_nextval

Line 356: select PAY_TAXABILITY_RULES_DATES_S.nextval

352:
353: --There is no record available for this legislation code in the PAY_TAXABILITY_RULES_DATES.
354: --So create a record there.
355:
356: select PAY_TAXABILITY_RULES_DATES_S.nextval
357: into ln_rules_nextval
358: from sys.dual;
359:
360: insert into pay_taxability_rules_dates

Line 360: insert into pay_taxability_rules_dates

356: select PAY_TAXABILITY_RULES_DATES_S.nextval
357: into ln_rules_nextval
358: from sys.dual;
359:
360: insert into pay_taxability_rules_dates
361: (taxability_rules_date_id, valid_date_from, valid_date_to,
362: legislation_code
363: --last_update_date, last_updated_by, last_update_login, created_by, creation_date, object_version_number
364: ) values

Line 451: (p_module_name => 'PAY_TAXABILITY_RULES'

447: --
448: when hr_api.cannot_find_prog_unit then
449: --
450: hr_api.cannot_find_prog_unit_error
451: (p_module_name => 'PAY_TAXABILITY_RULES'
452: ,p_hook_type => 'AI');
453: --
454: end;
455: --