[Home] [Help]
30: Cursor c1 is
31: Select
32: b.res_type_code,a.Res_Type_Id, a.resource_class_id
33: From
34: Pa_Res_Formats_B a,pa_res_types_b b
35: Where
36: Res_Format_Id = P_Res_Format_Id
37: AND a.res_type_id = b.res_type_id;
38:
37: AND a.res_type_id = b.res_type_id;
38:
39: CURSOR chk_job_format(P_Res_Format_Id IN NUMBER) IS
40: SELECT 'Y'
41: FROM Pa_Res_Formats_B fmt,
42: pa_res_types_b typ
43: WHERE fmt.Res_Format_Id = P_Res_Format_Id
44: AND fmt.res_type_id = typ.res_type_id
45: AND typ.res_type_code = 'JOB';
46:
47: Cursor c2 (P_Res_Type_Id IN Number,
48: P_Res_Class_Id IN Number) is
49: Select 'Y'
50: From Pa_Res_Formats_b fmt
51: Where fmt.Res_Type_Id = P_Res_Type_Id
52: And fmt.Resource_Class_Id = P_Res_Class_Id
53: And exists (Select 'Y'
54: From Pa_Plan_RL_Formats prf
91: * Suppose this resource list has 3 formats associated to it already
92: * (formats 1, 2 and 3).
93: * Now the user is trying to add a fourth format, format 4, and used for
94: * WP flag = Y.
95: * The validation is that the res_type_id of format 4 (from pa_res_formats_b)
96: * cannot be the
97: * same as the res_type_id for each of formats 1, 2 and 3. So, first we
98: * have to get all the
99: * formats associated to the list (from pa_plan_rl_formats), and for each
97: * same as the res_type_id for each of formats 1, 2 and 3. So, first we
98: * have to get all the
99: * formats associated to the list (from pa_plan_rl_formats), and for each
100: * of them, we have
101: * to get the res_type_id from pa_res_formats_b, and compare to the
102: * res_type_id for the p_format_id we are trying to add.
103: * If they do, then raise an error message "PA_PLAN_RL_FORMAT_WP_ERR"
104: **************************************************************************/
105: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;