DBA Data[Home] [Help]

APPS.FA_RX_PARAMETERS_PKG dependencies on FA_RX_REP_PARAMETERS

Line 21: cursor c is select rowid from fa_rx_rep_parameters

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:

Line 27: insert into fa_rx_rep_parameters (

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)

Line 66: FROM FA_RX_REP_parameters

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:

Line 119: update fa_rx_rep_parameters set

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,

Line 153: delete from fa_rx_rep_parameters

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;