APPS.IGS_UC_APP_REFEREES_PKG dependencies on IGS_UC_APP_REFEREES

Line 1: PACKAGE BODY igs_uc_app_referees_pkg AS

1: PACKAGE BODY igs_uc_app_referees_pkg AS
2: /* $Header: IGSXI52B.pls 120.1 2005/07/31 17:57:12 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_referees%ROWTYPE;

Line 5: old_references igs_uc_app_referees%ROWTYPE;

1: PACKAGE BODY igs_uc_app_referees_pkg AS
2: /* $Header: IGSXI52B.pls 120.1 2005/07/31 17:57:12 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_referees%ROWTYPE;
6: new_references igs_uc_app_referees%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_app_referees%ROWTYPE;

2: /* $Header: IGSXI52B.pls 120.1 2005/07/31 17:57:12 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_referees%ROWTYPE;
6: new_references igs_uc_app_referees%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 42: FROM igs_uc_app_referees

38: */
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM igs_uc_app_referees
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 158: FROM igs_uc_app_referees

154: || (reverse chronological order - newest change first)
155: */
156: CURSOR cur_rowid IS
157: SELECT rowid
158: FROM igs_uc_app_referees
159: WHERE app_no = x_app_no
160: AND referee_name = x_referee_name
161: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
162:

Line 194: FROM igs_uc_app_referees

190: || (reverse chronological order - newest change first)
191: */
192: CURSOR cur_rowid IS
193: SELECT rowid
194: FROM igs_uc_app_referees
195: WHERE ((app_no = x_app_no));
196:
197: lv_rowid cur_rowid%RowType;
198:

Line 338: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_REFEREES_PKG.INSERT_ROW');

334: x_last_update_login := -1;
335: END IF;
336: ELSE
337: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
338: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_REFEREES_PKG.INSERT_ROW');
339: igs_ge_msg_stack.add;
340: app_exception.raise_exception;
341: END IF;
342:

Line 366: INSERT INTO igs_uc_app_referees (

362: x_last_updated_by => x_last_updated_by,
363: x_last_update_login => x_last_update_login
364: );
365:
366: INSERT INTO igs_uc_app_referees (
367: app_no,
368: referee_name,
369: referee_post,
370: estab_name,

Line 449: FROM igs_uc_app_referees

445: fax,
446: email,
447: statement,
448: predicted_grades
449: FROM igs_uc_app_referees
450: WHERE rowid = x_rowid
451: FOR UPDATE NOWAIT;
452:
453: tlinfo c1%ROWTYPE;

Line 542: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_REFEREES_PKG.UPDATE_ROW');

538: x_last_update_login := -1;
539: END IF;
540: ELSE
541: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
542: fnd_message.set_token ('ROUTINE', 'IGS_UC_APP_REFEREES_PKG.UPDATE_ROW');
543: igs_ge_msg_stack.add;
544: app_exception.raise_exception;
545: END IF;
546:

Line 570: UPDATE igs_uc_app_referees

566: x_last_updated_by => x_last_updated_by,
567: x_last_update_login => x_last_update_login
568: );
569:
570: UPDATE igs_uc_app_referees
571: SET
572: app_no = new_references.app_no,
573: referee_name = new_references.referee_name,
574: referee_post = new_references.referee_post,

Line 625: FROM igs_uc_app_referees

621: || (reverse chronological order - newest change first)
622: */
623: CURSOR c1 IS
624: SELECT rowid
625: FROM igs_uc_app_referees
626: WHERE app_no = x_app_no;
627:
628: BEGIN
629:

Line 696: DELETE FROM igs_uc_app_referees

692: p_action => 'DELETE',
693: x_rowid => x_rowid
694: );
695:
696: DELETE FROM igs_uc_app_referees
697: WHERE rowid = x_rowid;
698:
699: IF (SQL%NOTFOUND) THEN
700: RAISE NO_DATA_FOUND;

Line 706: END igs_uc_app_referees_pkg;

702:
703: END delete_row;
704:
705:
706: END igs_uc_app_referees_pkg;
707: