APPS.IGS_PS_OF_OPT_UNT_ST_PKG dependencies on IGS_PS_OF_OPT_UNT_ST

Line 1: package body IGS_PS_OF_OPT_UNT_ST_PKG AS

1: package body IGS_PS_OF_OPT_UNT_ST_PKG AS
2: /* $Header: IGSPI50B.pls 115.7 2003/03/07 07:59:05 smvk ship $ */
3:
4: /* Change History : Bug ID : 1219904 schodava 00/03/02
5: Procedure affected : Insert_Row, Add_Row

Line 12: old_references IGS_PS_OF_OPT_UNT_ST%RowType;

8: Hence it is made an IN OUT NOCOPY parameter in the above 2 procedures and copied into the form.
9: */
10:
11: l_rowid VARCHAR2(25);
12: old_references IGS_PS_OF_OPT_UNT_ST%RowType;
13: new_references IGS_PS_OF_OPT_UNT_ST%RowType;
14:
15: PROCEDURE Set_Column_Values (
16: p_action IN VARCHAR2,

Line 13: new_references IGS_PS_OF_OPT_UNT_ST%RowType;

9: */
10:
11: l_rowid VARCHAR2(25);
12: old_references IGS_PS_OF_OPT_UNT_ST%RowType;
13: new_references IGS_PS_OF_OPT_UNT_ST%RowType;
14:
15: PROCEDURE Set_Column_Values (
16: p_action IN VARCHAR2,
17: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_PS_OF_OPT_UNT_ST

32: ) AS
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_PS_OF_OPT_UNT_ST
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 291: FROM IGS_PS_OF_OPT_UNT_ST

287: ) RETURN BOOLEAN AS
288:
289: CURSOR cur_rowid IS
290: SELECT rowid
291: FROM IGS_PS_OF_OPT_UNT_ST
292: WHERE course_cd = x_course_cd
293: AND crv_version_number = x_crv_version_number
294: AND cal_type = x_cal_type
295: AND location_cd = x_location_cd

Line 328: FROM IGS_PS_OF_OPT_UNT_ST

324: ) AS
325:
326: CURSOR cur_rowid IS
327: SELECT rowid
328: FROM IGS_PS_OF_OPT_UNT_ST
329: WHERE course_cd = x_course_cd
330: AND crv_version_number = x_version_number
331: AND cal_type = x_cal_type
332: AND location_cd = x_location_cd

Line 359: FROM IGS_PS_OF_OPT_UNT_ST

355: ) AS
356:
357: CURSOR cur_rowid IS
358: SELECT rowid
359: FROM IGS_PS_OF_OPT_UNT_ST
360: WHERE coo_id = x_coo_id ;
361:
362: lv_rowid cur_rowid%RowType;
363:

Line 389: FROM IGS_PS_OF_OPT_UNT_ST

385: ) AS
386:
387: CURSOR cur_rowid IS
388: SELECT rowid
389: FROM IGS_PS_OF_OPT_UNT_ST
390: WHERE course_cd = x_course_cd
391: AND crv_version_number = x_crv_version_number
392: AND cal_type = x_cal_type
393: AND unit_set_cd = x_unit_set_cd

Line 522: cursor C is select ROWID from IGS_PS_OF_OPT_UNT_ST

518: X_UNIT_SET_CD in VARCHAR2,
519: X_COO_ID in out NOCOPY NUMBER,
520: X_MODE in VARCHAR2 default 'R'
521: ) AS
522: cursor C is select ROWID from IGS_PS_OF_OPT_UNT_ST
523: where COURSE_CD = X_COURSE_CD
524: and LOCATION_CD = X_LOCATION_CD
525: and ATTENDANCE_MODE = X_ATTENDANCE_MODE
526: and CAL_TYPE = X_CAL_TYPE

Line 571: insert into IGS_PS_OF_OPT_UNT_ST (

567: x_last_update_date => X_LAST_UPDATE_DATE,
568: x_last_updated_by => X_LAST_UPDATED_BY,
569: x_last_update_login => X_LAST_UPDATE_LOGIN
570: );
571: insert into IGS_PS_OF_OPT_UNT_ST (
572: COURSE_CD,
573: CRV_VERSION_NUMBER,
574: CAL_TYPE,
575: LOCATION_CD,

Line 631: from IGS_PS_OF_OPT_UNT_ST

627: X_COO_ID in NUMBER
628: ) AS
629: cursor c1 is select
630: COO_ID
631: from IGS_PS_OF_OPT_UNT_ST
632: where ROWID = X_ROWID for update nowait;
633: tlinfo c1%rowtype;
634:
635: begin

Line 710: update IGS_PS_OF_OPT_UNT_ST set

706: x_last_update_date => X_LAST_UPDATE_DATE,
707: x_last_updated_by => X_LAST_UPDATED_BY,
708: x_last_update_login => X_LAST_UPDATE_LOGIN
709: );
710: update IGS_PS_OF_OPT_UNT_ST set
711: COO_ID = NEW_REFERENCES.COO_ID,
712: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
713: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
714: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 739: cursor c1 is select rowid from IGS_PS_OF_OPT_UNT_ST

735: X_UNIT_SET_CD in VARCHAR2,
736: X_COO_ID in out NOCOPY NUMBER,
737: X_MODE in VARCHAR2 default 'R'
738: ) AS
739: cursor c1 is select rowid from IGS_PS_OF_OPT_UNT_ST
740: where COURSE_CD = X_COURSE_CD
741: and LOCATION_CD = X_LOCATION_CD
742: and ATTENDANCE_MODE = X_ATTENDANCE_MODE
743: and CAL_TYPE = X_CAL_TYPE

Line 790: delete from IGS_PS_OF_OPT_UNT_ST

786: begin
787: Before_DML( p_action => 'DELETE',
788: x_rowid => X_ROWID
789: );
790: delete from IGS_PS_OF_OPT_UNT_ST
791: where ROWID = X_ROWID;
792: if (sql%notfound) then
793: raise no_data_found;
794: end if;

Line 801: end IGS_PS_OF_OPT_UNT_ST_PKG;

797: x_rowid => X_ROWID
798: );
799: end DELETE_ROW;
800:
801: end IGS_PS_OF_OPT_UNT_ST_PKG;