APPS.IGS_HE_POOUS_ALL_PKG dependencies on IGS_HE_POOUS_ALL

Line 1: PACKAGE BODY igs_he_poous_all_pkg AS

1: PACKAGE BODY igs_he_poous_all_pkg AS
2: /* $Header: IGSWI17B.pls 120.1 2006/05/22 09:25:33 jchakrab noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_poous_all%ROWTYPE;

Line 5: old_references igs_he_poous_all%ROWTYPE;

1: PACKAGE BODY igs_he_poous_all_pkg AS
2: /* $Header: IGSWI17B.pls 120.1 2006/05/22 09:25:33 jchakrab noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_poous_all%ROWTYPE;
6: new_references igs_he_poous_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_poous_all%ROWTYPE;

2: /* $Header: IGSWI17B.pls 120.1 2006/05/22 09:25:33 jchakrab noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_poous_all%ROWTYPE;
6: new_references igs_he_poous_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 73: FROM IGS_HE_POOUS_ALL

69: */
70:
71: CURSOR cur_old_ref_values IS
72: SELECT *
73: FROM IGS_HE_POOUS_ALL
74: WHERE rowid = x_rowid;
75:
76: BEGIN
77:

Line 303: FROM igs_he_poous_all

299: || (reverse chronological order - newest change first)
300: */
301: CURSOR cur_rowid IS
302: SELECT rowid
303: FROM igs_he_poous_all
304: WHERE hesa_poous_id = x_hesa_poous_id
305: FOR UPDATE NOWAIT;
306:
307: lv_rowid cur_rowid%RowType;

Line 345: FROM igs_he_poous_all

341: || (reverse chronological order - newest change first)
342: */
343: CURSOR cur_rowid IS
344: SELECT rowid
345: FROM igs_he_poous_all
346: WHERE course_cd = x_course_cd
347: AND crv_version_number = x_crv_version_number
348: AND cal_type = x_cal_type
349: AND location_cd = x_location_cd

Line 392: FROM igs_he_poous_all

388: || (reverse chronological order - newest change first)
389: */
390: CURSOR cur_rowid IS
391: SELECT rowid
392: FROM igs_he_poous_all
393: WHERE ((attendance_mode = x_attendance_mode) AND
394: (attendance_type = x_attendance_type) AND
395: (cal_type = x_cal_type) AND
396: (course_cd = x_course_cd) AND

Line 433: FROM igs_he_poous_all

429: || (reverse chronological order - newest change first)
430: */
431: CURSOR cur_rowid IS
432: SELECT rowid
433: FROM igs_he_poous_all
434: WHERE ((unit_set_cd = x_unit_set_cd) AND
435: (us_version_number = x_version_number));
436:
437: lv_rowid cur_rowid%RowType;

Line 473: FROM IGS_HE_POOUS_ALL

469: (reverse chronological order - newest change first)
470: ***************************************************************/
471: CURSOR cur_rowid IS
472: SELECT rowid
473: FROM IGS_HE_POOUS_ALL
474: WHERE COURSE_CD = x_course_cd
475: AND CRV_VERSION_NUMBER = x_version_number
476: AND CAL_TYPE = x_cal_type
477: AND UNIT_SET_CD = x_unit_set_cd

Line 748: FROM igs_he_poous_all

744: ||
745: */
746: CURSOR c IS
747: SELECT rowid
748: FROM igs_he_poous_all
749: WHERE hesa_poous_id = x_hesa_poous_id;
750:
751: x_last_update_date DATE;
752: x_last_updated_by NUMBER;

Line 776: SELECT igs_he_poous_all_s.NEXTVAL

772: igs_ge_msg_stack.add;
773: app_exception.raise_exception;
774: END IF;
775:
776: SELECT igs_he_poous_all_s.NEXTVAL
777: INTO x_hesa_poous_id
778: FROM dual;
779:
780: before_dml(

Line 827: INSERT INTO igs_he_poous_all (

823: x_last_update_login => x_last_update_login,
824: x_funding_source => x_funding_source
825: );
826:
827: INSERT INTO igs_he_poous_all (
828: hesa_poous_id,
829: org_id,
830: course_cd,
831: crv_version_number,

Line 1022: FROM igs_he_poous_all

1018: fundability_cd,
1019: fee_band,
1020: level_applicable_to_funding,
1021: funding_source
1022: FROM igs_he_poous_all
1023: WHERE rowid = x_rowid
1024: FOR UPDATE NOWAIT;
1025:
1026: tlinfo c1%ROWTYPE;

Line 1219: UPDATE igs_he_poous_all

1215: x_last_update_login => x_last_update_login,
1216: x_funding_source => x_funding_source
1217: );
1218:
1219: UPDATE igs_he_poous_all
1220: SET
1221: course_cd = new_references.course_cd,
1222: crv_version_number = new_references.crv_version_number,
1223: cal_type = new_references.cal_type,

Line 1327: FROM igs_he_poous_all

1323: ||
1324: */
1325: CURSOR c1 IS
1326: SELECT rowid
1327: FROM igs_he_poous_all
1328: WHERE hesa_poous_id = x_hesa_poous_id;
1329:
1330: BEGIN
1331:

Line 1446: DELETE FROM igs_he_poous_all

1442: p_action => 'DELETE',
1443: x_rowid => x_rowid
1444: );
1445:
1446: DELETE FROM igs_he_poous_all
1447: WHERE rowid = x_rowid;
1448:
1449: IF (SQL%NOTFOUND) THEN
1450: RAISE NO_DATA_FOUND;

Line 1456: END igs_he_poous_all_pkg;

1452:
1453: END delete_row;
1454:
1455:
1456: END igs_he_poous_all_pkg;