17: X_parameter_counter number,
18: X_column_name varchar2,
19: X_calling_fn varchar2) is
20:
21: cursor c is select rowid from fa_rx_rep_parameters
22: where report_id = X_report_id and name = X_name;
23:
24: begin
25:
23:
24: begin
25:
26:
27: insert into fa_rx_rep_parameters (
28: report_id, lov_id, name, required,
29: max_length, datatype, relational_op, last_update_date,
30: last_updated_by, created_by, creation_date,
31: last_update_login, parameter_counter, column_name)
62: X_calling_fn varchar2) is
63:
64: cursor c_reports is
65: SELECT *
66: FROM FA_RX_REP_parameters
67: WHERE ROWID = X_ROWID
68: FOR UPDATE OF REPORT_ID, name NOWAIT;
69: Recinfo c_reports%rowtype;
70:
115: X_calling_fn varchar2) is
116:
117: begin
118:
119: update fa_rx_rep_parameters set
120: report_id = X_report_id,
121: lov_id = X_lov_id,
122: name = X_name,
123: required = X_required,
149: X_calling_fn varchar2) is
150: begin
151:
152: if x_rowid is not null then
153: delete from fa_rx_rep_parameters
154: where rowid = X_rowid;
155: else -- error
156: null;
157: end if;