APPS.RG_DSS_VAR_SELECTIONS_PKG dependencies on RG_DSS_VAR_SELECTIONS

Line 1: PACKAGE BODY RG_DSS_VAR_SELECTIONS_PKG as

1: PACKAGE BODY RG_DSS_VAR_SELECTIONS_PKG as
2: /* $Header: rgidvslb.pls 120.2 2002/11/14 02:59:44 djogg ship $ */
3:
4:
5:

Line 15: FROM rg_dss_var_selections

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

Line 63: FROM rg_dss_var_selections

59: X_Attribute14 VARCHAR2,
60: X_Attribute15 VARCHAR2) IS
61: CURSOR C IS
62: SELECT rowid
63: FROM rg_dss_var_selections
64: WHERE selection_Id = X_Selection_Id;
65:
66: CURSOR C2 IS
67: SELECT rg_dss_var_selections_s.nextval

Line 67: SELECT rg_dss_var_selections_s.nextval

63: FROM rg_dss_var_selections
64: WHERE selection_Id = X_Selection_Id;
65:
66: CURSOR C2 IS
67: SELECT rg_dss_var_selections_s.nextval
68: FROM dual;
69:
70: BEGIN
71:

Line 87: INSERT INTO rg_dss_var_selections(

83: FETCH C2 INTO X_Selection_Id;
84: CLOSE C2;
85: END IF;
86:
87: INSERT INTO rg_dss_var_selections(
88: variable_id,
89: id_flex_code,
90: id_flex_num,
91: application_column_name,

Line 185: FROM rg_dss_var_selections

181: X_Attribute15 VARCHAR2
182: ) IS
183: CURSOR C IS
184: SELECT *
185: FROM rg_dss_var_selections
186: WHERE rowid = X_Rowid
187: FOR UPDATE of selection_id NOWAIT;
188: Recinfo C%ROWTYPE;
189: BEGIN

Line 310: UPDATE rg_dss_var_selections

306: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
307: APP_EXCEPTION.raise_exception;
308: END IF;
309:
310: UPDATE rg_dss_var_selections
311: SET
312: variable_id = X_Variable_Id,
313: id_flex_code = X_Id_Flex_Code,
314: id_flex_num = X_Id_Flex_Num,

Line 355: DELETE FROM rg_dss_var_selections

351: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
352: APP_EXCEPTION.raise_exception;
353: END IF;
354:
355: DELETE FROM rg_dss_var_selections
356: WHERE rowid = X_Rowid;
357:
358: IF (SQL%NOTFOUND) THEN
359: RAISE NO_DATA_FOUND;

Line 365: END RG_DSS_VAR_SELECTIONS_PKG;

361:
362: END Delete_Row;
363:
364:
365: END RG_DSS_VAR_SELECTIONS_PKG;