APPS.IGS_PS_FLD_STD_HIST_PKG dependencies on IGS_PS_FLD_STD_HIST_ALL

Line 5: old_references IGS_PS_FLD_STD_HIST_ALL%RowType;

1: package body IGS_PS_FLD_STD_HIST_PKG AS
2: /* $Header: IGSPI14B.pls 115.7 2003/06/05 13:10:07 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_FLD_STD_HIST_ALL%RowType;
6: new_references IGS_PS_FLD_STD_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_FLD_STD_HIST_ALL%RowType;

2: /* $Header: IGSPI14B.pls 115.7 2003/06/05 13:10:07 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_FLD_STD_HIST_ALL%RowType;
6: new_references IGS_PS_FLD_STD_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM IGS_PS_FLD_STD_HIST_ALL

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM IGS_PS_FLD_STD_HIST_ALL
30: WHERE rowid = x_rowid;
31:
32: BEGIN
33:

Line 162: FROM IGS_PS_FLD_STD_HIST_ALL

158: RETURN BOOLEAN AS
159:
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM IGS_PS_FLD_STD_HIST_ALL
163: WHERE course_cd = x_course_cd
164: AND version_number = x_version_number
165: AND field_of_study = x_field_of_study
166: AND hist_start_dt = x_hist_start_dt

Line 192: FROM IGS_PS_FLD_STD_HIST_ALL

188: ) AS
189:
190: CURSOR cur_rowid IS
191: SELECT rowid
192: FROM IGS_PS_FLD_STD_HIST_ALL
193: WHERE course_cd = x_course_cd
194: AND version_number = x_version_number ;
195:
196: lv_rowid cur_rowid%RowType;

Line 313: cursor C is select ROWID from IGS_PS_FLD_STD_HIST_ALL

309: X_MAJOR_FIELD_IND in VARCHAR2,
310: X_MODE in VARCHAR2 default 'R',
311: X_ORG_ID in NUMBER
312: ) AS
313: cursor C is select ROWID from IGS_PS_FLD_STD_HIST_ALL
314: where COURSE_CD = X_COURSE_CD
315: and FIELD_OF_STUDY = X_FIELD_OF_STUDY
316: and HIST_START_DT = X_HIST_START_DT
317: and VERSION_NUMBER = X_VERSION_NUMBER;

Line 359: insert into IGS_PS_FLD_STD_HIST_ALL (

355: x_last_update_login => X_LAST_UPDATE_LOGIN,
356: x_org_id => igs_ge_gen_003.get_org_id
357: );
358:
359: insert into IGS_PS_FLD_STD_HIST_ALL (
360: COURSE_CD,
361: VERSION_NUMBER,
362: FIELD_OF_STUDY,
363: HIST_START_DT,

Line 422: from IGS_PS_FLD_STD_HIST_ALL

418: HIST_END_DT,
419: HIST_WHO,
420: PERCENTAGE,
421: MAJOR_FIELD_IND
422: from IGS_PS_FLD_STD_HIST_ALL
423: where ROWID = X_ROWID
424: for update nowait;
425: tlinfo c1%rowtype;
426:

Line 511: update IGS_PS_FLD_STD_HIST_ALL set

507: x_last_update_login => X_LAST_UPDATE_LOGIN
508:
509: );
510:
511: update IGS_PS_FLD_STD_HIST_ALL set
512: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
513: HIST_WHO = NEW_REFERENCES.HIST_WHO,
514: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
515: MAJOR_FIELD_IND = NEW_REFERENCES.MAJOR_FIELD_IND,

Line 544: cursor c1 is select rowid from IGS_PS_FLD_STD_HIST_ALL

540: X_MAJOR_FIELD_IND in VARCHAR2,
541: X_MODE in VARCHAR2 default 'R',
542: X_ORG_ID in NUMBER
543: ) AS
544: cursor c1 is select rowid from IGS_PS_FLD_STD_HIST_ALL
545: where COURSE_CD = X_COURSE_CD
546: and FIELD_OF_STUDY = X_FIELD_OF_STUDY
547: and HIST_START_DT = X_HIST_START_DT
548: and VERSION_NUMBER = X_VERSION_NUMBER

Line 592: delete from IGS_PS_FLD_STD_HIST_ALL

588: Before_DML (
589: p_action => 'DELETE',
590: x_rowid => X_ROWID
591: );
592: delete from IGS_PS_FLD_STD_HIST_ALL
593: where ROWID = X_ROWID;
594:
595: if (sql%notfound) then
596: raise no_data_found;