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_GEN_014 dependencies on IGS_AD_PS_APPL

Line 16: new columns being added to IGS_AD_PS_APPL_INST

12: Who When What
13: rrengara 17-DEC-2002 When we are creating appl , appl program and instance in when other displayed
14: the SQLERRM in the log file
15: cdcruz 18-feb-2002 Bug 2217104 Admit to future term Enhancement,updated tbh call for
16: new columns being added to IGS_AD_PS_APPL_INST
17: rbezawad 30-Oct-2004 Added logic to properly handle the security Policy errors IGS_SC_POLICY_EXCEPTION
18: and IGS_SC_POLICY_UPD_DEL_EXCEP w.r.t. bug fix 3919112.
19:
20: ******************************************************************/

Line 402: 2.Inserts record into igs_ad_ps_appl table after validations

398: /*************************************************************************************************************************
399: Created By: [email protected]
400: Date Created : 12-27-2001
401: Purpose: 1.This Functions inserts an admission application Program
402: 2.Inserts record into igs_ad_ps_appl table after validations
403: 3.Returns boolean true if the record is inserted, boolean false if the proc fails.
404: 4.Flow/Calls used in the procedure :
405: |-->IGS_AD_GEN_002.admp_get_aa_dtl
406: |-->IGS_AD_VAL_ACA.admp_val_pref_limit(Validate preference limit) -IGSAD21B.pls

Line 414: |-->IGS_AD_PS_APPL_PKG.insert_row(Insert the record after all validation has been performed) -IGSAI16B.pls

410: |-->Validate admission code closed indicator
411: |-->IGS_AD_VAL_ACA.admp_val_aca_req_rec -IGSAD21B.pls
412: |-->IGS_AD_VAL_ACA.admp_val_aca_req_adv -IGSAD21B.pls
413: |-->IGS_AD_VAL_ACA.admp_val_aca_trnsfr(validation for course transfer)
414: |-->IGS_AD_PS_APPL_PKG.insert_row(Insert the record after all validation has been performed) -IGSAI16B.pls
415: Known limitations,enhancements,remarks:
416: Change History
417: Who When What
418: ***************************************************************************************************************************/

Line 460: CURSOR c_prg_exists(cp_person_id IGS_AD_PS_APPL.person_id%TYPE,

456: WHERE admission_cat = cp_admission_cat AND
457: s_admission_process_type = cp_s_admission_process_type AND
458: step_group_type <> 'TRACK'; -- 2402377
459:
460: CURSOR c_prg_exists(cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
461: cp_appl_no IGS_AD_PS_APPL.admission_appl_number%TYPE,
462: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE)
463: IS
464: SELECT tab.* --multiorg table , so rowid need not be selected explicitly

Line 461: cp_appl_no IGS_AD_PS_APPL.admission_appl_number%TYPE,

457: s_admission_process_type = cp_s_admission_process_type AND
458: step_group_type <> 'TRACK'; -- 2402377
459:
460: CURSOR c_prg_exists(cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
461: cp_appl_no IGS_AD_PS_APPL.admission_appl_number%TYPE,
462: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE)
463: IS
464: SELECT tab.* --multiorg table , so rowid need not be selected explicitly
465: FROM IGS_AD_PS_APPL tab

Line 462: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE)

458: step_group_type <> 'TRACK'; -- 2402377
459:
460: CURSOR c_prg_exists(cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
461: cp_appl_no IGS_AD_PS_APPL.admission_appl_number%TYPE,
462: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE)
463: IS
464: SELECT tab.* --multiorg table , so rowid need not be selected explicitly
465: FROM IGS_AD_PS_APPL tab
466: WHERE person_id = cp_person_id AND

Line 465: FROM IGS_AD_PS_APPL tab

461: cp_appl_no IGS_AD_PS_APPL.admission_appl_number%TYPE,
462: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE)
463: IS
464: SELECT tab.* --multiorg table , so rowid need not be selected explicitly
465: FROM IGS_AD_PS_APPL tab
466: WHERE person_id = cp_person_id AND
467: admission_appl_number = cp_appl_no AND
468: nominated_course_cd = cp_nominated_course_cd;
469:

Line 648: logDetail('Before Call to Igs_Ad_Ps_Appl_Pkg.Insert_Row',null);

644:
645:
646: -- Insert the record after all validation has been performed
647: l_org_id := igs_ge_gen_003.get_org_id;
648: logDetail('Before Call to Igs_Ad_Ps_Appl_Pkg.Insert_Row',null);
649: OPEN c_prg_exists(p_person_id,p_adm_appl_number,p_nominated_course_cd);
650: FETCH c_prg_exists INTO c_prg_exists_rec;
651:
652: IF c_prg_exists%NOTFOUND THEN

Line 653: IGS_AD_PS_APPL_PKG.Insert_Row (

649: OPEN c_prg_exists(p_person_id,p_adm_appl_number,p_nominated_course_cd);
650: FETCH c_prg_exists INTO c_prg_exists_rec;
651:
652: IF c_prg_exists%NOTFOUND THEN
653: IGS_AD_PS_APPL_PKG.Insert_Row (
654: X_Mode => 'R',
655: X_RowId => lv_rowid,
656: X_Person_Id => p_person_id,
657: X_Admission_Appl_Number => p_adm_appl_number,

Line 675: IGS_AD_PS_APPL_PKG.update_Row (

671: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
672: THEN
673: lv_mode := 'S';
674: END IF;
675: IGS_AD_PS_APPL_PKG.update_Row (
676: X_RowId => c_prg_exists_rec.row_id,
677: X_Person_Id => NVL(p_person_id,c_prg_exists_rec.person_id),
678: X_Admission_Appl_Number => NVL(p_adm_appl_number,c_prg_exists_rec.admission_appl_number),
679: X_Nominated_Course_Cd => NVL(p_nominated_course_cd,c_prg_exists_rec.nominated_course_cd),

Line 795: 2.Inserts record into igs_ad_ps_appl_inst table after validations

791: /*************************************************************************************************************************
792: Created By: [email protected]
793: Date Created : 12-27-2001
794: Purpose: 1.This Functions inserts an admission application Program Instance
795: 2.Inserts record into igs_ad_ps_appl_inst table after validations
796: 3.Returns boolean true if the record is inserted, boolean false if the proc fails.
797: 4.Flow/Calls used in the procedure :
798: |-->IGS_AD_GEN_004.admp_get_apcs_val(Get the admission process category steps.) -IGSAD04B.pls
799: |-->IGS_AD_VAL_ACAI.admp_val_acai_fc(Set fee category) -IGSAD22B.pls

Line 806: |-->IGS_AD_PS_APPL_INST_PKG.insert_row(Insert an admission program application instance with PENDING outcome) -IGSAI18B.pls

802: |-->Set admission COURSE application instance statuses for PENDING outcome
803: |-->validate_unit_sets(Validate the admission COURSE offering IGS_PS_UNIT set)
804: |-->admp_get_adm_step_values(get if location code, attendance mode and attendance type indicators are set)
805: |-->IGS_AD_VAL_ACAI.admp_val_acai_cop(Validate program offering patterns) -IGSAD22B.pls
806: |-->IGS_AD_PS_APPL_INST_PKG.insert_row(Insert an admission program application instance with PENDING outcome) -IGSAI18B.pls
807: Known limitations,enhancements,remarks:
808: Change History
809: Who When What
810: vdixit 19-Feb-2002 Added the logic to raise the business event in work flow

Line 823: -- This procedure inserts a new IGS_AD_PS_APPL_INST record.

819: l_sc_app_short_name VARCHAR2(50);
820: l_sc_message_name VARCHAR2(50);
821:
822: BEGIN
823: -- This procedure inserts a new IGS_AD_PS_APPL_INST record.
824: logHeader('insert_adm_appl_prog_inst',null);
825: DECLARE
826: e_resource_busy EXCEPTION;
827: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);

Line 899: FROM IGS_AD_PS_APPL_INST

895:
896:
897: CURSOR c_nxt_acai_seq_num IS
898: SELECT NVL(MAX(sequence_number), 0) + 1
899: FROM IGS_AD_PS_APPL_INST
900: WHERE
901: person_id = p_person_id AND
902: admission_appl_number = p_admission_appl_number AND
903: nominated_course_cd = p_course_cd;

Line 906: FROM IGS_AD_PS_APPL_INST APAI

902: admission_appl_number = p_admission_appl_number AND
903: nominated_course_cd = p_course_cd;
904: CURSOR c_upd_acai IS
905: SELECT ROWID, APAI.*
906: FROM IGS_AD_PS_APPL_INST APAI
907: WHERE
908: person_id = p_person_id AND
909: admission_appl_number = p_admission_appl_number AND
910: nominated_course_cd = p_course_cd AND

Line 933: Rec_IGS_AD_PS_APPL_Inst c_upd_acai%ROWTYPE;

929: step_group_type <> 'TRACK'; -- 2402377
930:
931:
932:
933: Rec_IGS_AD_PS_APPL_Inst c_upd_acai%ROWTYPE;
934: LV_ROWID VARCHAR2(25);
935: l_org_id NUMBER(15);
936: v_app_source igs_ad_code_classes.system_status%TYPE;
937: v_check_course_encumb VARCHAR2(1) DEFAULT 'N';

Line 1245: logDetail('Before Call to Igs_Ad_Ps_Appl_Inst_Pkg.Insert_Row',null);

1241: p_s_admission_process_type => p_s_admission_process_type,
1242: l_adm_doc_status => v_adm_doc_status,
1243: l_adm_entr_qual_status => v_adm_entry_qual_status);
1244:
1245: logDetail('Before Call to Igs_Ad_Ps_Appl_Inst_Pkg.Insert_Row',null);
1246:
1247: IF NVL(IGS_AD_SS_GEN_001.g_admin_security_on,'N') = 'Y'
1248: THEN
1249: lv_mode := 'S';

Line 1252: IGS_AD_PS_APPL_INST_PKG.Insert_Row (

1248: THEN
1249: lv_mode := 'S';
1250: END IF;
1251:
1252: IGS_AD_PS_APPL_INST_PKG.Insert_Row (
1253: X_ROWID => lv_rowid,
1254: X_PERSON_ID => p_Person_Id,
1255: X_ADMISSION_APPL_NUMBER => p_Admission_Appl_Number,
1256: X_NOMINATED_COURSE_CD =>p_course_cd,

Line 1385: logDetail('Before Call to Igs_Ad_Ps_Appl_Inst_Pkg.Insert_Row, returning TRUE',null);

1381: X_SCH_APL_TO_ID => p_sch_apl_to_id);
1382:
1383: p_message_name := NULL;
1384: p_sequence_number := v_acai_sequence_number;
1385: logDetail('Before Call to Igs_Ad_Ps_Appl_Inst_Pkg.Insert_Row, returning TRUE',null);
1386:
1387:
1388: -- begin apadegal adtd001 igs.m
1389: