APPS.IGS_HE_ST_UNT_VS_ALL_PKG dependencies on IGS_HE_ST_UNT_VS_ALL

Line 1: PACKAGE BODY igs_he_st_unt_vs_all_pkg AS

1: PACKAGE BODY igs_he_st_unt_vs_all_pkg AS
2: /* $Header: IGSWI24B.pls 120.1 2006/02/06 19:53:52 jbaber noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_st_unt_vs_all%ROWTYPE;

Line 5: old_references igs_he_st_unt_vs_all%ROWTYPE;

1: PACKAGE BODY igs_he_st_unt_vs_all_pkg AS
2: /* $Header: IGSWI24B.pls 120.1 2006/02/06 19:53:52 jbaber noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_st_unt_vs_all%ROWTYPE;
6: new_references igs_he_st_unt_vs_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_st_unt_vs_all%ROWTYPE;

2: /* $Header: IGSWI24B.pls 120.1 2006/02/06 19:53:52 jbaber noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_st_unt_vs_all%ROWTYPE;
6: new_references igs_he_st_unt_vs_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 40: FROM IGS_HE_ST_UNT_VS_ALL

36: */
37:
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM IGS_HE_ST_UNT_VS_ALL
41: WHERE rowid = x_rowid;
42:
43: BEGIN
44:

Line 155: FROM igs_he_st_unt_vs_all

151: || (reverse chronological order - newest change first)
152: */
153: CURSOR cur_rowid IS
154: SELECT rowid
155: FROM igs_he_st_unt_vs_all
156: WHERE hesa_st_unt_vs_id = x_hesa_st_unt_vs_id
157: FOR UPDATE NOWAIT;
158:
159: lv_rowid cur_rowid%RowType;

Line 191: FROM igs_he_st_unt_vs_all

187: || (reverse chronological order - newest change first)
188: */
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM igs_he_st_unt_vs_all
192: WHERE unit_cd = x_unit_cd
193: AND version_number = x_version_number
194: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
195:

Line 228: FROM igs_he_st_unt_vs_all

224: || (reverse chronological order - newest change first)
225: */
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM igs_he_st_unt_vs_all
229: WHERE ((unit_cd = x_unit_cd) AND
230: (version_number = x_version_number));
231:
232: lv_rowid cur_rowid%RowType;

Line 393: FROM igs_he_st_unt_vs_all

389: || (reverse chronological order - newest change first)
390: */
391: CURSOR c IS
392: SELECT rowid
393: FROM igs_he_st_unt_vs_all
394: WHERE hesa_st_unt_vs_id = x_hesa_st_unt_vs_id;
395:
396: x_last_update_date DATE;
397: x_last_updated_by NUMBER;

Line 421: SELECT igs_he_st_unt_vs_all_s.NEXTVAL

417: igs_ge_msg_stack.add;
418: app_exception.raise_exception;
419: END IF;
420:
421: SELECT igs_he_st_unt_vs_all_s.NEXTVAL
422: INTO x_hesa_st_unt_vs_id
423: FROM dual;
424:
425: before_dml(

Line 445: INSERT INTO igs_he_st_unt_vs_all (

441: x_last_update_login => x_last_update_login,
442: x_exclude_flag => x_exclude_flag
443: );
444:
445: INSERT INTO igs_he_st_unt_vs_all (
446: hesa_st_unt_vs_id,
447: org_id,
448: unit_cd,
449: version_number,

Line 525: FROM igs_he_st_unt_vs_all

521: module_length,
522: proportion_of_fte,
523: location_cd,
524: exclude_flag
525: FROM igs_he_st_unt_vs_all
526: WHERE rowid = x_rowid
527: FOR UPDATE NOWAIT;
528:
529: tlinfo c1%ROWTYPE;

Line 637: UPDATE igs_he_st_unt_vs_all

633: x_last_update_login => x_last_update_login,
634: x_exclude_flag => x_exclude_flag
635: );
636:
637: UPDATE igs_he_st_unt_vs_all
638: SET
639: unit_cd = new_references.unit_cd,
640: version_number = new_references.version_number,
641: prop_of_teaching_in_welsh = new_references.prop_of_teaching_in_welsh,

Line 685: FROM igs_he_st_unt_vs_all

681: || (reverse chronological order - newest change first)
682: */
683: CURSOR c1 IS
684: SELECT rowid
685: FROM igs_he_st_unt_vs_all
686: WHERE hesa_st_unt_vs_id = x_hesa_st_unt_vs_id;
687:
688: BEGIN
689:

Line 750: DELETE FROM igs_he_st_unt_vs_all

746: p_action => 'DELETE',
747: x_rowid => x_rowid
748: );
749:
750: DELETE FROM igs_he_st_unt_vs_all
751: WHERE rowid = x_rowid;
752:
753: IF (SQL%NOTFOUND) THEN
754: RAISE NO_DATA_FOUND;

Line 760: END igs_he_st_unt_vs_all_pkg;

756:
757: END delete_row;
758:
759:
760: END igs_he_st_unt_vs_all_pkg;