APPS.IGS_PR_STDNT_PR_FND_PKG dependencies on IGS_PR_STDNT_PR_FND

Line 1: PACKAGE BODY igs_pr_stdnt_pr_fnd_pkg AS

1: PACKAGE BODY igs_pr_stdnt_pr_fnd_pkg AS
2: /* $Header: IGSQI45B.pls 120.0 2005/07/05 12:15:50 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_stdnt_pr_fnd%ROWTYPE;

Line 5: old_references igs_pr_stdnt_pr_fnd%ROWTYPE;

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

Line 6: new_references igs_pr_stdnt_pr_fnd%ROWTYPE;

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

Line 33: FROM igs_pr_stdnt_pr_fnd

29: */
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM igs_pr_stdnt_pr_fnd
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 131: FROM igs_pr_stdnt_pr_fnd

127: || (reverse chronological order - newest change first)
128: */
129: CURSOR cur_rowid IS
130: SELECT rowid
131: FROM igs_pr_stdnt_pr_fnd
132: WHERE person_id = x_person_id
133: AND course_cd = x_course_cd
134: AND spo_sequence_number = x_spo_sequence_number
135: AND fund_code = x_fund_code

Line 171: FROM igs_pr_stdnt_pr_fnd

167: || (reverse chronological order - newest change first)
168: */
169: CURSOR cur_rowid IS
170: SELECT rowid
171: FROM igs_pr_stdnt_pr_fnd
172: WHERE ((course_cd = x_course_cd) AND
173: (person_id = x_person_id) AND
174: (spo_sequence_number = x_sequence_number));
175:

Line 208: FROM igs_pr_stdnt_pr_fnd

204: || (reverse chronological order - newest change first)
205: */
206: CURSOR cur_rowid IS
207: SELECT rowid
208: FROM igs_pr_stdnt_pr_fnd
209: WHERE ((fund_code = x_fund_code));
210:
211: lv_rowid cur_rowid%RowType;
212:

Line 363: INSERT INTO igs_pr_stdnt_pr_fnd (

359:
360: IF (x_mode = 'S') THEN
361: igs_sc_gen_001.set_ctx('R');
362: END IF;
363: INSERT INTO igs_pr_stdnt_pr_fnd (
364: person_id,
365: course_cd,
366: spo_sequence_number,
367: fund_code,

Line 426: FROM igs_pr_stdnt_pr_fnd

422: */
423: CURSOR c1 IS
424: SELECT
425: rowid
426: FROM igs_pr_stdnt_pr_fnd
427: WHERE rowid = x_rowid
428: FOR UPDATE NOWAIT;
429:
430: tlinfo c1%ROWTYPE;

Line 474: DELETE FROM igs_pr_stdnt_pr_fnd

470:
471: IF (x_mode = 'S') THEN
472: igs_sc_gen_001.set_ctx('R');
473: END IF;
474: DELETE FROM igs_pr_stdnt_pr_fnd
475: WHERE rowid = x_rowid;
476:
477: IF (SQL%NOTFOUND) THEN
478: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 491: END igs_pr_stdnt_pr_fnd_pkg;

487:
488: END delete_row;
489:
490:
491: END igs_pr_stdnt_pr_fnd_pkg;