APPS.IGS_PR_STU_ACAD_STAT_PKG dependencies on IGS_PR_STU_ACAD_STAT

Line 1: PACKAGE BODY IGS_PR_STU_ACAD_STAT_PKG AS

1: PACKAGE BODY IGS_PR_STU_ACAD_STAT_PKG AS
2: /* $Header: IGSQI39B.pls 115.3 2003/08/19 05:41:29 smanglm noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_stu_acad_stat%ROWTYPE;

Line 5: old_references igs_pr_stu_acad_stat%ROWTYPE;

1: PACKAGE BODY IGS_PR_STU_ACAD_STAT_PKG AS
2: /* $Header: IGSQI39B.pls 115.3 2003/08/19 05:41:29 smanglm noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_stu_acad_stat%ROWTYPE;
6: new_references igs_pr_stu_acad_stat%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pr_stu_acad_stat%ROWTYPE;

2: /* $Header: IGSQI39B.pls 115.3 2003/08/19 05:41:29 smanglm noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_stu_acad_stat%ROWTYPE;
6: new_references igs_pr_stu_acad_stat%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 43: FROM igs_pr_stu_acad_stat

39: */
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM igs_pr_stu_acad_stat
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 168: FROM igs_pr_stu_acad_stat

164: || (reverse chronological order - newest change first)
165: */
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM igs_pr_stu_acad_stat
169: WHERE person_id = x_person_id
170: AND course_cd = x_course_cd
171: AND cal_type = x_cal_type
172: AND ci_sequence_number = x_ci_sequence_number

Line 209: FROM igs_pr_stu_acad_stat

205: || (reverse chronological order - newest change first)
206: */
207: CURSOR cur_rowid IS
208: SELECT ROWID
209: FROM igs_pr_stu_acad_stat
210: WHERE person_id = x_person_id
211: AND course_cd = x_course_cd ;
212: lv_rowid cur_rowid%ROWTYPE;
213: BEGIN

Line 232: FROM igs_pr_stu_acad_stat

228: x_ci_sequence_number IN NUMBER
229: ) AS
230: CURSOR cur_rowid IS
231: SELECT ROWID
232: FROM igs_pr_stu_acad_stat
233: WHERE cal_type= x_cal_type
234: AND ci_sequence_number = x_ci_sequence_number;
235:
236: lv_rowid cur_rowid%ROWTYPE;

Line 264: FROM igs_pr_stu_acad_stat

260: || (reverse chronological order - newest change first)
261: */
262: CURSOR cur_rowid IS
263: SELECT rowid
264: FROM igs_pr_stu_acad_stat
265: WHERE ((stat_type = x_stat_type));
266:
267: lv_rowid cur_rowid%RowType;
268:

Line 408: FROM igs_pr_stu_acad_stat

404: || (reverse chronological order - newest change first)
405: */
406: CURSOR c IS
407: SELECT rowid
408: FROM igs_pr_stu_acad_stat
409: WHERE person_id = x_person_id
410: AND course_cd = x_course_cd
411: AND cal_type = x_cal_type
412: AND ci_sequence_number = x_ci_sequence_number

Line 463: INSERT INTO igs_pr_stu_acad_stat (

459: x_last_updated_by => x_last_updated_by,
460: x_last_update_login => x_last_update_login
461: );
462:
463: INSERT INTO igs_pr_stu_acad_stat (
464: person_id,
465: course_cd,
466: cal_type,
467: ci_sequence_number,

Line 549: FROM igs_pr_stu_acad_stat

545: earned_credit_points,
546: gpa,
547: gpa_credit_points,
548: gpa_quality_points
549: FROM igs_pr_stu_acad_stat
550: WHERE rowid = x_rowid
551: FOR UPDATE NOWAIT;
552:
553:

Line 666: UPDATE igs_pr_stu_acad_stat

662: x_last_updated_by => x_last_updated_by,
663: x_last_update_login => x_last_update_login
664: );
665:
666: UPDATE igs_pr_stu_acad_stat
667: SET
668: timeframe = new_references.timeframe,
669: source_type = new_references.source_type,
670: source_reference = new_references.source_reference,

Line 716: FROM igs_pr_stu_acad_stat

712: || (reverse chronological order - newest change first)
713: */
714: CURSOR c1 IS
715: SELECT rowid
716: FROM igs_pr_stu_acad_stat
717: WHERE person_id = x_person_id
718: AND course_cd = x_course_cd
719: AND cal_type = x_cal_type
720: AND ci_sequence_number = x_ci_sequence_number

Line 793: DELETE FROM igs_pr_stu_acad_stat

789: p_action => 'DELETE',
790: x_rowid => x_rowid
791: );
792:
793: DELETE FROM igs_pr_stu_acad_stat
794: WHERE rowid = x_rowid;
795:
796: IF (SQL%NOTFOUND) THEN
797: RAISE NO_DATA_FOUND;

Line 803: END igs_pr_stu_acad_stat_pkg;

799:
800: END delete_row;
801:
802:
803: END igs_pr_stu_acad_stat_pkg;
804: