APPS.RG_REPORT_SET_REQUESTS_PKG dependencies on RG_REPORT_SET_REQUESTS

Line 1: PACKAGE BODY rg_report_set_requests_pkg AS

1: PACKAGE BODY rg_report_set_requests_pkg AS
2: /* $Header: rgirsrqb.pls 120.3 2008/03/11 22:47:31 djogg ship $ */
3:
4:
5: --

Line 12: select RG_REPORT_SET_REQUESTS_S.NEXTVAL

8:
9: FUNCTION get_unique_id RETURN NUMBER IS
10: next_id NUMBER;
11: BEGIN
12: select RG_REPORT_SET_REQUESTS_S.NEXTVAL
13: into next_id
14: from dual;
15:
16: return (next_id);

Line 29: -- Insert a report set request into rg_report_set_requests.

25: -- NAME
26: -- insert_report_set_request
27: --
28: -- DESCRIPTION
29: -- Insert a report set request into rg_report_set_requests.
30: --
31: -- PARAMETERS
32: -- Listed below
33: --

Line 48: FROM RG_REPORT_SET_REQUESTS

44: x_accounting_date DATE,
45: x_unit_of_measure_id VARCHAR2) IS
46: CURSOR C IS
47: SELECT rowid
48: FROM RG_REPORT_SET_REQUESTS
49: WHERE report_set_request_id = x_report_set_request_id;
50: rowid VARCHAR2(30);
51: BEGIN
52: x_report_set_request_id := rg_report_set_requests_pkg.get_unique_id;

Line 52: x_report_set_request_id := rg_report_set_requests_pkg.get_unique_id;

48: FROM RG_REPORT_SET_REQUESTS
49: WHERE report_set_request_id = x_report_set_request_id;
50: rowid VARCHAR2(30);
51: BEGIN
52: x_report_set_request_id := rg_report_set_requests_pkg.get_unique_id;
53:
54: INSERT INTO RG_REPORT_SET_REQUESTS
55: ( REPORT_SET_REQUEST_ID,
56: REPORT_SET_ID,

Line 54: INSERT INTO RG_REPORT_SET_REQUESTS

50: rowid VARCHAR2(30);
51: BEGIN
52: x_report_set_request_id := rg_report_set_requests_pkg.get_unique_id;
53:
54: INSERT INTO RG_REPORT_SET_REQUESTS
55: ( REPORT_SET_REQUEST_ID,
56: REPORT_SET_ID,
57: LAST_UPDATE_DATE,
58: LAST_UPDATED_BY,

Line 133: END rg_report_set_requests_pkg;

129: CLOSE C;
130:
131: END insert_report_set_req_detail;
132:
133: END rg_report_set_requests_pkg;