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_EN_GEN_013 dependencies on IGS_AS_SU_SETATMPT

Line 26: --nalkumar 12-Oct-2001 Added CATALOG_CAL_TYPE and CATALOG_SEQ_NUM parameters to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the

22: -- a call to the delete row of the table IGS_EN_SU_ATTEMPT.This has been replaced with a call to update row
23: -- of the table IGS_EN_SU_ATTEMPT with the unit_attempt_status updated to 'DROPPED'
24: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
25: --
26: --nalkumar 12-Oct-2001 Added CATALOG_CAL_TYPE and CATALOG_SEQ_NUM parameters to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
27: -- Career impact Build Bug# 2027984.
28: --kkillams 20-12-2001 Added attribute_category to attribute20 parameters are added to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
29: -- YOP-EN build Bug No: 2156956.
30: --svenkata 20-Dec-2001 Added columns student_career_transcript and Student_career_statistics as part of build Career

Line 28: --kkillams 20-12-2001 Added attribute_category to attribute20 parameters are added to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the

24: --Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
25: --
26: --nalkumar 12-Oct-2001 Added CATALOG_CAL_TYPE and CATALOG_SEQ_NUM parameters to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
27: -- Career impact Build Bug# 2027984.
28: --kkillams 20-12-2001 Added attribute_category to attribute20 parameters are added to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
29: -- YOP-EN build Bug No: 2156956.
30: --svenkata 20-Dec-2001 Added columns student_career_transcript and Student_career_statistics as part of build Career
31: -- Impact Part2 . Bug #2158626
32: --svenkata 7-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added to table handler

Line 664: -- This module is called when a IGS_AS_SU_SETATMPT is ended (end_dt set).

660:
661: resource_busy_exception EXCEPTION;
662: PRAGMA EXCEPTION_INIT(resource_busy_exception, -54);
663: BEGIN -- enrp_upd_susa_end_dt
664: -- This module is called when a IGS_AS_SU_SETATMPT is ended (end_dt set).
665: -- This module will check if the IGS_PS_UNIT set has any child IGS_PS_UNIT sets and attempt
666: -- to set the end_dt and associated authorisation details for all children.
667: DECLARE
668: v_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE;

Line 668: v_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE;

664: -- This module is called when a IGS_AS_SU_SETATMPT is ended (end_dt set).
665: -- This module will check if the IGS_PS_UNIT set has any child IGS_PS_UNIT sets and attempt
666: -- to set the end_dt and associated authorisation details for all children.
667: DECLARE
668: v_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE;
669: v_us_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE;
670: v_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE;
671: v_authorised_person_id IGS_AS_SU_SETATMPT.authorised_person_id%TYPE;
672: v_authorised_on IGS_AS_SU_SETATMPT.authorised_on%TYPE;

Line 669: v_us_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE;

665: -- This module will check if the IGS_PS_UNIT set has any child IGS_PS_UNIT sets and attempt
666: -- to set the end_dt and associated authorisation details for all children.
667: DECLARE
668: v_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE;
669: v_us_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE;
670: v_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE;
671: v_authorised_person_id IGS_AS_SU_SETATMPT.authorised_person_id%TYPE;
672: v_authorised_on IGS_AS_SU_SETATMPT.authorised_on%TYPE;
673: v_selection_dt IGS_AS_SU_SETATMPT.selection_dt%TYPE;

Line 670: v_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE;

666: -- to set the end_dt and associated authorisation details for all children.
667: DECLARE
668: v_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE;
669: v_us_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE;
670: v_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE;
671: v_authorised_person_id IGS_AS_SU_SETATMPT.authorised_person_id%TYPE;
672: v_authorised_on IGS_AS_SU_SETATMPT.authorised_on%TYPE;
673: v_selection_dt IGS_AS_SU_SETATMPT.selection_dt%TYPE;
674: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;

Line 671: v_authorised_person_id IGS_AS_SU_SETATMPT.authorised_person_id%TYPE;

667: DECLARE
668: v_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE;
669: v_us_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE;
670: v_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE;
671: v_authorised_person_id IGS_AS_SU_SETATMPT.authorised_person_id%TYPE;
672: v_authorised_on IGS_AS_SU_SETATMPT.authorised_on%TYPE;
673: v_selection_dt IGS_AS_SU_SETATMPT.selection_dt%TYPE;
674: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
675: v_rqrmnts_complete_dt IGS_AS_SU_SETATMPT.rqrmnts_complete_dt%TYPE;

Line 672: v_authorised_on IGS_AS_SU_SETATMPT.authorised_on%TYPE;

668: v_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE;
669: v_us_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE;
670: v_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE;
671: v_authorised_person_id IGS_AS_SU_SETATMPT.authorised_person_id%TYPE;
672: v_authorised_on IGS_AS_SU_SETATMPT.authorised_on%TYPE;
673: v_selection_dt IGS_AS_SU_SETATMPT.selection_dt%TYPE;
674: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
675: v_rqrmnts_complete_dt IGS_AS_SU_SETATMPT.rqrmnts_complete_dt%TYPE;
676: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.parent_unit_set_cd%TYPE;

Line 673: v_selection_dt IGS_AS_SU_SETATMPT.selection_dt%TYPE;

669: v_us_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE;
670: v_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE;
671: v_authorised_person_id IGS_AS_SU_SETATMPT.authorised_person_id%TYPE;
672: v_authorised_on IGS_AS_SU_SETATMPT.authorised_on%TYPE;
673: v_selection_dt IGS_AS_SU_SETATMPT.selection_dt%TYPE;
674: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
675: v_rqrmnts_complete_dt IGS_AS_SU_SETATMPT.rqrmnts_complete_dt%TYPE;
676: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.parent_unit_set_cd%TYPE;
677: v_parent_sequence_number IGS_AS_SU_SETATMPT.parent_sequence_number%TYPE;

Line 674: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;

670: v_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE;
671: v_authorised_person_id IGS_AS_SU_SETATMPT.authorised_person_id%TYPE;
672: v_authorised_on IGS_AS_SU_SETATMPT.authorised_on%TYPE;
673: v_selection_dt IGS_AS_SU_SETATMPT.selection_dt%TYPE;
674: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
675: v_rqrmnts_complete_dt IGS_AS_SU_SETATMPT.rqrmnts_complete_dt%TYPE;
676: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.parent_unit_set_cd%TYPE;
677: v_parent_sequence_number IGS_AS_SU_SETATMPT.parent_sequence_number%TYPE;
678: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;

Line 675: v_rqrmnts_complete_dt IGS_AS_SU_SETATMPT.rqrmnts_complete_dt%TYPE;

671: v_authorised_person_id IGS_AS_SU_SETATMPT.authorised_person_id%TYPE;
672: v_authorised_on IGS_AS_SU_SETATMPT.authorised_on%TYPE;
673: v_selection_dt IGS_AS_SU_SETATMPT.selection_dt%TYPE;
674: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
675: v_rqrmnts_complete_dt IGS_AS_SU_SETATMPT.rqrmnts_complete_dt%TYPE;
676: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.parent_unit_set_cd%TYPE;
677: v_parent_sequence_number IGS_AS_SU_SETATMPT.parent_sequence_number%TYPE;
678: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
679: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;

Line 676: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.parent_unit_set_cd%TYPE;

672: v_authorised_on IGS_AS_SU_SETATMPT.authorised_on%TYPE;
673: v_selection_dt IGS_AS_SU_SETATMPT.selection_dt%TYPE;
674: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
675: v_rqrmnts_complete_dt IGS_AS_SU_SETATMPT.rqrmnts_complete_dt%TYPE;
676: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.parent_unit_set_cd%TYPE;
677: v_parent_sequence_number IGS_AS_SU_SETATMPT.parent_sequence_number%TYPE;
678: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
679: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
680: v_voluntary_end_ind IGS_AS_SU_SETATMPT.voluntary_end_ind%TYPE;

Line 677: v_parent_sequence_number IGS_AS_SU_SETATMPT.parent_sequence_number%TYPE;

673: v_selection_dt IGS_AS_SU_SETATMPT.selection_dt%TYPE;
674: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
675: v_rqrmnts_complete_dt IGS_AS_SU_SETATMPT.rqrmnts_complete_dt%TYPE;
676: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.parent_unit_set_cd%TYPE;
677: v_parent_sequence_number IGS_AS_SU_SETATMPT.parent_sequence_number%TYPE;
678: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
679: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
680: v_voluntary_end_ind IGS_AS_SU_SETATMPT.voluntary_end_ind%TYPE;
681: v_override_title IGS_AS_SU_SETATMPT.override_title%TYPE;

Line 678: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;

674: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
675: v_rqrmnts_complete_dt IGS_AS_SU_SETATMPT.rqrmnts_complete_dt%TYPE;
676: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.parent_unit_set_cd%TYPE;
677: v_parent_sequence_number IGS_AS_SU_SETATMPT.parent_sequence_number%TYPE;
678: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
679: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
680: v_voluntary_end_ind IGS_AS_SU_SETATMPT.voluntary_end_ind%TYPE;
681: v_override_title IGS_AS_SU_SETATMPT.override_title%TYPE;
682: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;

Line 679: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;

675: v_rqrmnts_complete_dt IGS_AS_SU_SETATMPT.rqrmnts_complete_dt%TYPE;
676: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.parent_unit_set_cd%TYPE;
677: v_parent_sequence_number IGS_AS_SU_SETATMPT.parent_sequence_number%TYPE;
678: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
679: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
680: v_voluntary_end_ind IGS_AS_SU_SETATMPT.voluntary_end_ind%TYPE;
681: v_override_title IGS_AS_SU_SETATMPT.override_title%TYPE;
682: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
683: v_s_completed_source_type IGS_AS_SU_SETATMPT.s_completed_source_type%TYPE;

Line 680: v_voluntary_end_ind IGS_AS_SU_SETATMPT.voluntary_end_ind%TYPE;

676: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.parent_unit_set_cd%TYPE;
677: v_parent_sequence_number IGS_AS_SU_SETATMPT.parent_sequence_number%TYPE;
678: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
679: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
680: v_voluntary_end_ind IGS_AS_SU_SETATMPT.voluntary_end_ind%TYPE;
681: v_override_title IGS_AS_SU_SETATMPT.override_title%TYPE;
682: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
683: v_s_completed_source_type IGS_AS_SU_SETATMPT.s_completed_source_type%TYPE;
684: v_catalog_cal_type IGS_AS_SU_SETATMPT.catalog_cal_type%TYPE;

Line 681: v_override_title IGS_AS_SU_SETATMPT.override_title%TYPE;

677: v_parent_sequence_number IGS_AS_SU_SETATMPT.parent_sequence_number%TYPE;
678: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
679: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
680: v_voluntary_end_ind IGS_AS_SU_SETATMPT.voluntary_end_ind%TYPE;
681: v_override_title IGS_AS_SU_SETATMPT.override_title%TYPE;
682: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
683: v_s_completed_source_type IGS_AS_SU_SETATMPT.s_completed_source_type%TYPE;
684: v_catalog_cal_type IGS_AS_SU_SETATMPT.catalog_cal_type%TYPE;
685: v_catalog_seq_num IGS_AS_SU_SETATMPT.catalog_seq_num%TYPE;

Line 682: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;

678: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
679: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
680: v_voluntary_end_ind IGS_AS_SU_SETATMPT.voluntary_end_ind%TYPE;
681: v_override_title IGS_AS_SU_SETATMPT.override_title%TYPE;
682: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
683: v_s_completed_source_type IGS_AS_SU_SETATMPT.s_completed_source_type%TYPE;
684: v_catalog_cal_type IGS_AS_SU_SETATMPT.catalog_cal_type%TYPE;
685: v_catalog_seq_num IGS_AS_SU_SETATMPT.catalog_seq_num%TYPE;
686: --kkillams attribute_category to attribute20 variables are added w.r.t to YOP-EN bug id :2156956

Line 683: v_s_completed_source_type IGS_AS_SU_SETATMPT.s_completed_source_type%TYPE;

679: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
680: v_voluntary_end_ind IGS_AS_SU_SETATMPT.voluntary_end_ind%TYPE;
681: v_override_title IGS_AS_SU_SETATMPT.override_title%TYPE;
682: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
683: v_s_completed_source_type IGS_AS_SU_SETATMPT.s_completed_source_type%TYPE;
684: v_catalog_cal_type IGS_AS_SU_SETATMPT.catalog_cal_type%TYPE;
685: v_catalog_seq_num IGS_AS_SU_SETATMPT.catalog_seq_num%TYPE;
686: --kkillams attribute_category to attribute20 variables are added w.r.t to YOP-EN bug id :2156956
687: v_attribute_category IGS_AS_SU_SETATMPT.attribute_category%TYPE;

Line 684: v_catalog_cal_type IGS_AS_SU_SETATMPT.catalog_cal_type%TYPE;

680: v_voluntary_end_ind IGS_AS_SU_SETATMPT.voluntary_end_ind%TYPE;
681: v_override_title IGS_AS_SU_SETATMPT.override_title%TYPE;
682: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
683: v_s_completed_source_type IGS_AS_SU_SETATMPT.s_completed_source_type%TYPE;
684: v_catalog_cal_type IGS_AS_SU_SETATMPT.catalog_cal_type%TYPE;
685: v_catalog_seq_num IGS_AS_SU_SETATMPT.catalog_seq_num%TYPE;
686: --kkillams attribute_category to attribute20 variables are added w.r.t to YOP-EN bug id :2156956
687: v_attribute_category IGS_AS_SU_SETATMPT.attribute_category%TYPE;
688: v_attribute1 IGS_AS_SU_SETATMPT.attribute1%TYPE;

Line 685: v_catalog_seq_num IGS_AS_SU_SETATMPT.catalog_seq_num%TYPE;

681: v_override_title IGS_AS_SU_SETATMPT.override_title%TYPE;
682: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
683: v_s_completed_source_type IGS_AS_SU_SETATMPT.s_completed_source_type%TYPE;
684: v_catalog_cal_type IGS_AS_SU_SETATMPT.catalog_cal_type%TYPE;
685: v_catalog_seq_num IGS_AS_SU_SETATMPT.catalog_seq_num%TYPE;
686: --kkillams attribute_category to attribute20 variables are added w.r.t to YOP-EN bug id :2156956
687: v_attribute_category IGS_AS_SU_SETATMPT.attribute_category%TYPE;
688: v_attribute1 IGS_AS_SU_SETATMPT.attribute1%TYPE;
689: v_attribute2 IGS_AS_SU_SETATMPT.attribute2%TYPE;

Line 687: v_attribute_category IGS_AS_SU_SETATMPT.attribute_category%TYPE;

683: v_s_completed_source_type IGS_AS_SU_SETATMPT.s_completed_source_type%TYPE;
684: v_catalog_cal_type IGS_AS_SU_SETATMPT.catalog_cal_type%TYPE;
685: v_catalog_seq_num IGS_AS_SU_SETATMPT.catalog_seq_num%TYPE;
686: --kkillams attribute_category to attribute20 variables are added w.r.t to YOP-EN bug id :2156956
687: v_attribute_category IGS_AS_SU_SETATMPT.attribute_category%TYPE;
688: v_attribute1 IGS_AS_SU_SETATMPT.attribute1%TYPE;
689: v_attribute2 IGS_AS_SU_SETATMPT.attribute2%TYPE;
690: v_attribute3 IGS_AS_SU_SETATMPT.attribute3%TYPE;
691: v_attribute4 IGS_AS_SU_SETATMPT.attribute4%TYPE;

Line 688: v_attribute1 IGS_AS_SU_SETATMPT.attribute1%TYPE;

684: v_catalog_cal_type IGS_AS_SU_SETATMPT.catalog_cal_type%TYPE;
685: v_catalog_seq_num IGS_AS_SU_SETATMPT.catalog_seq_num%TYPE;
686: --kkillams attribute_category to attribute20 variables are added w.r.t to YOP-EN bug id :2156956
687: v_attribute_category IGS_AS_SU_SETATMPT.attribute_category%TYPE;
688: v_attribute1 IGS_AS_SU_SETATMPT.attribute1%TYPE;
689: v_attribute2 IGS_AS_SU_SETATMPT.attribute2%TYPE;
690: v_attribute3 IGS_AS_SU_SETATMPT.attribute3%TYPE;
691: v_attribute4 IGS_AS_SU_SETATMPT.attribute4%TYPE;
692: v_attribute5 IGS_AS_SU_SETATMPT.attribute5%TYPE;

Line 689: v_attribute2 IGS_AS_SU_SETATMPT.attribute2%TYPE;

685: v_catalog_seq_num IGS_AS_SU_SETATMPT.catalog_seq_num%TYPE;
686: --kkillams attribute_category to attribute20 variables are added w.r.t to YOP-EN bug id :2156956
687: v_attribute_category IGS_AS_SU_SETATMPT.attribute_category%TYPE;
688: v_attribute1 IGS_AS_SU_SETATMPT.attribute1%TYPE;
689: v_attribute2 IGS_AS_SU_SETATMPT.attribute2%TYPE;
690: v_attribute3 IGS_AS_SU_SETATMPT.attribute3%TYPE;
691: v_attribute4 IGS_AS_SU_SETATMPT.attribute4%TYPE;
692: v_attribute5 IGS_AS_SU_SETATMPT.attribute5%TYPE;
693: v_attribute6 IGS_AS_SU_SETATMPT.attribute6%TYPE;

Line 690: v_attribute3 IGS_AS_SU_SETATMPT.attribute3%TYPE;

686: --kkillams attribute_category to attribute20 variables are added w.r.t to YOP-EN bug id :2156956
687: v_attribute_category IGS_AS_SU_SETATMPT.attribute_category%TYPE;
688: v_attribute1 IGS_AS_SU_SETATMPT.attribute1%TYPE;
689: v_attribute2 IGS_AS_SU_SETATMPT.attribute2%TYPE;
690: v_attribute3 IGS_AS_SU_SETATMPT.attribute3%TYPE;
691: v_attribute4 IGS_AS_SU_SETATMPT.attribute4%TYPE;
692: v_attribute5 IGS_AS_SU_SETATMPT.attribute5%TYPE;
693: v_attribute6 IGS_AS_SU_SETATMPT.attribute6%TYPE;
694: v_attribute7 IGS_AS_SU_SETATMPT.attribute7%TYPE;

Line 691: v_attribute4 IGS_AS_SU_SETATMPT.attribute4%TYPE;

687: v_attribute_category IGS_AS_SU_SETATMPT.attribute_category%TYPE;
688: v_attribute1 IGS_AS_SU_SETATMPT.attribute1%TYPE;
689: v_attribute2 IGS_AS_SU_SETATMPT.attribute2%TYPE;
690: v_attribute3 IGS_AS_SU_SETATMPT.attribute3%TYPE;
691: v_attribute4 IGS_AS_SU_SETATMPT.attribute4%TYPE;
692: v_attribute5 IGS_AS_SU_SETATMPT.attribute5%TYPE;
693: v_attribute6 IGS_AS_SU_SETATMPT.attribute6%TYPE;
694: v_attribute7 IGS_AS_SU_SETATMPT.attribute7%TYPE;
695: v_attribute8 IGS_AS_SU_SETATMPT.attribute8%TYPE;

Line 692: v_attribute5 IGS_AS_SU_SETATMPT.attribute5%TYPE;

688: v_attribute1 IGS_AS_SU_SETATMPT.attribute1%TYPE;
689: v_attribute2 IGS_AS_SU_SETATMPT.attribute2%TYPE;
690: v_attribute3 IGS_AS_SU_SETATMPT.attribute3%TYPE;
691: v_attribute4 IGS_AS_SU_SETATMPT.attribute4%TYPE;
692: v_attribute5 IGS_AS_SU_SETATMPT.attribute5%TYPE;
693: v_attribute6 IGS_AS_SU_SETATMPT.attribute6%TYPE;
694: v_attribute7 IGS_AS_SU_SETATMPT.attribute7%TYPE;
695: v_attribute8 IGS_AS_SU_SETATMPT.attribute8%TYPE;
696: v_attribute9 IGS_AS_SU_SETATMPT.attribute9%TYPE;

Line 693: v_attribute6 IGS_AS_SU_SETATMPT.attribute6%TYPE;

689: v_attribute2 IGS_AS_SU_SETATMPT.attribute2%TYPE;
690: v_attribute3 IGS_AS_SU_SETATMPT.attribute3%TYPE;
691: v_attribute4 IGS_AS_SU_SETATMPT.attribute4%TYPE;
692: v_attribute5 IGS_AS_SU_SETATMPT.attribute5%TYPE;
693: v_attribute6 IGS_AS_SU_SETATMPT.attribute6%TYPE;
694: v_attribute7 IGS_AS_SU_SETATMPT.attribute7%TYPE;
695: v_attribute8 IGS_AS_SU_SETATMPT.attribute8%TYPE;
696: v_attribute9 IGS_AS_SU_SETATMPT.attribute9%TYPE;
697: v_attribute10 IGS_AS_SU_SETATMPT.attribute10%TYPE;

Line 694: v_attribute7 IGS_AS_SU_SETATMPT.attribute7%TYPE;

690: v_attribute3 IGS_AS_SU_SETATMPT.attribute3%TYPE;
691: v_attribute4 IGS_AS_SU_SETATMPT.attribute4%TYPE;
692: v_attribute5 IGS_AS_SU_SETATMPT.attribute5%TYPE;
693: v_attribute6 IGS_AS_SU_SETATMPT.attribute6%TYPE;
694: v_attribute7 IGS_AS_SU_SETATMPT.attribute7%TYPE;
695: v_attribute8 IGS_AS_SU_SETATMPT.attribute8%TYPE;
696: v_attribute9 IGS_AS_SU_SETATMPT.attribute9%TYPE;
697: v_attribute10 IGS_AS_SU_SETATMPT.attribute10%TYPE;
698: v_attribute11 IGS_AS_SU_SETATMPT.attribute11%TYPE;

Line 695: v_attribute8 IGS_AS_SU_SETATMPT.attribute8%TYPE;

691: v_attribute4 IGS_AS_SU_SETATMPT.attribute4%TYPE;
692: v_attribute5 IGS_AS_SU_SETATMPT.attribute5%TYPE;
693: v_attribute6 IGS_AS_SU_SETATMPT.attribute6%TYPE;
694: v_attribute7 IGS_AS_SU_SETATMPT.attribute7%TYPE;
695: v_attribute8 IGS_AS_SU_SETATMPT.attribute8%TYPE;
696: v_attribute9 IGS_AS_SU_SETATMPT.attribute9%TYPE;
697: v_attribute10 IGS_AS_SU_SETATMPT.attribute10%TYPE;
698: v_attribute11 IGS_AS_SU_SETATMPT.attribute11%TYPE;
699: v_attribute12 IGS_AS_SU_SETATMPT.attribute12%TYPE;

Line 696: v_attribute9 IGS_AS_SU_SETATMPT.attribute9%TYPE;

692: v_attribute5 IGS_AS_SU_SETATMPT.attribute5%TYPE;
693: v_attribute6 IGS_AS_SU_SETATMPT.attribute6%TYPE;
694: v_attribute7 IGS_AS_SU_SETATMPT.attribute7%TYPE;
695: v_attribute8 IGS_AS_SU_SETATMPT.attribute8%TYPE;
696: v_attribute9 IGS_AS_SU_SETATMPT.attribute9%TYPE;
697: v_attribute10 IGS_AS_SU_SETATMPT.attribute10%TYPE;
698: v_attribute11 IGS_AS_SU_SETATMPT.attribute11%TYPE;
699: v_attribute12 IGS_AS_SU_SETATMPT.attribute12%TYPE;
700: v_attribute13 IGS_AS_SU_SETATMPT.attribute13%TYPE;

Line 697: v_attribute10 IGS_AS_SU_SETATMPT.attribute10%TYPE;

693: v_attribute6 IGS_AS_SU_SETATMPT.attribute6%TYPE;
694: v_attribute7 IGS_AS_SU_SETATMPT.attribute7%TYPE;
695: v_attribute8 IGS_AS_SU_SETATMPT.attribute8%TYPE;
696: v_attribute9 IGS_AS_SU_SETATMPT.attribute9%TYPE;
697: v_attribute10 IGS_AS_SU_SETATMPT.attribute10%TYPE;
698: v_attribute11 IGS_AS_SU_SETATMPT.attribute11%TYPE;
699: v_attribute12 IGS_AS_SU_SETATMPT.attribute12%TYPE;
700: v_attribute13 IGS_AS_SU_SETATMPT.attribute13%TYPE;
701: v_attribute14 IGS_AS_SU_SETATMPT.attribute14%TYPE;

Line 698: v_attribute11 IGS_AS_SU_SETATMPT.attribute11%TYPE;

694: v_attribute7 IGS_AS_SU_SETATMPT.attribute7%TYPE;
695: v_attribute8 IGS_AS_SU_SETATMPT.attribute8%TYPE;
696: v_attribute9 IGS_AS_SU_SETATMPT.attribute9%TYPE;
697: v_attribute10 IGS_AS_SU_SETATMPT.attribute10%TYPE;
698: v_attribute11 IGS_AS_SU_SETATMPT.attribute11%TYPE;
699: v_attribute12 IGS_AS_SU_SETATMPT.attribute12%TYPE;
700: v_attribute13 IGS_AS_SU_SETATMPT.attribute13%TYPE;
701: v_attribute14 IGS_AS_SU_SETATMPT.attribute14%TYPE;
702: v_attribute15 IGS_AS_SU_SETATMPT.attribute15%TYPE;

Line 699: v_attribute12 IGS_AS_SU_SETATMPT.attribute12%TYPE;

695: v_attribute8 IGS_AS_SU_SETATMPT.attribute8%TYPE;
696: v_attribute9 IGS_AS_SU_SETATMPT.attribute9%TYPE;
697: v_attribute10 IGS_AS_SU_SETATMPT.attribute10%TYPE;
698: v_attribute11 IGS_AS_SU_SETATMPT.attribute11%TYPE;
699: v_attribute12 IGS_AS_SU_SETATMPT.attribute12%TYPE;
700: v_attribute13 IGS_AS_SU_SETATMPT.attribute13%TYPE;
701: v_attribute14 IGS_AS_SU_SETATMPT.attribute14%TYPE;
702: v_attribute15 IGS_AS_SU_SETATMPT.attribute15%TYPE;
703: v_attribute16 IGS_AS_SU_SETATMPT.attribute16%TYPE;

Line 700: v_attribute13 IGS_AS_SU_SETATMPT.attribute13%TYPE;

696: v_attribute9 IGS_AS_SU_SETATMPT.attribute9%TYPE;
697: v_attribute10 IGS_AS_SU_SETATMPT.attribute10%TYPE;
698: v_attribute11 IGS_AS_SU_SETATMPT.attribute11%TYPE;
699: v_attribute12 IGS_AS_SU_SETATMPT.attribute12%TYPE;
700: v_attribute13 IGS_AS_SU_SETATMPT.attribute13%TYPE;
701: v_attribute14 IGS_AS_SU_SETATMPT.attribute14%TYPE;
702: v_attribute15 IGS_AS_SU_SETATMPT.attribute15%TYPE;
703: v_attribute16 IGS_AS_SU_SETATMPT.attribute16%TYPE;
704: v_attribute17 IGS_AS_SU_SETATMPT.attribute17%TYPE;

Line 701: v_attribute14 IGS_AS_SU_SETATMPT.attribute14%TYPE;

697: v_attribute10 IGS_AS_SU_SETATMPT.attribute10%TYPE;
698: v_attribute11 IGS_AS_SU_SETATMPT.attribute11%TYPE;
699: v_attribute12 IGS_AS_SU_SETATMPT.attribute12%TYPE;
700: v_attribute13 IGS_AS_SU_SETATMPT.attribute13%TYPE;
701: v_attribute14 IGS_AS_SU_SETATMPT.attribute14%TYPE;
702: v_attribute15 IGS_AS_SU_SETATMPT.attribute15%TYPE;
703: v_attribute16 IGS_AS_SU_SETATMPT.attribute16%TYPE;
704: v_attribute17 IGS_AS_SU_SETATMPT.attribute17%TYPE;
705: v_attribute18 IGS_AS_SU_SETATMPT.attribute18%TYPE;

Line 702: v_attribute15 IGS_AS_SU_SETATMPT.attribute15%TYPE;

698: v_attribute11 IGS_AS_SU_SETATMPT.attribute11%TYPE;
699: v_attribute12 IGS_AS_SU_SETATMPT.attribute12%TYPE;
700: v_attribute13 IGS_AS_SU_SETATMPT.attribute13%TYPE;
701: v_attribute14 IGS_AS_SU_SETATMPT.attribute14%TYPE;
702: v_attribute15 IGS_AS_SU_SETATMPT.attribute15%TYPE;
703: v_attribute16 IGS_AS_SU_SETATMPT.attribute16%TYPE;
704: v_attribute17 IGS_AS_SU_SETATMPT.attribute17%TYPE;
705: v_attribute18 IGS_AS_SU_SETATMPT.attribute18%TYPE;
706: v_attribute19 IGS_AS_SU_SETATMPT.attribute19%TYPE;

Line 703: v_attribute16 IGS_AS_SU_SETATMPT.attribute16%TYPE;

699: v_attribute12 IGS_AS_SU_SETATMPT.attribute12%TYPE;
700: v_attribute13 IGS_AS_SU_SETATMPT.attribute13%TYPE;
701: v_attribute14 IGS_AS_SU_SETATMPT.attribute14%TYPE;
702: v_attribute15 IGS_AS_SU_SETATMPT.attribute15%TYPE;
703: v_attribute16 IGS_AS_SU_SETATMPT.attribute16%TYPE;
704: v_attribute17 IGS_AS_SU_SETATMPT.attribute17%TYPE;
705: v_attribute18 IGS_AS_SU_SETATMPT.attribute18%TYPE;
706: v_attribute19 IGS_AS_SU_SETATMPT.attribute19%TYPE;
707: v_attribute20 IGS_AS_SU_SETATMPT.attribute20%TYPE;

Line 704: v_attribute17 IGS_AS_SU_SETATMPT.attribute17%TYPE;

700: v_attribute13 IGS_AS_SU_SETATMPT.attribute13%TYPE;
701: v_attribute14 IGS_AS_SU_SETATMPT.attribute14%TYPE;
702: v_attribute15 IGS_AS_SU_SETATMPT.attribute15%TYPE;
703: v_attribute16 IGS_AS_SU_SETATMPT.attribute16%TYPE;
704: v_attribute17 IGS_AS_SU_SETATMPT.attribute17%TYPE;
705: v_attribute18 IGS_AS_SU_SETATMPT.attribute18%TYPE;
706: v_attribute19 IGS_AS_SU_SETATMPT.attribute19%TYPE;
707: v_attribute20 IGS_AS_SU_SETATMPT.attribute20%TYPE;
708: v_message_name VARCHAR2(30);

Line 705: v_attribute18 IGS_AS_SU_SETATMPT.attribute18%TYPE;

701: v_attribute14 IGS_AS_SU_SETATMPT.attribute14%TYPE;
702: v_attribute15 IGS_AS_SU_SETATMPT.attribute15%TYPE;
703: v_attribute16 IGS_AS_SU_SETATMPT.attribute16%TYPE;
704: v_attribute17 IGS_AS_SU_SETATMPT.attribute17%TYPE;
705: v_attribute18 IGS_AS_SU_SETATMPT.attribute18%TYPE;
706: v_attribute19 IGS_AS_SU_SETATMPT.attribute19%TYPE;
707: v_attribute20 IGS_AS_SU_SETATMPT.attribute20%TYPE;
708: v_message_name VARCHAR2(30);
709: v_message_text VARCHAR2(2000);

Line 706: v_attribute19 IGS_AS_SU_SETATMPT.attribute19%TYPE;

702: v_attribute15 IGS_AS_SU_SETATMPT.attribute15%TYPE;
703: v_attribute16 IGS_AS_SU_SETATMPT.attribute16%TYPE;
704: v_attribute17 IGS_AS_SU_SETATMPT.attribute17%TYPE;
705: v_attribute18 IGS_AS_SU_SETATMPT.attribute18%TYPE;
706: v_attribute19 IGS_AS_SU_SETATMPT.attribute19%TYPE;
707: v_attribute20 IGS_AS_SU_SETATMPT.attribute20%TYPE;
708: v_message_name VARCHAR2(30);
709: v_message_text VARCHAR2(2000);
710: v_rowid ROWID;

Line 707: v_attribute20 IGS_AS_SU_SETATMPT.attribute20%TYPE;

703: v_attribute16 IGS_AS_SU_SETATMPT.attribute16%TYPE;
704: v_attribute17 IGS_AS_SU_SETATMPT.attribute17%TYPE;
705: v_attribute18 IGS_AS_SU_SETATMPT.attribute18%TYPE;
706: v_attribute19 IGS_AS_SU_SETATMPT.attribute19%TYPE;
707: v_attribute20 IGS_AS_SU_SETATMPT.attribute20%TYPE;
708: v_message_name VARCHAR2(30);
709: v_message_text VARCHAR2(2000);
710: v_rowid ROWID;
711:

Line 753: FROM IGS_AS_SU_SETATMPT susa

749: susa.attribute17,
750: susa.attribute18,
751: susa.attribute19,
752: susa.attribute20
753: FROM IGS_AS_SU_SETATMPT susa
754: START WITH susa.person_id = p_person_id AND
755: susa.course_cd = p_course_cd AND
756: susa.parent_unit_set_cd = p_unit_set_cd AND
757: susa.parent_sequence_number = p_sequence_number

Line 863: X_TABLE_NAME =>'IGS_AS_SU_SETATMPT',

859: -- Inserts a record into the s_disable_table_trigger
860: -- database table.
861: IGS_GE_S_DSB_TAB_TRG_PKG.INSERT_ROW(
862: X_ROWID => L_ROWID ,
863: X_TABLE_NAME =>'IGS_AS_SU_SETATMPT',
864: X_SESSION_ID => userenv('SESSIONID'),
865: x_mode => 'R'
866: );
867:

Line 871: -- to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the

867:
868: -- If valid, then end the IGS_PS_UNIT set attempt.
869:
870: -- Added CATALOG_CAL_TYPE and CATALOG_SEQ_NUM parameters
871: -- to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
872: -- Career impact Build Bug# 2027984.
873:
874: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW(
875: X_ROWID => V_ROWID,

Line 874: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW(

870: -- Added CATALOG_CAL_TYPE and CATALOG_SEQ_NUM parameters
871: -- to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
872: -- Career impact Build Bug# 2027984.
873:
874: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW(
875: X_ROWID => V_ROWID,
876: X_PERSON_ID => P_PERSON_ID,
877: X_COURSE_CD => P_COURSE_CD,
878: X_UNIT_SET_CD => V_UNIT_SET_CD,

Line 897: X_ATTRIBUTE1 => V_ATTRIBUTE1, --IGS_AS_SU_SETATMPT_PKG.update_row call w.r.t to YOP-EN bug id :2156956

893: X_S_COMPLETED_SOURCE_TYPE => V_S_COMPLETED_SOURCE_TYPE,
894: X_CATALOG_CAL_TYPE => V_CATALOG_CAL_TYPE,
895: X_CATALOG_SEQ_NUM => V_CATALOG_SEQ_NUM,
896: X_ATTRIBUTE_CATEGORY => V_ATTRIBUTE_CATEGORY, --kkillams attribute_category to attribute20 parameters are added to
897: X_ATTRIBUTE1 => V_ATTRIBUTE1, --IGS_AS_SU_SETATMPT_PKG.update_row call w.r.t to YOP-EN bug id :2156956
898: X_ATTRIBUTE2 => V_ATTRIBUTE2,
899: X_ATTRIBUTE3 => V_ATTRIBUTE3,
900: X_ATTRIBUTE4 => V_ATTRIBUTE4,
901: X_ATTRIBUTE5 => V_ATTRIBUTE5,

Line 922: IGS_GE_MNT_SDTT.genp_del_sdtt('IGS_AS_SU_SETATMPT');

918:
919:
920:
921: -- Re-enable triggers for the session.
922: IGS_GE_MNT_SDTT.genp_del_sdtt('IGS_AS_SU_SETATMPT');
923: END IF;
924: FETCH c_susa INTO v_rowid,
925: v_unit_set_cd,
926: v_us_version_number,

Line 1053: FROM IGS_AS_SU_SETATMPT susa

1049: susa.attribute17,
1050: susa.attribute18,
1051: susa.attribute19,
1052: susa.attribute20
1053: FROM IGS_AS_SU_SETATMPT susa
1054: START WITH susa.person_id = p_person_id AND
1055: susa.course_cd = p_course_cd AND
1056: susa.parent_unit_set_cd = p_unit_set_cd AND
1057: susa.parent_sequence_number = p_sequence_number

Line 1119: X_TABLE_NAME =>'IGS_AS_SU_SETATMPT',

1115: -- Inserts a record into the s_disable_table_trigger
1116: -- database table.
1117: IGS_GE_S_DSB_TAB_TRG_PKG.INSERT_ROW(
1118: X_ROWID => L_ROWID ,
1119: X_TABLE_NAME =>'IGS_AS_SU_SETATMPT',
1120: X_SESSION_ID => userenv('SESSIONID'),
1121: x_mode => 'R'
1122: );
1123:

Line 1127: -- to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the

1123:
1124: -- If valid, then unset the student confirmed indicator.
1125:
1126: -- Added CATALOG_CAL_TYPE and CATALOG_SEQ_NUM parameters
1127: -- to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
1128: -- Career impact Build Bug# 2027984.
1129:
1130: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW(X_ROWID => v_susa_rec.rowid,
1131: X_PERSON_ID => P_PERSON_ID,

Line 1130: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW(X_ROWID => v_susa_rec.rowid,

1126: -- Added CATALOG_CAL_TYPE and CATALOG_SEQ_NUM parameters
1127: -- to call IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW as per the
1128: -- Career impact Build Bug# 2027984.
1129:
1130: IGS_AS_SU_SETATMPT_PKG.UPDATE_ROW(X_ROWID => v_susa_rec.rowid,
1131: X_PERSON_ID => P_PERSON_ID,
1132: X_COURSE_CD => P_COURSE_CD,
1133: X_UNIT_SET_CD => v_susa_rec.unit_set_cd,
1134: X_SEQUENCE_NUMBER => v_susa_rec.sequence_number,

Line 1152: X_ATTRIBUTE1 => v_susa_rec.attribute1, --IGS_AS_SU_SETATMPT_PKG.update_row call w.r.t to YOP-EN bug id :2156956

1148: X_S_COMPLETED_SOURCE_TYPE => v_susa_rec.s_completed_source_type,
1149: X_CATALOG_CAL_TYPE => v_susa_rec.catalog_cal_type,
1150: X_CATALOG_SEQ_NUM => v_susa_rec.catalog_seq_num,
1151: X_ATTRIBUTE_CATEGORY => v_susa_rec.attribute_category, --kkillams attribute_category to attribute20 parameters are added to
1152: X_ATTRIBUTE1 => v_susa_rec.attribute1, --IGS_AS_SU_SETATMPT_PKG.update_row call w.r.t to YOP-EN bug id :2156956
1153: X_ATTRIBUTE2 => v_susa_rec.attribute2,
1154: X_ATTRIBUTE3 => v_susa_rec.attribute3,
1155: X_ATTRIBUTE4 => v_susa_rec.attribute4,
1156: X_ATTRIBUTE5 => v_susa_rec.attribute5,

Line 1177: IGS_GE_MNT_SDTT.genp_del_sdtt('IGS_AS_SU_SETATMPT');

1173: );
1174:
1175:
1176: -- Re-enable triggers for the session.
1177: IGS_GE_MNT_SDTT.genp_del_sdtt('IGS_AS_SU_SETATMPT');
1178: END IF;
1179: END LOOP;
1180: IF (v_susa_rec_found = TRUE AND
1181: v_enrp_val_susa_sci = FALSE) THEN