DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_PKG dependencies on PA_CONTROL_ITEMS_S

Line 106: SELECT pa_control_items_s.nextval

102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103:
104: --get the unique control item id from the Oracle Sequence
105: IF (px_ci_id is null) THEN
106: SELECT pa_control_items_s.nextval
107: INTO l_ci_id
108: FROM DUAL;
109: px_ci_id := l_ci_id;
110: END IF;

Line 383: update PA_CONTROL_ITEMS set

379: ) is
380: begin
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: update PA_CONTROL_ITEMS set
384: ci_type_id = Nvl(p_ci_type_id,ci_type_id)
385: ,summary = Nvl(p_summary,summary)
386: ,status_code = Nvl(p_status_code, status_code)
387: ,owner_id = Nvl(p_owner_id,owner_id)