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_PRC_TAC_OFFER dependencies on IGS_AD_APPL

Line 17: and new parameters to call to igs_ad_appl_pkg.insert_row

13: ssawhney feb15 bug 2225917 SWCR008 remove customer creation.
14: cdcruz feb18 bug 2217104 Admit to future term Enhancement,updated tbh call for
15: new columns being added to IGS_AD_PS_APPL_INST
16: knag 21-Nov-2002 Added new parameters to admp_ins_adm_appl for bug 2664410
17: and new parameters to call to igs_ad_appl_pkg.insert_row
18: pkpatel 01-DEC-2002 Bug NO: 2599109 (Sevis DLD)
19: Modified the the signatute of call to TBH IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW
20: anilk 18-FEB-2003 Bug#2784198
21: Added closed_ind = 'N' to where clause for cursor c_hl

Line 348: --Procedure inserts a new IGS_AD_APPL record. It uses an

344: rboddu 04-OCT-2002 Creating application with Application_Type. Bug :2599457
345: ******************************************************************/
346:
347: BEGIN --admp_ins_adm_appl
348: --Procedure inserts a new IGS_AD_APPL record. It uses an
349: --output parameter to pass back the new admission_appl_number used
350: DECLARE
351: v_dummy CHAR;
352: v_adm_fee_status VARCHAR2(10);

Line 353: v_adm_appl_number IGS_AD_APPL.admission_appl_number%TYPE;

349: --output parameter to pass back the new admission_appl_number used
350: DECLARE
351: v_dummy CHAR;
352: v_adm_fee_status VARCHAR2(10);
353: v_adm_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
354: v_message_name VARCHAR2(30);
355: v_return_type VARCHAR2(1);
356: v_title_required_ind VARCHAR2(1) DEFAULT 'Y';
357: v_birth_dt_required_ind VARCHAR2(1) DEFAULT 'Y';

Line 375: FROM igs_ad_appl

371: AND step_group_type <> 'TRACK';
372: -- Have to find the last admission_appl_number used.
373: CURSOR c_aa IS
374: SELECT NVL(MAX(admission_appl_number),0) + 1
375: FROM igs_ad_appl
376: WHERE person_id = p_person_id;
377:
378: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
379: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE

Line 378: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,

374: SELECT NVL(MAX(admission_appl_number),0) + 1
375: FROM igs_ad_appl
376: WHERE person_id = p_person_id;
377:
378: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
379: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
380: )
381: IS
382: SELECT admission_application_type

Line 379: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE

375: FROM igs_ad_appl
376: WHERE person_id = p_person_id;
377:
378: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
379: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
380: )
381: IS
382: SELECT admission_application_type
383: FROM igs_ad_ss_appl_typ

Line 389: l_application_type igs_ad_appl_all.application_type%TYPE;

385: AND S_admission_process_type = cp_s_adm_prc_typ
386: AND System_default = 'Y'
387: AND NVL(closed_ind, 'N') <> 'Y';
388:
389: l_application_type igs_ad_appl_all.application_type%TYPE;
390: lv_rowid VARCHAR2(25);
391: l_org_id NUMBER(15);
392: BEGIN
393: -- Work out NOCOPY the new admission_appl_number.

Line 534: p_message_name:= 'IGS_AD_APPL_TYPE_NULL';

530: CLOSE c_sys_def_appl_type;
531:
532: --Validate the Application Type and fail the validation if Application Type passed is NULL. Bug: 2599457
533: IF l_application_type IS NULL THEN
534: p_message_name:= 'IGS_AD_APPL_TYPE_NULL';
535: RETURN FALSE;
536: END IF;
537:
538: Igs_Ad_Appl_Pkg.Insert_Row (

Line 538: Igs_Ad_Appl_Pkg.Insert_Row (

534: p_message_name:= 'IGS_AD_APPL_TYPE_NULL';
535: RETURN FALSE;
536: END IF;
537:
538: Igs_Ad_Appl_Pkg.Insert_Row (
539: X_Mode => 'R',
540: X_RowId => lv_rowid,
541: X_Person_Id => p_Person_Id,
542: X_Admission_Appl_Number => v_adm_appl_number,

Line 1250: p_message_name := 'IGS_AD_APPL_NOTSET_LOCKING';

1246: CLOSE c_upd_acai;
1247: EXCEPTION
1248: -- check for locking on update, although this should never occur
1249: WHEN e_resource_busy THEN
1250: p_message_name := 'IGS_AD_APPL_NOTSET_LOCKING';
1251: p_return_type := 'W';
1252: RETURN FALSE;
1253: END;
1254: --------------------------

Line 1393: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE;

1389: v_acai_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE;
1390: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
1391: v_acai_hecs_payment_option IGS_AD_PS_APPL_INST.hecs_payment_option%TYPE;
1392: v_hecs_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE;
1393: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE;
1394: v_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE;
1395: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
1396: v_cnt_aa_acai_rec NUMBER(2);
1397: CURSOR c_aa_acai (

Line 1395: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;

1391: v_acai_hecs_payment_option IGS_AD_PS_APPL_INST.hecs_payment_option%TYPE;
1392: v_hecs_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE;
1393: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE;
1394: v_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE;
1395: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
1396: v_cnt_aa_acai_rec NUMBER(2);
1397: CURSOR c_aa_acai (
1398: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE) IS
1399: SELECT COUNT(*),

Line 1405: IGS_AD_APPL aa,

1401: acai.nominated_course_cd,
1402: acai.sequence_number,
1403: acai.hecs_payment_option
1404: FROM
1405: IGS_AD_APPL aa,
1406: IGS_AD_PS_APPL_INST acai
1407: WHERE
1408: aa.person_id = acai.person_id AND
1409: aa.admission_appl_number = acai.admission_appl_number AND

Line 1681: p_message_name := 'IGS_AD_APPL_MADE_INVALIDOFFER';

1677: RETURN FALSE;
1678: END;
1679: -- Warn that this applicant has been made more
1680: -- than one offer with different payment options
1681: p_message_name := 'IGS_AD_APPL_MADE_INVALIDOFFER';
1682: p_return_type := 'W';
1683: RETURN FALSE;
1684: ELSIF v_acai_hecs_payment_option IS NULL AND
1685: ((v_ref_cd_type = 'OTHER' AND p_fee_paying_appl_ind = 'U') OR

Line 1689: p_message_name := 'IGS_AD_APPL_MADE_INVALIDOFFER';

1685: ((v_ref_cd_type = 'OTHER' AND p_fee_paying_appl_ind = 'U') OR
1686: p_fee_paying_appl_ind = 'Y') THEN
1687: -- Warn that this applicant has been made more
1688: -- than one offer with different payment options
1689: p_message_name := 'IGS_AD_APPL_MADE_INVALIDOFFER';
1690: p_return_type := 'W';
1691: RETURN FALSE;
1692: ELSE
1693: -- Something is wrong!! Offer should not be made to same IGS_PS_COURSE twice.

Line 2488: v_admission_cat IGS_AD_APPL.admission_cat%TYPE DEFAULT NULL;

2484: PRAGMA EXCEPTION_INIT(e_integrity_exception, -2291);
2485: BEGIN -- admp_ins_adm_crs_app
2486: -- This module validate IGS_AD_PS_APLINSTUNT unit version.
2487: DECLARE
2488: v_admission_cat IGS_AD_APPL.admission_cat%TYPE DEFAULT NULL;
2489: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT
2490: NULL;
2491: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
2492: v_acad_ci_sequence_number

Line 2489: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT

2485: BEGIN -- admp_ins_adm_crs_app
2486: -- This module validate IGS_AD_PS_APLINSTUNT unit version.
2487: DECLARE
2488: v_admission_cat IGS_AD_APPL.admission_cat%TYPE DEFAULT NULL;
2489: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT
2490: NULL;
2491: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
2492: v_acad_ci_sequence_number
2493: IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;

Line 2491: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;

2487: DECLARE
2488: v_admission_cat IGS_AD_APPL.admission_cat%TYPE DEFAULT NULL;
2489: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT
2490: NULL;
2491: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
2492: v_acad_ci_sequence_number
2493: IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
2494: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
2495: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;

Line 2493: IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;

2489: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT
2490: NULL;
2491: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
2492: v_acad_ci_sequence_number
2493: IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
2494: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
2495: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
2496: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
2497: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;

Line 2494: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;

2490: NULL;
2491: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
2492: v_acad_ci_sequence_number
2493: IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
2494: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
2495: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
2496: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
2497: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;
2498: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;

Line 2495: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;

2491: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
2492: v_acad_ci_sequence_number
2493: IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
2494: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
2495: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
2496: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
2497: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;
2498: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;
2499: v_crv_version_number IGS_PS_VER.version_number%TYPE DEFAULT 0;

Line 2496: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;

2492: v_acad_ci_sequence_number
2493: IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
2494: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
2495: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
2496: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
2497: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;
2498: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;
2499: v_crv_version_number IGS_PS_VER.version_number%TYPE DEFAULT 0;
2500: v_message_name VARCHAR2(30) DEFAULT 0;

Line 2497: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;

2493: IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
2494: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
2495: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
2496: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
2497: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;
2498: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;
2499: v_crv_version_number IGS_PS_VER.version_number%TYPE DEFAULT 0;
2500: v_message_name VARCHAR2(30) DEFAULT 0;
2501: v_return_type VARCHAR2(1) DEFAULT NULL;

Line 2498: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;

2494: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
2495: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
2496: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
2497: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;
2498: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;
2499: v_crv_version_number IGS_PS_VER.version_number%TYPE DEFAULT 0;
2500: v_message_name VARCHAR2(30) DEFAULT 0;
2501: v_return_type VARCHAR2(1) DEFAULT NULL;
2502: v_pref_limit

Line 2508: cp_admission_cat IGS_AD_APPL.admission_cat%TYPE) IS

2504: v_late_appl_allowed_ind VARCHAR2(1) DEFAULT 'N';
2505: v_req_reconsider_allowed_ind VARCHAR2(1) DEFAULT 'N';
2506: v_req_adv_standing_allowed_ind VARCHAR2(1) DEFAULT 'N';
2507: CURSOR c_apcs(
2508: cp_admission_cat IGS_AD_APPL.admission_cat%TYPE) IS
2509: SELECT apcs.s_admission_step_type,
2510: step_type_restriction_num
2511: FROM IGS_AD_PRCS_CAT_STEP apcs
2512: WHERE apcs.admission_cat = cp_admission_cat AND