[Home] [Help]
618: ----------------------------------------------------------------------------
619: FOR c_rec in c_template LOOP
620: l_template_id := c_rec.template_id;
621:
622: DELETE FROM pay_ele_tmplt_class_usages
623: WHERE template_id = l_template_id;
624:
625: pay_element_template_api.delete_user_structure
626: (p_validate => false
784: ,p_object_version_number => l_ovn
785: ,p_effective_date => l_effective_date
786: );
787: -------------------------------------------------------------------------
788: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
789: -------------------------------------------------------------------------
790: DECLARE
791: CURSOR csr_get_class_id IS
792: SELECT classification_id
799: OPEN csr_get_class_id;
800: FETCH csr_get_class_id into l_classification_id;
801: CLOSE csr_get_class_id;
802:
803: INSERT INTO pay_ele_tmplt_class_usages
804: (ele_template_classification_id
805: ,classification_id
806: ,template_id
807: ,display_process_mode
861: ----------------------------------------------------------------------------
862: FOR c_rec in c_template LOOP
863: l_template_id := c_rec.template_id;
864:
865: DELETE FROM pay_ele_tmplt_class_usages
866: WHERE template_id = l_template_id;
867:
868: pay_element_template_api.delete_user_structure
869: (p_validate => false
1035: ,p_effective_date => l_effective_date
1036: );
1037:
1038: -------------------------------------------------------------------------
1039: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
1040: -------------------------------------------------------------------------
1041: DECLARE
1042: CURSOR csr_get_class_id IS
1043: SELECT classification_id
1050: OPEN csr_get_class_id;
1051: FETCH csr_get_class_id into l_classification_id;
1052: CLOSE csr_get_class_id;
1053:
1054: INSERT INTO pay_ele_tmplt_class_usages
1055: (ele_template_classification_id
1056: ,classification_id
1057: ,template_id
1058: ,display_process_mode
1103: ----------------------------------------------------------------------------
1104: FOR c_rec in c_template LOOP
1105: l_template_id := c_rec.template_id;
1106:
1107: DELETE FROM pay_ele_tmplt_class_usages
1108: WHERE template_id = l_template_id;
1109:
1110: pay_element_template_api.delete_user_structure
1111: (p_validate => false
1288: ,p_object_version_number => l_ovn
1289: ,p_effective_date => l_effective_date
1290: );
1291: -------------------------------------------------------------------------
1292: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
1293: -------------------------------------------------------------------------
1294: DECLARE
1295: CURSOR csr_get_class_id IS
1296: SELECT classification_id
1303: OPEN csr_get_class_id;
1304: FETCH csr_get_class_id into l_classification_id;
1305: CLOSE csr_get_class_id;
1306:
1307: INSERT INTO pay_ele_tmplt_class_usages
1308: (ele_template_classification_id
1309: ,classification_id
1310: ,template_id
1311: ,display_process_mode
1363: ----------------------------------------------------------------------------
1364: FOR c_rec in c_template LOOP
1365: l_template_id := c_rec.template_id;
1366:
1367: DELETE FROM pay_ele_tmplt_class_usages
1368: WHERE template_id = l_template_id;
1369:
1370: pay_element_template_api.delete_user_structure
1371: (p_validate => false
1771: ,p_object_version_number => l_ovn
1772: ,p_effective_date => l_effective_date
1773: );
1774: -------------------------------------------------------------------------
1775: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
1776: -------------------------------------------------------------------------
1777: DECLARE
1778: CURSOR csr_get_class_id IS
1779: SELECT classification_id
1786: OPEN csr_get_class_id;
1787: FETCH csr_get_class_id into l_classification_id;
1788: CLOSE csr_get_class_id;
1789:
1790: INSERT INTO pay_ele_tmplt_class_usages
1791: (ele_template_classification_id
1792: ,classification_id
1793: ,template_id
1794: ,display_process_mode
1841: ----------------------------------------------------------------------------
1842: FOR c_rec in c_template LOOP
1843: l_template_id := c_rec.template_id;
1844:
1845: DELETE FROM pay_ele_tmplt_class_usages
1846: WHERE template_id = l_template_id;
1847:
1848: pay_element_template_api.delete_user_structure
1849: (p_validate => false
2160: ,p_effective_date => l_effective_date
2161: );
2162:
2163: -------------------------------------------------------------------------
2164: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
2165: -------------------------------------------------------------------------
2166: DECLARE
2167: CURSOR csr_get_class_id IS
2168: SELECT classification_id
2175: OPEN csr_get_class_id;
2176: FETCH csr_get_class_id into l_classification_id;
2177: CLOSE csr_get_class_id;
2178:
2179: INSERT INTO pay_ele_tmplt_class_usages
2180: (ele_template_classification_id
2181: ,classification_id
2182: ,template_id
2183: ,display_process_mode
2230: ----------------------------------------------------------------------------
2231: FOR c_rec in c_template LOOP
2232: l_template_id := c_rec.template_id;
2233:
2234: DELETE FROM pay_ele_tmplt_class_usages
2235: WHERE template_id = l_template_id;
2236:
2237: pay_element_template_api.delete_user_structure
2238: (p_validate => false
2471: ,p_effective_date => l_effective_date
2472: );
2473:
2474: -------------------------------------------------------------------------
2475: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
2476: -------------------------------------------------------------------------
2477: DECLARE
2478: CURSOR csr_get_class_id IS
2479: SELECT classification_id
2486: OPEN csr_get_class_id;
2487: FETCH csr_get_class_id into l_classification_id;
2488: CLOSE csr_get_class_id;
2489:
2490: INSERT INTO pay_ele_tmplt_class_usages
2491: (ele_template_classification_id
2492: ,classification_id
2493: ,template_id
2494: ,display_process_mode
2540: ----------------------------------------------------------------------------
2541: FOR c_rec in c_template LOOP
2542: l_template_id := c_rec.template_id;
2543:
2544: DELETE FROM pay_ele_tmplt_class_usages
2545: WHERE template_id = l_template_id;
2546:
2547: pay_element_template_api.delete_user_structure
2548: (p_validate => false
2780: ,p_object_version_number => l_ovn
2781: ,p_effective_date => l_effective_date
2782: );
2783: -------------------------------------------------------------------------
2784: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
2785: -------------------------------------------------------------------------
2786: DECLARE
2787: CURSOR csr_get_class_id IS
2788: SELECT classification_id
2795: OPEN csr_get_class_id;
2796: FETCH csr_get_class_id into l_classification_id;
2797: CLOSE csr_get_class_id;
2798:
2799: INSERT INTO pay_ele_tmplt_class_usages
2800: (ele_template_classification_id
2801: ,classification_id
2802: ,template_id
2803: ,display_process_mode
2847: ----------------------------------------------------------------------------
2848: FOR c_rec in c_template LOOP
2849: l_template_id := c_rec.template_id;
2850:
2851: DELETE FROM pay_ele_tmplt_class_usages
2852: WHERE template_id = l_template_id;
2853:
2854: pay_element_template_api.delete_user_structure
2855: (p_validate => false
3040: ,p_effective_date => l_effective_date
3041: );
3042:
3043: -------------------------------------------------------------------------
3044: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
3045: -------------------------------------------------------------------------
3046: DECLARE
3047: CURSOR csr_get_class_id IS
3048: SELECT classification_id
3055: OPEN csr_get_class_id;
3056: FETCH csr_get_class_id into l_classification_id;
3057: CLOSE csr_get_class_id;
3058:
3059: INSERT INTO pay_ele_tmplt_class_usages
3060: (ele_template_classification_id
3061: ,classification_id
3062: ,template_id
3063: ,display_process_mode
3109: ----------------------------------------------------------------------------
3110: FOR c_rec in c_template LOOP
3111: l_template_id := c_rec.template_id;
3112:
3113: DELETE FROM pay_ele_tmplt_class_usages
3114: WHERE template_id = l_template_id;
3115:
3116: pay_element_template_api.delete_user_structure
3117: (p_validate => false
3362: ,p_effective_date => l_effective_date
3363: );
3364:
3365: -------------------------------------------------------------------------
3366: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
3367: -------------------------------------------------------------------------
3368: DECLARE
3369: CURSOR csr_get_class_id IS
3370: SELECT classification_id
3377: OPEN csr_get_class_id;
3378: FETCH csr_get_class_id into l_classification_id;
3379: CLOSE csr_get_class_id;
3380:
3381: INSERT INTO pay_ele_tmplt_class_usages
3382: (ele_template_classification_id
3383: ,classification_id
3384: ,template_id
3385: ,display_process_mode
3431: ----------------------------------------------------------------------------
3432: FOR c_rec in c_template LOOP
3433: l_template_id := c_rec.template_id;
3434:
3435: DELETE FROM pay_ele_tmplt_class_usages
3436: WHERE template_id = l_template_id;
3437:
3438: pay_element_template_api.delete_user_structure
3439: (p_validate => false
3633: ,p_effective_date => l_effective_date
3634: );
3635:
3636: -------------------------------------------------------------------------
3637: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
3638: -------------------------------------------------------------------------
3639: DECLARE
3640: CURSOR csr_get_class_id IS
3641: SELECT classification_id
3648: OPEN csr_get_class_id;
3649: FETCH csr_get_class_id into l_classification_id;
3650: CLOSE csr_get_class_id;
3651:
3652: INSERT INTO pay_ele_tmplt_class_usages
3653: (ele_template_classification_id
3654: ,classification_id
3655: ,template_id
3656: ,display_process_mode
3704: ----------------------------------------------------------------------------
3705: FOR c_rec in c_template LOOP
3706: l_template_id := c_rec.template_id;
3707:
3708: DELETE FROM pay_ele_tmplt_class_usages
3709: WHERE template_id = l_template_id;
3710:
3711: pay_element_template_api.delete_user_structure
3712: (p_validate => false
3986: ,p_effective_date => l_effective_date
3987: );
3988:
3989: -------------------------------------------------------------------------
3990: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
3991: -------------------------------------------------------------------------
3992: DECLARE
3993: CURSOR csr_get_class_id IS
3994: SELECT classification_id
4001: OPEN csr_get_class_id;
4002: FETCH csr_get_class_id into l_classification_id;
4003: CLOSE csr_get_class_id;
4004:
4005: INSERT INTO pay_ele_tmplt_class_usages
4006: (ele_template_classification_id
4007: ,classification_id
4008: ,template_id
4009: ,display_process_mode
4060: ----------------------------------------------------------------------------
4061: FOR c_rec in c_template LOOP
4062: l_template_id := c_rec.template_id;
4063:
4064: DELETE FROM pay_ele_tmplt_class_usages
4065: WHERE template_id = l_template_id;
4066:
4067: pay_element_template_api.delete_user_structure
4068: (p_validate => false
4400: ,p_effective_date => l_effective_date
4401: );
4402:
4403: -------------------------------------------------------------------------
4404: -- SECTION 7 : Insert into pay_ele_tmplt_class_usages
4405: -------------------------------------------------------------------------
4406: DECLARE
4407: CURSOR csr_get_class_id IS
4408: SELECT classification_id
4415: OPEN csr_get_class_id;
4416: FETCH csr_get_class_id into l_classification_id;
4417: CLOSE csr_get_class_id;
4418:
4419: INSERT INTO pay_ele_tmplt_class_usages
4420: (ele_template_classification_id
4421: ,classification_id
4422: ,template_id
4423: ,display_process_mode