[Home] [Help]
23: and cap.cagr_api_id = api.cagr_Api_id
24: and api.api_name = X_API_NAME;
25:
26: cursor CSR_SEQUENCE is
27: select PER_CAGR_API_PARAMETERS_S.nextval
28: from dual;
29:
30: begin
31: open CSR_CAGR_API ( X_API_NAME );
344: X_LAST_UPDATED_BY in NUMBER,
345: X_LAST_UPDATE_LOGIN in NUMBER
346: ) is
347: begin
348: update PER_CAGR_API_PARAMETERS set
349: DEFAULT_UOM = X_DEFAULT_UOM,
350: CAGR_API_ID = X_CAGR_API_ID,
351: PARAMETER_NAME = X_PARAMETER_NAME,
352: DISPLAY_NAME = X_DISPLAY_NAME,