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_AD_SS_GEN_001 dependencies on IGS_AD_UNIT_SETS

Line 54: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,

50: p_adm_appl_id IN NUMBER,
51: p_admission_appl_number IN NUMBER);
52: --dhan
53: --modified insert_unit_set_dtls, doesn't have major code 1, 2 SS Bug 2622488
54: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,
55: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
56: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
57: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
58: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE);

Line 55: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,

51: p_admission_appl_number IN NUMBER);
52: --dhan
53: --modified insert_unit_set_dtls, doesn't have major code 1, 2 SS Bug 2622488
54: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,
55: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
56: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
57: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
58: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE);
59: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE

Line 56: p_person_id IN igs_ad_unit_sets.person_id%TYPE,

52: --dhan
53: --modified insert_unit_set_dtls, doesn't have major code 1, 2 SS Bug 2622488
54: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,
55: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
56: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
57: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
58: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE);
59: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE
60: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE);

Line 57: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,

53: --modified insert_unit_set_dtls, doesn't have major code 1, 2 SS Bug 2622488
54: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,
55: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
56: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
57: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
58: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE);
59: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE
60: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE);
61: --added by nshee during build for Applicant-BOSS SS Bug 2622488

Line 59: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE

55: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
56: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
57: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
58: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE);
59: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE
60: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE);
61: --added by nshee during build for Applicant-BOSS SS Bug 2622488
62: PROCEDURE insert_acad_interest(p_person_id IN igs_ad_acad_interest.person_id%TYPE,
63: p_adm_appl_id IN igs_ss_ad_acadin_stg.ss_adm_appl_id%TYPE,

Line 60: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE);

56: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
57: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
58: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE);
59: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE
60: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE);
61: --added by nshee during build for Applicant-BOSS SS Bug 2622488
62: PROCEDURE insert_acad_interest(p_person_id IN igs_ad_acad_interest.person_id%TYPE,
63: p_adm_appl_id IN igs_ss_ad_acadin_stg.ss_adm_appl_id%TYPE,
64: p_adm_appl_number IN igs_ad_acad_interest.admission_appl_number%TYPE);

Line 730: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,

726: END IF;
727: App_Exception.Raise_Exception;
728: END update_person_type;
729:
730: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,
731: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
732: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
733: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
734: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE) AS

Line 731: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,

727: App_Exception.Raise_Exception;
728: END update_person_type;
729:
730: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,
731: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
732: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
733: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
734: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE) AS
735: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE

Line 732: p_person_id IN igs_ad_unit_sets.person_id%TYPE,

728: END update_person_type;
729:
730: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,
731: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
732: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
733: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
734: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE) AS
735: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE
736: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE) AS

Line 733: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,

729:
730: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,
731: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
732: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
733: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
734: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE) AS
735: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE
736: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE) AS
737: /*****************************************************************************************

Line 735: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE

731: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,
732: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
733: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
734: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE) AS
735: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE
736: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE) AS
737: /*****************************************************************************************
738: Created By: [email protected]
739: Date Created : 11-DEC-2001

Line 736: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE) AS

732: p_person_id IN igs_ad_unit_sets.person_id%TYPE,
733: p_adm_appl_number IN igs_ad_unit_sets.admission_appl_number%TYPE,
734: p_ss_adm_appl_id IN igs_ss_app_pgm_stg.ss_adm_appl_id%TYPE) AS
735: -- ,p_unit_set_cd IN igs_ad_unit_sets.unit_set_cd%TYPE
736: -- ,p_ver_no IN igs_ad_unit_sets.version_number%TYPE) AS
737: /*****************************************************************************************
738: Created By: [email protected]
739: Date Created : 11-DEC-2001
740: Purpose: 1. Inserts Unit Set Details (Major1/Major2)

Line 741: FLOW: IGS_AD_UNIT_SETS_PKG.insert_row

737: /*****************************************************************************************
738: Created By: [email protected]
739: Date Created : 11-DEC-2001
740: Purpose: 1. Inserts Unit Set Details (Major1/Major2)
741: FLOW: IGS_AD_UNIT_SETS_PKG.insert_row
742: Known limitations,enhancements,remarks:
743: Change History
744: Who When What
745: nshee 29-OCT-2002 Modified it, now it inserts data from desired unit sets and not the major1/major2.

Line 748: l_unit_set_id igs_ad_unit_sets.unit_set_id%TYPE;

744: Who When What
745: nshee 29-OCT-2002 Modified it, now it inserts data from desired unit sets and not the major1/major2.
746: *****************************************************************************************/
747: l_rowid VARCHAR2(25);
748: l_unit_set_id igs_ad_unit_sets.unit_set_id%TYPE;
749: l_rank igs_ad_unit_sets.rank%TYPE;
750: lv_mode VARCHAR2(1) DEFAULT 'R';
751: /*
752: CURSOR c_nxt_rank IS

Line 749: l_rank igs_ad_unit_sets.rank%TYPE;

745: nshee 29-OCT-2002 Modified it, now it inserts data from desired unit sets and not the major1/major2.
746: *****************************************************************************************/
747: l_rowid VARCHAR2(25);
748: l_unit_set_id igs_ad_unit_sets.unit_set_id%TYPE;
749: l_rank igs_ad_unit_sets.rank%TYPE;
750: lv_mode VARCHAR2(1) DEFAULT 'R';
751: /*
752: CURSOR c_nxt_rank IS
753: SELECT MAX(rank), 0) + 1

Line 754: FROM igs_ad_unit_sets

750: lv_mode VARCHAR2(1) DEFAULT 'R';
751: /*
752: CURSOR c_nxt_rank IS
753: SELECT MAX(rank), 0) + 1
754: FROM igs_ad_unit_sets
755: WHERE
756: person_id = p_person_id AND
757: admission_appl_number = p_adm_appl_number AND
758: nominated_course_cd = p_nominated_course_cd;

Line 779: logDetail('Before call to IGS_AD_UNIT_SETS_PKG.insert_row', 'S');

775: CLOSE c_nxt_rank;*/
776:
777: FOR c_des_unit_sets_rec IN c_des_unit_sets LOOP
778: IF c_des_unit_sets_rec.unit_set_cd IS NOT NULL THEN
779: logDetail('Before call to IGS_AD_UNIT_SETS_PKG.insert_row', 'S');
780: l_rowid := '';
781: l_unit_set_id := 0;
782:
783:

Line 789: IGS_AD_UNIT_SETS_PKG.insert_row(x_rowid => l_rowid,

785: THEN
786: lv_mode := 'S';
787: END IF;
788:
789: IGS_AD_UNIT_SETS_PKG.insert_row(x_rowid => l_rowid,
790: x_unit_set_id => l_unit_set_id,
791: x_person_id => p_person_id,
792: x_admission_appl_number => p_adm_appl_number,
793: x_nominated_course_cd => p_nominated_course_cd,

Line 805: 'Exception from IGS_AD_UNIT_SETS_PKG.insert_row ' ||

801: END LOOP;
802: EXCEPTION
803: WHEN OTHERS THEN
804: logDetail('Inside insert_unit_set_dtls' ||
805: 'Exception from IGS_AD_UNIT_SETS_PKG.insert_row ' ||
806: SQLERRM || 'person_id : ' ||
807: IGS_GE_NUMBER.TO_CANN(p_person_id),
808: 'S');
809: IF FND_MSG_PUB.Count_Msg < 1 THEN

Line 3387: p_rank IN igs_ad_unit_sets.rank%TYPE)

3383: FUNCTION get_major(p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
3384: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
3385: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
3386: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
3387: p_rank IN igs_ad_unit_sets.rank%TYPE)
3388: RETURN VARCHAR2 IS
3389: CURSOR cur_adm_unit_sets(p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
3390: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
3391: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

Line 3392: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE, p_rank igs_ad_unit_sets.rank%TYPE) IS

3388: RETURN VARCHAR2 IS
3389: CURSOR cur_adm_unit_sets(p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
3390: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
3391: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
3392: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE, p_rank igs_ad_unit_sets.rank%TYPE) IS
3393: SELECT u.title
3394: FROM igs_ad_unit_sets us, igs_en_unit_set u
3395: WHERE us.person_id = p_person_id
3396: AND us.admission_appl_number = p_admission_appl_number

Line 3394: FROM igs_ad_unit_sets us, igs_en_unit_set u

3390: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
3391: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
3392: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE, p_rank igs_ad_unit_sets.rank%TYPE) IS
3393: SELECT u.title
3394: FROM igs_ad_unit_sets us, igs_en_unit_set u
3395: WHERE us.person_id = p_person_id
3396: AND us.admission_appl_number = p_admission_appl_number
3397: AND us.nominated_course_cd = p_nominated_course_cd
3398: AND us.sequence_number = p_sequence_number