APPS.IGS_HE_AD_DTL_ALL_PKG dependencies on IGS_HE_AD_DTL_ALL

Line 1: PACKAGE BODY igs_he_ad_dtl_all_pkg AS

1: PACKAGE BODY igs_he_ad_dtl_all_pkg AS
2: /* $Header: IGSWI20B.pls 120.2 2005/07/03 18:32:47 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ad_dtl_all%ROWTYPE;

Line 5: old_references igs_he_ad_dtl_all%ROWTYPE;

1: PACKAGE BODY igs_he_ad_dtl_all_pkg AS
2: /* $Header: IGSWI20B.pls 120.2 2005/07/03 18:32:47 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ad_dtl_all%ROWTYPE;
6: new_references igs_he_ad_dtl_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_ad_dtl_all%ROWTYPE;

2: /* $Header: IGSWI20B.pls 120.2 2005/07/03 18:32:47 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_ad_dtl_all%ROWTYPE;
6: new_references igs_he_ad_dtl_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 39: FROM IGS_HE_AD_DTL_ALL

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

Line 137: FROM igs_he_ad_dtl_all

133: || (reverse chronological order - newest change first)
134: */
135: CURSOR cur_rowid IS
136: SELECT rowid
137: FROM igs_he_ad_dtl_all
138: WHERE hesa_ad_dtl_id = x_hesa_ad_dtl_id
139: FOR UPDATE NOWAIT;
140:
141: lv_rowid cur_rowid%RowType;

Line 175: FROM igs_he_ad_dtl_all

171: || (reverse chronological order - newest change first)
172: */
173: CURSOR cur_rowid IS
174: SELECT rowid
175: FROM igs_he_ad_dtl_all
176: WHERE ((admission_appl_number = x_admission_appl_number) AND
177: (nominated_course_cd = x_nominated_course_cd) AND
178: (person_id = x_person_id) AND
179: (sequence_number = x_sequence_number));

Line 304: FROM igs_he_ad_dtl_all

300: || (reverse chronological order - newest change first)
301: */
302: CURSOR c IS
303: SELECT rowid
304: FROM igs_he_ad_dtl_all
305: WHERE hesa_ad_dtl_id = x_hesa_ad_dtl_id;
306:
307: x_last_update_date DATE;
308: x_last_updated_by NUMBER;

Line 332: SELECT igs_he_ad_dtl_all_s.NEXTVAL

328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: END IF;
331:
332: SELECT igs_he_ad_dtl_all_s.NEXTVAL
333: INTO x_hesa_ad_dtl_id
334: FROM dual;
335:
336: before_dml(

Line 359: INSERT INTO igs_he_ad_dtl_all (

355:
356: IF (x_mode = 'S') THEN
357: igs_sc_gen_001.set_ctx('R');
358: END IF;
359: INSERT INTO igs_he_ad_dtl_all (
360: org_id,
361: hesa_ad_dtl_id,
362: person_id,
363: admission_appl_number,

Line 456: FROM igs_he_ad_dtl_all

452: occupation_cd,
453: domicile_cd,
454: social_class_cd,
455: special_student_cd
456: FROM igs_he_ad_dtl_all
457: WHERE rowid = x_rowid
458: FOR UPDATE NOWAIT;
459:
460: tlinfo c1%ROWTYPE;

Line 568: UPDATE igs_he_ad_dtl_all

564:
565: IF (x_mode = 'S') THEN
566: igs_sc_gen_001.set_ctx('R');
567: END IF;
568: UPDATE igs_he_ad_dtl_all
569: SET
570: person_id = new_references.person_id,
571: admission_appl_number = new_references.admission_appl_number,
572: nominated_course_cd = new_references.nominated_course_cd,

Line 634: FROM igs_he_ad_dtl_all

630: || (reverse chronological order - newest change first)
631: */
632: CURSOR c1 IS
633: SELECT rowid
634: FROM igs_he_ad_dtl_all
635: WHERE hesa_ad_dtl_id = x_hesa_ad_dtl_id;
636:
637: BEGIN
638:

Line 703: DELETE FROM igs_he_ad_dtl_all

699:
700: IF (x_mode = 'S') THEN
701: igs_sc_gen_001.set_ctx('R');
702: END IF;
703: DELETE FROM igs_he_ad_dtl_all
704: WHERE rowid = x_rowid;
705:
706: IF (SQL%NOTFOUND) THEN
707: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 720: END igs_he_ad_dtl_all_pkg;

716:
717: END delete_row;
718:
719:
720: END igs_he_ad_dtl_all_pkg;