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_APPL

Line 78: 2.Inserts record into igs_ad_appl table after validations

74: /*****************************************************************************************
75: Created By: [email protected]
76: Date Created : 12-27-2001
77: Purpose: 1.This Functions inserts an admission application
78: 2.Inserts record into igs_ad_appl table after validations
79: 3.Returns boolean true if the record is inserted, boolean false if the proc fails.
80: 4.Flow/Calls used in the procedure :
81: |-->IGS_AD_VAL_AA.admp_val_aa_insert (IGSAD76B.pls)
82: |-->IGS_AD_VAL_AA.admp_val_aa_acad_cal

Line 89: |-->IGS_AD_APPL_PKG.insert_row

85: |-->IGS_AD_VAL_AA.admp_val_aa_appl_dt
86: |-->IGS_AD_VAL_AA.admp_val_aa_aas
87: |-->IGS_AD_VAL_AA.admp_val_aa_afs
88: |-->IGS_AD_VAL_AA.admp_val_aa_tac_appl
89: |-->IGS_AD_APPL_PKG.insert_row
90:
91: Known limitations,enhancements,remarks:
92: Change History
93: Who When What

Line 94: rrengara 8-jul-2002 Added UK Parameters choice_number and routre pref to insert_adm_appl procedure for bug 2448262 and also added to igs_ad_appl_pkg.insert_row call

90:
91: Known limitations,enhancements,remarks:
92: Change History
93: Who When What
94: rrengara 8-jul-2002 Added UK Parameters choice_number and routre pref to insert_adm_appl procedure for bug 2448262 and also added to igs_ad_appl_pkg.insert_row call
95: rboddu 10-OCT-2002 Added the check for NULL Application Type. Bug: 2599457
96: rghosh 14-nov-2002 Added UK Parameters alt_appl_id to insert_adm_appl procedure for bug 2664410 and also added to igs_ad_appl_pkg.insert_row call
97: *****************************************************************************************/
98:

Line 96: rghosh 14-nov-2002 Added UK Parameters alt_appl_id to insert_adm_appl procedure for bug 2664410 and also added to igs_ad_appl_pkg.insert_row call

92: Change History
93: Who When What
94: rrengara 8-jul-2002 Added UK Parameters choice_number and routre pref to insert_adm_appl procedure for bug 2448262 and also added to igs_ad_appl_pkg.insert_row call
95: rboddu 10-OCT-2002 Added the check for NULL Application Type. Bug: 2599457
96: rghosh 14-nov-2002 Added UK Parameters alt_appl_id to insert_adm_appl procedure for bug 2664410 and also added to igs_ad_appl_pkg.insert_row call
97: *****************************************************************************************/
98:
99: --Local variables to check if the Security Policy exception already set or not. Ref: Bug 3919112
100: l_sc_encoded_text VARCHAR2(4000);

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

103: l_sc_app_short_name VARCHAR2(50);
104: l_sc_message_name VARCHAR2(50);
105:
106: BEGIN --admp_ins_adm_appl
107: --Procedure inserts a new IGS_AD_APPL record. It uses an
108: --output parameter to pass back the new admission_appl_number used
109: DECLARE
110: v_dummy CHAR;
111: v_adm_fee_status VARCHAR2(10);

Line 112: v_adm_appl_number IGS_AD_APPL.admission_appl_number%TYPE;

108: --output parameter to pass back the new admission_appl_number used
109: DECLARE
110: v_dummy CHAR;
111: v_adm_fee_status VARCHAR2(10);
112: v_adm_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
113: v_message_name VARCHAR2(30);
114: v_return_type VARCHAR2(1);
115: v_title_required_ind VARCHAR2(1) DEFAULT 'Y';
116: v_birth_dt_required_ind VARCHAR2(1) DEFAULT 'Y';

Line 134: FROM IGS_AD_APPL /Replaced as part of Bug 3150054/

130: step_group_type <> 'TRACK'; --2402377
131: -- Have to find the last admission_appl_number used.
132: CURSOR c_aa IS
133: SELECT NVL(MAX(admission_appl_number),0) + 1
134: FROM IGS_AD_APPL /*Replaced as part of Bug 3150054*/
135: WHERE person_id = p_person_id;
136:
137: CURSOR c_appl_type(p_admission_application_type igs_ad_ss_appl_typ.admission_application_type%TYPE) IS
138: SELECT a.admission_application_type

Line 288: p_message_name:= 'IGS_AD_APPL_TYPE_NULL';

284: END IF;
285:
286: --Validate the Application Type and fail the validation if Application Type passed is NULL. Bug: 2599457
287: IF p_application_type IS NULL THEN
288: p_message_name:= 'IGS_AD_APPL_TYPE_NULL';
289: RETURN FALSE;
290: ELSE
291: OPEN c_appl_type(p_application_type);
292: FETCH c_appl_type INTO l_appl_type;

Line 295: p_message_name:= 'IGS_AD_APPL_TYP_APC_CLOSED';

291: OPEN c_appl_type(p_application_type);
292: FETCH c_appl_type INTO l_appl_type;
293: CLOSE c_appl_type;
294: IF l_appl_type IS NULL THEN
295: p_message_name:= 'IGS_AD_APPL_TYP_APC_CLOSED';
296: RETURN FALSE;
297: END IF;
298: END IF;
299:

Line 328: IGS_AD_APPL_PKG.insert_row (

324: --Now insert the new record
325: --Populate the org id
326: l_org_id := igs_ge_gen_003.get_org_id;
327:
328: IGS_AD_APPL_PKG.insert_row (
329: X_Mode => 'R',
330: X_RowId => lv_rowid,
331: X_Person_Id => p_Person_Id,
332: X_Admission_Appl_Number => v_adm_appl_number,

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

425: BEGIN -- insert_adm_appl --Main Loop Begin
426: -- This module validate IGS_AD_PS_APLINSTUNT unit version.
427: logheader('insert_adm_appl',null);
428: DECLARE --i=Inner Loop Declare
429: v_admission_cat IGS_AD_APPL.admission_cat%TYPE DEFAULT NULL;
430: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT NULL;
431: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
432: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
433: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;

Line 430: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT NULL;

426: -- This module validate IGS_AD_PS_APLINSTUNT unit version.
427: logheader('insert_adm_appl',null);
428: DECLARE --i=Inner Loop Declare
429: v_admission_cat IGS_AD_APPL.admission_cat%TYPE DEFAULT NULL;
430: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT NULL;
431: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
432: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
433: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
434: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;

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

427: logheader('insert_adm_appl',null);
428: DECLARE --i=Inner Loop Declare
429: v_admission_cat IGS_AD_APPL.admission_cat%TYPE DEFAULT NULL;
430: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT NULL;
431: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
432: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
433: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
434: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
435: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;

Line 432: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;

428: DECLARE --i=Inner Loop Declare
429: v_admission_cat IGS_AD_APPL.admission_cat%TYPE DEFAULT NULL;
430: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT NULL;
431: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
432: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
433: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
434: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
435: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
436: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;

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

429: v_admission_cat IGS_AD_APPL.admission_cat%TYPE DEFAULT NULL;
430: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT NULL;
431: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
432: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
433: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
434: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
435: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
436: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;
437: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;

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

430: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE DEFAULT NULL;
431: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
432: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
433: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
434: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
435: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
436: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;
437: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;
438: v_crv_version_number IGS_PS_VER.version_number%TYPE DEFAULT 0;

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

431: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE DEFAULT NULL;
432: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
433: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
434: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
435: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
436: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;
437: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;
438: v_crv_version_number IGS_PS_VER.version_number%TYPE DEFAULT 0;
439: v_message_name VARCHAR2(30) DEFAULT 0;

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

432: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE DEFAULT 0;
433: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
434: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
435: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
436: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;
437: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;
438: v_crv_version_number IGS_PS_VER.version_number%TYPE DEFAULT 0;
439: v_message_name VARCHAR2(30) DEFAULT 0;
440: v_return_type VARCHAR2(1) DEFAULT NULL;

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

433: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE DEFAULT NULL;
434: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE DEFAULT 0;
435: v_appl_dt IGS_AD_APPL.appl_dt%TYPE DEFAULT NULL;
436: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE DEFAULT NULL;
437: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE DEFAULT NULL;
438: v_crv_version_number IGS_PS_VER.version_number%TYPE DEFAULT 0;
439: v_message_name VARCHAR2(30) DEFAULT 0;
440: v_return_type VARCHAR2(1) DEFAULT NULL;
441: v_pref_limit IGS_AD_PRCS_CAT_STEP.step_type_restriction_num%TYPE DEFAULT NULL;

Line 450: cp_admission_cat IGS_AD_APPL.admission_cat%TYPE,

446: cst_error CONSTANT VARCHAR2(1) := 'E';
447:
448:
449: CURSOR c_apcs(
450: cp_admission_cat IGS_AD_APPL.admission_cat%TYPE,
451: cp_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE)
452: IS
453: SELECT s_admission_step_type,
454: step_type_restriction_num

Line 451: cp_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE)

447:
448:
449: CURSOR c_apcs(
450: cp_admission_cat IGS_AD_APPL.admission_cat%TYPE,
451: cp_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE)
452: IS
453: SELECT s_admission_step_type,
454: step_type_restriction_num
455: FROM IGS_AD_PRCS_CAT_STEP

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

890: l_var VARCHAR2(1);
891: l_late_ind VARCHAR2(1);
892: l_finaid_apply_date DATE;
893: l_msg_data VARCHAR2(2000);
894: v_admission_cat IGS_AD_APPL.admission_cat%TYPE DEFAULT NULL;
895:
896:
897: CURSOR c_nxt_acai_seq_num IS
898: SELECT NVL(MAX(sequence_number), 0) + 1

Line 921: cp_admission_cat IGS_AD_APPL.admission_cat%TYPE,

917: WHERE code_id = p_app_source_id AND
918: class = 'SYS_APPL_SOURCE';
919:
920: CURSOR c_apcs(
921: cp_admission_cat IGS_AD_APPL.admission_cat%TYPE,
922: cp_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE)
923: IS
924: SELECT s_admission_step_type,
925: step_type_restriction_num

Line 922: cp_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE)

918: class = 'SYS_APPL_SOURCE';
919:
920: CURSOR c_apcs(
921: cp_admission_cat IGS_AD_APPL.admission_cat%TYPE,
922: cp_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE)
923: IS
924: SELECT s_admission_step_type,
925: step_type_restriction_num
926: FROM IGS_AD_PRCS_CAT_STEP

Line 1907: SELECT ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE FROM IGS_AD_APPL_ALL

1903: l_errbuf VARCHAR2(2000);
1904: l_retcode NUMBER;
1905:
1906: CURSOR c_adm_cat(cp_person_id IN NUMBER, cp_admission_Appl_number IN NUMBER) IS
1907: SELECT ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE FROM IGS_AD_APPL_ALL
1908: WHERE PERSON_ID = cp_person_id AND ADMISSION_APPL_NUMBER = cp_admission_Appl_number;
1909:
1910: l_adm_cat_rec c_adm_cat%ROWTYPE;
1911:

Line 2006: SELECT ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE FROM IGS_AD_APPL_ALL

2002: ) IS
2003:
2004: l_rowid ROWID;
2005: CURSOR c_adm_cat(cp_person_id IN NUMBER, cp_admission_Appl_number IN NUMBER) IS
2006: SELECT ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE FROM IGS_AD_APPL_ALL
2007: WHERE PERSON_ID = cp_person_id AND ADMISSION_APPL_NUMBER = cp_admission_Appl_number;
2008:
2009: l_adm_cat_rec c_adm_cat%ROWTYPE;
2010: