APPS.IGS_PE_PERS_PREFS_PKG dependencies on IGS_PE_PERS_PREFS_ALL

Line 7: old_references IGS_PE_PERS_PREFS_ALL%RowType;

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

Line 8: new_references IGS_PE_PERS_PREFS_ALL%RowType;

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

Line 40: FROM IGS_PE_PERS_PREFS_ALL

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

Line 293: FROM IGS_PE_PERS_PREFS_ALL

289: ) RETURN BOOLEAN AS
290:
291: CURSOR cur_rowid IS
292: SELECT rowid
293: FROM IGS_PE_PERS_PREFS_ALL
294: WHERE person_id = x_person_id
295: FOR UPDATE NOWAIT;
296:
297: lv_rowid cur_rowid%RowType;

Line 320: FROM IGS_PE_PERS_PREFS_ALL

316: ) AS
317:
318: CURSOR cur_rowid IS
319: SELECT rowid
320: FROM IGS_PE_PERS_PREFS_ALL
321: WHERE person_id = x_person_id ;
322:
323: lv_rowid cur_rowid%RowType;
324:

Line 482: cursor C is select ROWID from IGS_PE_PERS_PREFS_ALL

478: X_ALLOW_STND_REQ_IND in VARCHAR2,
479: X_ORG_ID in NUMBER,
480: X_MODE in VARCHAR2 default 'R'
481: ) AS
482: cursor C is select ROWID from IGS_PE_PERS_PREFS_ALL
483: where PERSON_ID = X_PERSON_ID;
484: X_LAST_UPDATE_DATE DATE;
485: X_LAST_UPDATED_BY NUMBER;
486: X_LAST_UPDATE_LOGIN NUMBER;

Line 533: insert into IGS_PE_PERS_PREFS_ALL (

529: x_last_update_date=>X_LAST_UPDATE_DATE,
530: x_last_updated_by=>X_LAST_UPDATED_BY,
531: x_last_update_login=>X_LAST_UPDATE_LOGIN
532: );
533: insert into IGS_PE_PERS_PREFS_ALL (
534: PERSON_ID,
535: ENR_ACAD_CAL_TYPE,
536: ENR_ACAD_SEQUENCE_NUMBER,
537: ENR_ENROLMENT_CAT,

Line 633: from IGS_PE_PERS_PREFS_ALL

629: ENQ_ADM_CAL_TYPE,
630: ENQ_ADM_CI_SEQUENCE_NUMBER,
631: SERVER_PRINTER_DFLT,
632: ALLOW_STND_REQ_IND
633: from IGS_PE_PERS_PREFS_ALL
634: where ROWID = X_ROWID
635: for update nowait;
636: tlinfo c1%rowtype;
637:

Line 774: update IGS_PE_PERS_PREFS_ALL set

770: x_last_update_date=>X_LAST_UPDATE_DATE,
771: x_last_updated_by=>X_LAST_UPDATED_BY,
772: x_last_update_login=>X_LAST_UPDATE_LOGIN
773: );
774: update IGS_PE_PERS_PREFS_ALL set
775: ENR_ACAD_CAL_TYPE = NEW_REFERENCES.ENR_ACAD_CAL_TYPE,
776: ENR_ACAD_SEQUENCE_NUMBER = NEW_REFERENCES.ENR_ACAD_SEQUENCE_NUMBER,
777: ENR_ENROLMENT_CAT = NEW_REFERENCES.ENR_ENROLMENT_CAT,
778: ENR_ENR_METHOD_TYPE = NEW_REFERENCES.ENR_ENR_METHOD_TYPE,

Line 827: cursor c1 is select rowid from IGS_PE_PERS_PREFS_ALL

823: X_ALLOW_STND_REQ_IND in VARCHAR2,
824: X_ORG_ID in NUMBER,
825: X_MODE in VARCHAR2 default 'R'
826: ) AS
827: cursor c1 is select rowid from IGS_PE_PERS_PREFS_ALL
828: where PERSON_ID = X_PERSON_ID
829: ;
830:
831: begin

Line 890: delete from IGS_PE_PERS_PREFS_ALL

886: Before_DML(
887: p_action => 'DELETE',
888: x_rowid => X_ROWID
889: );
890: delete from IGS_PE_PERS_PREFS_ALL
891: where ROWID = X_ROWID;
892: if (sql%notfound) then
893: raise no_data_found;
894: end if;