APPS.IGS_AD_SCHL_APLY_TO_PKG dependencies on IGS_AD_SCHL_APLY_TO

Line 1: PACKAGE BODY igs_ad_schl_aply_to_pkg AS

1: PACKAGE BODY igs_ad_schl_aply_to_pkg AS
2: /* $Header: IGSAIE4B.pls 115.9 2003/10/30 13:17:35 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_schl_aply_to%ROWTYPE;

Line 5: old_references igs_ad_schl_aply_to%ROWTYPE;

1: PACKAGE BODY igs_ad_schl_aply_to_pkg AS
2: /* $Header: IGSAIE4B.pls 115.9 2003/10/30 13:17:35 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_schl_aply_to%ROWTYPE;
6: new_references igs_ad_schl_aply_to%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_schl_aply_to%ROWTYPE;

2: /* $Header: IGSAIE4B.pls 115.9 2003/10/30 13:17:35 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_schl_aply_to%ROWTYPE;
6: new_references igs_ad_schl_aply_to%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_AD_SCHL_APLY_TO

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

Line 142: FROM igs_ad_schl_aply_to

138: || (reverse chronological order - newest change first)
139: */
140: CURSOR cur_rowid IS
141: SELECT rowid
142: FROM igs_ad_schl_aply_to
143: WHERE sch_apl_to_id = x_sch_apl_to_id AND
144: closed_ind = NVL(x_closed_ind,closed_ind)
145: FOR UPDATE NOWAIT;
146:

Line 174: igs_ad_ps_appl_inst_pkg.GET_FK_IGS_AD_SCHL_APLY_TO (

170: Who When What
171: (reverse chronological order - newest change first)
172: ***************************************************************/
173: BEGIN
174: igs_ad_ps_appl_inst_pkg.GET_FK_IGS_AD_SCHL_APLY_TO (
175: old_references.sch_apl_to_id
176: );
177: END Check_Child_Existance;
178:

Line 195: FROM igs_ad_schl_aply_to

191: || (reverse chronological order - newest change first)
192: */
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM igs_ad_schl_aply_to
196: WHERE school_applying_to = x_school_applying_to
197: AND org_unit_cd = x_org_unit_cd
198: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
199: AND closed_ind = NVL(x_closed_ind,closed_ind);

Line 232: FROM igs_ad_schl_aply_to

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

Line 355: FROM igs_ad_schl_aply_to

351: || (reverse chronological order - newest change first)
352: */
353: CURSOR c IS
354: SELECT rowid
355: FROM igs_ad_schl_aply_to
356: WHERE sch_apl_to_id = x_sch_apl_to_id;
357:
358: x_last_update_date DATE;
359: x_last_updated_by NUMBER;

Line 399: INSERT INTO igs_ad_schl_aply_to (

395: x_last_updated_by => x_last_updated_by,
396: x_last_update_login => x_last_update_login
397: );
398:
399: INSERT INTO igs_ad_schl_aply_to (
400: sch_apl_to_id,
401: school_applying_to,
402: description,
403: org_unit_cd,

Line 411: igs_ad_schl_aply_to_s.NEXTVAL,

407: last_update_date,
408: last_updated_by,
409: last_update_login
410: ) VALUES (
411: igs_ad_schl_aply_to_s.NEXTVAL,
412: new_references.school_applying_to,
413: new_references.description,
414: new_references.org_unit_cd,
415: new_references.closed_ind,

Line 457: FROM igs_ad_schl_aply_to

453: school_applying_to,
454: description,
455: org_unit_cd,
456: closed_ind
457: FROM igs_ad_schl_aply_to
458: WHERE rowid = x_rowid
459: FOR UPDATE NOWAIT;
460:
461: tlinfo c1%ROWTYPE;

Line 552: UPDATE igs_ad_schl_aply_to

548: x_last_updated_by => x_last_updated_by,
549: x_last_update_login => x_last_update_login
550: );
551:
552: UPDATE igs_ad_schl_aply_to
553: SET
554: school_applying_to = new_references.school_applying_to,
555: description = new_references.description,
556: org_unit_cd = new_references.org_unit_cd,

Line 590: FROM igs_ad_schl_aply_to

586: || (reverse chronological order - newest change first)
587: */
588: CURSOR c1 IS
589: SELECT rowid
590: FROM igs_ad_schl_aply_to
591: WHERE sch_apl_to_id = x_sch_apl_to_id;
592:
593: BEGIN
594:

Line 645: DELETE FROM igs_ad_schl_aply_to

641: p_action => 'DELETE',
642: x_rowid => x_rowid
643: );
644:
645: DELETE FROM igs_ad_schl_aply_to
646: WHERE rowid = x_rowid;
647:
648: IF (SQL%NOTFOUND) THEN
649: RAISE NO_DATA_FOUND;

Line 655: END igs_ad_schl_aply_to_pkg;

651:
652: END delete_row;
653:
654:
655: END igs_ad_schl_aply_to_pkg;