APPS.IGS_PR_COHORT_PKG dependencies on IGS_PR_COHORT

Line 1: PACKAGE BODY igs_pr_cohort_pkg AS

1: PACKAGE BODY igs_pr_cohort_pkg AS
2: /* $Header: IGSQI41B.pls 115.4 2002/11/29 03:25:25 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_cohort%ROWTYPE;

Line 5: old_references igs_pr_cohort%ROWTYPE;

1: PACKAGE BODY igs_pr_cohort_pkg AS
2: /* $Header: IGSQI41B.pls 115.4 2002/11/29 03:25:25 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_cohort%ROWTYPE;
6: new_references igs_pr_cohort%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pr_cohort%ROWTYPE;

2: /* $Header: IGSQI41B.pls 115.4 2002/11/29 03:25:25 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_cohort%ROWTYPE;
6: new_references igs_pr_cohort%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 40: FROM igs_pr_cohort

36: */
37:
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM igs_pr_cohort
41: WHERE rowid = x_rowid;
42:
43: BEGIN
44:

Line 189: igs_pr_cohort_inst_pkg.get_fk_igs_pr_cohort (

185: || (reverse chronological order - newest change first)
186: */
187: BEGIN
188:
189: igs_pr_cohort_inst_pkg.get_fk_igs_pr_cohort (
190: old_references.cohort_name
191: );
192:
193: END check_child_existance;

Line 210: FROM igs_pr_cohort

206: || (reverse chronological order - newest change first)
207: */
208: CURSOR cur_rowid IS
209: SELECT rowid
210: FROM igs_pr_cohort
211: WHERE cohort_name = x_cohort_name
212: FOR UPDATE NOWAIT;
213:
214: lv_rowid cur_rowid%RowType;

Line 244: FROM igs_pr_cohort

240: || (reverse chronological order - newest change first)
241: */
242: CURSOR cur_rowid IS
243: SELECT rowid
244: FROM igs_pr_cohort
245: WHERE ((stat_type = x_stat_type));
246:
247: lv_rowid cur_rowid%RowType;
248:

Line 279: FROM igs_pr_cohort

275: || (reverse chronological order - newest change first)
276: */
277: CURSOR cur_rowid IS
278: SELECT rowid
279: FROM igs_pr_cohort
280: WHERE ((rule_sequence_number = x_sequence_number));
281:
282: lv_rowid cur_rowid%RowType;
283:

Line 463: INSERT INTO igs_pr_cohort (

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_cohort (
464: cohort_name,
465: description,
466: org_unit_cd,
467: stat_type,

Line 537: FROM igs_pr_cohort

533: incl_on_transcript_ind,
534: incl_on_stud_acad_hist_ind,
535: rule_sequence_number,
536: closed_ind
537: FROM igs_pr_cohort
538: WHERE rowid = x_rowid
539: FOR UPDATE NOWAIT;
540:
541: tlinfo c1%ROWTYPE;

Line 650: UPDATE igs_pr_cohort

646: x_last_updated_by => x_last_updated_by,
647: x_last_update_login => x_last_update_login
648: );
649:
650: UPDATE igs_pr_cohort
651: SET
652: description = new_references.description,
653: org_unit_cd = new_references.org_unit_cd,
654: stat_type = new_references.stat_type,

Line 700: FROM igs_pr_cohort

696: || (reverse chronological order - newest change first)
697: */
698: CURSOR c1 IS
699: SELECT rowid
700: FROM igs_pr_cohort
701: WHERE cohort_name = x_cohort_name;
702:
703: BEGIN
704:

Line 767: DELETE FROM igs_pr_cohort

763: p_action => 'DELETE',
764: x_rowid => x_rowid
765: );
766:
767: DELETE FROM igs_pr_cohort
768: WHERE rowid = x_rowid;
769:
770: IF (SQL%NOTFOUND) THEN
771: RAISE NO_DATA_FOUND;

Line 777: END igs_pr_cohort_pkg;

773:
774: END delete_row;
775:
776:
777: END igs_pr_cohort_pkg;