APPS.PA_CREATE_RESOURCE dependencies on PA_PLAN_RL_FORMATS

Line 931: pa_plan_rl_formats_pvt.Create_Plan_RL_Format(

927: LOOP
928: fetch csr_get_formats into l_format_id, l_res_class_id,
929: l_res_class_code;
930: exit when csr_get_formats%NOTFOUND;
931: pa_plan_rl_formats_pvt.Create_Plan_RL_Format(
932: P_Res_List_Id => l_resource_list_id,
933: P_Res_Format_Id => l_format_id,
934: X_Plan_RL_Format_Id => l_plan_rl_format_id,
935: X_Record_Version_Number => l_record_version_number,

Line 1033: pa_plan_rl_formats_pvt.Create_Plan_RL_Format(

1029: open csr_get_default_format; --Added for CBS::13535688
1030: fetch csr_get_default_format into l_format_id, l_res_class_id,
1031: l_res_class_code;
1032:
1033: pa_plan_rl_formats_pvt.Create_Plan_RL_Format(
1034: P_Res_List_Id => l_resource_list_id,
1035: P_Res_Format_Id => l_format_id,
1036: X_Plan_RL_Format_Id => l_plan_rl_format_id,
1037: X_Record_Version_Number => l_record_version_number,

Line 1177: from pa_plan_rl_formats prl,

1173: * irrespective of the format.
1174: ***********************************************************/
1175: CURSOR chk_wp_change_allowed IS
1176: select count(typ.res_type_code)-- , typ.res_type_code
1177: from pa_plan_rl_formats prl,
1178: pa_res_formats_b fmt,
1179: pa_res_types_b typ
1180: where prl.resource_list_id = p_resource_list_id
1181: and prl.res_format_id = fmt.res_format_id

Line 1513: pa_plan_rl_formats_pvt.Create_Plan_RL_Format(

1509: LOOP
1510: fetch csr_get_formats into l_format_id, l_res_class_id,
1511: l_res_class_code;
1512: exit when csr_get_formats%NOTFOUND;
1513: pa_plan_rl_formats_pvt.Create_Plan_RL_Format(
1514: P_Res_List_Id => p_resource_list_id,
1515: P_Res_Format_Id => l_format_id,
1516: X_Plan_RL_Format_Id => l_plan_rl_format_id,
1517: X_Record_Version_Number => l_record_version_number,

Line 1600: pa_plan_rl_formats_pvt.Create_Plan_RL_Format(

1596: open csr_get_default_format; --Added for CBS::13535688
1597: fetch csr_get_default_format into l_format_id, l_res_class_id,
1598: l_res_class_code;
1599:
1600: pa_plan_rl_formats_pvt.Create_Plan_RL_Format(
1601: P_Res_List_Id => p_resource_list_id,
1602: P_Res_Format_Id => l_format_id,
1603: X_Plan_RL_Format_Id => l_plan_rl_format_id,
1604: X_Record_Version_Number => l_record_version_number,

Line 3960: delete from pa_plan_rl_formats

3956: delete from pa_resource_list_members
3957: where resource_list_id = p_resource_list_id;
3958:
3959: -- Delete resource formats from the list
3960: delete from pa_plan_rl_formats
3961: where resource_list_id = p_resource_list_id;
3962:
3963: -- Delete the planning resource list - TL
3964: delete from pa_resource_lists_tl

Line 4644: INSERT INTO pa_plan_rl_formats

4640: and T.LANGUAGE = L.LANGUAGE_CODE);
4641:
4642:
4643: -- hr_utility.trace('TL insert');
4644: INSERT INTO pa_plan_rl_formats
4645: (SELECT
4646: Pa_Plan_RL_Formats_S.nextval,
4647: X_Resource_List_Id,
4648: res_format_id,

Line 4646: Pa_Plan_RL_Formats_S.nextval,

4642:
4643: -- hr_utility.trace('TL insert');
4644: INSERT INTO pa_plan_rl_formats
4645: (SELECT
4646: Pa_Plan_RL_Formats_S.nextval,
4647: X_Resource_List_Id,
4648: res_format_id,
4649: 1,
4650: sysdate,

Line 4656: pa_plan_rl_formats

4652: sysdate,
4653: fnd_global.user_id,
4654: fnd_global.login_id
4655: FROM
4656: pa_plan_rl_formats
4657: WHERE
4658: resource_list_id=p_parent_resource_list_id
4659: AND p_migration_code IN ('N','M')); --Bug 3710189
4660: