APPS.IGS_PE_ATHLETIC_DTL_PKG dependencies on IGS_PE_ATHLETIC_DTL

Line 1: PACKAGE BODY igs_pe_athletic_dtl_pkg AS

1: PACKAGE BODY igs_pe_athletic_dtl_pkg AS
2: /* $Header: IGSNI95B.pls 120.1 2005/06/28 05:07:22 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_athletic_dtl%ROWTYPE;

Line 5: old_references igs_pe_athletic_dtl%ROWTYPE;

1: PACKAGE BODY igs_pe_athletic_dtl_pkg AS
2: /* $Header: IGSNI95B.pls 120.1 2005/06/28 05:07:22 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_athletic_dtl%ROWTYPE;
6: new_references igs_pe_athletic_dtl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_athletic_dtl%ROWTYPE;

2: /* $Header: IGSNI95B.pls 120.1 2005/06/28 05:07:22 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_athletic_dtl%ROWTYPE;
6: new_references igs_pe_athletic_dtl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 37: FROM igs_pe_athletic_dtl

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

Line 161: FROM igs_pe_athletic_dtl

157: || (reverse chronological order - newest change first)
158: */
159: CURSOR cur_rowid IS
160: SELECT rowid
161: FROM igs_pe_athletic_dtl
162: WHERE athletic_details_id = x_athletic_details_id
163: FOR UPDATE NOWAIT;
164:
165: lv_rowid cur_rowid%RowType;

Line 196: FROM igs_pe_athletic_dtl

192: || (reverse chronological order - newest change first)
193: */
194: CURSOR cur_rowid IS
195: SELECT rowid
196: FROM igs_pe_athletic_dtl
197: WHERE person_id = x_person_id
198: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
199:
200: lv_rowid cur_rowid%RowType;

Line 231: FROM igs_pe_athletic_dtl

227: || (reverse chronological order - newest change first)
228: */
229: CURSOR cur_rowid IS
230: SELECT rowid
231: FROM igs_pe_athletic_dtl
232: WHERE ((eligibility_status_cd = x_code_id));
233:
234: lv_rowid cur_rowid%RowType;
235:

Line 266: FROM igs_pe_athletic_dtl

262: || (reverse chronological order - newest change first)
263: */
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM igs_pe_athletic_dtl
267: WHERE ((person_id = x_party_id));
268:
269: lv_rowid cur_rowid%RowType;
270:

Line 391: FROM igs_pe_athletic_dtl

387: || (reverse chronological order - newest change first)
388: */
389: CURSOR c IS
390: SELECT rowid
391: FROM igs_pe_athletic_dtl
392: WHERE athletic_details_id = x_athletic_details_id;
393:
394: x_last_update_date DATE;
395: x_last_updated_by NUMBER;

Line 419: SELECT igs_pe_athletic_dtl_s.NEXTVAL

415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: END IF;
418:
419: SELECT igs_pe_athletic_dtl_s.NEXTVAL
420: INTO x_athletic_details_id
421: FROM dual;
422:
423: before_dml(

Line 444: INSERT INTO igs_pe_athletic_dtl (

440:
441: IF (x_mode = 'S') THEN
442: igs_sc_gen_001.set_ctx('R');
443: END IF;
444: INSERT INTO igs_pe_athletic_dtl (
445: athletic_details_id,
446: person_id,
447: athletic_gpa,
448: eligibility_status_cd,

Line 531: FROM igs_pe_athletic_dtl

527: predict_elig_code,
528: tentative_adm_code,
529: review_date,
530: comments
531: FROM igs_pe_athletic_dtl
532: WHERE rowid = x_rowid
533: FOR UPDATE NOWAIT;
534:
535: tlinfo c1%ROWTYPE;

Line 638: UPDATE igs_pe_athletic_dtl

634:
635: IF (x_mode = 'S') THEN
636: igs_sc_gen_001.set_ctx('R');
637: END IF;
638: UPDATE igs_pe_athletic_dtl
639: SET
640: person_id = new_references.person_id,
641: athletic_gpa = new_references.athletic_gpa,
642: eligibility_status_cd = new_references.eligibility_status_cd,

Line 702: FROM igs_pe_athletic_dtl

698: || (reverse chronological order - newest change first)
699: */
700: CURSOR c1 IS
701: SELECT rowid
702: FROM igs_pe_athletic_dtl
703: WHERE athletic_details_id = x_athletic_details_id;
704:
705: BEGIN
706:

Line 767: DELETE FROM igs_pe_athletic_dtl

763:
764: IF (x_mode = 'S') THEN
765: igs_sc_gen_001.set_ctx('R');
766: END IF;
767: DELETE FROM igs_pe_athletic_dtl
768: WHERE rowid = x_rowid;
769:
770: IF (SQL%NOTFOUND) THEN
771: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 784: END igs_pe_athletic_dtl_pkg;

780:
781: END delete_row;
782:
783:
784: END igs_pe_athletic_dtl_pkg;