APPS.IGS_PR_COHORT_INST_PKG dependencies on IGS_PR_COHORT_INST

Line 1: PACKAGE BODY igs_pr_cohort_inst_pkg AS

1: PACKAGE BODY igs_pr_cohort_inst_pkg AS
2: /* $Header: IGSQI42B.pls 115.5 2002/11/29 03:25:42 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_cohort_inst%ROWTYPE;

Line 5: old_references igs_pr_cohort_inst%ROWTYPE;

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

Line 6: new_references igs_pr_cohort_inst%ROWTYPE;

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

Line 35: FROM igs_pr_cohort_inst

31: */
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM igs_pr_cohort_inst
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 129: igs_pr_cohinst_rank_pkg.get_fk_igs_pr_cohort_inst (

125: || (reverse chronological order - newest change first)
126: */
127: BEGIN
128:
129: igs_pr_cohinst_rank_pkg.get_fk_igs_pr_cohort_inst (
130: old_references.cohort_name,
131: old_references.load_cal_type,
132: old_references.load_ci_sequence_number
133: );

Line 154: FROM igs_pr_cohort_inst

150: || (reverse chronological order - newest change first)
151: */
152: CURSOR cur_rowid IS
153: SELECT rowid
154: FROM igs_pr_cohort_inst
155: WHERE cohort_name = x_cohort_name
156: AND load_cal_type = x_load_cal_type
157: AND load_ci_sequence_number = x_load_ci_sequence_number
158: FOR UPDATE NOWAIT;

Line 190: FROM igs_pr_cohort_inst

186: || (reverse chronological order - newest change first)
187: */
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM igs_pr_cohort_inst
191: WHERE ((cohort_name = x_cohort_name));
192:
193: lv_rowid cur_rowid%RowType;
194:

Line 226: FROM igs_pr_cohort_inst

222: || (reverse chronological order - newest change first)
223: */
224: CURSOR cur_rowid IS
225: SELECT rowid
226: FROM igs_pr_cohort_inst
227: WHERE ((load_cal_type = x_cal_type) AND
228: (load_ci_sequence_number = x_sequence_number));
229:
230: lv_rowid cur_rowid%RowType;

Line 406: INSERT INTO igs_pr_cohort_inst (

402: x_last_updated_by => x_last_updated_by,
403: x_last_update_login => x_last_update_login
404: );
405:
406: INSERT INTO igs_pr_cohort_inst (
407: cohort_name,
408: load_cal_type,
409: load_ci_sequence_number,
410: cohort_status,

Line 466: FROM igs_pr_cohort_inst

462: SELECT
463: cohort_status,
464: rank_status,
465: run_date
466: FROM igs_pr_cohort_inst
467: WHERE rowid = x_rowid
468: FOR UPDATE NOWAIT;
469:
470: tlinfo c1%ROWTYPE;

Line 580: UPDATE igs_pr_cohort_inst

576: x_program_update_date := SYSDATE;
577: END IF;
578: END IF;
579:
580: UPDATE igs_pr_cohort_inst
581: SET
582: cohort_status = new_references.cohort_status,
583: rank_status = new_references.rank_status,
584: run_date = new_references.run_date,

Line 633: FROM igs_pr_cohort_inst

629: || (reverse chronological order - newest change first)
630: */
631: CURSOR c1 IS
632: SELECT rowid
633: FROM igs_pr_cohort_inst
634: WHERE cohort_name = x_cohort_name
635: AND load_cal_type = x_load_cal_type
636: AND load_ci_sequence_number = x_load_ci_sequence_number;
637:

Line 692: DELETE FROM igs_pr_cohort_inst

688: p_action => 'DELETE',
689: x_rowid => x_rowid
690: );
691:
692: DELETE FROM igs_pr_cohort_inst
693: WHERE rowid = x_rowid;
694:
695: IF (SQL%NOTFOUND) THEN
696: RAISE NO_DATA_FOUND;

Line 702: END igs_pr_cohort_inst_pkg;

698:
699: END delete_row;
700:
701:
702: END igs_pr_cohort_inst_pkg;