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_UC_QUAL_DETS_PKG dependencies on IGS_UC_QUAL_DETS

Line 1: PACKAGE BODY igs_uc_qual_dets_pkg AS

1: PACKAGE BODY igs_uc_qual_dets_pkg AS
2: /* $Header: IGSXI37B.pls 120.3 2005/10/17 02:23:43 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_qual_dets%ROWTYPE;

Line 5: old_references igs_uc_qual_dets%ROWTYPE;

1: PACKAGE BODY igs_uc_qual_dets_pkg AS
2: /* $Header: IGSXI37B.pls 120.3 2005/10/17 02:23:43 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_qual_dets%ROWTYPE;
6: new_references igs_uc_qual_dets%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_qual_dets%ROWTYPE;

2: /* $Header: IGSXI37B.pls 120.3 2005/10/17 02:23:43 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_qual_dets%ROWTYPE;
6: new_references igs_uc_qual_dets%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 44: FROM IGS_UC_QUAL_DETS

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

Line 146: FROM igs_uc_qual_dets

142: || (reverse chronological order - newest change first)
143: */
144: CURSOR cur_rowid IS
145: SELECT rowid
146: FROM igs_uc_qual_dets
147: WHERE person_id = x_person_id
148: AND exam_level = x_exam_level
149: AND ((subject_code = x_subject_code) OR (subject_code IS NULL AND x_subject_code IS NULL))
150: AND ((year = x_year) OR (year IS NULL AND x_year IS NULL))

Line 286: IGS_AV_STND_UNIT_LVL_PKG.GET_FK_IGS_UC_QUAL_DETS(

282:
283:
284: PROCEDURE Check_Child_Existance AS
285: BEGIN
286: IGS_AV_STND_UNIT_LVL_PKG.GET_FK_IGS_UC_QUAL_DETS(
287: old_references.QUAL_DETS_ID
288: );
289: END Check_Child_Existance;
290:

Line 307: FROM igs_uc_qual_dets

303: || (reverse chronological order - newest change first)
304: */
305: CURSOR cur_rowid IS
306: SELECT rowid
307: FROM igs_uc_qual_dets
308: WHERE qual_dets_id = x_qual_dets_id;
309:
310: lv_rowid cur_rowid%RowType;
311:

Line 343: FROM igs_uc_qual_dets

339: || (reverse chronological order - newest change first)
340: */
341: CURSOR cur_rowid IS
342: SELECT rowid
343: FROM igs_uc_qual_dets
344: WHERE ((claimed_result = x_grade) AND
345: (grading_schema_cd = x_grading_schema_cd) AND
346: (version_number = x_version_number))
347: OR ((grading_schema_cd = x_grading_schema_cd) AND

Line 386: FROM igs_uc_qual_dets

382: || (reverse chronological order - newest change first)
383: */
384: CURSOR cur_rowid IS
385: SELECT rowid
386: FROM igs_uc_qual_dets
387: WHERE ((exam_level = x_award_cd));
388:
389: lv_rowid cur_rowid%RowType;
390:

Line 421: FROM igs_uc_qual_dets

417: || (reverse chronological order - newest change first)
418: */
419: CURSOR cur_rowid IS
420: SELECT rowid
421: FROM igs_uc_qual_dets
422: WHERE ((subject_code = x_field_of_study));
423:
424: lv_rowid cur_rowid%RowType;
425:

Line 456: FROM igs_uc_qual_dets

452: || (reverse chronological order - newest change first)
453: */
454: CURSOR cur_rowid IS
455: SELECT rowid
456: FROM igs_uc_qual_dets
457: WHERE ((awarding_body = x_party_number));
458:
459: lv_rowid cur_rowid%RowType;
460:

Line 493: FROM igs_uc_qual_dets

489: || get_fk_igs_pe_person w.r.t. Bug 2541370.
490: */
491: CURSOR cur_rowid IS
492: SELECT rowid
493: FROM igs_uc_qual_dets
494: WHERE ((person_id = x_person_id));
495:
496: lv_rowid cur_rowid%RowType;
497:

Line 641: FROM igs_uc_qual_dets

637: || (reverse chronological order - newest change first)
638: */
639: CURSOR c IS
640: SELECT rowid
641: FROM igs_uc_qual_dets
642: WHERE qual_dets_id = x_qual_dets_id;
643:
644: x_last_update_date DATE;
645: x_last_updated_by NUMBER;

Line 669: SELECT igs_uc_qual_dets_s.NEXTVAL

665: igs_ge_msg_stack.add;
666: app_exception.raise_exception;
667: END IF;
668:
669: SELECT igs_uc_qual_dets_s.NEXTVAL
670: INTO x_qual_dets_id
671: FROM dual;
672:
673: before_dml(

Line 701: INSERT INTO igs_uc_qual_dets (

697:
698: IF (x_mode = 'S') THEN
699: igs_sc_gen_001.set_ctx('R');
700: END IF;
701: INSERT INTO igs_uc_qual_dets (
702: qual_dets_id,
703: person_id,
704: exam_level,
705: subject_code,

Line 816: FROM igs_uc_qual_dets

812: claimed_result,
813: ucas_tariff,
814: imported_flag,
815: imported_date
816: FROM igs_uc_qual_dets
817: WHERE rowid = x_rowid
818: FOR UPDATE NOWAIT;
819:
820: tlinfo c1%ROWTYPE;

Line 944: UPDATE igs_uc_qual_dets

940:
941: IF (x_mode = 'S') THEN
942: igs_sc_gen_001.set_ctx('R');
943: END IF;
944: UPDATE igs_uc_qual_dets
945: SET
946: person_id = new_references.person_id,
947: exam_level = new_references.exam_level,
948: subject_code = new_references.subject_code,

Line 1021: FROM igs_uc_qual_dets

1017: || (reverse chronological order - newest change first)
1018: */
1019: CURSOR c1 IS
1020: SELECT rowid
1021: FROM igs_uc_qual_dets
1022: WHERE qual_dets_id = x_qual_dets_id;
1023:
1024: BEGIN
1025:

Line 1100: DELETE FROM igs_uc_qual_dets

1096:
1097: IF (x_mode = 'S') THEN
1098: igs_sc_gen_001.set_ctx('R');
1099: END IF;
1100: DELETE FROM igs_uc_qual_dets
1101: WHERE rowid = x_rowid;
1102:
1103: IF (SQL%NOTFOUND) THEN
1104: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 1117: END igs_uc_qual_dets_pkg;

1113:
1114: END delete_row;
1115:
1116:
1117: END igs_uc_qual_dets_pkg;