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_TERM_UNITDTLS_PKG dependencies on IGS_AD_TERM_UNITDTLS

Line 1: PACKAGE BODY igs_ad_term_unitdtls_pkg AS

1: PACKAGE BODY igs_ad_term_unitdtls_pkg AS
2: /* $Header: IGSAI84B.pls 120.2 2005/10/01 21:47:44 appldev ship $ */
3: PROCEDURE update_term_tab(x_term_id IN NUMBER);
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_term_unitdtls%RowType;

Line 5: old_references igs_ad_term_unitdtls%RowType;

1: PACKAGE BODY igs_ad_term_unitdtls_pkg AS
2: /* $Header: IGSAI84B.pls 120.2 2005/10/01 21:47:44 appldev ship $ */
3: PROCEDURE update_term_tab(x_term_id IN NUMBER);
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_term_unitdtls%RowType;
6: new_references igs_ad_term_unitdtls%RowType;
7:
8:
9: PROCEDURE Check_Status

Line 6: new_references igs_ad_term_unitdtls%RowType;

2: /* $Header: IGSAI84B.pls 120.2 2005/10/01 21:47:44 appldev ship $ */
3: PROCEDURE update_term_tab(x_term_id IN NUMBER);
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_term_unitdtls%RowType;
6: new_references igs_ad_term_unitdtls%RowType;
7:
8:
9: PROCEDURE Check_Status
10: AS

Line 84: FROM IGS_AD_TERM_UNITDTLS

80: ***************************************************************/
81:
82: CURSOR cur_old_ref_values IS
83: SELECT *
84: FROM IGS_AD_TERM_UNITDTLS
85: WHERE rowid = x_rowid;
86:
87: BEGIN
88:

Line 277: FROM igs_ad_term_unitdtls

273: ***************************************************************/
274:
275: CURSOR cur_rowid IS
276: SELECT rowid
277: FROM igs_ad_term_unitdtls
278: WHERE unit_details_id = x_unit_details_id
279: FOR UPDATE NOWAIT;
280:
281: lv_rowid cur_rowid%RowType;

Line 314: FROM igs_ad_term_unitdtls

310: ***************************************************************/
311:
312: CURSOR cur_rowid IS
313: SELECT rowid
314: FROM igs_ad_term_unitdtls
315: WHERE unit = x_unit
316: AND term_details_id = x_term_details_id and ((l_rowid is null) or (rowid <> l_rowid))
317:
318: ;

Line 351: FROM igs_ad_term_unitdtls

347: ***************************************************************/
348:
349: CURSOR cur_rowid IS
350: SELECT rowid
351: FROM igs_ad_term_unitdtls
352: WHERE unit_difficulty = x_code_id ;
353:
354: lv_rowid cur_rowid%RowType;
355:

Line 388: FROM igs_ad_term_unitdtls

384: ***************************************************************/
385:
386: CURSOR cur_rowid IS
387: SELECT rowid
388: FROM igs_ad_term_unitdtls
389: WHERE term_details_id = x_term_details_id ;
390:
391: lv_rowid cur_rowid%RowType;
392:

Line 412: IGS_AV_STND_UNIT_PKG.GET_FK_IGS_AD_TERM_UNITDTLS (

408: PROCEDURE Check_Child_Existance AS
409: BEGIN
410: -- Next part of code has been added as per bug# 2401170
411: -- Start of new code.
412: IGS_AV_STND_UNIT_PKG.GET_FK_IGS_AD_TERM_UNITDTLS (
413: old_references.unit_details_id
414: );
415: IGS_AV_STND_UNIT_LVL_PKG.GET_FK_IGS_AD_TERM_UNITDTLS (
416: old_references.unit_details_id

Line 415: IGS_AV_STND_UNIT_LVL_PKG.GET_FK_IGS_AD_TERM_UNITDTLS (

411: -- Start of new code.
412: IGS_AV_STND_UNIT_PKG.GET_FK_IGS_AD_TERM_UNITDTLS (
413: old_references.unit_details_id
414: );
415: IGS_AV_STND_UNIT_LVL_PKG.GET_FK_IGS_AD_TERM_UNITDTLS (
416: old_references.unit_details_id
417: );
418: -- End of new code. Bug# 2401170
419: END Check_Child_Existance;

Line 577: cursor C is select ROWID from IGS_AD_TERM_UNITDTLS

573:
574: (reverse chronological order - newest change first)
575: ***************************************************************/
576:
577: cursor C is select ROWID from IGS_AD_TERM_UNITDTLS
578: where UNIT_DETAILS_ID= X_UNIT_DETAILS_ID
579: ;
580: X_LAST_UPDATE_DATE DATE ;
581: X_LAST_UPDATED_BY NUMBER ;

Line 641: insert into IGS_AD_TERM_UNITDTLS (

637:
638: IF (x_mode = 'S') THEN
639: igs_sc_gen_001.set_ctx('R');
640: END IF;
641: insert into IGS_AD_TERM_UNITDTLS (
642: UNIT_DETAILS_ID
643: ,TERM_DETAILS_ID
644: ,UNIT
645: ,UNIT_DIFFICULTY

Line 662: IGS_AD_TERM_UNITDTLS_S.NEXTVAL

658: ,PROGRAM_ID
659: ,PROGRAM_APPLICATION_ID
660: ,PROGRAM_UPDATE_DATE
661: ) values (
662: IGS_AD_TERM_UNITDTLS_S.NEXTVAL
663: ,NEW_REFERENCES.TERM_DETAILS_ID
664: ,NEW_REFERENCES.UNIT
665: ,NEW_REFERENCES.UNIT_DIFFICULTY
666: ,NEW_REFERENCES.UNIT_NAME

Line 743: from IGS_AD_TERM_UNITDTLS

739: , CP_EARNED
740: , GRADE
741: , UNIT_GRADE_POINTS
742: , DEG_AUD_DETAIL_ID
743: from IGS_AD_TERM_UNITDTLS
744: where ROWID = X_ROWID
745: for update nowait;
746: tlinfo c1%rowtype;
747: begin

Line 873: UPDATE IGS_AD_TERM_UNITDTLS SET

869:
870: IF (x_mode = 'S') THEN
871: igs_sc_gen_001.set_ctx('R');
872: END IF;
873: UPDATE IGS_AD_TERM_UNITDTLS SET
874: TERM_DETAILS_ID = NEW_REFERENCES.TERM_DETAILS_ID,
875: UNIT = NEW_REFERENCES.UNIT,
876: UNIT_DIFFICULTY = NEW_REFERENCES.UNIT_DIFFICULTY,
877: UNIT_NAME = NEW_REFERENCES.UNIT_NAME,

Line 944: cursor c1 is select ROWID from IGS_AD_TERM_UNITDTLS

940:
941: (reverse chronological order - newest change first)
942: ***************************************************************/
943:
944: cursor c1 is select ROWID from IGS_AD_TERM_UNITDTLS
945: where UNIT_DETAILS_ID= X_UNIT_DETAILS_ID
946: ;
947: begin
948: open c1;

Line 1005: delete from IGS_AD_TERM_UNITDTLS

1001: );
1002: IF (x_mode = 'S') THEN
1003: igs_sc_gen_001.set_ctx('R');
1004: END IF;
1005: delete from IGS_AD_TERM_UNITDTLS
1006: where ROWID = X_ROWID;
1007: if (sql%notfound) then
1008: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1009: igs_ge_msg_stack.add;

Line 1037: FROM igs_ad_term_unitdtls

1033: (reverse chronological order - newest change first)
1034: ***************************************************************/
1035: CURSOR c_get_data IS
1036: SELECT SUM(NVL(cp_attempted,0)) tcpa, SUM(NVL(cp_earned,0)) tcpe,SUM(NVL(unit_grade_points,0)) tugp
1037: FROM igs_ad_term_unitdtls
1038: WHERE term_details_id = x_term_id
1039: GROUP BY term_details_id;
1040:
1041: l_cp_attempted_total igs_ad_term_details.total_cp_attempted%TYPE;

Line 1060: END igs_ad_term_unitdtls_pkg;

1056:
1057:
1058:
1059:
1060: END igs_ad_term_unitdtls_pkg;