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_TST_RSLT_DTLS_PKG dependencies on IGS_AD_TST_RSLT_DTLS

Line 1: PACKAGE BODY igs_ad_tst_rslt_dtls_pkg AS

1: PACKAGE BODY igs_ad_tst_rslt_dtls_pkg AS
2: /* $Header: IGSAI80B.pls 120.4 2005/08/22 04:45:30 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_tst_rslt_dtls%RowType;
5: new_references igs_ad_tst_rslt_dtls%RowType;

Line 4: old_references igs_ad_tst_rslt_dtls%RowType;

1: PACKAGE BODY igs_ad_tst_rslt_dtls_pkg AS
2: /* $Header: IGSAI80B.pls 120.4 2005/08/22 04:45:30 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_tst_rslt_dtls%RowType;
5: new_references igs_ad_tst_rslt_dtls%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_tst_rslt_dtls%RowType;

1: PACKAGE BODY igs_ad_tst_rslt_dtls_pkg AS
2: /* $Header: IGSAI80B.pls 120.4 2005/08/22 04:45:30 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_tst_rslt_dtls%RowType;
5: new_references igs_ad_tst_rslt_dtls%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 62: FROM IGS_AD_TST_RSLT_DTLS

58: ***************************************************************/
59:
60: CURSOR cur_old_ref_values IS
61: SELECT *
62: FROM IGS_AD_TST_RSLT_DTLS
63: WHERE rowid = x_rowid;
64:
65: BEGIN
66:

Line 332: FROM igs_ad_tst_rslt_dtls

328: ***************************************************************/
329:
330: CURSOR cur_rowid IS
331: SELECT rowid
332: FROM igs_ad_tst_rslt_dtls
333: WHERE tst_rslt_dtls_id = x_tst_rslt_dtls_id
334: FOR UPDATE NOWAIT;
335:
336: lv_rowid cur_rowid%RowType;

Line 369: FROM igs_ad_tst_rslt_dtls

365: ***************************************************************/
366:
367: CURSOR cur_rowid IS
368: SELECT rowid
369: FROM igs_ad_tst_rslt_dtls
370: WHERE test_results_id = x_test_results_id
371: AND test_segment_id = x_test_segment_id and ((l_rowid is null) or (rowid <> l_rowid))
372:
373: ;

Line 406: FROM igs_ad_tst_rslt_dtls

402: ***************************************************************/
403:
404: CURSOR cur_rowid IS
405: SELECT rowid
406: FROM igs_ad_tst_rslt_dtls
407: WHERE irregularity_code_id = x_code_id ;
408:
409: lv_rowid cur_rowid%RowType;
410:

Line 443: FROM igs_ad_tst_rslt_dtls

439: ***************************************************************/
440:
441: CURSOR cur_rowid IS
442: SELECT rowid
443: FROM igs_ad_tst_rslt_dtls
444: WHERE test_results_id = x_test_results_id ;
445:
446: lv_rowid cur_rowid%RowType;
447:

Line 480: FROM igs_ad_tst_rslt_dtls

476: ***************************************************************/
477:
478: CURSOR cur_rowid IS
479: SELECT rowid
480: FROM igs_ad_tst_rslt_dtls
481: WHERE test_segment_id = x_test_segment_id ;
482:
483: lv_rowid cur_rowid%RowType;
484:

Line 504: igs_av_stnd_unit_pkg.get_fk_igs_ad_tst_rslt_dtls (

500: PROCEDURE Check_Child_Existance AS
501: BEGIN
502: -- Next part of code has been added as per bug# 2401170
503: -- Start of new code.
504: igs_av_stnd_unit_pkg.get_fk_igs_ad_tst_rslt_dtls (
505: old_references.tst_rslt_dtls_id
506: );
507: igs_av_stnd_unit_lvl_pkg.get_fk_igs_ad_tst_rslt_dtls (
508: old_references.tst_rslt_dtls_id

Line 507: igs_av_stnd_unit_lvl_pkg.get_fk_igs_ad_tst_rslt_dtls (

503: -- Start of new code.
504: igs_av_stnd_unit_pkg.get_fk_igs_ad_tst_rslt_dtls (
505: old_references.tst_rslt_dtls_id
506: );
507: igs_av_stnd_unit_lvl_pkg.get_fk_igs_ad_tst_rslt_dtls (
508: old_references.tst_rslt_dtls_id
509: );
510: -- End of new code. Bug# 2401170
511: END Check_Child_Existance;

Line 518: FROM IGS_AD_TST_RSLT_DTLS A,

514: AS
515:
516: CURSOR c_calc_comp_score(cp_test_results_id IN NUMBER) IS
517: SELECT SUM(test_score)
518: FROM IGS_AD_TST_RSLT_DTLS A,
519: IGS_AD_TEST_SEGMENTS B
520: WHERE A.TEST_results_ID = cp_test_results_id
521: AND A.TEST_SEGMENT_ID = B.test_segment_id
522: AND B.INCLUDE_IN_COMP_SCORE = 'Y';

Line 1118: cursor C is select ROWID from IGS_AD_TST_RSLT_DTLS

1114:
1115: (reverse chronological order - newest change first)
1116: ***************************************************************/
1117:
1118: cursor C is select ROWID from IGS_AD_TST_RSLT_DTLS
1119: where TST_RSLT_DTLS_ID= X_TST_RSLT_DTLS_ID
1120: ;
1121: X_LAST_UPDATE_DATE DATE ;
1122: X_LAST_UPDATED_BY NUMBER ;

Line 1205: insert into IGS_AD_TST_RSLT_DTLS (

1201: x_last_update_login=>X_LAST_UPDATE_LOGIN);
1202: IF (x_mode = 'S') THEN
1203: igs_sc_gen_001.set_ctx('R');
1204: END IF;
1205: insert into IGS_AD_TST_RSLT_DTLS (
1206: TST_RSLT_DTLS_ID
1207: ,TEST_RESULTS_ID
1208: ,TEST_SEGMENT_ID
1209: ,TEST_SCORE

Line 1248: IGS_AD_TST_RSLT_DTLS_S.NEXTVAL

1244: ,PROGRAM_ID
1245: ,PROGRAM_APPLICATION_ID
1246: ,PROGRAM_UPDATE_DATE
1247: ) values (
1248: IGS_AD_TST_RSLT_DTLS_S.NEXTVAL
1249: ,NEW_REFERENCES.TEST_RESULTS_ID
1250: ,NEW_REFERENCES.TEST_SEGMENT_ID
1251: ,NEW_REFERENCES.TEST_SCORE
1252: ,NEW_REFERENCES.PERCENTILE

Line 1399: from IGS_AD_TST_RSLT_DTLS

1395: , ATTRIBUTE17
1396: , ATTRIBUTE18
1397: , ATTRIBUTE19
1398: , ATTRIBUTE20
1399: from IGS_AD_TST_RSLT_DTLS
1400: where ROWID = X_ROWID
1401: for update nowait;
1402: tlinfo c1%rowtype;
1403: begin

Line 1649: update IGS_AD_TST_RSLT_DTLS set

1645:
1646: IF (x_mode = 'S') THEN
1647: igs_sc_gen_001.set_ctx('R');
1648: END IF;
1649: update IGS_AD_TST_RSLT_DTLS set
1650: TEST_RESULTS_ID = NEW_REFERENCES.TEST_RESULTS_ID,
1651: TEST_SEGMENT_ID = NEW_REFERENCES.TEST_SEGMENT_ID,
1652: TEST_SCORE = NEW_REFERENCES.TEST_SCORE,
1653: PERCENTILE = NEW_REFERENCES.PERCENTILE,

Line 1770: cursor c1 is select ROWID from IGS_AD_TST_RSLT_DTLS

1766:
1767: (reverse chronological order - newest change first)
1768: ***************************************************************/
1769:
1770: cursor c1 is select ROWID from IGS_AD_TST_RSLT_DTLS
1771: where TST_RSLT_DTLS_ID= X_TST_RSLT_DTLS_ID
1772: ;
1773: L_MODE VARCHAR2(1);
1774: begin

Line 1877: delete from IGS_AD_TST_RSLT_DTLS

1873: );
1874: IF (x_mode = 'S') THEN
1875: igs_sc_gen_001.set_ctx('R');
1876: END IF;
1877: delete from IGS_AD_TST_RSLT_DTLS
1878: where ROWID = X_ROWID;
1879: if (sql%notfound) then
1880: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1881: igs_ge_msg_stack.add;

Line 1896: END igs_ad_tst_rslt_dtls_pkg;

1892: );
1893:
1894: END DELETE_ROW;
1895:
1896: END igs_ad_tst_rslt_dtls_pkg;