APPS.IGS_PR_STU_OU_HIST_PKG dependencies on IGS_PR_STU_OU_HIST_ALL

Line 4: old_references igs_pr_stu_ou_hist_all%RowType;

1: PACKAGE BODY igs_pr_stu_ou_hist_pkg AS
2: /* $Header: IGSQI28B.pls 115.10 2002/12/23 07:34:00 ddey ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pr_stu_ou_hist_all%RowType;
5: new_references igs_pr_stu_ou_hist_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_pr_stu_ou_hist_all%RowType;

1: PACKAGE BODY igs_pr_stu_ou_hist_pkg AS
2: /* $Header: IGSQI28B.pls 115.10 2002/12/23 07:34:00 ddey ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pr_stu_ou_hist_all%RowType;
5: new_references igs_pr_stu_ou_hist_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 67: FROM IGS_PR_STU_OU_HIST_ALL

63: ***************************************************************/
64:
65: CURSOR cur_old_ref_values IS
66: SELECT *
67: FROM IGS_PR_STU_OU_HIST_ALL
68: WHERE rowid = x_rowid;
69:
70: BEGIN
71:

Line 330: FROM igs_pr_stu_ou_hist_all

326: ***************************************************************/
327:
328: CURSOR cur_rowid IS
329: SELECT rowid
330: FROM igs_pr_stu_ou_hist_all
331: WHERE person_id = x_person_id
332: AND course_cd = x_course_cd
333: AND sequence_number = x_sequence_number
334: AND hist_start_dt = x_hist_start_dt

Line 371: FROM igs_pr_stu_ou_hist_all

367: ***************************************************************/
368:
369: CURSOR cur_rowid IS
370: SELECT rowid
371: FROM igs_pr_stu_ou_hist_all
372: WHERE person_id = x_person_id
373: AND course_cd = x_course_cd
374: AND sequence_number = x_sequence_number ;
375:

Line 625: cursor C is select ROWID from IGS_PR_STU_OU_HIST_ALL

621:
622: (reverse chronological order - newest change first)
623: ***************************************************************/
624:
625: cursor C is select ROWID from IGS_PR_STU_OU_HIST_ALL
626: where PERSON_ID= X_PERSON_ID
627: and COURSE_CD = X_COURSE_CD
628: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
629: and HIST_START_DT = X_HIST_START_DT

Line 698: insert into IGS_PR_STU_OU_HIST_ALL (

694: x_last_update_date=>X_LAST_UPDATE_DATE,
695: x_last_updated_by=>X_LAST_UPDATED_BY,
696: x_last_update_login=>X_LAST_UPDATE_LOGIN,
697: x_org_id=>igs_ge_gen_003.get_org_id);
698: insert into IGS_PR_STU_OU_HIST_ALL (
699: PERSON_ID
700: ,COURSE_CD
701: ,SEQUENCE_NUMBER
702: ,HIST_START_DT

Line 879: from IGS_PR_STU_OU_HIST_ALL

875: , SHOW_CAUSE_DT
876: , SHOW_CAUSE_EXPIRY_DT
877: , SHOW_CAUSE_OUTCOME_DT
878: , SHOW_CAUSE_OUTCOME_TYPE
879: from IGS_PR_STU_OU_HIST_ALL
880: where ROWID = X_ROWID
881: for update nowait;
882: tlinfo c1%rowtype;
883: begin

Line 1112: update IGS_PR_STU_OU_HIST_ALL set

1108: x_created_by=>X_LAST_UPDATED_BY,
1109: x_last_update_date=>X_LAST_UPDATE_DATE,
1110: x_last_updated_by=>X_LAST_UPDATED_BY,
1111: x_last_update_login=>X_LAST_UPDATE_LOGIN );
1112: update IGS_PR_STU_OU_HIST_ALL set
1113: APPEAL_COMMENTS = NEW_REFERENCES.APPEAL_COMMENTS,
1114: APPEAL_DT = NEW_REFERENCES.APPEAL_DT,
1115: APPEAL_EXPIRY_DT = NEW_REFERENCES.APPEAL_EXPIRY_DT,
1116: APPEAL_OUTCOME_DT = NEW_REFERENCES.APPEAL_OUTCOME_DT,

Line 1210: cursor c1 is select ROWID from IGS_PR_STU_OU_HIST_ALL

1206:
1207: (reverse chronological order - newest change first)
1208: ***************************************************************/
1209:
1210: cursor c1 is select ROWID from IGS_PR_STU_OU_HIST_ALL
1211: where PERSON_ID= X_PERSON_ID
1212: and COURSE_CD = X_COURSE_CD
1213: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
1214: and HIST_START_DT = X_HIST_START_DT

Line 1323: delete from IGS_PR_STU_OU_HIST_ALL

1319: Before_DML (
1320: p_action => 'DELETE',
1321: x_rowid => X_ROWID
1322: );
1323: delete from IGS_PR_STU_OU_HIST_ALL
1324: where ROWID = X_ROWID;
1325: if (sql%notfound) then
1326: raise no_data_found;
1327: end if;