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_PS_PAT_OF_STUDY_PKG dependencies on IGS_PS_PAT_OF_STUDY

Line 1: package body IGS_PS_PAT_OF_STUDY_PKG as

1: package body IGS_PS_PAT_OF_STUDY_PKG as
2: /* $Header: IGSPI61B.pls 115.6 2003/10/30 13:31:15 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_PAT_OF_STUDY%RowType;
5: new_references IGS_PS_PAT_OF_STUDY%RowType;

Line 4: old_references IGS_PS_PAT_OF_STUDY%RowType;

1: package body IGS_PS_PAT_OF_STUDY_PKG as
2: /* $Header: IGSPI61B.pls 115.6 2003/10/30 13:31:15 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_PAT_OF_STUDY%RowType;
5: new_references IGS_PS_PAT_OF_STUDY%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_PAT_OF_STUDY%RowType;

1: package body IGS_PS_PAT_OF_STUDY_PKG as
2: /* $Header: IGSPI61B.pls 115.6 2003/10/30 13:31:15 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_PAT_OF_STUDY%RowType;
5: new_references IGS_PS_PAT_OF_STUDY%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_PS_PAT_OF_STUDY

29: ) AS
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM IGS_PS_PAT_OF_STUDY
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 469: IGS_PS_PAT_STUDY_PRD_PKG.GET_FK_IGS_PS_PAT_OF_STUDY (

465:
466: PROCEDURE Check_Child_Existance AS
467: BEGIN
468:
469: IGS_PS_PAT_STUDY_PRD_PKG.GET_FK_IGS_PS_PAT_OF_STUDY (
470: old_references.course_cd,
471: old_references.version_number,
472: old_references.cal_type,
473: old_references.sequence_number

Line 487: FROM IGS_PS_PAT_OF_STUDY

483: ) RETURN BOOLEAN AS
484:
485: CURSOR cur_rowid IS
486: SELECT rowid
487: FROM IGS_PS_PAT_OF_STUDY
488: WHERE course_cd = x_course_cd
489: AND version_number = x_version_number
490: AND cal_type = x_cal_type
491: AND sequence_number = x_sequence_number

Line 515: FROM IGS_PS_PAT_OF_STUDY

511: ) AS
512:
513: CURSOR cur_rowid IS
514: SELECT rowid
515: FROM IGS_PS_PAT_OF_STUDY
516: WHERE admission_cat = x_admission_cat ;
517:
518: lv_rowid cur_rowid%RowType;
519:

Line 541: FROM IGS_PS_PAT_OF_STUDY

537: ) AS
538:
539: CURSOR cur_rowid IS
540: SELECT rowid
541: FROM IGS_PS_PAT_OF_STUDY
542: WHERE attendance_mode = x_attendance_mode ;
543:
544: lv_rowid cur_rowid%RowType;
545:

Line 567: FROM IGS_PS_PAT_OF_STUDY

563: ) AS
564:
565: CURSOR cur_rowid IS
566: SELECT rowid
567: FROM IGS_PS_PAT_OF_STUDY
568: WHERE attendance_type = x_attendance_type ;
569:
570: lv_rowid cur_rowid%RowType;
571:

Line 593: FROM IGS_PS_PAT_OF_STUDY

589: ) AS
590:
591: CURSOR cur_rowid IS
592: SELECT rowid
593: FROM IGS_PS_PAT_OF_STUDY
594: WHERE admission_cal_type = x_cal_type ;
595:
596: lv_rowid cur_rowid%RowType;
597:

Line 620: FROM IGS_PS_PAT_OF_STUDY

616: ) AS
617:
618: CURSOR cur_rowid IS
619: SELECT rowid
620: FROM IGS_PS_PAT_OF_STUDY
621: WHERE cal_type = x_cal_type
622: AND aprvd_ci_sequence_number = x_sequence_number ;
623:
624: lv_rowid cur_rowid%RowType;

Line 649: FROM IGS_PS_PAT_OF_STUDY

645: ) AS
646:
647: CURSOR cur_rowid IS
648: SELECT rowid
649: FROM IGS_PS_PAT_OF_STUDY
650: WHERE course_cd = x_course_cd
651: AND version_number = x_version_number
652: AND cal_type = x_cal_type ;
653:

Line 677: FROM IGS_PS_PAT_OF_STUDY

673: ) AS
674:
675: CURSOR cur_rowid IS
676: SELECT rowid
677: FROM IGS_PS_PAT_OF_STUDY
678: WHERE location_cd = x_location_cd ;
679:
680: lv_rowid cur_rowid%RowType;
681:

Line 819: cursor C is select ROWID from IGS_PS_PAT_OF_STUDY

815: X_ALWAYS_PRE_ENROL_IND in VARCHAR2,
816: X_ACAD_PERD_UNIT_SET in VARCHAR2 default NULL,
817: X_MODE in VARCHAR2 default 'R'
818: ) as
819: cursor C is select ROWID from IGS_PS_PAT_OF_STUDY
820: where COURSE_CD = X_COURSE_CD
821: and CAL_TYPE = X_CAL_TYPE
822: and VERSION_NUMBER = X_VERSION_NUMBER
823: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;

Line 869: insert into IGS_PS_PAT_OF_STUDY (

865: x_last_update_date => X_LAST_UPDATE_DATE,
866: x_last_updated_by => X_LAST_UPDATED_BY,
867: x_last_update_login => X_LAST_UPDATE_LOGIN
868: );
869: insert into IGS_PS_PAT_OF_STUDY (
870: COURSE_CD,
871: VERSION_NUMBER,
872: CAL_TYPE,
873: SEQUENCE_NUMBER,

Line 953: from IGS_PS_PAT_OF_STUDY

949: APRVD_CI_SEQUENCE_NUMBER,
950: NUMBER_OF_PERIODS,
951: ALWAYS_PRE_ENROL_IND,
952: ACAD_PERD_UNIT_SET
953: from IGS_PS_PAT_OF_STUDY
954: where ROWID = X_ROWID for update nowait;
955: tlinfo c1%rowtype;
956:
957: begin

Line 1068: update IGS_PS_PAT_OF_STUDY set

1064: x_last_updated_by => X_LAST_UPDATED_BY,
1065: x_last_update_login => X_LAST_UPDATE_LOGIN
1066: );
1067:
1068: update IGS_PS_PAT_OF_STUDY set
1069: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
1070: ATTENDANCE_MODE = NEW_REFERENCES.ATTENDANCE_MODE,
1071: ATTENDANCE_TYPE = NEW_REFERENCES.ATTENDANCE_TYPE,
1072: UNIT_SET_CD = NEW_REFERENCES.UNIT_SET_CD,

Line 1112: cursor c1 is select rowid from IGS_PS_PAT_OF_STUDY

1108: X_ALWAYS_PRE_ENROL_IND in VARCHAR2,
1109: X_ACAD_PERD_UNIT_SET in VARCHAR2,
1110: X_MODE in VARCHAR2 default 'R'
1111: ) as
1112: cursor c1 is select rowid from IGS_PS_PAT_OF_STUDY
1113: where COURSE_CD = X_COURSE_CD
1114: and CAL_TYPE = X_CAL_TYPE
1115: and VERSION_NUMBER = X_VERSION_NUMBER
1116: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 1170: delete from IGS_PS_PAT_OF_STUDY

1166: Before_DML( p_action => 'DELETE',
1167: x_rowid => X_ROWID
1168: );
1169:
1170: delete from IGS_PS_PAT_OF_STUDY
1171: where ROWID=X_ROWID;
1172: if (sql%notfound) then
1173: raise no_data_found;
1174: end if;

Line 1181: end IGS_PS_PAT_OF_STUDY_PKG;

1177: x_rowid => X_ROWID
1178: );
1179: end DELETE_ROW;
1180:
1181: end IGS_PS_PAT_OF_STUDY_PKG;