DBA Data[Home] [Help]

PACKAGE: APPS.PER_VALID_GRADES_PKG

Source


1 PACKAGE PER_VALID_GRADES_PKG AUTHID CURRENT_USER as
2 /* $Header: pevgr01t.pkh 115.1 2004/01/13 05:16:30 bsubrama ship $ */
3 --
4 PROCEDURE get_grade(p_grade_id    in     number,
5           p_grade       IN OUT nocopy VARCHAR2);
6 --
7 PROCEDURE get_next_sequence(p_valid_grade_id in out nocopy number);
8 --
9 -- Bug 3338072
10 -- Added new parameters p_date_from and p_date_to
11 PROCEDURE check_unique_grade(
12    p_business_group_id       in number,
13    p_job_id                  in number,
14    p_grade_id                in number,
15    p_rowid                   in varchar2,
16    p_date_from               in date,
17    p_date_to                 in date default null );
18 --
19 PROCEDURE check_date_from(p_grade_id  number,
20            p_date_from date);
21 --
22 PROCEDURE check_date_to(p_grade_id    number,
23          p_date_to     date,
24          p_end_of_time date);
25 --
26 END PER_VALID_GRADES_PKG;