APPS.RG_DSS_VARIABLES_PKG dependencies on RG_DSS_VARIABLES

Line 1: PACKAGE BODY RG_DSS_VARIABLES_PKG as

1: PACKAGE BODY RG_DSS_VARIABLES_PKG as
2: /*$Header: rgidvarb.pls 120.3 2003/04/29 00:47:31 djogg ship $*/
3:
4: /*** PUBLIC FUNCTIONS ***/
5:

Line 9: SELECT rg_dss_variables_s.nextval

5:
6: FUNCTION get_new_id RETURN NUMBER IS
7: new_id NUMBER;
8: BEGIN
9: SELECT rg_dss_variables_s.nextval
10: INTO new_id
11: FROM sys.dual;
12:
13: RETURN(new_id);

Line 103: FROM rg_dss_variables

99: dummy NUMBER;
100: BEGIN
101: SELECT 1
102: INTO dummy
103: FROM rg_dss_variables
104: WHERE name = X_Name
105: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
106:
107: -- name already exists for a different variable: ERROR

Line 124: FROM rg_dss_variables

120: dummy NUMBER;
121: BEGIN
122: SELECT 1
123: INTO dummy
124: FROM rg_dss_variables
125: WHERE object_name = X_Object_Name
126: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
127:
128: -- name already exists for a different variable: ERROR

Line 319: 'RG_DSS_VARIABLES_PKG.generate_matching_struc');

315: RAISE;
316: WHEN OTHERS THEN
317: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
318: fnd_message.set_token('PROCEDURE',
319: 'RG_DSS_VARIABLES_PKG.generate_matching_struc');
320: RAISE;
321: END generate_matching_struc;
322:
323: PROCEDURE insert_row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 393: FROM rg_dss_variables

389: X_Segment30_Type IN OUT NOCOPY VARCHAR2
390: ) IS
391: CURSOR C IS
392: SELECT rowid
393: FROM rg_dss_variables
394: WHERE variable_id = X_Variable_Id;
395:
396: BEGIN
397: check_unique_name(X_Rowid, X_Name);

Line 442: INSERT INTO rg_dss_variables(

438: X_Segment29_Type,
439: X_Segment30_Type);
440: END IF;
441:
442: INSERT INTO rg_dss_variables(
443: variable_id,
444: name,
445: object_name,
446: column_label,

Line 657: FROM rg_dss_variables

653: X_Segment30_Type VARCHAR2
654: ) IS
655: CURSOR C IS
656: SELECT *
657: FROM rg_dss_variables
658: WHERE rowid = X_Rowid
659: FOR UPDATE of variable_id NOWAIT;
660: Recinfo C%ROWTYPE;
661: BEGIN

Line 928: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN

924: X_Segment30_Type IN OUT NOCOPY VARCHAR2
925: ) IS
926: BEGIN
927:
928: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
929: -- can't modify a variable that is used in a frozen system
930: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
931: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
932: APP_EXCEPTION.raise_exception;

Line 973: UPDATE rg_dss_variables

969: X_Segment29_Type,
970: X_Segment30_Type);
971: END IF;
972:
973: UPDATE rg_dss_variables
974: SET
975: variable_id = X_Variable_Id,
976: name = X_Name,
977: object_name = X_Object_Name,

Line 1049: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN

1045: END Update_Row;
1046:
1047: PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Variable_Id NUMBER) IS
1048: BEGIN
1049: IF (RG_DSS_VARIABLES_PKG.used_in_frozen_system(X_Variable_Id)) THEN
1050: -- can't modify a variable that is used in a frozen system
1051: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
1052: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
1053: APP_EXCEPTION.raise_exception;

Line 1065: DELETE FROM rg_dss_variables

1061:
1062: DELETE FROM rg_dss_var_templates
1063: WHERE variable_id = X_Variable_Id;
1064:
1065: DELETE FROM rg_dss_variables
1066: WHERE rowid = X_Rowid;
1067:
1068: IF (SQL%NOTFOUND) THEN
1069: RAISE NO_DATA_FOUND;

Line 1075: END RG_DSS_VARIABLES_PKG;

1071:
1072: END Delete_Row;
1073:
1074:
1075: END RG_DSS_VARIABLES_PKG;