APPS.RG_DSS_SYSTEM_VARIABLES_PKG dependencies on RG_DSS_SYSTEM_VARIABLES

Line 1: PACKAGE BODY RG_DSS_SYSTEM_VARIABLES_PKG as

1: PACKAGE BODY RG_DSS_SYSTEM_VARIABLES_PKG as
2: /* $Header: rgidsvrb.pls 120.2 2002/11/14 02:59:03 djogg ship $ */
3:
4:
5:

Line 15: FROM rg_dss_system_variables

11: dummy NUMBER;
12: BEGIN
13: SELECT 1
14: INTO dummy
15: FROM rg_dss_system_variables
16: WHERE system_id = X_System_Id
17: AND variable_id = X_Variable_Id
18: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
19:

Line 60: FROM rg_dss_system_variables

56: X_Attribute14 VARCHAR2,
57: X_Attribute15 VARCHAR2) IS
58: CURSOR C IS
59: SELECT rowid
60: FROM rg_dss_system_variables
61: WHERE system_variable_id = X_System_Variable_Id;
62:
63: CURSOR C2 IS
64: SELECT rg_dss_system_variables_s.nextval

Line 64: SELECT rg_dss_system_variables_s.nextval

60: FROM rg_dss_system_variables
61: WHERE system_variable_id = X_System_Variable_Id;
62:
63: CURSOR C2 IS
64: SELECT rg_dss_system_variables_s.nextval
65: FROM dual;
66:
67: BEGIN
68:

Line 77: INSERT INTO rg_dss_system_variables(

73: FETCH C2 INTO X_System_Variable_Id;
74: CLOSE C2;
75: END IF;
76:
77: INSERT INTO rg_dss_system_variables(
78: system_id,
79: variable_id,
80: system_variable_id,
81: last_update_date,

Line 166: FROM rg_dss_system_variables

162: X_Attribute15 VARCHAR2
163: ) IS
164: CURSOR C IS
165: SELECT *
166: FROM rg_dss_system_variables
167: WHERE rowid = X_Rowid
168: FOR UPDATE of system_variable_id NOWAIT;
169: Recinfo C%ROWTYPE;
170: BEGIN

Line 272: UPDATE rg_dss_system_variables

268: X_Attribute14 VARCHAR2,
269: X_Attribute15 VARCHAR2) IS
270: BEGIN
271:
272: UPDATE rg_dss_system_variables
273: SET
274: system_id = X_System_Id,
275: variable_id = X_Variable_Id,
276: system_variable_id = X_System_Variable_Id,

Line 307: DELETE FROM rg_dss_system_variables

303:
304: PROCEDURE delete_row(X_Rowid VARCHAR2) IS
305: BEGIN
306:
307: DELETE FROM rg_dss_system_variables
308: WHERE rowid = X_Rowid;
309:
310: IF (SQL%NOTFOUND) THEN
311: RAISE NO_DATA_FOUND;

Line 317: END RG_DSS_SYSTEM_VARIABLES_PKG;

313:
314: END delete_row;
315:
316:
317: END RG_DSS_SYSTEM_VARIABLES_PKG;