DBA Data[Home] [Help]

APPS.PER_KR_G_POINT_AMOUNT_PKG dependencies on PER_KR_G_POINT_AMOUNT_F

Line 65: INSERT INTO per_kr_g_point_amount_f

61: END IF;
62: --
63: CLOSE c_s1;
64: --
65: INSERT INTO per_kr_g_point_amount_f
66: (grade_point_amount_id
67: ,effective_start_date
68: ,effective_end_date
69: ,grade_point_id

Line 245: FROM per_kr_g_point_amount_f

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

Line 437: UPDATE per_kr_g_point_amount_f

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

Line 491: DELETE FROM per_kr_g_point_amount_f

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