APPS.IGS_PS_OFR_PKG dependencies on IGS_PS_OFR_ALL

Line 6: old_references IGS_PS_OFR_ALL%RowType;

2: /* $Header: IGSPI19B.pls 115.6 2002/11/29 02:04:15 nsidana ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_OFR_ALL%RowType;
7: new_references IGS_PS_OFR_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_PS_OFR_ALL%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_OFR_ALL%RowType;
7: new_references IGS_PS_OFR_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 55: FROM IGS_PS_OFR_ALL

51: (reverse chronological order - newest change first)
52: ***************************************************************/
53: CURSOR cur_old_ref_values IS
54: SELECT *
55: FROM IGS_PS_OFR_ALL
56: WHERE rowid = x_rowid;
57:
58: BEGIN
59:

Line 332: FROM IGS_PS_OFR_ALL

328: RETURN BOOLEAN AS
329:
330: CURSOR cur_rowid IS
331: SELECT rowid
332: FROM IGS_PS_OFR_ALL
333: WHERE course_cd = x_course_cd
334: AND version_number = x_version_number
335: AND cal_type = x_cal_type
336: FOR UPDATE NOWAIT;

Line 368: FROM IGS_PS_OFR_ALL

364: (reverse chronological order - newest change first)
365: ***************************************************************/
366: CURSOR cur_rowid IS
367: SELECT rowid
368: FROM IGS_PS_OFR_ALL
369: WHERE cal_type = x_cal_type ;
370:
371: lv_rowid cur_rowid%RowType;
372:

Line 403: FROM IGS_PS_OFR_ALL

399: (reverse chronological order - newest change first)
400: ***************************************************************/
401: CURSOR cur_rowid IS
402: SELECT rowid
403: FROM IGS_PS_OFR_ALL
404: WHERE course_cd = x_course_cd
405: AND version_number = x_version_number ;
406:
407: lv_rowid cur_rowid%RowType;

Line 595: cursor C is select ROWID from IGS_PS_OFR_ALL

591: Who When What
592: sbeerell 09-MAY-2000 Changed according to DLD version 2
593: (reverse chronological order - newest change first)
594: ***************************************************************/
595: cursor C is select ROWID from IGS_PS_OFR_ALL
596: where COURSE_CD = X_COURSE_CD
597: and VERSION_NUMBER = X_VERSION_NUMBER
598: and CAL_TYPE = X_CAL_TYPE;
599: X_LAST_UPDATE_DATE DATE;

Line 656: insert into IGS_PS_OFR_ALL (

652: x_last_update_login => X_LAST_UPDATE_LOGIN,
653: x_org_id => igs_ge_gen_003.get_org_id
654: );
655:
656: insert into IGS_PS_OFR_ALL (
657: COURSE_CD,
658: VERSION_NUMBER,
659: CAL_TYPE,
660: ATTRIBUTE_CATEGORY,

Line 772: from IGS_PS_OFR_ALL

768: sbeerell 09-MAY-2000 Changed according to DLD version 2
769: (reverse chronological order - newest change first)
770: ***************************************************************/
771: cursor c1 is select ROWID
772: from IGS_PS_OFR_ALL
773: where ROWID = X_ROWID
774: for update nowait;
775: tlinfo c1%rowtype;
776:

Line 809: delete from IGS_PS_OFR_ALL

805: Before_DML (
806: p_action => 'DELETE',
807: x_rowid => X_ROWID
808: );
809: delete from IGS_PS_OFR_ALL
810: where ROWID = X_ROWID;
811: if (sql%notfound) then
812: raise no_data_found;
813: end if;