APPS.PER_KR_GRADES_PKG dependencies on PER_KR_GRADES

Line 1: PACKAGE BODY per_kr_grades_pkg AS

1: PACKAGE BODY per_kr_grades_pkg AS
2: /* $Header: pekrsg01.pkb 115.1 2002/12/03 09:34:22 viagarwa noship $ */
3: -------------------------------------------------------------------------------------
4: PROCEDURE insert_row
5: (p_row_id IN OUT NOCOPY VARCHAR2

Line 22: SELECT per_kr_grades_s.NEXTVAL

18: ,p_creation_date DATE
19: ) IS
20: --
21: CURSOR c_s1 IS
22: SELECT per_kr_grades_s.NEXTVAL
23: FROM dual;
24: --
25: BEGIN
26: --

Line 36: INSERT INTO per_kr_grades

32: END IF;
33: --
34: CLOSE c_s1;
35: --
36: INSERT INTO per_kr_grades
37: (grade_id
38: ,business_group_id
39: ,sequence
40: ,grade_name

Line 100: FROM per_kr_grades

96: ,last_updated_by
97: ,last_update_login
98: ,created_by
99: ,creation_date
100: FROM per_kr_grades
101: WHERE rowid = chartorowid(p_row_id)
102: FOR UPDATE of grade_id NOWAIT;
103: --
104: recinfo c1%ROWTYPE;

Line 175: UPDATE per_kr_grades

171: ,p_creation_date DATE
172: ) IS
173:
174: BEGIN
175: UPDATE per_kr_grades
176: SET sequence =p_sequence
177: ,grade_name =p_grade_name
178: ,enabled_flag =p_enabled_flag
179: ,start_date_active =p_start_date_active

Line 198: DELETE FROM per_kr_grades

194: (p_row_id VARCHAR2
195: ) IS
196: BEGIN
197: --
198: DELETE FROM per_kr_grades
199: WHERE rowid = chartorowid(p_row_id);
200: --
201: IF (SQL%NOTFOUND) THEN
202: RAISE NO_DATA_FOUND;

Line 207: END per_kr_grades_pkg;

203: END IF;
204: --
205: END delete_row;
206: -------------------------------------------------------------------------------------
207: END per_kr_grades_pkg;