APPS.RG_REPORTS_PKG dependencies on RG_REPORTS

Line 1: PACKAGE BODY RG_REPORTS_PKG AS

1: PACKAGE BODY RG_REPORTS_PKG AS
2: /* $Header: rgireptb.pls 120.7 2003/10/24 23:55:27 vtreiger ship $ */
3:
4: --
5: -- PRIVATE

Line 11: -- find the record in rg_reports wiht report_id which stored in recinfo

7: --
8: -- NAME
9: -- select_row
10: -- DESCRIPTION
11: -- find the record in rg_reports wiht report_id which stored in recinfo
12: -- PARAMETERS
13: -- 1. recinfo
14: --
15: --

Line 16: PROCEDURE select_row (recinfo IN OUT NOCOPY rg_reports%ROWTYPE) IS

12: -- PARAMETERS
13: -- 1. recinfo
14: --
15: --
16: PROCEDURE select_row (recinfo IN OUT NOCOPY rg_reports%ROWTYPE) IS
17: BEGIN
18: SELECT *
19: INTO recinfo
20: FROM rg_reports

Line 20: FROM rg_reports

16: PROCEDURE select_row (recinfo IN OUT NOCOPY rg_reports%ROWTYPE) IS
17: BEGIN
18: SELECT *
19: INTO recinfo
20: FROM rg_reports
21: WHERE report_id = recinfo.report_id;
22: END select_row;
23:
24: --

Line 32: SELECT rg_reports_s.nextval

28:
29: FUNCTION get_report_id RETURN NUMBER IS
30: new_sequence_number NUMBER;
31: BEGIN
32: SELECT rg_reports_s.nextval
33: INTO new_sequence_number
34: FROM dual;
35:
36: RETURN(new_sequence_number);

Line 118: FROM rg_reports

114: BEGIN
115: SELECT 1 INTO dummy FROM dual
116: WHERE NOT EXISTS
117: (SELECT 1
118: FROM rg_reports
119: WHERE report_id <> cur_report_id
120: AND name = new_name
121: AND application_id = cur_application_id
122: );

Line 187: FROM rg_reports

183: X_Attribute14 VARCHAR2,
184: X_Attribute15 VARCHAR2
185: ) IS
186: CURSOR C IS SELECT rowid
187: FROM rg_reports
188: WHERE report_id = X_Report_Id;
189: BEGIN
190:
191: IF (X_Report_Id IS NULL) THEN

Line 212: INSERT INTO rg_reports(

208: APP_EXCEPTION.raise_exception;
209: END IF;
210: END IF;
211:
212: INSERT INTO rg_reports(
213: application_id,
214: report_id,
215: last_update_date,
216: last_updated_by,

Line 353: FROM rg_reports

349: X_Attribute15 VARCHAR2
350: ) IS
351: CURSOR C IS
352: SELECT *
353: FROM rg_reports
354: WHERE rowid = X_Rowid
355: FOR UPDATE of Report_Id NOWAIT;
356: Recinfo C%ROWTYPE;
357: BEGIN

Line 529: UPDATE rg_reports

525: X_Attribute14 VARCHAR2,
526: X_Attribute15 VARCHAR2
527: ) IS
528: BEGIN
529: UPDATE rg_reports
530: SET
531: application_id = X_Application_Id,
532: report_id = X_Report_Id,
533: last_update_date = X_Last_Update_Date,

Line 585: FROM rg_reports

581: BEGIN
582:
583: SELECT nvl(parameter_set_id,-1)
584: INTO X_parameter_set_id
585: FROM rg_reports
586: WHERE rowid = X_Rowid;
587:
588: DELETE FROM rg_reports
589: WHERE rowid = X_Rowid;

Line 588: DELETE FROM rg_reports

584: INTO X_parameter_set_id
585: FROM rg_reports
586: WHERE rowid = X_Rowid;
587:
588: DELETE FROM rg_reports
589: WHERE rowid = X_Rowid;
590:
591: if (SQL%NOTFOUND) then
592: RAISE NO_DATA_FOUND;

Line 615: recinfo rg_reports%ROWTYPE;

611: -- 2. Report name
612: --
613: PROCEDURE select_columns(report_id IN NUMBER,
614: name IN OUT NOCOPY VARCHAR2) IS
615: recinfo rg_reports%ROWTYPE;
616: BEGIN
617: recinfo.report_id := report_id;
618: select_row(recinfo);
619: name := recinfo.name;

Line 750: FROM rg_reports

746: IS
747: CURSOR report IS
748: SELECT application_id, id_flex_code, structure_id,
749: segment_override, override_alc_ledger_currency
750: FROM rg_reports
751: WHERE report_id = x_report_id;
752:
753: appl_id NUMBER;
754: flex_code VARCHAR2(4);

Line 805: END RG_REPORTS_PKG;

801: RETURN conv_seg_override;
802:
803: END find_report_segment_override;
804:
805: END RG_REPORTS_PKG;