APPS.IGS_AZ_ADVISORS_PKG dependencies on IGS_AZ_ADVISORS

Line 1: PACKAGE BODY igs_az_advisors_pkg AS

1: PACKAGE BODY igs_az_advisors_pkg AS
2: /* $Header: IGSHI03B.pls 115.4 2003/06/30 05:38:13 kdande noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_az_advisors%ROWTYPE;

Line 5: old_references igs_az_advisors%ROWTYPE;

1: PACKAGE BODY igs_az_advisors_pkg AS
2: /* $Header: IGSHI03B.pls 115.4 2003/06/30 05:38:13 kdande noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_az_advisors%ROWTYPE;
6: new_references igs_az_advisors%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_az_advisors%ROWTYPE;

2: /* $Header: IGSHI03B.pls 115.4 2003/06/30 05:38:13 kdande noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_az_advisors%ROWTYPE;
6: new_references igs_az_advisors%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 38: FROM igs_az_advisors

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

Line 147: igs_az_advising_rels_pkg.get_fk_igs_az_advisors (

143: || (reverse chronological order - newest change first)
144: */
145: BEGIN
146:
147: igs_az_advising_rels_pkg.get_fk_igs_az_advisors (
148: old_references.group_advisor_id
149: );
150:
151: END check_child_existance;

Line 168: FROM igs_az_advisors

164: || (reverse chronological order - newest change first)
165: */
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM igs_az_advisors
169: WHERE group_advisor_id = x_group_advisor_id;
170:
171: lv_rowid cur_rowid%RowType;
172:

Line 203: FROM igs_az_advisors

199: || (reverse chronological order - newest change first)
200: */
201: CURSOR cur_rowid IS
202: SELECT rowid
203: FROM igs_az_advisors
204: WHERE advisor_person_id = x_advisor_person_id
205: AND group_name = x_group_name
206: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
207:

Line 239: FROM igs_az_advisors

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

Line 396: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISORS_PKG.INSERT_ROW');

392: x_last_update_login := -1;
393: END IF;
394: ELSE
395: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
396: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISORS_PKG.INSERT_ROW');
397: igs_ge_msg_stack.add;
398: app_exception.raise_exception;
399: END IF;
400:

Line 422: INSERT INTO igs_az_advisors (

418: x_last_updated_by => x_last_updated_by,
419: x_last_update_login => x_last_update_login
420: );
421:
422: INSERT INTO igs_az_advisors (
423: group_advisor_id,
424: group_name,
425: advisor_person_id,
426: start_date,

Line 438: igs_az_advisors_s.NEXTVAL,

434: last_update_date,
435: last_updated_by,
436: last_update_login
437: ) VALUES (
438: igs_az_advisors_s.NEXTVAL,
439: new_references.group_name,
440: new_references.advisor_person_id,
441: new_references.start_date,
442: new_references.end_date,

Line 524: FROM igs_az_advisors

520: max_students_num,
521: notified_date,
522: accept_add_flag,
523: accept_delete_flag
524: FROM igs_az_advisors
525: WHERE rowid = x_rowid
526: FOR UPDATE NOWAIT;
527:
528: tlinfo c1%ROWTYPE;

Line 646: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISORS_PKG.UPDATE_ROW');

642: x_last_update_login := -1;
643: END IF;
644: ELSE
645: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
646: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISORS_PKG.UPDATE_ROW');
647: igs_ge_msg_stack.add;
648: app_exception.raise_exception;
649: END IF;
650:

Line 684: UPDATE igs_az_advisors

680: new_references.accept_delete_flag := NULL;
681: END IF;
682: END IF;
683:
684: UPDATE igs_az_advisors
685: SET
686: group_name = new_references.group_name,
687: advisor_person_id = new_references.advisor_person_id,
688: start_date = new_references.start_date,

Line 762: FROM igs_az_advisors

758: || (reverse chronological order - newest change first)
759: */
760: CURSOR c1 IS
761: SELECT rowid
762: FROM igs_az_advisors
763: WHERE group_advisor_id = x_group_advisor_id;
764:
765: l_return_status VARCHAR2(10);
766: l_msg_data VARCHAR2(2000);

Line 839: DELETE FROM igs_az_advisors

835: p_action => 'DELETE',
836: x_rowid => x_rowid
837: );
838:
839: DELETE FROM igs_az_advisors
840: WHERE rowid = x_rowid;
841:
842: IF (SQL%NOTFOUND) THEN
843: RAISE NO_DATA_FOUND;

Line 881: END igs_az_advisors_pkg;

877: RETURN;
878:
879: END delete_row;
880:
881: END igs_az_advisors_pkg;