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.

APPS.IGS_AD_APPL_EVAL_PKG dependencies on IGS_AD_APPL_EVAL

Line 1: PACKAGE BODY igs_ad_appl_eval_pkg AS

1: PACKAGE BODY igs_ad_appl_eval_pkg AS
2: /* $Header: IGSAIA4B.pls 120.4 2006/07/31 13:28:15 rbezawad ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_appl_eval%RowType;
5: new_references igs_ad_appl_eval%RowType;

Line 4: old_references igs_ad_appl_eval%RowType;

1: PACKAGE BODY igs_ad_appl_eval_pkg AS
2: /* $Header: IGSAIA4B.pls 120.4 2006/07/31 13:28:15 rbezawad ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_appl_eval%RowType;
5: new_references igs_ad_appl_eval%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_appl_eval%RowType;

1: PACKAGE BODY igs_ad_appl_eval_pkg AS
2: /* $Header: IGSAIA4B.pls 120.4 2006/07/31 13:28:15 rbezawad ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_appl_eval%RowType;
5: new_references igs_ad_appl_eval%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 45: FROM IGS_AD_APPL_EVAL

41: ***************************************************************/
42:
43: CURSOR cur_old_ref_values IS
44: SELECT *
45: FROM IGS_AD_APPL_EVAL
46: WHERE rowid = x_rowid;
47:
48: BEGIN
49:

Line 220: FROM igs_ad_appl_eval

216: ***************************************************************/
217:
218: CURSOR cur_rowid IS
219: SELECT rowid
220: FROM igs_ad_appl_eval
221: WHERE appl_eval_id = x_appl_eval_id AND
222: NVL(closed_ind,'N') = DECODE(closed_ind,NULL,'N',NVL(x_closed_ind,closed_ind))
223: FOR UPDATE NOWAIT;
224:

Line 257: FROM igs_ad_appl_eval

253: ***************************************************************/
254:
255: CURSOR cur_rowid IS
256: SELECT rowid
257: FROM igs_ad_appl_eval
258: WHERE rating_values_id = x_rating_values_id ;
259:
260: lv_rowid cur_rowid%RowType;
261:

Line 294: FROM igs_ad_appl_eval

290: ***************************************************************/
291:
292: CURSOR cur_rowid IS
293: SELECT rowid
294: FROM igs_ad_appl_eval
295: WHERE rating_type_id = x_code_id ;
296:
297: lv_rowid cur_rowid%RowType;
298:

Line 334: FROM igs_ad_appl_eval

330: ***************************************************************/
331:
332: CURSOR cur_rowid IS
333: SELECT rowid
334: FROM igs_ad_appl_eval
335: WHERE person_id = x_person_id
336: AND admission_appl_number = x_admission_appl_number
337: AND nominated_course_cd = x_nominated_course_cd
338: AND sequence_number = x_sequence_number ;

Line 374: FROM igs_ad_appl_eval

370: ***************************************************************/
371:
372: CURSOR cur_rowid IS
373: SELECT rowid
374: FROM igs_ad_appl_eval
375: WHERE evaluator_id = x_person_id ;
376:
377: lv_rowid cur_rowid%RowType;
378:

Line 411: FROM igs_ad_appl_eval

407: ***************************************************************/
408:
409: CURSOR cur_rowid IS
410: SELECT rowid
411: FROM igs_ad_appl_eval
412: WHERE rating_scale_id = x_rating_scale_id ;
413:
414: lv_rowid cur_rowid%RowType;
415:

Line 662: from igs_ad_appl_eval

658: /* Given an evaluation sequence this function is used to find out the next evaluator person id */
659:
660: cursor c_next_eval IS
661: select evaluation_sequence
662: from igs_ad_appl_eval
663: where person_id = x_person_id
664: and admission_appl_number = x_admission_appl_number
665: and nominated_course_cd = x_nominated_course_cd
666: and sequence_number = x_sequence_number

Line 673: From IGS_AD_APPL_EVAL

669:
670: cursor c_next_person_id(cp_eval_seq number) is
671: Select
672: distinct EVALUATOR_ID
673: From IGS_AD_APPL_EVAL
674: Where EVALUATION_SEQUENCE = cp_eval_seq
675: and person_id = x_person_id
676: and admission_appl_number = x_admission_appl_number
677: and nominated_course_cd = x_nominated_course_cd

Line 726: FROM IGS_AD_APPL_EVAL

722: AND a.appl_rev_profile_id = r.appl_rev_profile_id;
723:
724: Cursor c_eval_num IS
725: SELECT 'X' --bug 3709285 arvsrini
726: FROM IGS_AD_APPL_EVAL
727: WHERE EVALUATION_SEQUENCE = x_eval_seq
728: AND rating_type_ID is NOT NULL
729: AND rating_scale_id IS NOT NULL
730: AND EVALUATION_DATE IS NULL

Line 739: FROM IGS_AD_APPL_EVAL

735: AND SEQUENCE_NUMBER = x_sequence_number;
736:
737:
738: /* SELECT count(rowid)
739: FROM IGS_AD_APPL_EVAL
740: WHERE EVALUATION_SEQUENCE = x_eval_seq
741: AND rating_type_ID is NOT NULL
742: AND rating_scale_id IS NOT NULL
743: AND EVALUATION_DATE IS NOT NULL

Line 789: From IGS_AD_APPL_EVAL

785:
786: /* Select
787: distinct person_id
788: Into l_person_id
789: From IGS_AD_APPL_EVAL
790: Where EVALUATION_SEQUENCE = x_eval_seq + 1; */
791:
792: Wf_Directory.GetRoleName('HZ_PARTY', l_person_id, l_person_name, l_full_name);
793:

Line 863: cursor C is select ROWID from IGS_AD_APPL_EVAL

859:
860: (reverse chronological order - newest change first)
861: ***************************************************************/
862:
863: cursor C is select ROWID from IGS_AD_APPL_EVAL
864: where APPL_EVAL_ID= X_APPL_EVAL_ID
865: ;
866: X_LAST_UPDATE_DATE DATE ;
867: X_LAST_UPDATED_BY NUMBER ;

Line 931: INSERT INTO igs_ad_appl_eval (

927: x_closed_ind => X_CLOSED_IND);
928: IF (x_mode = 'S') THEN
929: igs_sc_gen_001.set_ctx('R');
930: END IF;
931: INSERT INTO igs_ad_appl_eval (
932: appl_eval_id
933: ,person_id
934: ,admission_appl_number
935: ,nominated_course_cd

Line 957: igs_ad_appl_eval_s.NEXTVAL

953: ,evaluation_sequence
954: ,rating_scale_id
955: ,closed_ind
956: ) VALUES (
957: igs_ad_appl_eval_s.NEXTVAL
958: ,new_references.person_id
959: ,new_references.admission_appl_number
960: ,new_references.nominated_course_cd
961: ,new_references.sequence_number

Line 1059: FROM igs_ad_appl_eval

1055: rating_notes,
1056: evaluation_sequence,
1057: rating_scale_id,
1058: closed_ind
1059: FROM igs_ad_appl_eval
1060: WHERE rowid = x_rowid
1061: FOR UPDATE NOWAIT;
1062:
1063: tlinfo c1%ROWTYPE;

Line 1203: UPDATE igs_ad_appl_eval SET

1199:
1200: IF (x_mode = 'S') THEN
1201: igs_sc_gen_001.set_ctx('R');
1202: END IF;
1203: UPDATE igs_ad_appl_eval SET
1204: person_id = new_references.person_id,
1205: admission_appl_number = new_references.admission_appl_number,
1206: nominated_course_cd = new_references.nominated_course_cd,
1207: sequence_number = new_references.sequence_number,

Line 1309: SELECT rowid FROM igs_ad_appl_eval

1305: (reverse chronological order - newest change first)
1306: ***************************************************************/
1307:
1308: CURSOR c1 IS
1309: SELECT rowid FROM igs_ad_appl_eval
1310: WHERE appl_eval_id= x_appl_eval_id;
1311:
1312: BEGIN
1313: OPEN c1;

Line 1369: from igs_ad_appl_eval

1365:
1366: /* Given an evaluation sequence this function is used to find out the previous evaluation sequence number */
1367: cursor c_prev_eval IS
1368: select evaluation_sequence
1369: from igs_ad_appl_eval
1370: where person_id = x_person_id
1371: and admission_appl_number = x_admission_appl_number
1372: and nominated_course_cd = x_nominated_course_cd
1373: and sequence_number = x_sequence_number

Line 1406: FROM IGS_AD_APPL_EVAL

1402: /* Cursor to find out if there are still some records for the evaluation sequence that is getting deleted */
1403:
1404: cursor c_seq_exists IS
1405: SELECT evaluation_sequence
1406: FROM IGS_AD_APPL_EVAL
1407: WHERE person_id = x_person_id
1408: AND admission_appl_number = x_admission_appl_number
1409: AND nominated_course_cd = x_nominated_course_cd
1410: AND sequence_number = x_sequence_number

Line 1417: FROM IGS_AD_APPL_EVAL

1413: /* Cursor to find out if the previous evaluation sequence has been completed or not */
1414:
1415: cursor c_prev_seq_compl (cp_prev_seq_number IN NUMBER) IS
1416: SELECT evaluation_sequence
1417: FROM IGS_AD_APPL_EVAL
1418: WHERE person_id = x_person_id
1419: AND admission_appl_number = x_admission_appl_number
1420: AND nominated_course_cd = x_nominated_course_cd
1421: AND sequence_number = x_sequence_number

Line 1500: FROM igs_ad_appl_eval

1496: nominated_course_cd,
1497: sequence_number,
1498: evaluator_id,
1499: evaluation_sequence
1500: FROM igs_ad_appl_eval
1501: WHERE rowid = x_rowid;
1502:
1503: l_del_appl_eval c_del_appl_eval%ROWTYPE;
1504: --

Line 1519: DELETE FROM igs_ad_appl_eval

1515:
1516: IF (x_mode = 'S') THEN
1517: igs_sc_gen_001.set_ctx('R');
1518: END IF;
1519: DELETE FROM igs_ad_appl_eval
1520: WHERE rowid = x_rowid;
1521: IF (sql%NOTFOUND) THEN
1522: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1523: igs_ge_msg_stack.add;

Line 1566: END igs_ad_appl_eval_pkg;

1562: RAISE;
1563: END IF;
1564: END delete_row;
1565:
1566: END igs_ad_appl_eval_pkg;