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_UP_HEADER_PKG dependencies on IGS_AD_UP_HEADER

Line 1: PACKAGE BODY igs_ad_up_header_pkg AS

1: PACKAGE BODY igs_ad_up_header_pkg AS
2: /* $Header: IGSAI92B.pls 115.12 2003/10/30 13:24:44 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_up_header%RowType;
5: new_references igs_ad_up_header%RowType;

Line 4: old_references igs_ad_up_header%RowType;

1: PACKAGE BODY igs_ad_up_header_pkg AS
2: /* $Header: IGSAI92B.pls 115.12 2003/10/30 13:24:44 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_up_header%RowType;
5: new_references igs_ad_up_header%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_up_header%RowType;

1: PACKAGE BODY igs_ad_up_header_pkg AS
2: /* $Header: IGSAI92B.pls 115.12 2003/10/30 13:24:44 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_up_header%RowType;
5: new_references igs_ad_up_header%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM IGS_AD_UP_HEADER

32: ***************************************************************/
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_AD_UP_HEADER
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 227: Igs_Ad_Up_Detail_Pkg.Get_FK_Igs_Ad_Up_Header (

223: ***************************************************************/
224:
225: BEGIN
226:
227: Igs_Ad_Up_Detail_Pkg.Get_FK_Igs_Ad_Up_Header (
228: old_references.up_header_id
229: );
230:
231: END Check_Child_Existance;

Line 250: FROM igs_ad_up_header

246: ***************************************************************/
247:
248: CURSOR cur_rowid IS
249: SELECT rowid
250: FROM igs_ad_up_header
251: WHERE up_header_id = x_up_header_id
252: FOR UPDATE NOWAIT;
253:
254: lv_rowid cur_rowid%RowType;

Line 288: FROM igs_ad_up_header

284: ***************************************************************/
285:
286: CURSOR cur_rowid IS
287: SELECT rowid
288: FROM igs_ad_up_header
289: WHERE admission_test_type = x_admission_test_type
290: and ((l_rowid is null) or (rowid <> l_rowid));
291:
292: CURSOR test_type_seg_cur IS

Line 294: FROM igs_ad_up_header

290: and ((l_rowid is null) or (rowid <> l_rowid));
291:
292: CURSOR test_type_seg_cur IS
293: SELECT rowid
294: FROM igs_ad_up_header
295: WHERE admission_test_type = x_admission_test_type AND
296: test_segment_id = x_test_segment_id AND
297: ((l_rowid is null) or (rowid <> l_rowid));
298:

Line 345: FROM igs_ad_up_header

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

Line 382: FROM igs_ad_up_header

378: ***************************************************************/
379:
380: CURSOR cur_rowid IS
381: SELECT rowid
382: FROM igs_ad_up_header
383: WHERE test_segment_id = x_test_segment_id ;
384:
385: lv_rowid cur_rowid%RowType;
386:

Line 540: cursor C is select ROWID from IGS_AD_UP_HEADER

536:
537: (reverse chronological order - newest change first)
538: ***************************************************************/
539:
540: cursor C is select ROWID from IGS_AD_UP_HEADER
541: where UP_HEADER_ID= X_UP_HEADER_ID
542: ;
543: X_LAST_UPDATE_DATE DATE ;
544: X_LAST_UPDATED_BY NUMBER ;

Line 581: insert into IGS_AD_UP_HEADER (

577: x_created_by=>X_LAST_UPDATED_BY,
578: x_last_update_date=>X_LAST_UPDATE_DATE,
579: x_last_updated_by=>X_LAST_UPDATED_BY,
580: x_last_update_login=>X_LAST_UPDATE_LOGIN);
581: insert into IGS_AD_UP_HEADER (
582: MAX_SCORE
583: ,UP_HEADER_ID
584: ,ADMISSION_TEST_TYPE
585: ,TEST_SEGMENT_ID

Line 595: ,IGS_AD_UP_HEADER_S.NEXTVAL

591: ,LAST_UPDATED_BY
592: ,LAST_UPDATE_LOGIN
593: ) values (
594: NEW_REFERENCES.MAX_SCORE
595: ,IGS_AD_UP_HEADER_S.NEXTVAL
596: ,NEW_REFERENCES.ADMISSION_TEST_TYPE
597: ,NEW_REFERENCES.TEST_SEGMENT_ID
598: ,NEW_REFERENCES.DEFINITION_LEVEL
599: ,NEW_REFERENCES.MIN_SCORE

Line 642: from IGS_AD_UP_HEADER

638: , ADMISSION_TEST_TYPE
639: , TEST_SEGMENT_ID
640: , DEFINITION_LEVEL
641: , MIN_SCORE
642: from IGS_AD_UP_HEADER
643: where ROWID = X_ROWID
644: for update nowait;
645: tlinfo c1%rowtype;
646: begin

Line 728: update IGS_AD_UP_HEADER set

724: x_created_by=>X_LAST_UPDATED_BY,
725: x_last_update_date=>X_LAST_UPDATE_DATE,
726: x_last_updated_by=>X_LAST_UPDATED_BY,
727: x_last_update_login=>X_LAST_UPDATE_LOGIN);
728: update IGS_AD_UP_HEADER set
729: MAX_SCORE = NEW_REFERENCES.MAX_SCORE,
730: ADMISSION_TEST_TYPE = NEW_REFERENCES.ADMISSION_TEST_TYPE,
731: TEST_SEGMENT_ID = NEW_REFERENCES.TEST_SEGMENT_ID,
732: DEFINITION_LEVEL = NEW_REFERENCES.DEFINITION_LEVEL,

Line 768: cursor c1 is select ROWID from IGS_AD_UP_HEADER

764:
765: (reverse chronological order - newest change first)
766: ***************************************************************/
767:
768: cursor c1 is select ROWID from IGS_AD_UP_HEADER
769: where UP_HEADER_ID= X_UP_HEADER_ID
770: ;
771: begin
772: open c1;

Line 817: delete from IGS_AD_UP_HEADER

813: Before_DML (
814: p_action => 'DELETE',
815: x_rowid => X_ROWID
816: );
817: delete from IGS_AD_UP_HEADER
818: where ROWID = X_ROWID;
819: if (sql%notfound) then
820: raise no_data_found;
821: end if;

Line 827: END igs_ad_up_header_pkg;

823: p_action => 'DELETE',
824: x_rowid => X_ROWID
825: );
826: end DELETE_ROW;
827: END igs_ad_up_header_pkg;