APPS.PAY_CREATE_ELEMNT_TMPLT_RECORD dependencies on PAY_ELE_TMPLT_CLASS_USAGES

Line 179: FROM pay_ele_tmplt_class_usages

175: l_classification_id := get_classification_id(l_classification_name(i),p_legislation_code);
176:
177: SELECT COUNT(*)
178: INTO ln_exists
179: FROM pay_ele_tmplt_class_usages
180: WHERE classification_id = l_classification_id
181: AND template_id = p_template_id;
182:
183: hr_utility.trace('ln_exists = ' || to_char(ln_exists));

Line 193: INSERT INTO pay_ele_tmplt_class_usages

189: FROM dual;
190:
191: hr_utility.trace('ln_ele_tmplt_class_id ' ||ln_ele_tmplt_class_id);
192:
193: INSERT INTO pay_ele_tmplt_class_usages
194: ( ele_template_classification_id
195: ,classification_id
196: ,template_id
197: ,display_process_mode

Line 289: delete from PAY_ELE_TMPLT_CLASS_USAGES

285:
286: IF (l_template_exists = 'Y')
287: THEN
288: BEGIN
289: delete from PAY_ELE_TMPLT_CLASS_USAGES
290: where template_id = l_template_id;
291:
292: pay_element_template_api.delete_user_structure(false,true,
293: l_template_id);

Line 1428: delete from PAY_ELE_TMPLT_CLASS_USAGES

1424:
1425: IF (l_template_exists = 'Y')
1426: THEN
1427: BEGIN
1428: delete from PAY_ELE_TMPLT_CLASS_USAGES
1429: where template_id = l_template_id;
1430:
1431: pay_element_template_api.delete_user_structure(false,true,
1432: l_template_id);

Line 2058: delete from PAY_ELE_TMPLT_CLASS_USAGES

2054:
2055: IF (l_template_exists = 'Y')
2056: THEN
2057: BEGIN
2058: delete from PAY_ELE_TMPLT_CLASS_USAGES
2059: where template_id = l_template_id;
2060:
2061: pay_element_template_api.delete_user_structure(false,true,
2062: l_template_id);

Line 3030: delete from PAY_ELE_TMPLT_CLASS_USAGES

3026:
3027: IF (l_template_exists = 'Y')
3028: THEN
3029: BEGIN
3030: delete from PAY_ELE_TMPLT_CLASS_USAGES
3031: where template_id = l_template_id;
3032:
3033: pay_element_template_api.delete_user_structure(false,true,
3034: l_template_id);

Line 4272: delete from PAY_ELE_TMPLT_CLASS_USAGES

4268:
4269: IF (l_template_exists = 'Y')
4270: THEN
4271: BEGIN
4272: delete from PAY_ELE_TMPLT_CLASS_USAGES
4273: where template_id = l_template_id;
4274:
4275: pay_element_template_api.delete_user_structure(false,true,
4276: l_template_id);