APPS.RG_REPORT_CALCULATIONS_PKG dependencies on RG_REPORT_CALCULATIONS

Line 1: PACKAGE BODY RG_REPORT_CALCULATIONS_PKG AS

1: PACKAGE BODY RG_REPORT_CALCULATIONS_PKG AS
2: -- $Header: rgiraclb.pls 120.3 2006/03/13 19:52:39 ticheng ship $
3: -- Name
4: -- RG_REPORT_CALCULATIONS_PKG
5: -- Purpose

Line 4: -- RG_REPORT_CALCULATIONS_PKG

1: PACKAGE BODY RG_REPORT_CALCULATIONS_PKG AS
2: -- $Header: rgiraclb.pls 120.3 2006/03/13 19:52:39 ticheng ship $
3: -- Name
4: -- RG_REPORT_CALCULATIONS_PKG
5: -- Purpose
6: -- to include all sever side procedures and packages for table
7: -- RG_REPORT_CALCULATIONS
8: -- Notes

Line 7: -- RG_REPORT_CALCULATIONS

3: -- Name
4: -- RG_REPORT_CALCULATIONS_PKG
5: -- Purpose
6: -- to include all sever side procedures and packages for table
7: -- RG_REPORT_CALCULATIONS
8: -- Notes
9: --
10: -- History
11: -- 11/01/93 A Chen Created

Line 26: from rg_report_calculations

22: X_axis_seq NUMBER) RETURN BOOLEAN IS
23: dummy NUMBER;
24: BEGIN
25: select 1 into dummy
26: from rg_report_calculations
27: where axis_set_id = X_axis_set_id
28: and axis_seq = X_axis_seq
29: and rownum < 2;
30: RETURN (TRUE);

Line 42: delete from rg_report_calculations

38: PROCEDURE delete_rows(X_axis_set_id NUMBER,
39: X_axis_seq NUMBER) IS
40: BEGIN
41: IF (X_axis_seq = -1) THEN
42: delete from rg_report_calculations
43: where axis_set_id = X_axis_set_id;
44: ELSE
45: delete from rg_report_calculations
46: where axis_set_id = X_axis_set_id

Line 45: delete from rg_report_calculations

41: IF (X_axis_seq = -1) THEN
42: delete from rg_report_calculations
43: where axis_set_id = X_axis_set_id;
44: ELSE
45: delete from rg_report_calculations
46: where axis_set_id = X_axis_set_id
47: and axis_seq = X_axis_seq;
48: END IF;
49: END delete_rows;

Line 57: (SELECT 1 FROM rg_report_calculations

53: X_axis_seq NUMBER, X_calculation_seq NUMBER) IS
54: Dummy NUMBER;
55: BEGIN
56: SELECT 1 INTO Dummy FROM dual WHERE NOT EXISTS
57: (SELECT 1 FROM rg_report_calculations
58: WHERE axis_set_id = X_axis_set_id
59: AND axis_seq = X_axis_seq
60: AND calculation_seq = X_calculation_seq
61: AND ((X_rowid IS NULL) OR (rowid <> X_rowid))

Line 121: FROM RG_REPORT_CALCULATIONS

117: BEGIN
118: /* Retrieve creation date from existing row */
119: SELECT creation_date, last_updated_by
120: INTO v_creation_date, v_last_updated_by
121: FROM RG_REPORT_CALCULATIONS
122: WHERE axis_set_id = X_axis_set_id
123: AND axis_seq = X_axis_seq
124: AND calculation_seq = X_calculation_seq;
125:

Line 135: UPDATE RG_REPORT_CALCULATIONS

131: /*
132: * Update only if force_edits is 'Y' or owner = 'SEED'
133: */
134: IF (v_user_id = 1 or X_force_edits = 'Y') THEN
135: UPDATE RG_REPORT_CALCULATIONS
136: SET application_id = X_application_id,
137: last_update_date = sysdate,
138: last_updated_by = v_user_id,
139: last_update_login = 0,

Line 176: INSERT INTO RG_REPORT_CALCULATIONS

172: WHEN NO_DATA_FOUND THEN
173: /*
174: * If the row doesn't exist yet, insert.
175: */
176: INSERT INTO RG_REPORT_CALCULATIONS
177: (application_id,
178: axis_set_id,
179: axis_seq,
180: calculation_seq,

Line 262: UPDATE RG_REPORT_CALCULATIONS

258: /*
259: * Update only if force_edits is 'Y' or owner = 'SEED'
260: */
261: IF (v_user_id = 1 or X_force_edits = 'Y') THEN
262: UPDATE RG_REPORT_CALCULATIONS
263: SET axis_name_low = X_axis_name_low,
264: axis_name_high = X_axis_name_high
265: WHERE axis_set_id = X_axis_set_id
266: AND axis_seq = X_axis_seq

Line 274: END RG_REPORT_CALCULATIONS_PKG;

270: WHERE installed_flag = 'B');
271: END IF;
272: END Translate_Row;
273:
274: END RG_REPORT_CALCULATIONS_PKG;