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_TEST_RESULTS_PKG dependencies on IGS_AD_TEST_RESULTS

Line 1: PACKAGE BODY igs_ad_test_results_pkg AS

1: PACKAGE BODY igs_ad_test_results_pkg AS
2: /* $Header: IGSAI79B.pls 120.3 2005/08/05 05:55:13 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_test_results%RowType;
5: new_references igs_ad_test_results%RowType;

Line 4: old_references igs_ad_test_results%RowType;

1: PACKAGE BODY igs_ad_test_results_pkg AS
2: /* $Header: IGSAI79B.pls 120.3 2005/08/05 05:55:13 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_test_results%RowType;
5: new_references igs_ad_test_results%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_test_results%RowType;

1: PACKAGE BODY igs_ad_test_results_pkg AS
2: /* $Header: IGSAI79B.pls 120.3 2005/08/05 05:55:13 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_test_results%RowType;
5: new_references igs_ad_test_results%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 66: FROM IGS_AD_TEST_RESULTS

62: ***************************************************************/
63:
64: CURSOR cur_old_ref_values IS
65: SELECT *
66: FROM IGS_AD_TEST_RESULTS
67: WHERE rowid = x_rowid;
68:
69: CURSOR score_type_cur(cp_admission_test_type VARCHAR2) IS
70: SELECT score_type

Line 333: Igs_Ad_Tst_Rslt_Dtls_Pkg.Get_FK_Igs_Ad_Test_Results (

329: ***************************************************************/
330:
331: BEGIN
332:
333: Igs_Ad_Tst_Rslt_Dtls_Pkg.Get_FK_Igs_Ad_Test_Results (
334: old_references.test_results_id
335: );
336:
337: END Check_Child_Existance;

Line 442: FROM igs_ad_test_results

438: ***************************************************************/
439:
440: CURSOR cur_rowid IS
441: SELECT rowid
442: FROM igs_ad_test_results
443: WHERE test_results_id = x_test_results_id
444: FOR UPDATE NOWAIT;
445:
446: lv_rowid cur_rowid%RowType;

Line 478: FROM igs_ad_test_results

474: ***************************************************************/
475:
476: CURSOR cur_rowid IS
477: SELECT rowid
478: FROM igs_ad_test_results
479: WHERE edu_level_id = x_code_id ;
480:
481: CURSOR cur_rowid2 IS
482: SELECT rowid

Line 483: FROM igs_ad_test_results

479: WHERE edu_level_id = x_code_id ;
480:
481: CURSOR cur_rowid2 IS
482: SELECT rowid
483: FROM igs_ad_test_results
484: WHERE grade_id = x_code_id ;
485:
486: CURSOR cur_rowid3 IS
487: SELECT rowid

Line 488: FROM igs_ad_test_results

484: WHERE grade_id = x_code_id ;
485:
486: CURSOR cur_rowid3 IS
487: SELECT rowid
488: FROM igs_ad_test_results
489: WHERE score_source_id = x_code_id ;
490:
491: lv_rowid cur_rowid%RowType;
492:

Line 546: FROM igs_ad_test_results

542: ***************************************************************/
543:
544: CURSOR cur_rowid IS
545: SELECT rowid
546: FROM igs_ad_test_results
547: WHERE admission_test_type = x_admission_test_type ;
548:
549: lv_rowid cur_rowid%RowType;
550:

Line 584: FROM igs_ad_test_results

580: ***************************************************************/
581:
582: CURSOR cur_rowid IS
583: SELECT rowid
584: FROM igs_ad_test_results
585: WHERE person_id = x_person_id ;
586:
587: lv_rowid cur_rowid%RowType;
588:

Line 857: cursor C is select ROWID from IGS_AD_TEST_RESULTS

853: pbondugu 03-04-2003 For test_date and score_report_date trunc of those fileds are inserted into tables.
854:
855: ***************************************************************/
856:
857: cursor C is select ROWID from IGS_AD_TEST_RESULTS
858: where TEST_RESULTS_ID= X_TEST_RESULTS_ID;
859:
860: X_LAST_UPDATE_DATE DATE ;
861: X_LAST_UPDATED_BY NUMBER ;

Line 947: insert into IGS_AD_TEST_RESULTS (

943: x_active_ind => X_ACTIVE_IND );
944: IF (x_mode = 'S') THEN
945: igs_sc_gen_001.set_ctx('R');
946: END IF;
947: insert into IGS_AD_TEST_RESULTS (
948: TEST_RESULTS_ID
949: ,PERSON_ID
950: ,ADMISSION_TEST_TYPE
951: ,TEST_DATE

Line 993: IGS_AD_TEST_RESULTS_S.NEXTVAL

989: ,PROGRAM_APPLICATION_ID
990: ,PROGRAM_UPDATE_DATE
991: ,ACTIVE_IND
992: ) values (
993: IGS_AD_TEST_RESULTS_S.NEXTVAL
994: ,NEW_REFERENCES.PERSON_ID
995: ,NEW_REFERENCES.ADMISSION_TEST_TYPE
996: ,NEW_REFERENCES.TEST_DATE
997: ,NEW_REFERENCES.SCORE_REPORT_DATE

Line 1152: from IGS_AD_TEST_RESULTS

1148: , ATTRIBUTE18
1149: , ATTRIBUTE19
1150: , ATTRIBUTE20
1151: , ACTIVE_IND
1152: from IGS_AD_TEST_RESULTS
1153: where ROWID = X_ROWID
1154: for update nowait;
1155: tlinfo c1%rowtype;
1156: begin

Line 1418: update IGS_AD_TEST_RESULTS set

1414:
1415: IF (x_mode = 'S') THEN
1416: igs_sc_gen_001.set_ctx('R');
1417: END IF;
1418: update IGS_AD_TEST_RESULTS set
1419: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1420: ADMISSION_TEST_TYPE = NEW_REFERENCES.ADMISSION_TEST_TYPE,
1421: TEST_DATE = NEW_REFERENCES.TEST_DATE,
1422: SCORE_REPORT_DATE = NEW_REFERENCES.SCORE_REPORT_DATE,

Line 1543: cursor c1 is select ROWID from IGS_AD_TEST_RESULTS

1539: GSCC standard says that default value should be
1540: present only in specification
1541: ***************************************************************/
1542:
1543: cursor c1 is select ROWID from IGS_AD_TEST_RESULTS
1544: where TEST_RESULTS_ID= X_TEST_RESULTS_ID
1545: ;
1546: L_MODE VARCHAR2(1);
1547: begin

Line 1656: delete from IGS_AD_TEST_RESULTS

1652: );
1653: IF (x_mode = 'S') THEN
1654: igs_sc_gen_001.set_ctx('R');
1655: END IF;
1656: delete from IGS_AD_TEST_RESULTS
1657: where ROWID = X_ROWID;
1658: if (sql%notfound) then
1659: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1660: igs_ge_msg_stack.add;

Line 1673: END igs_ad_test_results_pkg;

1669: p_action => 'DELETE',
1670: x_rowid => X_ROWID
1671: );
1672: end DELETE_ROW;
1673: END igs_ad_test_results_pkg;