APPS.RG_REPORT_SETS_PKG dependencies on RG_REPORT_SETS

Line 1: PACKAGE BODY rg_report_sets_pkg AS

1: PACKAGE BODY rg_report_sets_pkg AS
2: /* $Header: rgirsetb.pls 120.1 2003/04/29 01:29:29 djogg ship $ */
3: --
4: -- PUBLIC FUNCTION
5: --

Line 12: SELECT rg_report_sets_s.nextval

8: RETURN NUMBER
9: IS
10: new_sequence_number NUMBER;
11: BEGIN
12: SELECT rg_report_sets_s.nextval
13: INTO new_sequence_number
14: FROM dual;
15:
16: RETURN(new_sequence_number);

Line 29: FROM rg_report_sets

25: rec_returned NUMBER;
26: BEGIN
27: SELECT count(*)
28: INTO rec_returned
29: FROM rg_report_sets
30: WHERE report_set_id <> cur_report_set_id
31: AND name = new_name
32: AND application_id = cur_application_id;
33:

Line 41: END rg_report_sets_pkg;

37: RETURN(FALSE);
38: END IF;
39: END check_dup_report_set_name;
40:
41: END rg_report_sets_pkg;