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_OFR_OPT_PKG dependencies on IGS_PS_OFR_OPT_ALL

Line 4: old_references IGS_PS_OFR_OPT_ALL%RowType;

1: PACKAGE BODY igs_ps_ofr_opt_pkg AS
2: /* $Header: IGSPI23B.pls 120.0 2005/06/01 14:01:40 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_OFR_OPT_ALL%RowType;
5: new_references IGS_PS_OFR_OPT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_OFR_OPT_ALL%RowType;

1: PACKAGE BODY igs_ps_ofr_opt_pkg AS
2: /* $Header: IGSPI23B.pls 120.0 2005/06/01 14:01:40 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_OFR_OPT_ALL%RowType;
5: new_references IGS_PS_OFR_OPT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 55: FROM IGS_PS_OFR_OPT_ALL

51: ) AS
52:
53: CURSOR cur_old_ref_values IS
54: SELECT *
55: FROM IGS_PS_OFR_OPT_ALL
56: WHERE rowid = x_rowid;
57:
58: BEGIN
59:

Line 129: -- BEFORE INSERT OR UPDATE OR DELETE ON IGS_PS_OFR_OPT_ALL

125: END Set_Column_Values;
126:
127: -- Trigger description :-
128: -- "OSS_TST".TRG_COO_BR_IUD
129: -- BEFORE INSERT OR UPDATE OR DELETE ON IGS_PS_OFR_OPT_ALL
130: -- REFERENCING
131: -- NEW AS NEW
132: -- OLD AS OLD
133: -- FOR EACH ROW

Line 531: IGS_HE_POOUS_OU_ALL_PKG.GET_FK_IGS_PS_OFR_OPT_ALL

527: );
528:
529:
530: --This procedure call was added as part of #2330002 by sbaliga
531: IGS_HE_POOUS_OU_ALL_PKG.GET_FK_IGS_PS_OFR_OPT_ALL
532: ( old_references.course_cd,
533: old_references.version_number,
534: old_references.cal_type,
535: old_references.location_cd,

Line 547: 'BEGIN IGS_HE_POOUS_ALL_PKG.GET_FK_IGS_PS_OFR_OPT_ALL(:1,:2,:3,:4,:5,:6); END;'

543: FETCH c_hesa INTO l_hesa;
544: IF c_hesa%FOUND THEN
545:
546: EXECUTE IMMEDIATE
547: 'BEGIN IGS_HE_POOUS_ALL_PKG.GET_FK_IGS_PS_OFR_OPT_ALL(:1,:2,:3,:4,:5,:6); END;'
548: USING
549: old_references.course_cd,
550: old_references.version_number,
551: old_references.cal_type,

Line 593: FROM IGS_PS_OFR_OPT_ALL

589: RETURN BOOLEAN AS
590:
591: CURSOR cur_rowid IS
592: SELECT rowid
593: FROM IGS_PS_OFR_OPT_ALL
594: WHERE course_cd = x_course_cd
595: AND version_number = x_version_number
596: AND cal_type = x_cal_type
597: AND location_cd = x_location_cd

Line 625: FROM IGS_PS_OFR_OPT_ALL

621: RETURN BOOLEAN AS
622:
623: CURSOR cur_rowid IS
624: SELECT rowid
625: FROM IGS_PS_OFR_OPT_ALL
626: WHERE coo_id = x_coo_id
627: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
628: AND DELETE_FLAG = 'N';
629:

Line 652: FROM IGS_PS_OFR_OPT_ALL

648: ) AS
649:
650: CURSOR cur_rowid IS
651: SELECT rowid
652: FROM IGS_PS_OFR_OPT_ALL
653: WHERE attendance_mode = x_attendance_mode
654: AND delete_flag = 'N';
655:
656: lv_rowid cur_rowid%RowType;

Line 679: FROM IGS_PS_OFR_OPT_ALL

675: ) AS
676:
677: CURSOR cur_rowid IS
678: SELECT rowid
679: FROM IGS_PS_OFR_OPT_ALL
680: WHERE attendance_type = x_attendance_type
681: AND delete_flag = 'N';
682:
683: lv_rowid cur_rowid%RowType;

Line 708: FROM IGS_PS_OFR_OPT_ALL

704: ) AS
705:
706: CURSOR cur_rowid IS
707: SELECT rowid
708: FROM IGS_PS_OFR_OPT_ALL
709: WHERE course_cd = x_course_cd
710: AND version_number = x_version_number
711: AND cal_type = x_cal_type
712: AND delete_flag = 'N';

Line 737: FROM IGS_PS_OFR_OPT_ALL

733: ) AS
734:
735: CURSOR cur_rowid IS
736: SELECT rowid
737: FROM IGS_PS_OFR_OPT_ALL
738: WHERE location_cd = x_location_cd
739: AND delete_flag = 'N';
740:
741: lv_rowid cur_rowid%RowType;

Line 764: FROM IGS_PS_OFR_OPT_ALL

760: ) AS
761:
762: CURSOR cur_rowid IS
763: SELECT rowid
764: FROM IGS_PS_OFR_OPT_ALL
765: WHERE enr_officer_person_id = x_person_id
766: AND delete_flag = 'N';
767:
768: lv_rowid cur_rowid%RowType;

Line 1098: CURSOR cur_check_for_deleted_rec(cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,

1094: X_DELETE_FLAG IN VARCHAR2
1095: ) AS
1096:
1097: --This cursor is added as a part of locking build
1098: CURSOR cur_check_for_deleted_rec(cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
1099: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
1100: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
1101: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE,
1102: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,

Line 1099: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,

1095: ) AS
1096:
1097: --This cursor is added as a part of locking build
1098: CURSOR cur_check_for_deleted_rec(cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
1099: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
1100: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
1101: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE,
1102: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
1103: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE) IS

Line 1100: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,

1096:
1097: --This cursor is added as a part of locking build
1098: CURSOR cur_check_for_deleted_rec(cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
1099: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
1100: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
1101: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE,
1102: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
1103: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE) IS
1104: SELECT rowid

Line 1101: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE,

1097: --This cursor is added as a part of locking build
1098: CURSOR cur_check_for_deleted_rec(cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
1099: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
1100: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
1101: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE,
1102: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
1103: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE) IS
1104: SELECT rowid
1105: FROM igs_ps_ofr_opt_all

Line 1102: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,

1098: CURSOR cur_check_for_deleted_rec(cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
1099: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
1100: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
1101: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE,
1102: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
1103: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE) IS
1104: SELECT rowid
1105: FROM igs_ps_ofr_opt_all
1106: WHERE course_cd=cp_course_cd

Line 1103: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE) IS

1099: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
1100: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
1101: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE,
1102: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
1103: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE) IS
1104: SELECT rowid
1105: FROM igs_ps_ofr_opt_all
1106: WHERE course_cd=cp_course_cd
1107: AND version_number=cp_version_number

Line 1105: FROM igs_ps_ofr_opt_all

1101: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE,
1102: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
1103: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE) IS
1104: SELECT rowid
1105: FROM igs_ps_ofr_opt_all
1106: WHERE course_cd=cp_course_cd
1107: AND version_number=cp_version_number
1108: AND cal_type =cp_cal_type
1109: AND location_cd = cp_location_cd

Line 1117: cursor C is select ROWID from IGS_PS_OFR_OPT_ALL

1113: l_rowid VARCHAR2(25);
1114:
1115:
1116:
1117: cursor C is select ROWID from IGS_PS_OFR_OPT_ALL
1118: where COURSE_CD = X_COURSE_CD
1119: and VERSION_NUMBER = X_VERSION_NUMBER
1120: and CAL_TYPE = X_CAL_TYPE
1121: and ATTENDANCE_MODE = X_ATTENDANCE_MODE

Line 1202: insert into IGS_PS_OFR_OPT_ALL (

1198: FETCH cur_check_for_deleted_rec INTO l_rowid;
1199: IF cur_check_for_deleted_rec%NOTFOUND THEN
1200: CLOSE cur_check_for_deleted_rec;
1201:
1202: insert into IGS_PS_OFR_OPT_ALL (
1203: COURSE_CD,
1204: VERSION_NUMBER,
1205: CAL_TYPE,
1206: LOCATION_CD,

Line 1292: UPDATE IGS_PS_OFR_OPT_ALL

1288: );
1289: ELSE
1290: CLOSE cur_check_for_deleted_rec;
1291:
1292: UPDATE IGS_PS_OFR_OPT_ALL
1293: SET
1294: FORCED_LOCATION_IND=NEW_REFERENCES.FORCED_LOCATION_IND,
1295: FORCED_ATT_MODE_IND=NEW_REFERENCES.FORCED_ATT_MODE_IND,
1296: FORCED_ATT_TYPE_IND=NEW_REFERENCES.FORCED_ATT_TYPE_IND,

Line 1402: from IGS_PS_OFR_OPT_ALL

1398: FORCED_ATT_MODE_IND,
1399: FORCED_ATT_TYPE_IND,
1400: TIME_LIMITATION,
1401: ENR_OFFICER_PERSON_ID
1402: from IGS_PS_OFR_OPT_ALL
1403: where ROWID = X_ROWID
1404: for update nowait;
1405: tlinfo c1%rowtype;
1406:

Line 1551: update IGS_PS_OFR_OPT_ALL set

1547: IF NVL(x_delete_flag,'N') = 'Y' THEN
1548: Check_Child_Existance;
1549: END IF;
1550:
1551: update IGS_PS_OFR_OPT_ALL set
1552: COO_ID = NEW_REFERENCES.COO_ID,
1553: FORCED_LOCATION_IND = NEW_REFERENCES.FORCED_LOCATION_IND,
1554: FORCED_ATT_MODE_IND = NEW_REFERENCES.FORCED_ATT_MODE_IND,
1555: FORCED_ATT_TYPE_IND = NEW_REFERENCES.FORCED_ATT_TYPE_IND,

Line 1637: cursor c1 is select rowid from IGS_PS_OFR_OPT_ALL

1633: X_PROGRAM_LENGTH IN NUMBER ,
1634: X_PROGRAM_LENGTH_MEASUREMENT IN VARCHAR2 ,
1635: X_DELETE_FLAG IN VARCHAR2
1636: ) AS
1637: cursor c1 is select rowid from IGS_PS_OFR_OPT_ALL
1638: where COURSE_CD = X_COURSE_CD
1639: and VERSION_NUMBER = X_VERSION_NUMBER
1640: and CAL_TYPE = X_CAL_TYPE
1641: and ATTENDANCE_MODE = X_ATTENDANCE_MODE

Line 1740: delete from IGS_PS_OFR_OPT_ALL

1736: Before_DML (
1737: p_action => 'DELETE',
1738: x_rowid => X_ROWID
1739: );
1740: delete from IGS_PS_OFR_OPT_ALL
1741: where ROWID = X_ROWID;
1742: if (sql%notfound) then
1743: raise no_data_found;
1744: end if;