APPS.IGS_PS_USEC_TCH_RESP_PKG dependencies on IGS_PS_USEC_TCH_RESP

Line 1: PACKAGE BODY igs_ps_usec_tch_resp_pkg AS

1: PACKAGE BODY igs_ps_usec_tch_resp_pkg AS
2: /* $Header: IGSPI1EB.pls 120.0 2005/06/01 13:03:25 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_tch_resp%RowType;
5: new_references igs_ps_usec_tch_resp%RowType;

Line 4: old_references igs_ps_usec_tch_resp%RowType;

1: PACKAGE BODY igs_ps_usec_tch_resp_pkg AS
2: /* $Header: IGSPI1EB.pls 120.0 2005/06/01 13:03:25 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_tch_resp%RowType;
5: new_references igs_ps_usec_tch_resp%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_usec_tch_resp%RowType;

1: PACKAGE BODY igs_ps_usec_tch_resp_pkg AS
2: /* $Header: IGSPI1EB.pls 120.0 2005/06/01 13:03:25 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_usec_tch_resp%RowType;
5: new_references igs_ps_usec_tch_resp%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 39: FROM IGS_PS_USEC_TCH_RESP

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

Line 252: FROM igs_ps_usec_tch_resp

248: ***************************************************************/
249:
250: CURSOR cur_rowid IS
251: SELECT rowid
252: FROM igs_ps_usec_tch_resp
253: WHERE unit_section_teach_resp_id = x_unit_section_teach_resp_id
254: FOR UPDATE NOWAIT;
255:
256: lv_rowid cur_rowid%RowType;

Line 289: FROM igs_ps_usec_tch_resp

285: ***************************************************************/
286:
287: CURSOR cur_rowid IS
288: SELECT rowid
289: FROM igs_ps_usec_tch_resp
290: WHERE uoo_id = x_uoo_id and instructor_id = x_instructor_id and ((l_rowid is null) or (rowid <> l_rowid))
291:
292: ;
293: lv_rowid cur_rowid%RowType;

Line 324: FROM igs_ps_usec_tch_resp

320: ***************************************************************/
321:
322: CURSOR cur_rowid IS
323: SELECT rowid
324: FROM igs_ps_usec_tch_resp
325: WHERE uoo_id = x_uoo_id ;
326:
327: lv_rowid cur_rowid%RowType;
328:

Line 491: cursor C is select ROWID from IGS_PS_USEC_TCH_RESP

487:
488: (reverse chronological order - newest change first)
489: ***************************************************************/
490:
491: cursor C is select ROWID from IGS_PS_USEC_TCH_RESP
492: where UNIT_SECTION_TEACH_RESP_ID= X_UNIT_SECTION_TEACH_RESP_ID
493: ;
494: X_LAST_UPDATE_DATE DATE ;
495: X_LAST_UPDATED_BY NUMBER ;

Line 518: igs_ps_usec_tch_resp_s.NEXTVAL

514: app_exception.raise_exception;
515: end if;
516:
517: SELECT
518: igs_ps_usec_tch_resp_s.NEXTVAL
519: INTO
520: X_UNIT_SECTION_TEACH_RESP_ID
521: FROM Dual;
522:

Line 540: insert into IGS_PS_USEC_TCH_RESP (

536: x_created_by=>X_LAST_UPDATED_BY,
537: x_last_update_date=>X_LAST_UPDATE_DATE,
538: x_last_updated_by=>X_LAST_UPDATED_BY,
539: x_last_update_login=>X_LAST_UPDATE_LOGIN);
540: insert into IGS_PS_USEC_TCH_RESP (
541: UNIT_SECTION_TEACH_RESP_ID
542: ,INSTRUCTOR_ID
543: ,CONFIRMED_FLAG
544: ,PERCENTAGE_ALLOCATION

Line 613: from IGS_PS_USEC_TCH_RESP

609: , LEAD_INSTRUCTOR_FLAG
610: , UOO_ID
611: , INSTRUCTIONAL_LOAD_LAB
612: , INSTRUCTIONAL_LOAD_LECTURE
613: from IGS_PS_USEC_TCH_RESP
614: where ROWID = X_ROWID
615: for update nowait;
616: tlinfo c1%rowtype;
617: begin

Line 716: update IGS_PS_USEC_TCH_RESP set

712: x_created_by=>X_LAST_UPDATED_BY,
713: x_last_update_date=>X_LAST_UPDATE_DATE,
714: x_last_updated_by=>X_LAST_UPDATED_BY,
715: x_last_update_login=>X_LAST_UPDATE_LOGIN);
716: update IGS_PS_USEC_TCH_RESP set
717: INSTRUCTOR_ID = NEW_REFERENCES.INSTRUCTOR_ID,
718: CONFIRMED_FLAG = NEW_REFERENCES.CONFIRMED_FLAG,
719: PERCENTAGE_ALLOCATION = NEW_REFERENCES.PERCENTAGE_ALLOCATION,
720: INSTRUCTIONAL_LOAD = NEW_REFERENCES.INSTRUCTIONAL_LOAD,

Line 762: cursor c1 is select ROWID from IGS_PS_USEC_TCH_RESP

758:
759: (reverse chronological order - newest change first)
760: ***************************************************************/
761:
762: cursor c1 is select ROWID from IGS_PS_USEC_TCH_RESP
763: where UNIT_SECTION_TEACH_RESP_ID= X_UNIT_SECTION_TEACH_RESP_ID
764: ;
765: begin
766: open c1;

Line 817: delete from IGS_PS_USEC_TCH_RESP

813: Before_DML (
814: p_action => 'DELETE',
815: x_rowid => X_ROWID
816: );
817: delete from IGS_PS_USEC_TCH_RESP
818: where ROWID = X_ROWID;
819: if (sql%notfound) then
820: raise no_data_found;
821: end if;

Line 827: END igs_ps_usec_tch_resp_pkg;

823: p_action => 'DELETE',
824: x_rowid => X_ROWID
825: );
826: end DELETE_ROW;
827: END igs_ps_usec_tch_resp_pkg;