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_SEGMENTS_PKG dependencies on IGS_AD_TEST_SEGMENTS

Line 1: PACKAGE BODY igs_ad_test_segments_pkg AS

1: PACKAGE BODY igs_ad_test_segments_pkg AS
2: /* $Header: IGSAI78B.pls 120.1 2005/06/28 04:38:35 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_test_segments%RowType;
5: new_references igs_ad_test_segments%RowType;

Line 4: old_references igs_ad_test_segments%RowType;

1: PACKAGE BODY igs_ad_test_segments_pkg AS
2: /* $Header: IGSAI78B.pls 120.1 2005/06/28 04:38:35 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_test_segments%RowType;
5: new_references igs_ad_test_segments%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_test_segments%RowType;

1: PACKAGE BODY igs_ad_test_segments_pkg AS
2: /* $Header: IGSAI78B.pls 120.1 2005/06/28 04:38:35 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_test_segments%RowType;
5: new_references igs_ad_test_segments%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 48: FROM IGS_AD_TEST_SEGMENTS

44: ***************************************************************/
45:
46: CURSOR cur_old_ref_values IS
47: SELECT *
48: FROM IGS_AD_TEST_SEGMENTS
49: WHERE rowid = x_rowid;
50:
51: BEGIN
52:

Line 318: Igs_Ad_Tst_Rslt_Dtls_Pkg.Get_FK_Igs_Ad_Test_Segments (

314: ***************************************************************/
315:
316: BEGIN
317:
318: Igs_Ad_Tst_Rslt_Dtls_Pkg.Get_FK_Igs_Ad_Test_Segments (
319: old_references.test_segment_id
320: );
321:
322: Igs_Ad_Up_Header_Pkg.Get_FK_Igs_Ad_Test_Segments (

Line 322: Igs_Ad_Up_Header_Pkg.Get_FK_Igs_Ad_Test_Segments (

318: Igs_Ad_Tst_Rslt_Dtls_Pkg.Get_FK_Igs_Ad_Test_Segments (
319: old_references.test_segment_id
320: );
321:
322: Igs_Ad_Up_Header_Pkg.Get_FK_Igs_Ad_Test_Segments (
323: old_references.test_segment_id
324: );
325:
326: END Check_Child_Existance;

Line 335: The corresponding detail IGS_AD_TEST_SEGMENTS are not checked

331: /***************************************************************
332: Created By :rboddu
333: Date Created By :12-Oct-2001
334: Purpose : When record is deleted from the master table IGS_AD_TEST_TYPE
335: The corresponding detail IGS_AD_TEST_SEGMENTS are not checked
336: for dependency. To implement the dependency check this procedure
337: is added here and is being called from IGS_AD_TEST_TYPE_PKG.
338: Know limitations, enhancements or remarks
339: Change History

Line 347: FROM IGS_AD_TEST_SEGMENTS

343: ***************************************************************/
344:
345: CURSOR cur_rowid IS
346: SELECT rowid
347: FROM IGS_AD_TEST_SEGMENTS
348: WHERE admission_test_type = x_admission_test_type ;
349:
350:
351: lv_rowid cur_rowid%RowType;

Line 387: FROM igs_ad_test_segments

383: ***************************************************************/
384:
385: CURSOR cur_rowid IS
386: SELECT rowid
387: FROM igs_ad_test_segments
388: WHERE test_segment_id = x_test_segment_id AND
389: closed_ind = NVL(x_closed_ind,closed_ind)
390: FOR UPDATE NOWAIT;
391:

Line 426: FROM igs_ad_test_segments

422: ***************************************************************/
423:
424: CURSOR cur_rowid IS
425: SELECT rowid
426: FROM igs_ad_test_segments
427: WHERE admission_test_type = x_admission_test_type
428: AND test_segment_name = x_test_segment_name AND
429: ((l_rowid is null) or (rowid <> l_rowid)) AND
430: closed_ind = NVL(x_closed_ind,closed_ind) ;

Line 465: FROM igs_ad_test_segments

461: ***************************************************************/
462:
463: CURSOR cur_unique_rowid IS
464: SELECT rowid
465: FROM igs_ad_test_segments
466: WHERE admission_test_type = x_admission_test_type AND
467: ((l_rowid is null) or (rowid <> l_rowid)) AND
468: segment_group = x_segment_group AND
469: segment_type = 'SCORE' ;

Line 661: FROM IGS_AD_TEST_SEGMENTS

657: ***************************************************************/
658:
659: CURSOR c IS
660: SELECT ROWID
661: FROM IGS_AD_TEST_SEGMENTS
662: WHERE TEST_SEGMENT_ID= X_TEST_SEGMENT_ID;
663:
664: X_LAST_UPDATE_DATE DATE ;
665: X_LAST_UPDATED_BY NUMBER ;

Line 724: INSERT INTO IGS_AD_TEST_SEGMENTS (

720:
721: IF (x_mode = 'S') THEN
722: igs_sc_gen_001.set_ctx('R');
723: END IF;
724: INSERT INTO IGS_AD_TEST_SEGMENTS (
725: MIN_SCORE
726: ,MAX_SCORE
727: ,INCLUDE_IN_COMP_SCORE
728: ,SCORE_IND

Line 760: ,IGS_AD_TEST_SEGMENTS_S.NEXTVAL

756: ,NEW_REFERENCES.PERCENTILE_YEAR_RANK_IND
757: ,NEW_REFERENCES.SCORE_BAND_UPPER_IND
758: ,NEW_REFERENCES.SCORE_BAND_LOWER_IND
759: ,NEW_REFERENCES.IRREGULARITY_CODE_IND
760: ,IGS_AD_TEST_SEGMENTS_S.NEXTVAL
761: ,NEW_REFERENCES.ADMISSION_TEST_TYPE
762: ,NEW_REFERENCES.TEST_SEGMENT_NAME
763: ,NEW_REFERENCES.DESCRIPTION
764: ,NEW_REFERENCES.CLOSED_IND

Line 857: from IGS_AD_TEST_SEGMENTS

853: , DESCRIPTION
854: , CLOSED_IND
855: , SEGMENT_TYPE
856: , SEGMENT_GROUP
857: from IGS_AD_TEST_SEGMENTS
858: where ROWID = X_ROWID
859: for update nowait;
860: tlinfo c1%rowtype;
861: begin

Line 986: update IGS_AD_TEST_SEGMENTS set

982:
983: IF (x_mode = 'S') THEN
984: igs_sc_gen_001.set_ctx('R');
985: END IF;
986: update IGS_AD_TEST_SEGMENTS set
987: MIN_SCORE = NEW_REFERENCES.MIN_SCORE,
988: MAX_SCORE = NEW_REFERENCES.MAX_SCORE,
989: INCLUDE_IN_COMP_SCORE = NEW_REFERENCES.INCLUDE_IN_COMP_SCORE,
990: SCORE_IND = NEW_REFERENCES.SCORE_IND,

Line 1070: cursor c1 is select ROWID from IGS_AD_TEST_SEGMENTS

1066:
1067: (reverse chronological order - newest change first)
1068: ***************************************************************/
1069:
1070: cursor c1 is select ROWID from IGS_AD_TEST_SEGMENTS
1071: where TEST_SEGMENT_ID= X_TEST_SEGMENT_ID;
1072: l_mode VARCHAR2(1);
1073:
1074: begin

Line 1150: delete from IGS_AD_TEST_SEGMENTS

1146: );
1147: IF (x_mode = 'S') THEN
1148: igs_sc_gen_001.set_ctx('R');
1149: END IF;
1150: delete from IGS_AD_TEST_SEGMENTS
1151: where ROWID = X_ROWID;
1152: if (sql%notfound) then
1153: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1154: igs_ge_msg_stack.add;

Line 1167: END igs_ad_test_segments_pkg;

1163: p_action => 'DELETE',
1164: x_rowid => X_ROWID
1165: );
1166: end DELETE_ROW;
1167: END igs_ad_test_segments_pkg;