APPS.PAY_IN_ELEMENT_TEMPLATE_PKG dependencies on PAY_ELE_TMPLT_CLASS_USAGES

Line 514: DELETE FROM pay_ele_tmplt_class_usages

510: pay_in_utils.set_location(g_debug,l_procedure,25);
511:
512: BEGIN
513:
514: DELETE FROM pay_ele_tmplt_class_usages
515: WHERE template_id = l_template_id;
516:
517: pay_element_template_api.delete_user_structure(FALSE ,TRUE ,
518: l_template_id);

Line 1026: -- PAY_ELE_TMPLT_CLASS_USAGES row.

1022: SET enabled_flag = l_enabled_flag
1023: WHERE currency_code = pay_in_etw_struct.g_currency_code;
1024:
1025: --
1026: -- PAY_ELE_TMPLT_CLASS_USAGES row.
1027: --
1028: pay_in_utils.set_location(g_debug,l_procedure,350);
1029: create_template_association( l_template_rec.template_id, l_template_rec.category );
1030:

Line 1079: FROM pay_ele_tmplt_class_usages

1075:
1076: pay_in_utils.set_location(g_debug,l_procedure,20);
1077: SELECT count(*)
1078: INTO l_exists
1079: FROM pay_ele_tmplt_class_usages
1080: WHERE classification_id = l_classification_id
1081: AND template_id = p_template_id;
1082:
1083: pay_in_utils.set_location(g_debug,l_procedure,30);

Line 1092: INSERT INTO pay_ele_tmplt_class_usages

1088: INTO l_ele_tmplt_class_id
1089: FROM dual;
1090:
1091: pay_in_utils.set_location(g_debug,l_procedure,50);
1092: INSERT INTO pay_ele_tmplt_class_usages
1093: ( ele_template_classification_id
1094: ,classification_id
1095: ,template_id
1096: ,display_process_mode

Line 1139: DELETE FROM pay_ele_tmplt_class_usages

1135: BEGIN
1136: g_debug := hr_utility.debug_enabled;
1137: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1138:
1139: DELETE FROM pay_ele_tmplt_class_usages
1140: WHERE ele_template_classification_id
1141: IN (SELECT petcu.ele_template_classification_id
1142: FROM pay_ele_tmplt_class_usages petcu
1143: ,pay_element_classifications pec

Line 1142: FROM pay_ele_tmplt_class_usages petcu

1138:
1139: DELETE FROM pay_ele_tmplt_class_usages
1140: WHERE ele_template_classification_id
1141: IN (SELECT petcu.ele_template_classification_id
1142: FROM pay_ele_tmplt_class_usages petcu
1143: ,pay_element_classifications pec
1144: ,pay_element_templates pet
1145: WHERE petcu.classification_id = pec.classification_id
1146: AND petcu.template_id = pet.template_id