APPS.IGS_GR_GRADUAND_HIST_PKG dependencies on IGS_GR_GRADUAND_HIST_ALL

Line 4: old_references IGS_GR_GRADUAND_HIST_ALL%RowType;

1: package body IGS_GR_GRADUAND_HIST_PKG as
2: /* $Header: IGSGI13B.pls 115.7 2003/10/07 08:21:12 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_GRADUAND_HIST_ALL%RowType;
5: new_references IGS_GR_GRADUAND_HIST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GR_GRADUAND_HIST_ALL%RowType;

1: package body IGS_GR_GRADUAND_HIST_PKG as
2: /* $Header: IGSGI13B.pls 115.7 2003/10/07 08:21:12 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_GRADUAND_HIST_ALL%RowType;
5: new_references IGS_GR_GRADUAND_HIST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 45: FROM IGS_GR_GRADUAND_HIST_ALL

41: ) AS
42:
43: CURSOR cur_old_ref_values IS
44: SELECT *
45: FROM IGS_GR_GRADUAND_HIST_ALL
46: WHERE rowid = x_rowid;
47:
48: BEGIN
49:

Line 110: FROM IGS_GR_GRADUAND_HIST_ALL

106: ) RETURN BOOLEAN AS
107:
108: CURSOR cur_rowid IS
109: SELECT rowid
110: FROM IGS_GR_GRADUAND_HIST_ALL
111: WHERE person_id = x_person_id
112: AND create_dt = x_create_dt
113: AND hist_start_dt = x_hist_start_dt
114: FOR UPDATE NOWAIT;

Line 490: cursor C is select ROWID from IGS_GR_GRADUAND_HIST_ALL

486: X_COMMENTS in VARCHAR2,
487: X_MODE in VARCHAR2 default 'R',
488: X_ORG_ID in NUMBER
489: ) AS
490: cursor C is select ROWID from IGS_GR_GRADUAND_HIST_ALL
491: where PERSON_ID = X_PERSON_ID
492: and CREATE_DT = X_CREATE_DT
493: and HIST_START_DT = X_HIST_START_DT;
494: X_LAST_UPDATE_DATE DATE;

Line 550: insert into IGS_GR_GRADUAND_HIST_ALL (

546: x_last_update_login => X_LAST_UPDATE_LOGIN,
547: x_org_id => igs_ge_gen_003.get_org_id
548: );
549:
550: insert into IGS_GR_GRADUAND_HIST_ALL (
551: PERSON_ID,
552: CREATE_DT,
553: HIST_START_DT,
554: HIST_END_DT,

Line 671: from IGS_GR_GRADUAND_HIST_ALL

667: SUR_FOR_COURSE_CD,
668: SUR_FOR_CRS_VERSION_NUMBER,
669: SUR_FOR_AWARD_CD,
670: COMMENTS
671: from IGS_GR_GRADUAND_HIST_ALL
672: where ROWID = X_ROWID for update nowait;
673: tlinfo c1%rowtype;
674:
675: begin

Line 836: update IGS_GR_GRADUAND_HIST_ALL set

832: x_last_updated_by => X_LAST_UPDATED_BY,
833: x_last_update_login => X_LAST_UPDATE_LOGIN
834: );
835:
836: update IGS_GR_GRADUAND_HIST_ALL set
837: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
838: HIST_WHO = NEW_REFERENCES.HIST_WHO,
839: GRD_CAL_TYPE = NEW_REFERENCES.GRD_CAL_TYPE,
840: GRD_CI_SEQUENCE_NUMBER = NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER,

Line 898: cursor c1 is select rowid from IGS_GR_GRADUAND_HIST_ALL

894: X_COMMENTS in VARCHAR2,
895: X_MODE in VARCHAR2 default 'R',
896: X_ORG_ID in NUMBER
897: ) AS
898: cursor c1 is select rowid from IGS_GR_GRADUAND_HIST_ALL
899: where PERSON_ID = X_PERSON_ID
900: and CREATE_DT = X_CREATE_DT
901: and HIST_START_DT = X_HIST_START_DT
902: ;

Line 978: delete from IGS_GR_GRADUAND_HIST_ALL

974: X_ROWID in VARCHAR2
975: ) AS
976: begin
977:
978: delete from IGS_GR_GRADUAND_HIST_ALL
979: where ROWID = X_ROWID;
980: if (sql%notfound) then
981: raise no_data_found;
982: end if;