APPS.RG_REPORT_REQUESTS_PKG dependencies on RG_REPORT_REQUESTS

Line 1: PACKAGE BODY RG_REPORT_REQUESTS_PKG as

1: PACKAGE BODY RG_REPORT_REQUESTS_PKG as
2: /* $Header: rgirreqb.pls 120.5 2003/04/29 00:47:54 djogg ship $ */
3:
4:
5: /* Name: init

Line 101: SELECT rg_report_requests_s.nextval

97: RETURN NUMBER
98: IS
99: new_sequence_number NUMBER;
100: BEGIN
101: SELECT rg_report_requests_s.nextval
102: INTO new_sequence_number
103: FROM dual;
104:
105: RETURN(new_sequence_number);

Line 118: FROM rg_report_requests

114: rec_returned NUMBER;
115: BEGIN
116: SELECT count(*)
117: INTO rec_returned
118: FROM rg_report_requests
119: WHERE report_set_id = cur_report_set_id
120: AND report_request_id <> cur_report_request_id
121: AND sequence = new_sequence;
122:

Line 177: CURSOR C IS SELECT rowid FROM RG_REPORT_REQUESTS

173: X_Attribute14 VARCHAR2,
174: X_Attribute15 VARCHAR2,
175: X_Runtime_Option_Context VARCHAR2
176: ) IS
177: CURSOR C IS SELECT rowid FROM RG_REPORT_REQUESTS
178:
179: WHERE report_request_id = X_Report_Request_Id;
180:
181: BEGIN

Line 183: INSERT INTO RG_REPORT_REQUESTS(

179: WHERE report_request_id = X_Report_Request_Id;
180:
181: BEGIN
182:
183: INSERT INTO RG_REPORT_REQUESTS(
184: application_id,
185: report_request_id,
186: last_update_date,
187: last_updated_by,

Line 328: FROM RG_REPORT_REQUESTS

324: X_Runtime_Option_Context VARCHAR2
325: ) IS
326: CURSOR C IS
327: SELECT *
328: FROM RG_REPORT_REQUESTS
329: WHERE rowid = X_Rowid
330: FOR UPDATE of Report_Request_Id NOWAIT;
331: Recinfo C%ROWTYPE;
332: BEGIN

Line 512: UPDATE RG_REPORT_REQUESTS

508: X_Attribute15 VARCHAR2,
509: X_Runtime_Option_Context VARCHAR2
510: ) IS
511: BEGIN
512: UPDATE RG_REPORT_REQUESTS
513: SET
514:
515: application_id = X_Application_Id,
516: report_request_id = X_Report_Request_Id,

Line 566: DELETE FROM RG_REPORT_REQUESTS

562: END Update_Row;
563:
564: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
565: BEGIN
566: DELETE FROM RG_REPORT_REQUESTS
567: WHERE rowid = X_Rowid;
568:
569: if (SQL%NOTFOUND) then
570: RAISE NO_DATA_FOUND;

Line 574: END RG_REPORT_REQUESTS_PKG;

570: RAISE NO_DATA_FOUND;
571: end if;
572: END Delete_Row;
573:
574: END RG_REPORT_REQUESTS_PKG;