APPS.IGS_HE_UT_EXCL_QALS_PKG dependencies on IGS_HE_UT_EXCL_QALS

Line 1: PACKAGE BODY igs_he_ut_excl_qals_pkg AS

1: PACKAGE BODY igs_he_ut_excl_qals_pkg AS
2: /* $Header: IGSWI41B.pls 115.0 2003/09/02 13:20:29 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_excl_qals%ROWTYPE;

Line 5: old_references igs_he_ut_excl_qals%ROWTYPE;

1: PACKAGE BODY igs_he_ut_excl_qals_pkg AS
2: /* $Header: IGSWI41B.pls 115.0 2003/09/02 13:20:29 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_excl_qals%ROWTYPE;
6: new_references igs_he_ut_excl_qals%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_ut_excl_qals%ROWTYPE;

2: /* $Header: IGSWI41B.pls 115.0 2003/09/02 13:20:29 smaddali noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ut_excl_qals%ROWTYPE;
6: new_references igs_he_ut_excl_qals%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM igs_he_ut_excl_qals

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

Line 115: FROM igs_he_ut_excl_qals

111: || (reverse chronological order - newest change first)
112: */
113: CURSOR cur_rowid IS
114: SELECT rowid
115: FROM igs_he_ut_excl_qals
116: WHERE excl_qual_id = x_excl_qual_id
117: FOR UPDATE NOWAIT;
118:
119: lv_rowid cur_rowid%RowType;

Line 150: FROM igs_he_ut_excl_qals

146: || (reverse chronological order - newest change first)
147: */
148: CURSOR cur_rowid IS
149: SELECT rowid
150: FROM igs_he_ut_excl_qals
151: WHERE ((tariff_calc_type_cd = x_tariff_calc_type_cd));
152:
153: lv_rowid cur_rowid%RowType;
154:

Line 187: FROM igs_he_ut_excl_qals

183: || smaddali modified cursor cur_rowid to add check for rowid as it was missing
184: */
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM igs_he_ut_excl_qals
188: WHERE tariff_calc_type_cd = x_tariff_calc_type_cd
189: AND ((award_cd = x_award_cd) OR ((award_cd IS NULL) AND (X_award_cd IS NULL)))
190: AND ((field_of_study = x_field_of_study) OR ((field_of_study IS NULL) AND (X_field_of_study IS NULL)))
191: AND ((l_rowid IS NULL) OR (rowid <> l_rowid)) ;

Line 346: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_EXCL_QALS_PKG.INSERT_ROW');

342: x_last_update_login := -1;
343: END IF;
344: ELSE
345: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
346: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_EXCL_QALS_PKG.INSERT_ROW');
347: igs_ge_msg_stack.add;
348: app_exception.raise_exception;
349: END IF;
350:

Line 367: INSERT INTO igs_he_ut_excl_qals (

363: x_last_updated_by => x_last_updated_by,
364: x_last_update_login => x_last_update_login
365: );
366:
367: INSERT INTO igs_he_ut_excl_qals (
368: excl_qual_id,
369: tariff_calc_type_cd,
370: award_cd,
371: field_of_study,

Line 378: igs_he_ut_excl_qals_s.NEXTVAL,

374: last_update_date,
375: last_updated_by,
376: last_update_login
377: ) VALUES (
378: igs_he_ut_excl_qals_s.NEXTVAL,
379: new_references.tariff_calc_type_cd,
380: new_references.award_cd,
381: new_references.field_of_study,
382: x_last_update_date,

Line 415: FROM igs_he_ut_excl_qals

411: SELECT
412: tariff_calc_type_cd,
413: award_cd,
414: field_of_study
415: FROM igs_he_ut_excl_qals
416: WHERE rowid = x_rowid
417: FOR UPDATE NOWAIT;
418:
419: tlinfo c1%ROWTYPE;

Line 489: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_EXCL_QALS_PKG.UPDATE_ROW');

485: x_last_update_login := -1;
486: END IF;
487: ELSE
488: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
489: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_EXCL_QALS_PKG.UPDATE_ROW');
490: igs_ge_msg_stack.add;
491: app_exception.raise_exception;
492: END IF;
493:

Line 508: UPDATE igs_he_ut_excl_qals

504: x_last_updated_by => x_last_updated_by,
505: x_last_update_login => x_last_update_login
506: );
507:
508: UPDATE igs_he_ut_excl_qals
509: SET
510: tariff_calc_type_cd = new_references.tariff_calc_type_cd,
511: award_cd = new_references.award_cd,
512: field_of_study = new_references.field_of_study,

Line 546: FROM igs_he_ut_excl_qals

542: || (reverse chronological order - newest change first)
543: */
544: CURSOR c1 IS
545: SELECT rowid
546: FROM igs_he_ut_excl_qals
547: WHERE excl_qual_id = x_excl_qual_id;
548:
549: BEGIN
550:

Line 599: DELETE FROM igs_he_ut_excl_qals

595: p_action => 'DELETE',
596: x_rowid => x_rowid
597: );
598:
599: DELETE FROM igs_he_ut_excl_qals
600: WHERE rowid = x_rowid;
601:
602: IF (SQL%NOTFOUND) THEN
603: RAISE NO_DATA_FOUND;

Line 611: END igs_he_ut_excl_qals_pkg;

607:
608: END delete_row;
609:
610:
611: END igs_he_ut_excl_qals_pkg;