APPS.IGS_PR_STDNT_PR_AWD_PKG dependencies on IGS_PR_STDNT_PR_AWD

Line 1: PACKAGE BODY igs_pr_stdnt_pr_awd_pkg AS

1: PACKAGE BODY igs_pr_stdnt_pr_awd_pkg AS
2: /* $Header: IGSQI38B.pls 120.0 2005/07/05 11:59:53 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_stdnt_pr_awd%ROWTYPE;

Line 5: old_references igs_pr_stdnt_pr_awd%ROWTYPE;

1: PACKAGE BODY igs_pr_stdnt_pr_awd_pkg AS
2: /* $Header: IGSQI38B.pls 120.0 2005/07/05 11:59:53 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_stdnt_pr_awd%ROWTYPE;
6: new_references igs_pr_stdnt_pr_awd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pr_stdnt_pr_awd%ROWTYPE;

2: /* $Header: IGSQI38B.pls 120.0 2005/07/05 11:59:53 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_stdnt_pr_awd%ROWTYPE;
6: new_references igs_pr_stdnt_pr_awd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM igs_pr_stdnt_pr_awd

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

Line 134: FROM igs_pr_stdnt_pr_awd

130: || (reverse chronological order - newest change first)
131: */
132: CURSOR cur_rowid IS
133: SELECT rowid
134: FROM igs_pr_stdnt_pr_awd
135: WHERE person_id = x_person_id
136: AND course_cd = x_course_cd
137: AND spo_sequence_number = x_spo_sequence_number
138: AND award_cd = x_award_cd

Line 174: FROM igs_pr_stdnt_pr_awd

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

Line 290: FROM igs_pr_stdnt_pr_awd

286: || (reverse chronological order - newest change first)
287: */
288: CURSOR c IS
289: SELECT rowid
290: FROM igs_pr_stdnt_pr_awd
291: WHERE person_id = x_person_id
292: AND course_cd = x_course_cd
293: AND spo_sequence_number = x_spo_sequence_number
294: AND award_cd = x_award_cd;

Line 338: INSERT INTO igs_pr_stdnt_pr_awd (

334:
335: IF (x_mode = 'S') THEN
336: igs_sc_gen_001.set_ctx('R');
337: END IF;
338: INSERT INTO igs_pr_stdnt_pr_awd (
339: person_id,
340: course_cd,
341: spo_sequence_number,
342: award_cd,

Line 407: FROM igs_pr_stdnt_pr_awd

403: */
404: CURSOR c1 IS
405: SELECT
406: rowid
407: FROM igs_pr_stdnt_pr_awd
408: WHERE rowid = x_rowid
409: FOR UPDATE NOWAIT;
410:
411: tlinfo c1%ROWTYPE;

Line 455: DELETE FROM igs_pr_stdnt_pr_awd

451:
452: IF (x_mode = 'S') THEN
453: igs_sc_gen_001.set_ctx('R');
454: END IF;
455: DELETE FROM igs_pr_stdnt_pr_awd
456: WHERE rowid = x_rowid;
457:
458: IF (SQL%NOTFOUND) THEN
459: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 472: END igs_pr_stdnt_pr_awd_pkg;

468:
469: END delete_row;
470:
471:
472: END igs_pr_stdnt_pr_awd_pkg;