DBA Data[Home] [Help]

APPS.IGS_AD_GEN_014 dependencies on IGS_AD_PS_APPL_PKG

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 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),