APPS.IGS_PS_TYPE_HIST_PKG dependencies on IGS_PS_TYPE_HIST_ALL

Line 5: old_references IGS_PS_TYPE_HIST_ALL%RowType;

1: package body IGS_PS_TYPE_HIST_PKG AS
2: /* $Header: IGSPI39B.pls 115.9 2002/11/29 02:24:02 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_TYPE_HIST_ALL%RowType;
6: new_references IGS_PS_TYPE_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_TYPE_HIST_ALL%RowType;

2: /* $Header: IGSPI39B.pls 115.9 2002/11/29 02:24:02 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_TYPE_HIST_ALL%RowType;
6: new_references IGS_PS_TYPE_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 33: FROM IGS_PS_TYPE_HIST_ALL

29: x_org_id IN NUMBER ) AS
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM IGS_PS_TYPE_HIST_ALL
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 180: FROM IGS_PS_TYPE_HIST_ALL

176: ) RETURN BOOLEAN AS
177:
178: CURSOR cur_rowid IS
179: SELECT rowid
180: FROM IGS_PS_TYPE_HIST_ALL
181: WHERE course_type = x_course_type
182: AND hist_start_dt = x_hist_start_dt
183: FOR UPDATE NOWAIT;
184:

Line 316: cursor C is select ROWID from IGS_PS_TYPE_HIST_ALL

312: X_MODE in VARCHAR2,
313: X_ORG_ID in NUMBER
314: ) AS
315:
316: cursor C is select ROWID from IGS_PS_TYPE_HIST_ALL
317: where COURSE_TYPE = X_COURSE_TYPE
318: and HIST_START_DT = X_HIST_START_DT;
319: X_LAST_UPDATE_DATE DATE;
320: X_LAST_UPDATED_BY NUMBER;

Line 364: insert into IGS_PS_TYPE_HIST_ALL (

360: x_last_updated_by => X_LAST_UPDATED_BY,
361: x_last_update_login => X_LAST_UPDATE_LOGIN,
362: x_org_id => igs_ge_gen_003.get_org_id
363: );
364: insert into IGS_PS_TYPE_HIST_ALL (
365: COURSE_TYPE,
366: HIST_START_DT,
367: HIST_END_DT,
368: HIST_WHO,

Line 448: from IGS_PS_TYPE_HIST_ALL

444: RESEARCH_TYPE_IND,
445: CLOSED_IND,
446: PRIMARY_AUTO_SELECT,
447: FIN_AID_PROGRAM_TYPE
448: from IGS_PS_TYPE_HIST_ALL
449: where ROWID = X_ROWID for update nowait;
450: tlinfo c1%rowtype;
451:
452: begin

Line 563: update IGS_PS_TYPE_HIST_ALL set

559: x_last_update_date => X_LAST_UPDATE_DATE,
560: x_last_updated_by => X_LAST_UPDATED_BY,
561: x_last_update_login => X_LAST_UPDATE_LOGIN
562: );
563: update IGS_PS_TYPE_HIST_ALL set
564: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
565: HIST_WHO = NEW_REFERENCES.HIST_WHO,
566: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
567: GOVT_COURSE_TYPE = NEW_REFERENCES.GOVT_COURSE_TYPE,

Line 607: cursor c1 is select rowid from IGS_PS_TYPE_HIST_ALL

603: X_FIN_AID_PROGRAM_TYPE IN VARCHAR2,
604: X_MODE in VARCHAR2,
605: X_ORG_ID in NUMBER
606: ) AS
607: cursor c1 is select rowid from IGS_PS_TYPE_HIST_ALL
608: where COURSE_TYPE = X_COURSE_TYPE
609: and HIST_START_DT = X_HIST_START_DT
610: ;
611: begin

Line 662: delete from IGS_PS_TYPE_HIST_ALL

658: begin
659: Before_DML( p_action => 'DELETE',
660: x_rowid => X_ROWID
661: );
662: delete from IGS_PS_TYPE_HIST_ALL
663: where ROWID = X_ROWID;
664: if (sql%notfound) then
665: raise no_data_found;
666: end if;