APPS.IGS_AD_APPL_ARP_PKG dependencies on IGS_AD_APPL_ARP

Line 1: PACKAGE BODY igs_ad_appl_arp_pkg AS

1: PACKAGE BODY igs_ad_appl_arp_pkg AS
2: /* $Header: IGSAIF7B.pls 120.4 2005/10/03 08:23:47 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_appl_arp%ROWTYPE;

Line 5: old_references igs_ad_appl_arp%ROWTYPE;

1: PACKAGE BODY igs_ad_appl_arp_pkg AS
2: /* $Header: IGSAIF7B.pls 120.4 2005/10/03 08:23:47 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_appl_arp%ROWTYPE;
6: new_references igs_ad_appl_arp%ROWTYPE;
7:
8:
9: PROCEDURE set_column_values (

Line 6: new_references igs_ad_appl_arp%ROWTYPE;

2: /* $Header: IGSAIF7B.pls 120.4 2005/10/03 08:23:47 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_appl_arp%ROWTYPE;
6: new_references igs_ad_appl_arp%ROWTYPE;
7:
8:
9: PROCEDURE set_column_values (
10: p_action IN VARCHAR2,

Line 37: FROM igs_ad_appl_arp

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

Line 168: FROM igs_ad_appl_arp

164: || (reverse chronological order - newest change first)
165: */
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM igs_ad_appl_arp
169: WHERE appl_arp_id = x_appl_arp_id
170: FOR UPDATE NOWAIT;
171:
172: lv_rowid cur_rowid%RowType;

Line 204: FROM igs_ad_appl_arp

200: || (reverse chronological order - newest change first)
201: */
202: CURSOR cur_rowid IS
203: SELECT rowid
204: FROM igs_ad_appl_arp
205: WHERE ((appl_revprof_revgr_id = x_appl_revprof_revgr_id));
206:
207: lv_rowid cur_rowid%RowType;
208:

Line 239: FROM igs_ad_appl_arp

235: || (reverse chronological order - newest change first)
236: */
237: CURSOR cur_rowid IS
238: SELECT rowid
239: FROM igs_ad_appl_arp
240: WHERE ((appl_rev_profile_id = x_appl_rev_profile_id));
241:
242: lv_rowid cur_rowid%RowType;
243:

Line 279: FROM igs_ad_appl_arp

275: || (reverse chronological order - newest change first)
276: */
277: CURSOR cur_rowid IS
278: SELECT rowid
279: FROM igs_ad_appl_arp
280: WHERE ((person_id = x_person_id) AND
281: (sequence_number = x_sequence_number) AND
282: (admission_appl_number = x_admission_appl_number) AND
283: (nominated_course_cd = x_nominated_course_cd));

Line 481: FROM igs_ad_appl_arp

477: || (reverse chronological order - newest change first)
478: */
479: CURSOR c IS
480: SELECT rowid
481: FROM igs_ad_appl_arp
482: WHERE appl_arp_id = x_appl_arp_id;
483:
484: x_last_update_date DATE;
485: x_last_updated_by NUMBER;

Line 546: INSERT INTO igs_ad_appl_arp (

542:
543: IF (x_mode = 'S') THEN
544: igs_sc_gen_001.set_ctx('R');
545: END IF;
546: INSERT INTO igs_ad_appl_arp (
547: appl_arp_id,
548: person_id,
549: admission_appl_number,
550: nominated_course_cd,

Line 564: igs_ad_appl_arp_s.NEXTVAL,

560: program_id,
561: program_application_id,
562: program_update_date
563: ) VALUES (
564: igs_ad_appl_arp_s.NEXTVAL,
565: new_references.person_id,
566: new_references.admission_appl_number,
567: new_references.nominated_course_cd,
568: new_references.sequence_number,

Line 639: FROM igs_ad_appl_arp

635: nominated_course_cd,
636: sequence_number,
637: appl_rev_profile_id,
638: appl_revprof_revgr_id
639: FROM igs_ad_appl_arp
640: WHERE rowid = x_rowid
641: FOR UPDATE NOWAIT;
642:
643: tlinfo c1%ROWTYPE;

Line 762: UPDATE igs_ad_appl_arp

758:
759: IF (x_mode = 'S') THEN
760: igs_sc_gen_001.set_ctx('R');
761: END IF;
762: UPDATE igs_ad_appl_arp
763: SET
764: person_id = new_references.person_id,
765: admission_appl_number = new_references.admission_appl_number,
766: nominated_course_cd = new_references.nominated_course_cd,

Line 834: FROM igs_ad_appl_arp

830: || (reverse chronological order - newest change first)
831: */
832: CURSOR c1 IS
833: SELECT rowid
834: FROM igs_ad_appl_arp
835: WHERE appl_arp_id = x_appl_arp_id;
836:
837: BEGIN
838:

Line 898: DELETE FROM igs_ad_appl_arp

894:
895: IF (x_mode = 'S') THEN
896: igs_sc_gen_001.set_ctx('R');
897: END IF;
898: DELETE FROM igs_ad_appl_arp
899: WHERE rowid = x_rowid;
900:
901: IF (SQL%NOTFOUND) THEN
902: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 922: END igs_ad_appl_arp_pkg;

918:
919: END delete_row;
920:
921:
922: END igs_ad_appl_arp_pkg;