APPS.IGS_PR_COHINST_RANK_PKG dependencies on IGS_PR_COHINST_RANK

Line 1: PACKAGE BODY igs_pr_cohinst_rank_pkg AS

1: PACKAGE BODY igs_pr_cohinst_rank_pkg AS
2: /* $Header: IGSQI43B.pls 120.0 2005/07/05 12:06:37 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_cohinst_rank%ROWTYPE;

Line 5: old_references igs_pr_cohinst_rank%ROWTYPE;

1: PACKAGE BODY igs_pr_cohinst_rank_pkg AS
2: /* $Header: IGSQI43B.pls 120.0 2005/07/05 12:06:37 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_cohinst_rank%ROWTYPE;
6: new_references igs_pr_cohinst_rank%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pr_cohinst_rank%ROWTYPE;

2: /* $Header: IGSQI43B.pls 120.0 2005/07/05 12:06:37 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_cohinst_rank%ROWTYPE;
6: new_references igs_pr_cohinst_rank%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 38: FROM igs_pr_cohinst_rank

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM igs_pr_cohinst_rank
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 147: FROM igs_pr_cohinst_rank

143: || (reverse chronological order - newest change first)
144: */
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM igs_pr_cohinst_rank
148: WHERE person_id = x_person_id
149: AND course_cd = x_course_cd
150: AND cohort_name = x_cohort_name
151: AND load_cal_type = x_load_cal_type

Line 187: FROM igs_pr_cohinst_rank

183: || (reverse chronological order - newest change first)
184: */
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM igs_pr_cohinst_rank
188: WHERE ((cohort_name = x_cohort_name) AND
189: (load_cal_type = x_load_cal_type) AND
190: (load_ci_sequence_number = x_load_ci_sequence_number));
191:

Line 225: FROM igs_pr_cohinst_rank

221: || (reverse chronological order - newest change first)
222: */
223: CURSOR cur_rowid IS
224: SELECT rowid
225: FROM igs_pr_cohinst_rank
226: WHERE ((course_cd = x_course_cd) AND
227: (person_id = x_person_id));
228:
229: lv_rowid cur_rowid%RowType;

Line 416: INSERT INTO igs_pr_cohinst_rank (

412: x_last_updated_by => x_last_updated_by,
413: x_last_update_login => x_last_update_login
414: );
415:
416: INSERT INTO igs_pr_cohinst_rank (
417: cohort_name,
418: load_cal_type,
419: load_ci_sequence_number,
420: person_id,

Line 486: FROM igs_pr_cohinst_rank

482: as_of_rank_gpa,
483: cohort_rank,
484: cohort_override_rank,
485: comments
486: FROM igs_pr_cohinst_rank
487: WHERE rowid = x_rowid
488: FOR UPDATE NOWAIT;
489:
490: tlinfo c1%ROWTYPE;

Line 607: UPDATE igs_pr_cohinst_rank

603: x_program_update_date := SYSDATE;
604: END IF;
605: END IF;
606:
607: UPDATE igs_pr_cohinst_rank
608: SET
609: as_of_rank_gpa = new_references.as_of_rank_gpa,
610: cohort_rank = new_references.cohort_rank,
611: cohort_override_rank = new_references.cohort_override_rank,

Line 708: FROM igs_pr_cohinst_rank

704: || (reverse chronological order - newest change first)
705: */
706: CURSOR c1 IS
707: SELECT rowid
708: FROM igs_pr_cohinst_rank
709: WHERE person_id = x_person_id
710: AND course_cd = x_course_cd
711: AND cohort_name = x_cohort_name
712: AND load_cal_type = x_load_cal_type

Line 775: DELETE FROM igs_pr_cohinst_rank

771: p_action => 'DELETE',
772: x_rowid => x_rowid
773: );
774:
775: DELETE FROM igs_pr_cohinst_rank
776: WHERE rowid = x_rowid;
777:
778: IF (SQL%NOTFOUND) THEN
779: RAISE NO_DATA_FOUND;

Line 785: END igs_pr_cohinst_rank_pkg;

781:
782: END delete_row;
783:
784:
785: END igs_pr_cohinst_rank_pkg;