APPS.IGS_RE_SCHL_TYPE_PKG dependencies on IGS_RE_SCHL_TYPE_ALL

Line 5: old_references IGS_RE_SCHL_TYPE_ALL%RowType;

1: package body IGS_RE_SCHL_TYPE_PKG as
2: /* $Header: IGSRI10B.pls 115.5 2002/11/29 03:33:46 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_SCHL_TYPE_ALL%RowType;
6: new_references IGS_RE_SCHL_TYPE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RE_SCHL_TYPE_ALL%RowType;

2: /* $Header: IGSRI10B.pls 115.5 2002/11/29 03:33:46 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_SCHL_TYPE_ALL%RowType;
6: new_references IGS_RE_SCHL_TYPE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 27: FROM IGS_RE_SCHL_TYPE_ALL

23: ) AS
24:
25: CURSOR cur_old_ref_values IS
26: SELECT *
27: FROM IGS_RE_SCHL_TYPE_ALL
28: WHERE rowid = x_rowid;
29:
30: BEGIN
31:

Line 158: FROM IGS_RE_SCHL_TYPE_ALL

154: ) RETURN BOOLEAN AS
155:
156: CURSOR cur_rowid IS
157: SELECT rowid
158: FROM IGS_RE_SCHL_TYPE_ALL
159: WHERE scholarship_type = x_scholarship_type
160: FOR UPDATE NOWAIT;
161:
162: lv_rowid cur_rowid%RowType;

Line 185: FROM IGS_RE_SCHL_TYPE_ALL

181: ) AS
182:
183: CURSOR cur_rowid IS
184: SELECT rowid
185: FROM IGS_RE_SCHL_TYPE_ALL
186: WHERE org_unit_cd_from = x_org_unit_cd
187: AND ou_start_dt_from = x_start_dt ;
188:
189: lv_rowid cur_rowid%RowType;

Line 212: FROM IGS_RE_SCHL_TYPE_ALL

208: ) AS
209:
210: CURSOR cur_rowid IS
211: SELECT rowid
212: FROM IGS_RE_SCHL_TYPE_ALL
213: WHERE person_id_from = x_person_id ;
214:
215: lv_rowid cur_rowid%RowType;
216:

Line 312: cursor C is select ROWID from IGS_RE_SCHL_TYPE_ALL

308: X_CLOSED_IND in VARCHAR2,
309: X_MODE in VARCHAR2 default 'R',
310: X_ORG_ID in NUMBER
311: ) As
312: cursor C is select ROWID from IGS_RE_SCHL_TYPE_ALL
313: where SCHOLARSHIP_TYPE = X_SCHOLARSHIP_TYPE;
314: X_LAST_UPDATE_DATE DATE;
315: X_LAST_UPDATED_BY NUMBER;
316: X_LAST_UPDATE_LOGIN NUMBER;

Line 354: insert into IGS_RE_SCHL_TYPE_ALL (

350: x_last_update_login => X_LAST_UPDATE_LOGIN,
351: x_org_id => igs_ge_gen_003.get_org_id
352: );
353:
354: insert into IGS_RE_SCHL_TYPE_ALL (
355: SCHOLARSHIP_TYPE,
356: DESCRIPTION,
357: ORG_UNIT_CD_FROM,
358: OU_START_DT_FROM,

Line 407: from IGS_RE_SCHL_TYPE_ALL

403: ORG_UNIT_CD_FROM,
404: OU_START_DT_FROM,
405: PERSON_ID_FROM,
406: CLOSED_IND
407: from IGS_RE_SCHL_TYPE_ALL
408: where ROWID = X_ROWID
409: for update nowait;
410: tlinfo c1%rowtype;
411:

Line 494: update IGS_RE_SCHL_TYPE_ALL set

490: x_last_update_date => X_LAST_UPDATE_DATE,
491: x_last_update_login => X_LAST_UPDATE_LOGIN
492: );
493:
494: update IGS_RE_SCHL_TYPE_ALL set
495: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
496: ORG_UNIT_CD_FROM = NEW_REFERENCES.ORG_UNIT_CD_FROM,
497: OU_START_DT_FROM = NEW_REFERENCES.OU_START_DT_FROM,
498: PERSON_ID_FROM = NEW_REFERENCES.PERSON_ID_FROM,

Line 522: cursor c1 is select rowid from IGS_RE_SCHL_TYPE_ALL

518: X_CLOSED_IND in VARCHAR2,
519: X_MODE in VARCHAR2 default 'R',
520: X_ORG_ID in NUMBER
521: ) as
522: cursor c1 is select rowid from IGS_RE_SCHL_TYPE_ALL
523: where SCHOLARSHIP_TYPE = X_SCHOLARSHIP_TYPE
524: ;
525: begin
526: open c1;

Line 564: delete from IGS_RE_SCHL_TYPE_ALL

560: p_action => 'DELETE',
561: x_rowid => X_ROWID
562: );
563:
564: delete from IGS_RE_SCHL_TYPE_ALL
565: where ROWID = X_ROWID;
566: if (sql%notfound) then
567: raise no_data_found;
568: end if;