APPS.IGS_HE_ST_SPA_UT_ALL_PKG dependencies on IGS_HE_ST_SPA_UT_ALL

Line 1: PACKAGE BODY igs_he_st_spa_ut_all_pkg AS

1: PACKAGE BODY igs_he_st_spa_ut_all_pkg AS
2: /* $Header: IGSWI23B.pls 115.8 2002/11/29 04:40:51 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_st_spa_ut_all%ROWTYPE;

Line 5: old_references igs_he_st_spa_ut_all%ROWTYPE;

1: PACKAGE BODY igs_he_st_spa_ut_all_pkg AS
2: /* $Header: IGSWI23B.pls 115.8 2002/11/29 04:40:51 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_st_spa_ut_all%ROWTYPE;
6: new_references igs_he_st_spa_ut_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_st_spa_ut_all%ROWTYPE;

2: /* $Header: IGSWI23B.pls 115.8 2002/11/29 04:40:51 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_st_spa_ut_all%ROWTYPE;
6: new_references igs_he_st_spa_ut_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 37: FROM IGS_HE_ST_SPA_UT_ALL

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_HE_ST_SPA_UT_ALL
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 169: FROM igs_he_st_spa_ut_all

165: || (reverse chronological order - newest change first)
166: */
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM igs_he_st_spa_ut_all
170: WHERE hesa_st_spau_id = x_hesa_st_spau_id
171: FOR UPDATE NOWAIT;
172:
173: lv_rowid cur_rowid%RowType;

Line 206: FROM igs_he_st_spa_ut_all

202: || (reverse chronological order - newest change first)
203: */
204: CURSOR cur_rowid IS
205: SELECT rowid
206: FROM igs_he_st_spa_ut_all
207: WHERE person_id = x_person_id
208: AND course_cd = x_course_cd
209: AND ((qualification_level = x_qualification_level) OR (qualification_level IS NULL AND x_qualification_level IS NULL))
210: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 244: FROM igs_he_st_spa_ut_all

240: || (reverse chronological order - newest change first)
241: */
242: CURSOR cur_rowid IS
243: SELECT rowid
244: FROM igs_he_st_spa_ut_all
245: WHERE ((course_cd = x_course_cd) AND
246: (person_id = x_person_id));
247:
248: lv_rowid cur_rowid%RowType;

Line 372: FROM igs_he_st_spa_ut_all

368: || (reverse chronological order - newest change first)
369: */
370: CURSOR c IS
371: SELECT rowid
372: FROM igs_he_st_spa_ut_all
373: WHERE hesa_st_spau_id = x_hesa_st_spau_id;
374:
375: x_last_update_date DATE;
376: x_last_updated_by NUMBER;

Line 400: SELECT igs_he_st_spa_ut_all_s.NEXTVAL

396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: END IF;
399:
400: SELECT igs_he_st_spa_ut_all_s.NEXTVAL
401: INTO x_hesa_st_spau_id
402: FROM dual;
403:
404: before_dml(

Line 422: INSERT INTO igs_he_st_spa_ut_all (

418: x_last_updated_by => x_last_updated_by,
419: x_last_update_login => x_last_update_login
420: );
421:
422: INSERT INTO igs_he_st_spa_ut_all (
423: hesa_st_spau_id,
424: org_id,
425: person_id,
426: course_cd,

Line 493: FROM igs_he_st_spa_ut_all

489: version_number,
490: qualification_level,
491: number_of_qual,
492: tariff_score
493: FROM igs_he_st_spa_ut_all
494: WHERE rowid = x_rowid
495: FOR UPDATE NOWAIT;
496:
497: tlinfo c1%ROWTYPE;

Line 598: UPDATE igs_he_st_spa_ut_all

594: x_last_updated_by => x_last_updated_by,
595: x_last_update_login => x_last_update_login
596: );
597:
598: UPDATE igs_he_st_spa_ut_all
599: SET
600: person_id = new_references.person_id,
601: course_cd = new_references.course_cd,
602: version_number = new_references.version_number,

Line 641: FROM igs_he_st_spa_ut_all

637: || (reverse chronological order - newest change first)
638: */
639: CURSOR c1 IS
640: SELECT rowid
641: FROM igs_he_st_spa_ut_all
642: WHERE hesa_st_spau_id = x_hesa_st_spau_id;
643:
644: BEGIN
645:

Line 702: DELETE FROM igs_he_st_spa_ut_all

698: p_action => 'DELETE',
699: x_rowid => x_rowid
700: );
701:
702: DELETE FROM igs_he_st_spa_ut_all
703: WHERE rowid = x_rowid;
704:
705: IF (SQL%NOTFOUND) THEN
706: RAISE NO_DATA_FOUND;

Line 712: END igs_he_st_spa_ut_all_pkg;

708:
709: END delete_row;
710:
711:
712: END igs_he_st_spa_ut_all_pkg;