APPS.PER_KR_GRADE_AMOUNT_PKG dependencies on PER_KR_GRADE_AMOUNT

Line 1: PACKAGE BODY per_kr_grade_amount_pkg AS

1: PACKAGE BODY per_kr_grade_amount_pkg AS
2: /* $Header: pekrsg02.pkb 115.1 2002/12/03 09:36:23 viagarwa noship $ */
3: -------------------------------------------------------------------------------------
4: PROCEDURE insert_row
5: (p_row_id IN OUT NOCOPY VARCHAR2

Line 51: SELECT per_kr_grade_amount_s.NEXTVAL

47: ,p_attribute30 VARCHAR2
48: ) IS
49: --
50: CURSOR c_s1 IS
51: SELECT per_kr_grade_amount_s.NEXTVAL
52: FROM dual;
53: --
54: BEGIN
55: --

Line 65: INSERT INTO per_kr_grade_amount_f

61: END IF;
62: --
63: CLOSE c_s1;
64: --
65: INSERT INTO per_kr_grade_amount_f
66: (grade_amount_id
67: ,effective_start_date
68: ,effective_end_date
69: ,grade_id

Line 245: FROM per_kr_grade_amount

241: ,attribute27
242: ,attribute28
243: ,attribute29
244: ,attribute30
245: FROM per_kr_grade_amount
246: WHERE rowid = chartorowid(p_row_id)
247: FOR UPDATE OF grade_amount_id NOWAIT;
248: --
249: recinfo c1%ROWTYPE;

Line 437: UPDATE per_kr_grade_amount

433: ,p_attribute29 VARCHAR2
434: ,p_attribute30 VARCHAR2
435: ) IS
436: BEGIN
437: UPDATE per_kr_grade_amount
438: SET effective_start_date = p_effective_start_date
439: ,effective_end_date = p_effective_end_date
440: ,grade_amount = p_grade_amount
441: ,object_version_number = p_object_version_number

Line 491: DELETE FROM per_kr_grade_amount_f

487: (p_row_id VARCHAR2
488: ) IS
489: BEGIN
490: --
491: DELETE FROM per_kr_grade_amount_f
492: WHERE rowid = chartorowid(p_row_id);
493: --
494: IF (SQL%NOTFOUND) THEN
495: RAISE NO_DATA_FOUND;

Line 500: END per_kr_grade_amount_pkg;

496: END IF;
497: --
498: END delete_row;
499: -------------------------------------------------------------------------------------
500: END per_kr_grade_amount_pkg;