APPS.RG_DSS_VAR_TEMPLATES_PKG dependencies on RG_DSS_VAR_TEMPLATES

Line 1: PACKAGE BODY RG_DSS_VAR_TEMPLATES_PKG as

1: PACKAGE BODY RG_DSS_VAR_TEMPLATES_PKG as
2: /*$Header: rgidvtlb.pls 120.3 2003/04/29 00:47:35 djogg ship $*/
3:
4: FUNCTION validate_templates(X_Variable_Id NUMBER) RETURN VARCHAR2 IS
5: X_Segment1 VARCHAR2(25);

Line 108: FROM rg_dss_var_templates

104: INTO dummy
105: FROM dual
106: WHERE exists (
107: SELECT 'x'
108: FROM rg_dss_var_templates
109: WHERE variable_id = X_Variable_Id );
110: EXCEPTION
111: WHEN NO_DATA_FOUND THEN
112: return('I');

Line 121: FROM rg_dss_var_templates

117: INTO dummy
118: FROM dual
119: WHERE exists (
120: SELECT 'Bad'
121: FROM rg_dss_var_templates
122: WHERE
123: variable_id = X_Variable_Id
124: AND ( instr(decode(X_Segment1,'ANY','DTR',X_Segment1),
125: decode(Segment1_Type,'D','D','T','T','R')) = 0

Line 206: RG_DSS_VAR_TEMPLATES vt

202: BEGIN
203: SELECT st.template_id,st.template_name
204: INTO X_New_Template_Id,X_New_Template_Name
205: FROM GL_SUMMARY_TEMPLATES st,
206: RG_DSS_VAR_TEMPLATES vt
207: WHERE vt.variable_id = X_Variable_Id
208: AND vt.template_id = X_Template_Id
209: AND st.ledger_id = X_Ledger_Id
210: AND st.status = 'F'

Line 248: 'RG_DSS_VAR_TEMPLATES.Get_New_Template_Id');

244: X_New_Template_Id := -1;
245: WHEN OTHERS THEN
246: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
247: fnd_message.set_token('PROCEDURE',
248: 'RG_DSS_VAR_TEMPLATES.Get_New_Template_Id');
249: RAISE;
250: END Get_New_Template_Id;
251:
252: PROCEDURE check_unique_template(X_Rowid VARCHAR2,

Line 259: FROM rg_dss_var_templates

255: dummy NUMBER;
256: BEGIN
257: SELECT 1
258: INTO dummy
259: FROM rg_dss_var_templates
260: WHERE variable_id = X_Variable_Id
261: AND template_id = X_Template_Id
262: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
263:

Line 330: CURSOR C IS SELECT rowid FROM RG_DSS_VAR_TEMPLATES

326: X_Attribute13 VARCHAR2,
327: X_Attribute14 VARCHAR2,
328: X_Attribute15 VARCHAR2
329: ) IS
330: CURSOR C IS SELECT rowid FROM RG_DSS_VAR_TEMPLATES
331: WHERE variable_id = X_Variable_Id
332: AND template_id = X_Template_Id;
333: BEGIN
334:

Line 337: INSERT INTO RG_DSS_VAR_TEMPLATES(

333: BEGIN
334:
335: check_unique_template(X_Rowid, X_Variable_Id, X_Template_Id);
336:
337: INSERT INTO RG_DSS_VAR_TEMPLATES(
338: variable_id,
339: template_id,
340: last_update_date,
341: last_updated_by,

Line 509: FROM RG_DSS_VAR_TEMPLATES

505: X_Attribute15 VARCHAR2
506: ) IS
507: CURSOR C IS
508: SELECT *
509: FROM RG_DSS_VAR_TEMPLATES
510: WHERE rowid = X_Rowid
511: FOR UPDATE of Variable_Id NOWAIT;
512: Recinfo C%ROWTYPE;
513:

Line 730: UPDATE RG_DSS_VAR_TEMPLATES

726: X_Attribute14 VARCHAR2,
727: X_Attribute15 VARCHAR2
728: ) IS
729: BEGIN
730: UPDATE RG_DSS_VAR_TEMPLATES
731: SET
732: variable_id = X_Variable_Id,
733: template_id = X_Template_Id,
734: last_update_date = X_Last_Update_Date,

Line 793: DELETE FROM RG_DSS_VAR_TEMPLATES

789:
790:
791: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
792: BEGIN
793: DELETE FROM RG_DSS_VAR_TEMPLATES
794: WHERE rowid = X_Rowid;
795:
796: if (SQL%NOTFOUND) then
797: Raise NO_DATA_FOUND;

Line 802: END RG_DSS_VAR_TEMPLATES_PKG;

798: end if;
799: END Delete_Row;
800:
801:
802: END RG_DSS_VAR_TEMPLATES_PKG;