[Home] [Help]
909: LOOP
910: fetch csr_get_formats into l_format_id, l_res_class_id,
911: l_res_class_code;
912: exit when csr_get_formats%NOTFOUND;
913: pa_plan_rl_formats_pvt.Create_Plan_RL_Format(
914: P_Res_List_Id => l_resource_list_id,
915: P_Res_Format_Id => l_format_id,
916: X_Plan_RL_Format_Id => l_plan_rl_format_id,
917: X_Record_Version_Number => l_record_version_number,
1047: * irrespective of the format.
1048: ***********************************************************/
1049: CURSOR chk_wp_change_allowed IS
1050: select count(typ.res_type_code)-- , typ.res_type_code
1051: from pa_plan_rl_formats prl,
1052: pa_res_formats_b fmt,
1053: pa_res_types_b typ
1054: where prl.resource_list_id = p_resource_list_id
1055: and prl.res_format_id = fmt.res_format_id
3607: delete from pa_resource_list_members
3608: where resource_list_id = p_resource_list_id;
3609:
3610: -- Delete resource formats from the list
3611: delete from pa_plan_rl_formats
3612: where resource_list_id = p_resource_list_id;
3613:
3614: -- Delete the planning resource list - TL
3615: delete from pa_resource_lists_tl
4287: and T.LANGUAGE = L.LANGUAGE_CODE);
4288:
4289:
4290: -- hr_utility.trace('TL insert');
4291: INSERT INTO pa_plan_rl_formats
4292: (SELECT
4293: Pa_Plan_RL_Formats_S.nextval,
4294: X_Resource_List_Id,
4295: res_format_id,
4289:
4290: -- hr_utility.trace('TL insert');
4291: INSERT INTO pa_plan_rl_formats
4292: (SELECT
4293: Pa_Plan_RL_Formats_S.nextval,
4294: X_Resource_List_Id,
4295: res_format_id,
4296: 1,
4297: sysdate,
4299: sysdate,
4300: fnd_global.user_id,
4301: fnd_global.login_id
4302: FROM
4303: pa_plan_rl_formats
4304: WHERE
4305: resource_list_id=p_parent_resource_list_id
4306: AND p_migration_code IN ('N','M')); --Bug 3710189
4307: