APPS.IGS_UC_REF_TARIFF_PKG dependencies on IGS_UC_REF_TARIFF

Line 1: PACKAGE BODY igs_uc_ref_tariff_pkg AS

1: PACKAGE BODY igs_uc_ref_tariff_pkg AS
2: /* $Header: IGSXI41B.pls 115.3 2003/02/28 07:51:34 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_tariff%ROWTYPE;

Line 5: old_references igs_uc_ref_tariff%ROWTYPE;

1: PACKAGE BODY igs_uc_ref_tariff_pkg AS
2: /* $Header: IGSXI41B.pls 115.3 2003/02/28 07:51:34 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_tariff%ROWTYPE;
6: new_references igs_uc_ref_tariff%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_ref_tariff%ROWTYPE;

2: /* $Header: IGSXI41B.pls 115.3 2003/02/28 07:51:34 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_ref_tariff%ROWTYPE;
6: new_references igs_uc_ref_tariff%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM igs_uc_ref_tariff

29: */
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM igs_uc_ref_tariff
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 89: FROM igs_uc_ref_tariff

85: || (reverse chronological order - newest change first)
86: */
87: CURSOR cur_rowid IS
88: SELECT rowid
89: FROM igs_uc_ref_tariff
90: WHERE exam_level = x_exam_level
91: AND exam_grade = x_exam_grade ;
92:
93: lv_rowid cur_rowid%RowType;

Line 233: INSERT INTO igs_uc_ref_tariff (

229: x_last_updated_by => x_last_updated_by,
230: x_last_update_login => x_last_update_login
231: );
232:
233: INSERT INTO igs_uc_ref_tariff (
234: exam_level,
235: exam_grade,
236: tariff_score,
237: imported,

Line 278: FROM igs_uc_ref_tariff

274: CURSOR c1 IS
275: SELECT
276: tariff_score,
277: imported
278: FROM igs_uc_ref_tariff
279: WHERE rowid = x_rowid
280: FOR UPDATE NOWAIT;
281:
282: tlinfo c1%ROWTYPE;

Line 369: UPDATE igs_uc_ref_tariff

365: x_last_updated_by => x_last_updated_by,
366: x_last_update_login => x_last_update_login
367: );
368:
369: UPDATE igs_uc_ref_tariff
370: SET
371: tariff_score = new_references.tariff_score,
372: imported = new_references.imported,
373: last_update_date = x_last_update_date,

Line 404: FROM igs_uc_ref_tariff

400: || (reverse chronological order - newest change first)
401: */
402: CURSOR c1 IS
403: SELECT rowid
404: FROM igs_uc_ref_tariff
405: WHERE exam_level = x_exam_level
406: AND exam_grade = x_exam_grade;
407:
408: BEGIN

Line 458: DELETE FROM igs_uc_ref_tariff

454: p_action => 'DELETE',
455: x_rowid => x_rowid
456: );
457:
458: DELETE FROM igs_uc_ref_tariff
459: WHERE rowid = x_rowid;
460:
461: IF (SQL%NOTFOUND) THEN
462: RAISE NO_DATA_FOUND;

Line 468: END igs_uc_ref_tariff_pkg;

464:
465: END delete_row;
466:
467:
468: END igs_uc_ref_tariff_pkg;