APPS.IEC_G_REP_REPORTS_VALS_PKG dependencies on IEC_G_REP_REPORTS_VALS

Line 1: package body IEC_G_REP_REPORTS_VALS_PKG as

1: package body IEC_G_REP_REPORTS_VALS_PKG as
2: /* $Header: IECREPVB.pls 115.0 2004/03/24 05:12:27 anayak noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 18: from IEC_G_REP_REPORTS_VALS

14: X_LAST_UPDATE_LOGIN in NUMBER,
15: X_OBJECT_VERSION_NUMBER in NUMBER
16: ) is
17: cursor C is select ROWID
18: from IEC_G_REP_REPORTS_VALS
19: where
20: VALUE_ID = X_VALUE_ID
21: and PARAM_NAME = X_PARAM_NAME
22: and PARAM_VALUE = X_PARAM_VALUE

Line 27: insert into iec_g_rep_reports_vals

23: and REPORT_ID = X_REPORT_ID;
24:
25: begin
26:
27: insert into iec_g_rep_reports_vals
28: ( VALUE_ID,
29: PARAM_NAME,
30: PARAM_VALUE,
31: REPORT_ID,

Line 71: from iec_g_rep_reports_vals

67: PARAM_NAME,
68: PARAM_VALUE,
69: REPORT_ID,
70: OBJECT_VERSION_NUMBER
71: from iec_g_rep_reports_vals
72: where VALUE_ID = X_VALUE_ID
73: for update of PARAM_NAME, PARAM_VALUE, REPORT_ID, OBJECT_VERSION_NUMBER nowait;
74: recinfo c%rowtype;
75: begin

Line 109: update iec_g_rep_reports_vals

105: X_OBJECT_VERSION_NUMBER in NUMBER
106: ) is
107: begin
108:
109: update iec_g_rep_reports_vals
110: set LAST_UPDATED_BY = X_LAST_UPDATED_BY,
111: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
112: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
113: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 130: delete from iec_g_rep_reports_vals

126: procedure DELETE_ROW (
127: X_VALUE_ID in NUMBER
128: ) is
129: begin
130: delete from iec_g_rep_reports_vals
131: where VALUE_ID = X_VALUE_ID;
132:
133: if (sql%notfound) then
134: raise no_data_found;

Line 161: end IEC_G_REP_REPORTS_VALS_PKG;

157: INSERT_ROW (ROW_ID, X_VALUE_ID, X_PARAM_NAME, X_PARAM_VALUE, X_REPORT_ID, 0, SYSDATE, USER_ID, SYSDATE, USER_ID, 0);
158:
159: end LOAD_ROW;
160:
161: end IEC_G_REP_REPORTS_VALS_PKG;