eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_AZ_ADVISING_RELS_PKG dependencies on IGS_AZ_ADVISING_RELS

Line 1: PACKAGE BODY IGS_AZ_ADVISING_RELS_PKG AS

1: PACKAGE BODY IGS_AZ_ADVISING_RELS_PKG AS
2: /* $Header: IGSHI04B.pls 115.2 2003/06/16 09:56:50 anilk noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AZ_ADVISING_RELS%ROWTYPE;

Line 5: old_references IGS_AZ_ADVISING_RELS%ROWTYPE;

1: PACKAGE BODY IGS_AZ_ADVISING_RELS_PKG AS
2: /* $Header: IGSHI04B.pls 115.2 2003/06/16 09:56:50 anilk noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AZ_ADVISING_RELS%ROWTYPE;
6: new_references IGS_AZ_ADVISING_RELS%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AZ_ADVISING_RELS%ROWTYPE;

2: /* $Header: IGSHI04B.pls 115.2 2003/06/16 09:56:50 anilk noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AZ_ADVISING_RELS%ROWTYPE;
6: new_references IGS_AZ_ADVISING_RELS%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM IGS_AZ_ADVISING_RELS

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

Line 166: FROM IGS_AZ_ADVISING_RELS

162: || (reverse chronological order - newest change first)
163: */
164: CURSOR cur_rowid IS
165: SELECT rowid
166: FROM IGS_AZ_ADVISING_RELS
167: WHERE group_advising_rel_id = x_group_advising_rel_id
168: FOR UPDATE NOWAIT;
169:
170: lv_rowid cur_rowid%RowType;

Line 203: FROM IGS_AZ_ADVISING_RELS

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

Line 240: FROM IGS_AZ_ADVISING_RELS

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

Line 275: FROM IGS_AZ_ADVISING_RELS

271: || (reverse chronological order - newest change first)
272: */
273: CURSOR cur_rowid IS
274: SELECT rowid
275: FROM IGS_AZ_ADVISING_RELS
276: WHERE ((group_student_id = x_group_student_id));
277:
278: lv_rowid cur_rowid%RowType;
279:

Line 310: FROM IGS_AZ_ADVISING_RELS

306: || (reverse chronological order - newest change first)
307: */
308: CURSOR cur_rowid IS
309: SELECT rowid
310: FROM IGS_AZ_ADVISING_RELS
311: WHERE ((group_advisor_id = x_group_advisor_id));
312:
313: lv_rowid cur_rowid%RowType;
314:

Line 452: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISING_RELS_PKG.INSERT_ROW');

448: x_last_update_login := -1;
449: END IF;
450: ELSE
451: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
452: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISING_RELS_PKG.INSERT_ROW');
453: igs_ge_msg_stack.add;
454: app_exception.raise_exception;
455: END IF;
456:

Line 475: INSERT INTO IGS_AZ_ADVISING_RELS (

471: x_last_updated_by => x_last_updated_by,
472: x_last_update_login => x_last_update_login
473: );
474:
475: INSERT INTO IGS_AZ_ADVISING_RELS (
476: group_advising_rel_id,
477: group_name,
478: group_advisor_id,
479: group_student_id,

Line 488: IGS_AZ_ADVISING_RELS_s.NEXTVAL,

484: last_update_date,
485: last_updated_by,
486: last_update_login
487: ) VALUES (
488: IGS_AZ_ADVISING_RELS_s.NEXTVAL,
489: new_references.group_name,
490: new_references.group_advisor_id,
491: new_references.group_student_id,
492: TRUNC(new_references.START_DATE),

Line 563: FROM IGS_AZ_ADVISING_RELS

559: group_advisor_id,
560: group_student_id,
561: START_DATE,
562: END_DATE
563: FROM IGS_AZ_ADVISING_RELS
564: WHERE rowid = x_rowid
565: FOR UPDATE NOWAIT;
566:
567: tlinfo c1%ROWTYPE;

Line 677: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISING_RELS_PKG.UPDATE_ROW');

673: x_last_update_login := -1;
674: END IF;
675: ELSE
676: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
677: fnd_message.set_token ('ROUTINE', 'IGS_AZ_ADVISING_RELS_PKG.UPDATE_ROW');
678: igs_ge_msg_stack.add;
679: app_exception.raise_exception;
680: END IF;
681:

Line 710: UPDATE IGS_AZ_ADVISING_RELS

706: --IF new_references.START_DATE IS NULL THEN
707: -- DELETE_ROW(x_rowid, X_RETURN_STATUS, X_MSG_DATA, X_MSG_COUNT);
708: --ELSE
709:
710: UPDATE IGS_AZ_ADVISING_RELS
711: SET
712: group_name = new_references.group_name,
713: group_advisor_id = new_references.group_advisor_id,
714: group_student_id = new_references.group_student_id,

Line 787: FROM IGS_AZ_ADVISING_RELS

783: L_MSG_COUNT NUMBER(10);
784:
785: CURSOR c1 IS
786: SELECT rowid
787: FROM IGS_AZ_ADVISING_RELS
788: WHERE group_advising_rel_id = x_group_advising_rel_id;
789:
790: BEGIN
791:

Line 854: DELETE FROM IGS_AZ_ADVISING_RELS

850: p_action => 'DELETE',
851: x_rowid => x_rowid
852: );
853:
854: DELETE FROM IGS_AZ_ADVISING_RELS
855: WHERE rowid = x_rowid;
856:
857: IF (SQL%NOTFOUND) THEN
858: RAISE NO_DATA_FOUND;

Line 896: END IGS_AZ_ADVISING_RELS_pkg;

892: RETURN;
893: END delete_row;
894:
895:
896: END IGS_AZ_ADVISING_RELS_pkg;