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_AS_GRD_SCH_GRADE_PKG dependencies on IGS_AS_GRD_SCH_GRADE

Line 1: package body IGS_AS_GRD_SCH_GRADE_PKG AS

1: package body IGS_AS_GRD_SCH_GRADE_PKG AS
2: /* $Header: IGSDI21B.pls 120.0 2005/07/05 11:28:46 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_GRD_SCH_GRADE%RowType;
5: new_references IGS_AS_GRD_SCH_GRADE%RowType;

Line 4: old_references IGS_AS_GRD_SCH_GRADE%RowType;

1: package body IGS_AS_GRD_SCH_GRADE_PKG AS
2: /* $Header: IGSDI21B.pls 120.0 2005/07/05 11:28:46 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_GRD_SCH_GRADE%RowType;
5: new_references IGS_AS_GRD_SCH_GRADE%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_AS_GRD_SCH_GRADE%RowType;

1: package body IGS_AS_GRD_SCH_GRADE_PKG AS
2: /* $Header: IGSDI21B.pls 120.0 2005/07/05 11:28:46 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_GRD_SCH_GRADE%RowType;
5: new_references IGS_AS_GRD_SCH_GRADE%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_dflt_outstanding_ind IN VARCHAR2 DEFAULT NULL,

Line 64: FROM IGS_AS_GRD_SCH_GRADE

60: ) AS
61:
62: CURSOR cur_old_ref_values IS
63: SELECT *
64: FROM IGS_AS_GRD_SCH_GRADE
65: WHERE rowid = x_rowid;
66:
67: BEGIN
68: l_rowid := x_rowid;

Line 504: -- Added igs_av_stnd_unit_pkg.get_fk_igs_as_grd_sch_grade

500: --who when what
501: --smadathi 29-MAY-2001 The foreign key references to IGS_PS_UNT_REPT_FMLY , IGS_PS_UNT_PRV_GRADE removed as per DLD
502: --smadathi 25-MAY-2001 The foreign key references to IGS_PS_USEC_PRV_GRAD removed as per DLD
503: --pkpatel 04-SEP-2001 Bug no. 1960126 Dld Academic Record Maintenance
504: -- Added igs_av_stnd_unit_pkg.get_fk_igs_as_grd_sch_grade
505: BEGIN
506: IGS_AD_ADM_UT_STA_GD_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (
507: old_references.grading_schema_cd,
508: old_references.version_number,

Line 506: IGS_AD_ADM_UT_STA_GD_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (

502: --smadathi 25-MAY-2001 The foreign key references to IGS_PS_USEC_PRV_GRAD removed as per DLD
503: --pkpatel 04-SEP-2001 Bug no. 1960126 Dld Academic Record Maintenance
504: -- Added igs_av_stnd_unit_pkg.get_fk_igs_as_grd_sch_grade
505: BEGIN
506: IGS_AD_ADM_UT_STA_GD_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (
507: old_references.grading_schema_cd,
508: old_references.version_number,
509: old_references.grade
510: );

Line 511: IGS_AS_INS_GRD_ENTRY_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (

507: old_references.grading_schema_cd,
508: old_references.version_number,
509: old_references.grade
510: );
511: IGS_AS_INS_GRD_ENTRY_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (
512: old_references.grading_schema_cd,
513: old_references.version_number,
514: old_references.grade
515: );

Line 516: IGS_AS_GRD_SCH_TRN_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (

512: old_references.grading_schema_cd,
513: old_references.version_number,
514: old_references.grade
515: );
516: IGS_AS_GRD_SCH_TRN_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (
517: old_references.grading_schema_cd,
518: old_references.version_number,
519: old_references.grade
520: );

Line 521: IGS_AS_GRD_SCH_TRN_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (

517: old_references.grading_schema_cd,
518: old_references.version_number,
519: old_references.grade
520: );
521: IGS_AS_GRD_SCH_TRN_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (
522: old_references.grading_schema_cd,
523: old_references.version_number,
524: old_references.grade
525: );

Line 526: IGS_AS_NON_ENR_STDOT_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (

522: old_references.grading_schema_cd,
523: old_references.version_number,
524: old_references.grade
525: );
526: IGS_AS_NON_ENR_STDOT_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (
527: old_references.grading_schema_cd,
528: old_references.version_number,
529: old_references.grade
530: );

Line 531: IGS_AS_SU_STMPTOUT_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (

527: old_references.grading_schema_cd,
528: old_references.version_number,
529: old_references.grade
530: );
531: IGS_AS_SU_STMPTOUT_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (
532: old_references.grading_schema_cd,
533: old_references.version_number,
534: old_references.grade
535: );

Line 536: IGS_AS_SU_STMPTOUT_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (

532: old_references.grading_schema_cd,
533: old_references.version_number,
534: old_references.grade
535: );
536: IGS_AS_SU_STMPTOUT_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (
537: old_references.grading_schema_cd,
538: old_references.version_number,
539: old_references.grade
540: );

Line 542: IGS_AS_INC_GRD_CPROF_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (

538: old_references.version_number,
539: old_references.grade
540: );
541:
542: IGS_AS_INC_GRD_CPROF_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (
543: old_references.grading_schema_cd,
544: old_references.version_number,
545: old_references.grade
546: );

Line 548: IGS_AV_STND_UNIT_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (

544: old_references.version_number,
545: old_references.grade
546: );
547:
548: IGS_AV_STND_UNIT_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (
549: old_references.grading_schema_cd,
550: old_references.version_number,
551: old_references.grade
552: );

Line 554: IGS_AS_SU_ATMPT_ITM_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (

550: old_references.version_number,
551: old_references.grade
552: );
553: -- Added by DDEY as a part of Bug# 2162831
554: IGS_AS_SU_ATMPT_ITM_PKG.GET_FK_IGS_AS_GRD_SCH_GRADE (
555: old_references.grading_schema_cd ,
556: old_references.version_number ,
557: old_references.grade
558: );

Line 568: FROM IGS_AS_GRD_SCH_GRADE

564: x_grade IN VARCHAR2
565: ) RETURN BOOLEAN AS
566: CURSOR cur_rowid IS
567: SELECT rowid
568: FROM IGS_AS_GRD_SCH_GRADE
569: WHERE grading_schema_cd = x_grading_schema_cd
570: AND version_number = x_version_number
571: AND grade = x_grade;
572: lv_rowid cur_rowid%RowType;

Line 593: FROM IGS_AS_GRD_SCH_GRADE

589: x_version_number IN NUMBER
590: ) AS
591: CURSOR cur_rowid IS
592: SELECT rowid
593: FROM IGS_AS_GRD_SCH_GRADE
594: WHERE grading_schema_cd = x_grading_schema_cd
595: AND version_number = x_version_number ;
596: lv_rowid cur_rowid%RowType;
597: BEGIN

Line 615: FROM IGS_AS_GRD_SCH_GRADE

611: x_s_result_type IN VARCHAR2
612: ) AS
613: CURSOR cur_rowid IS
614: SELECT rowid
615: FROM IGS_AS_GRD_SCH_GRADE
616: WHERE s_result_type = x_s_result_type ;
617: lv_rowid cur_rowid%RowType;
618: BEGIN
619: Open cur_rowid;

Line 851: cursor C is select ROWID from IGS_AS_GRD_SCH_GRADE

847: x_attribute20 IN VARCHAR2,
848: X_MODE in VARCHAR2 default 'R',
849: x_closed_ind IN VARCHAR2 default 'N'
850: ) AS
851: cursor C is select ROWID from IGS_AS_GRD_SCH_GRADE
852: where GRADING_SCHEMA_CD = X_GRADING_SCHEMA_CD
853: and VERSION_NUMBER = X_VERSION_NUMBER
854: and GRADE = X_GRADE;
855: X_LAST_UPDATE_DATE DATE;

Line 932: insert into IGS_AS_GRD_SCH_GRADE (

928: x_last_updated_by=>X_LAST_UPDATED_BY,
929: x_last_update_login=>X_LAST_UPDATE_LOGIN,
930: x_closed_ind => x_closed_ind
931: );
932: insert into IGS_AS_GRD_SCH_GRADE (
933: GRADING_SCHEMA_CD,
934: VERSION_NUMBER,
935: GRADE,
936: FULL_GRADE_NAME,

Line 1142: from IGS_AS_GRD_SCH_GRADE

1138: attribute18,
1139: attribute19,
1140: attribute20,
1141: closed_ind
1142: from IGS_AS_GRD_SCH_GRADE
1143: where ROWID = X_ROWID for update nowait;
1144: tlinfo c1%rowtype;
1145: begin
1146: open c1;

Line 1334: update IGS_AS_GRD_SCH_GRADE set

1330: x_last_updated_by=>X_LAST_UPDATED_BY,
1331: x_last_update_login=>X_LAST_UPDATE_LOGIN,
1332: x_closed_ind => x_closed_ind
1333: );
1334: update IGS_AS_GRD_SCH_GRADE set
1335: FULL_GRADE_NAME = NEW_REFERENCES.FULL_GRADE_NAME,
1336: S_RESULT_TYPE = NEW_REFERENCES.S_RESULT_TYPE,
1337: SHOW_ON_NOTICEBOARD_IND = NEW_REFERENCES.SHOW_ON_NOTICEBOARD_IND,
1338: SHOW_ON_OFFICIAL_NTFCTN_IND = NEW_REFERENCES.SHOW_ON_OFFICIAL_NTFCTN_IND,

Line 1440: cursor c1 is select rowid from IGS_AS_GRD_SCH_GRADE

1436: x_attribute20 IN VARCHAR2,
1437: X_MODE in VARCHAR2 default 'R',
1438: x_closed_ind IN VARCHAR2 default 'N'
1439: ) AS
1440: cursor c1 is select rowid from IGS_AS_GRD_SCH_GRADE
1441: where GRADING_SCHEMA_CD = X_GRADING_SCHEMA_CD
1442: and VERSION_NUMBER = X_VERSION_NUMBER
1443: and GRADE = X_GRADE
1444: ;

Line 1553: end IGS_AS_GRD_SCH_GRADE_PKG;

1549: X_MODE,
1550: x_closed_ind);
1551: end ADD_ROW;
1552:
1553: end IGS_AS_GRD_SCH_GRADE_PKG;