DBA Data[Home] [Help]

APPS.PA_PLAN_RES_DEFAULTS_PVT dependencies on PA_PLAN_RES_DEFAULTS_S

Line 31: select nvl(X_PLAN_RES_DEFAULT_ID,PA_PLAN_RES_DEFAULTS_S.nextval)

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 (

Line 161: update PA_PLAN_RES_DEFAULTS set

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,