APPS.IGS_AD_RVGR_EVALTR_PKG dependencies on IGS_AD_RVGR_EVALTR

Line 1: PACKAGE BODY igs_ad_rvgr_evaltr_pkg AS

1: PACKAGE BODY igs_ad_rvgr_evaltr_pkg AS
2: /* $Header: IGSAIF6B.pls 115.10 2003/03/25 13:38:59 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_rvgr_evaltr%ROWTYPE;

Line 5: old_references igs_ad_rvgr_evaltr%ROWTYPE;

1: PACKAGE BODY igs_ad_rvgr_evaltr_pkg AS
2: /* $Header: IGSAIF6B.pls 115.10 2003/03/25 13:38:59 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_rvgr_evaltr%ROWTYPE;
6: new_references igs_ad_rvgr_evaltr%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_rvgr_evaltr%ROWTYPE;

2: /* $Header: IGSAIF6B.pls 115.10 2003/03/25 13:38:59 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_rvgr_evaltr%ROWTYPE;
6: new_references igs_ad_rvgr_evaltr%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM igs_ad_rvgr_evaltr

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

Line 152: FROM igs_ad_rvgr_evaltr

148: || (reverse chronological order - newest change first)
149: */
150: CURSOR cur_rowid IS
151: SELECT rowid
152: FROM igs_ad_rvgr_evaltr
153: WHERE revgr_evaluator_id = x_revgr_evaluator_id
154: FOR UPDATE NOWAIT;
155:
156: lv_rowid cur_rowid%RowType;

Line 188: FROM igs_ad_rvgr_evaltr

184: || (reverse chronological order - newest change first)
185: */
186: CURSOR cur_rowid IS
187: SELECT rowid
188: FROM igs_ad_rvgr_evaltr
189: WHERE appl_revprof_revgr_id = x_appl_revprof_revgr_id
190: AND person_id = x_person_id
191: AND (l_rowid IS NULL OR rowid <> l_rowid)
192: FOR UPDATE NOWAIT;

Line 225: FROM igs_ad_rvgr_evaltr

221: || (reverse chronological order - newest change first)
222: */
223: CURSOR cur_rowid IS
224: SELECT rowid
225: FROM igs_ad_rvgr_evaltr
226: WHERE ((appl_revprof_revgr_id = x_appl_revprof_revgr_id));
227:
228: lv_rowid cur_rowid%RowType;
229:

Line 258: FROM igs_ad_rvgr_evaltr

254: || (reverse chronological order - newest change first)
255: */
256: CURSOR cur_rowid IS
257: SELECT rowid
258: FROM igs_ad_rvgr_evaltr
259: WHERE (person_id = x_person_id) ;
260:
261: lv_rowid cur_rowid%RowType;
262:

Line 381: FROM igs_ad_rvgr_evaltr

377: || (reverse chronological order - newest change first)
378: */
379: CURSOR c IS
380: SELECT rowid
381: FROM igs_ad_rvgr_evaltr
382: WHERE revgr_evaluator_id = x_revgr_evaluator_id;
383:
384: x_last_update_date DATE;
385: x_last_updated_by NUMBER;

Line 426: INSERT INTO igs_ad_rvgr_evaltr (

422: x_last_updated_by => x_last_updated_by,
423: x_last_update_login => x_last_update_login
424: );
425:
426: INSERT INTO igs_ad_rvgr_evaltr (
427: revgr_evaluator_id,
428: appl_revprof_revgr_id,
429: person_id,
430: person_number,

Line 439: igs_ad_rvgr_evaltr_s.NEXTVAL,

435: last_update_date,
436: last_updated_by,
437: last_update_login
438: ) VALUES (
439: igs_ad_rvgr_evaltr_s.NEXTVAL,
440: new_references.appl_revprof_revgr_id,
441: new_references.person_id,
442: new_references.person_number,
443: new_references.evaluation_sequence,

Line 488: FROM igs_ad_rvgr_evaltr

484: person_id,
485: person_number,
486: evaluation_sequence,
487: program_approver_ind
488: FROM igs_ad_rvgr_evaltr
489: WHERE rowid = x_rowid
490: FOR UPDATE NOWAIT;
491:
492: tlinfo c1%ROWTYPE;

Line 586: UPDATE igs_ad_rvgr_evaltr

582: x_last_updated_by => x_last_updated_by,
583: x_last_update_login => x_last_update_login
584: );
585:
586: UPDATE igs_ad_rvgr_evaltr
587: SET
588: appl_revprof_revgr_id = new_references.appl_revprof_revgr_id,
589: person_id = new_references.person_id,
590: person_number = new_references.person_number,

Line 626: FROM igs_ad_rvgr_evaltr

622: || (reverse chronological order - newest change first)
623: */
624: CURSOR c1 IS
625: SELECT rowid
626: FROM igs_ad_rvgr_evaltr
627: WHERE revgr_evaluator_id = x_revgr_evaluator_id;
628:
629: BEGIN
630:

Line 683: DELETE FROM igs_ad_rvgr_evaltr

679: p_action => 'DELETE',
680: x_rowid => x_rowid
681: );
682:
683: DELETE FROM igs_ad_rvgr_evaltr
684: WHERE rowid = x_rowid;
685:
686: IF (SQL%NOTFOUND) THEN
687: RAISE NO_DATA_FOUND;

Line 693: END igs_ad_rvgr_evaltr_pkg;

689:
690: END delete_row;
691:
692:
693: END igs_ad_rvgr_evaltr_pkg;