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

Line 1: PACKAGE BODY igs_ps_ofr_opt_pkg AS

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;

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 438: --ckasu 04-Dec-2003 Added IGS_EN_SPA_TERMS_PKG.GET_UFK_IGS_PS_OFR_OPT

434: Who When What
435:
436: --sbaliga 9-May-2002 Added 2 more calls to check for child existence
437: as aprt of #2330002
438: --ckasu 04-Dec-2003 Added IGS_EN_SPA_TERMS_PKG.GET_UFK_IGS_PS_OFR_OPT
439: for Term Records Build
440:
441: */
442:

Line 445: IGS_PS_ENT_PT_REF_CD_PKG.GET_FK_IGS_PS_OFR_OPT (

441: */
442:
443: BEGIN
444:
445: IGS_PS_ENT_PT_REF_CD_PKG.GET_FK_IGS_PS_OFR_OPT (
446: old_references.course_cd,
447: old_references.version_number,
448: old_references.cal_type,
449: old_references.location_cd,

Line 454: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT (

450: old_references.attendance_mode,
451: old_references.attendance_type
452: );
453:
454: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT (
455: old_references.coo_id
456: );
457:
458: IGS_PS_OFR_OPT_NOTE_PKG.GET_FK_IGS_PS_OFR_OPT (

Line 458: IGS_PS_OFR_OPT_NOTE_PKG.GET_FK_IGS_PS_OFR_OPT (

454: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT (
455: old_references.coo_id
456: );
457:
458: IGS_PS_OFR_OPT_NOTE_PKG.GET_FK_IGS_PS_OFR_OPT (
459: old_references.course_cd,
460: old_references.version_number,
461: old_references.cal_type,
462: old_references.location_cd,

Line 467: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT (

463: old_references.attendance_mode,
464: old_references.attendance_type
465: );
466:
467: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT (
468: old_references.coo_id
469: );
470:
471: IGS_PS_OFR_PAT_PKG.GET_FK_IGS_PS_OFR_OPT (

Line 471: IGS_PS_OFR_PAT_PKG.GET_FK_IGS_PS_OFR_OPT (

467: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT (
468: old_references.coo_id
469: );
470:
471: IGS_PS_OFR_PAT_PKG.GET_FK_IGS_PS_OFR_OPT (
472: old_references.course_cd,
473: old_references.version_number,
474: old_references.cal_type,
475: old_references.location_cd,

Line 481: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT (

477: old_references.attendance_type
478: );
479:
480:
481: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT (
482: old_references.coo_id
483: );
484:
485: IGS_EN_SPA_TERMS_PKG.GET_UFK_IGS_PS_OFR_OPT (

Line 485: IGS_EN_SPA_TERMS_PKG.GET_UFK_IGS_PS_OFR_OPT (

481: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT (
482: old_references.coo_id
483: );
484:
485: IGS_EN_SPA_TERMS_PKG.GET_UFK_IGS_PS_OFR_OPT (
486: old_references.coo_id
487: );
488:
489: IGS_PS_OF_OPT_AD_CAT_PKG.GET_FK_IGS_PS_OFR_OPT (

Line 489: IGS_PS_OF_OPT_AD_CAT_PKG.GET_FK_IGS_PS_OFR_OPT (

485: IGS_EN_SPA_TERMS_PKG.GET_UFK_IGS_PS_OFR_OPT (
486: old_references.coo_id
487: );
488:
489: IGS_PS_OF_OPT_AD_CAT_PKG.GET_FK_IGS_PS_OFR_OPT (
490: old_references.course_cd,
491: old_references.version_number,
492: old_references.cal_type,
493: old_references.location_cd,

Line 498: IGS_PS_OF_OPT_AD_CAT_PKG.GET_UFK_IGS_PS_OFR_OPT (

494: old_references.attendance_mode,
495: old_references.attendance_type
496: );
497:
498: IGS_PS_OF_OPT_AD_CAT_PKG.GET_UFK_IGS_PS_OFR_OPT (
499: old_references.coo_id
500: );
501:
502: IGS_PS_OF_OPT_UNT_ST_PKG.GET_FK_IGS_PS_OFR_OPT (

Line 502: IGS_PS_OF_OPT_UNT_ST_PKG.GET_FK_IGS_PS_OFR_OPT (

498: IGS_PS_OF_OPT_AD_CAT_PKG.GET_UFK_IGS_PS_OFR_OPT (
499: old_references.coo_id
500: );
501:
502: IGS_PS_OF_OPT_UNT_ST_PKG.GET_FK_IGS_PS_OFR_OPT (
503: old_references.course_cd,
504: old_references.version_number,
505: old_references.cal_type,
506: old_references.location_cd,

Line 512: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT (

508: old_references.attendance_type
509: );
510:
511:
512: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT (
513: old_references.coo_id
514: );
515:
516: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_PS_OFR_OPT (

Line 516: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_PS_OFR_OPT (

512: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT (
513: old_references.coo_id
514: );
515:
516: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_PS_OFR_OPT (
517: old_references.course_cd,
518: old_references.version_number,
519: old_references.cal_type,
520: old_references.location_cd,

Line 525: IGS_EN_STDNT_PS_ATT_PKG.GET_UFK_IGS_PS_OFR_OPT (

521: old_references.attendance_mode,
522: old_references.attendance_type
523: );
524:
525: IGS_EN_STDNT_PS_ATT_PKG.GET_UFK_IGS_PS_OFR_OPT (
526: old_references.coo_id
527: );
528:
529:

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 570: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);

566:
567: IF (old_references.coo_id = new_references.coo_id) OR (old_references.coo_id IS NULL) THEN
568: NULL;
569: ELSE
570: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
571: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
572: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
573: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
574: IGS_EN_STDNT_PS_ATT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);

Line 571: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);

567: IF (old_references.coo_id = new_references.coo_id) OR (old_references.coo_id IS NULL) THEN
568: NULL;
569: ELSE
570: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
571: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
572: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
573: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
574: IGS_EN_STDNT_PS_ATT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
575: IGS_PS_OF_OPT_AD_CAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);

Line 572: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);

568: NULL;
569: ELSE
570: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
571: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
572: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
573: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
574: IGS_EN_STDNT_PS_ATT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
575: IGS_PS_OF_OPT_AD_CAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
576: END IF;

Line 573: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);

569: ELSE
570: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
571: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
572: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
573: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
574: IGS_EN_STDNT_PS_ATT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
575: IGS_PS_OF_OPT_AD_CAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
576: END IF;
577:

Line 574: IGS_EN_STDNT_PS_ATT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);

570: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
571: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
572: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
573: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
574: IGS_EN_STDNT_PS_ATT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
575: IGS_PS_OF_OPT_AD_CAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
576: END IF;
577:
578: END Check_UK_Child_Existance;

Line 575: IGS_PS_OF_OPT_AD_CAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);

571: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
572: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
573: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
574: IGS_EN_STDNT_PS_ATT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
575: IGS_PS_OF_OPT_AD_CAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
576: END IF;
577:
578: END Check_UK_Child_Existance;
579:

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 931: p_n_coo_id IN igs_ps_ofr_opt.coo_id%TYPE,

927: END IF;
928: END Before_DML;
929:
930: PROCEDURE dflt_prg_ofropt_ref_code(
931: p_n_coo_id IN igs_ps_ofr_opt.coo_id%TYPE,
932: p_message_name OUT NOCOPY VARCHAR2
933: ) AS
934: /************************************************************************
935: Created By : rbezawad

Line 942: CURSOR c_ofr_opt (cp_coo_id igs_ps_ofr_opt.coo_id%TYPE) IS

938: Known limitations, enhancements or remarks:
939: Change History :
940: Who When What
941: *************************************************************************/
942: CURSOR c_ofr_opt (cp_coo_id igs_ps_ofr_opt.coo_id%TYPE) IS
943: SELECT course_cd,
944: version_number,
945: cal_type,
946: location_cd,

Line 949: FROM igs_ps_ofr_opt

945: cal_type,
946: location_cd,
947: attendance_type,
948: attendance_mode
949: FROM igs_ps_ofr_opt
950: WHERE coo_id = cp_coo_id;
951:
952: l_ofr_opt c_ofr_opt%ROWTYPE;
953:

Line 1029: CURSOR c_coo(cp_rowid igs_ps_ofr_opt.row_id%TYPE) IS

1025: p_action IN VARCHAR2,
1026: x_rowid IN VARCHAR2
1027: ) AS
1028: l_message_name VARCHAR2(30) ;
1029: CURSOR c_coo(cp_rowid igs_ps_ofr_opt.row_id%TYPE) IS
1030: SELECT coo_id
1031: FROM igs_ps_ofr_opt
1032: WHERE ROWID = cp_rowid;
1033: l_coo_id igs_ps_ofr_opt.coo_id%TYPE;

Line 1031: FROM igs_ps_ofr_opt

1027: ) AS
1028: l_message_name VARCHAR2(30) ;
1029: CURSOR c_coo(cp_rowid igs_ps_ofr_opt.row_id%TYPE) IS
1030: SELECT coo_id
1031: FROM igs_ps_ofr_opt
1032: WHERE ROWID = cp_rowid;
1033: l_coo_id igs_ps_ofr_opt.coo_id%TYPE;
1034: BEGIN
1035:

Line 1033: l_coo_id igs_ps_ofr_opt.coo_id%TYPE;

1029: CURSOR c_coo(cp_rowid igs_ps_ofr_opt.row_id%TYPE) IS
1030: SELECT coo_id
1031: FROM igs_ps_ofr_opt
1032: WHERE ROWID = cp_rowid;
1033: l_coo_id igs_ps_ofr_opt.coo_id%TYPE;
1034: BEGIN
1035:
1036: l_rowid := x_rowid;
1037:

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;

Line 1751: end IGS_PS_OFR_OPT_PKG;

1747: x_rowid => X_ROWID
1748: );
1749: end DELETE_ROW;
1750:
1751: end IGS_PS_OFR_OPT_PKG;