APPS.PAY_CREATE_ELEMNT_TMPLT_RECORD dependencies on PAY_ELE_TMPLT_CLASS_USAGES

Line 158: FROM pay_ele_tmplt_class_usages

154: l_classification_id := get_classification_id(l_classification_name(i),p_legislation_code);
155:
156: SELECT COUNT(*)
157: INTO ln_exists
158: FROM pay_ele_tmplt_class_usages
159: WHERE classification_id = l_classification_id
160: AND template_id = p_template_id;
161:
162: hr_utility.trace('ln_exists = ' || to_char(ln_exists));

Line 172: INSERT INTO pay_ele_tmplt_class_usages

168: FROM dual;
169:
170: hr_utility.trace('ln_ele_tmplt_class_id ' ||ln_ele_tmplt_class_id);
171:
172: INSERT INTO pay_ele_tmplt_class_usages
173: ( ele_template_classification_id
174: ,classification_id
175: ,template_id
176: ,display_process_mode

Line 268: delete from PAY_ELE_TMPLT_CLASS_USAGES

264:
265: IF (l_template_exists = 'Y')
266: THEN
267: BEGIN
268: delete from PAY_ELE_TMPLT_CLASS_USAGES
269: where template_id = l_template_id;
270:
271: pay_element_template_api.delete_user_structure(false,true,
272: l_template_id);

Line 1207: delete from PAY_ELE_TMPLT_CLASS_USAGES

1203:
1204: IF (l_template_exists = 'Y')
1205: THEN
1206: BEGIN
1207: delete from PAY_ELE_TMPLT_CLASS_USAGES
1208: where template_id = l_template_id;
1209:
1210: pay_element_template_api.delete_user_structure(false,true,
1211: l_template_id);

Line 1677: delete from PAY_ELE_TMPLT_CLASS_USAGES

1673:
1674: IF (l_template_exists = 'Y')
1675: THEN
1676: BEGIN
1677: delete from PAY_ELE_TMPLT_CLASS_USAGES
1678: where template_id = l_template_id;
1679:
1680: pay_element_template_api.delete_user_structure(false,true,
1681: l_template_id);

Line 2441: delete from PAY_ELE_TMPLT_CLASS_USAGES

2437:
2438: IF (l_template_exists = 'Y')
2439: THEN
2440: BEGIN
2441: delete from PAY_ELE_TMPLT_CLASS_USAGES
2442: where template_id = l_template_id;
2443:
2444: pay_element_template_api.delete_user_structure(false,true,
2445: l_template_id);

Line 3469: delete from PAY_ELE_TMPLT_CLASS_USAGES

3465:
3466: IF (l_template_exists = 'Y')
3467: THEN
3468: BEGIN
3469: delete from PAY_ELE_TMPLT_CLASS_USAGES
3470: where template_id = l_template_id;
3471:
3472: pay_element_template_api.delete_user_structure(false,true,
3473: l_template_id);