27: cursor C is select ROWID from PA_PLAN_RES_DEFAULTS
28: where plan_res_default_id = l_plan_res_default_id;
29: begin
30:
31: select nvl(X_PLAN_RES_DEFAULT_ID,PA_PLAN_RES_DEFAULTS_S.nextval)
32: into l_plan_res_default_id
33: from dual;
34:
35: insert into PA_PLAN_RES_DEFAULTS (
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158: x_msg_count := 0;
159:
160:
161: update PA_PLAN_RES_DEFAULTS set
162: RESOURCE_CLASS_ID = P_RESOURCE_CLASS_ID,
163: OBJECT_TYPE = P_OBJECT_TYPE,
164: OBJECT_ID = P_OBJECT_ID,
165: SPREAD_CURVE_ID = P_SPREAD_CURVE_ID,