[Home] [Help]
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79:
80: --get the unique control item id from the Oracle Sequence
81: IF (px_ci_id is null) THEN
82: SELECT pa_control_items_s.nextval
83: INTO l_ci_id
84: FROM DUAL;
85: px_ci_id := l_ci_id;
86: END IF;
295: ) is
296: begin
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: update PA_CONTROL_ITEMS set
300: ci_type_id = Nvl(p_ci_type_id,ci_type_id)
301: ,summary = Nvl(p_summary,summary)
302: ,status_code = Nvl(p_status_code, status_code)
303: ,owner_id = Nvl(p_owner_id,owner_id)