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

Line 1: PACKAGE BODY igs_ad_ps_appl_inst_pkg AS

1: PACKAGE BODY igs_ad_ps_appl_inst_pkg AS
2: /* $Header: IGSAI18B.pls 120.14 2006/05/30 11:00:51 pbondugu ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_ps_appl_inst_all%RowType;
5: new_references igs_ad_ps_appl_inst_all%RowType;

Line 4: old_references igs_ad_ps_appl_inst_all%RowType;

1: PACKAGE BODY igs_ad_ps_appl_inst_pkg AS
2: /* $Header: IGSAI18B.pls 120.14 2006/05/30 11:00:51 pbondugu ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_ps_appl_inst_all%RowType;
5: new_references igs_ad_ps_appl_inst_all%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2,

Line 5: new_references igs_ad_ps_appl_inst_all%RowType;

1: PACKAGE BODY igs_ad_ps_appl_inst_pkg AS
2: /* $Header: IGSAI18B.pls 120.14 2006/05/30 11:00:51 pbondugu ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_ps_appl_inst_all%RowType;
5: new_references igs_ad_ps_appl_inst_all%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2,
9: x_org_id IN NUMBER,

Line 160: FROM IGS_AD_PS_APPL_INST_ALL

156: (reverse chronological order - newest change first)
157: ***************************************************************/
158: CURSOR cur_old_ref_values IS
159: SELECT *
160: FROM IGS_AD_PS_APPL_INST_ALL
161: WHERE rowid = x_rowid;
162: BEGIN
163: l_rowid := x_rowid;
164: -- Code for setting the Old and New Reference Values.

Line 171: IGS_AD_GEN_001.SET_TOKEN('From Table IGS_AD_PS_APPL_INST_ALL P_action NOT IN INSERT or VALiDATE_INSERT' );

167: Fetch cur_old_ref_values INTO old_references;
168: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
169: Close cur_old_ref_values;
170: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
171: IGS_AD_GEN_001.SET_TOKEN('From Table IGS_AD_PS_APPL_INST_ALL P_action NOT IN INSERT or VALiDATE_INSERT' );
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: Return;
175: END IF;

Line 348: v_transfer_course_cd IGS_AD_PS_APPL.transfer_course_cd%TYPE;

344: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
345: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
346: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
347: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
348: v_transfer_course_cd IGS_AD_PS_APPL.transfer_course_cd%TYPE;
349: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
350: v_pref_allowed_ind VARCHAR2(1) ;
351: v_pref_limit NUMBER;
352: v_cond_offer_doc_allowed_ind VARCHAR2(1) ;

Line 372: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,

368: cst_transfer CONSTANT VARCHAR2(8) := 'TRANSFER';
369: -- Variables added to handle mutation logic
370: v_index BINARY_INTEGER;
371: CURSOR c_aca (
372: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
373: cp_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE,
374: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE) IS
375: SELECT transfer_course_cd
376: FROM IGS_AD_PS_APPL

Line 373: cp_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE,

369: -- Variables added to handle mutation logic
370: v_index BINARY_INTEGER;
371: CURSOR c_aca (
372: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
373: cp_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE,
374: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE) IS
375: SELECT transfer_course_cd
376: FROM IGS_AD_PS_APPL
377: WHERE person_id = cp_person_id AND

Line 374: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE) IS

370: v_index BINARY_INTEGER;
371: CURSOR c_aca (
372: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
373: cp_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE,
374: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE) IS
375: SELECT transfer_course_cd
376: FROM IGS_AD_PS_APPL
377: WHERE person_id = cp_person_id AND
378: admission_appl_number = cp_admission_appl_number AND

Line 376: FROM IGS_AD_PS_APPL

372: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
373: cp_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE,
374: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE) IS
375: SELECT transfer_course_cd
376: FROM IGS_AD_PS_APPL
377: WHERE person_id = cp_person_id AND
378: admission_appl_number = cp_admission_appl_number AND
379: nominated_course_cd = cp_nominated_course_cd;
380: CURSOR c_apcs (

Line 391: cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,

387: WHERE admission_cat = cp_admission_cat AND
388: s_admission_process_type = cp_s_admission_process_type AND
389: step_group_type <> 'TRACK'; --2402377
390: CURSOR c_pti (
391: cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
392: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
393: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
394: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
395: SELECT pti.rowid row_id

Line 392: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,

388: s_admission_process_type = cp_s_admission_process_type AND
389: step_group_type <> 'TRACK'; --2402377
390: CURSOR c_pti (
391: cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
392: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
393: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
394: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
395: SELECT pti.rowid row_id
396: FROM igs_pe_typ_instances_all pti,

Line 393: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

389: step_group_type <> 'TRACK'; --2402377
390: CURSOR c_pti (
391: cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
392: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
393: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
394: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
395: SELECT pti.rowid row_id
396: FROM igs_pe_typ_instances_all pti,
397: igs_pe_person_types ppt

Line 394: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS

390: CURSOR c_pti (
391: cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
392: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
393: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
394: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
395: SELECT pti.rowid row_id
396: FROM igs_pe_typ_instances_all pti,
397: igs_pe_person_types ppt
398: WHERE pti.person_id = cp_person_id

Line 417: igs_ad_ps_appl_inst_all aplinst

413: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
414: SELECT admprd.single_response_flag
415: FROM igs_ad_prd_ad_prc_ca admprd,
416: igs_ad_appl_all appl,
417: igs_ad_ps_appl_inst_all aplinst
418: WHERE appl.person_id = new_references.person_id
419: AND appl.admission_appl_number = new_references.admission_appl_number
420: AND appl.person_id = aplinst.person_id
421: AND appl.admission_appl_number = aplinst.admission_appl_number

Line 430: igs_ad_ps_appl_inst aplinst,

426:
427: CURSOR get_aplinst_response_accepted IS
428: SELECT distinct appl.application_id, aplinst.nominated_course_cd
429: FROM igs_ad_appl_all appl,
430: igs_ad_ps_appl_inst aplinst,
431: igs_ad_prd_ad_prc_ca admprd
432: WHERE appl.person_id = aplinst.person_id
433: AND appl.admission_appl_number = aplinst.admission_appl_number
434: AND appl.person_id = new_references.person_id

Line 455: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;

451: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
452: l_application_id igs_ad_appl_all.application_id%TYPE;
453: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
454: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
455: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
456:
457: l_s_adm_outcome_status VARCHAR2(30) ;
458: cst_withdrawn CONSTANT VARCHAR2(10) := 'WITHDRAWN';
459:

Line 463: FROM IGS_AD_PS_APPL_ALL apl

459:
460: --- begin apadegal ADTD001 RE-OPEN Build igs.m
461: CURSOR cur_reconsider IS
462: SELECT req_for_reconsideration_ind
463: FROM IGS_AD_PS_APPL_ALL apl
464: WHERE apl.person_id = new_references.person_id
465: AND apl.admission_appl_number = new_references.admission_appl_number
466: AND apl.nominated_course_cd = new_references.nominated_course_cd ;
467:

Line 1832: CURSOR c_pti (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,

1828: p_inserting IN BOOLEAN,
1829: p_updating IN BOOLEAN,
1830: p_deleting IN BOOLEAN
1831: ) AS
1832: CURSOR c_pti (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
1833: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
1834: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1835: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
1836: SELECT pti.rowid row_id,pti.*

Line 1833: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,

1829: p_updating IN BOOLEAN,
1830: p_deleting IN BOOLEAN
1831: ) AS
1832: CURSOR c_pti (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
1833: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
1834: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1835: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
1836: SELECT pti.rowid row_id,pti.*
1837: FROM igs_pe_typ_instances_all pti,

Line 1834: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

1830: p_deleting IN BOOLEAN
1831: ) AS
1832: CURSOR c_pti (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
1833: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
1834: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1835: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
1836: SELECT pti.rowid row_id,pti.*
1837: FROM igs_pe_typ_instances_all pti,
1838: igs_pe_person_types ppt

Line 1835: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS

1831: ) AS
1832: CURSOR c_pti (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
1833: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
1834: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1835: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
1836: SELECT pti.rowid row_id,pti.*
1837: FROM igs_pe_typ_instances_all pti,
1838: igs_pe_person_types ppt
1839: WHERE pti.person_id = cp_person_id

Line 1847: CURSOR c_ptyp_inst (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,

1843: AND ppt.person_type_code = pti.person_type_code
1844: AND ppt.system_type = 'APPLICANT'
1845: AND pti.end_date IS NULL;
1846:
1847: CURSOR c_ptyp_inst (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
1848: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
1849: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1850: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
1851: cp_end_method igs_lookup_values.lookup_code%TYPE) IS

Line 1848: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,

1844: AND ppt.system_type = 'APPLICANT'
1845: AND pti.end_date IS NULL;
1846:
1847: CURSOR c_ptyp_inst (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
1848: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
1849: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1850: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
1851: cp_end_method igs_lookup_values.lookup_code%TYPE) IS
1852: SELECT pti.rowid row_id,pti.*

Line 1849: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

1845: AND pti.end_date IS NULL;
1846:
1847: CURSOR c_ptyp_inst (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
1848: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
1849: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1850: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
1851: cp_end_method igs_lookup_values.lookup_code%TYPE) IS
1852: SELECT pti.rowid row_id,pti.*
1853: FROM igs_pe_typ_instances_all pti,

Line 1850: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,

1846:
1847: CURSOR c_ptyp_inst (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
1848: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
1849: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1850: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
1851: cp_end_method igs_lookup_values.lookup_code%TYPE) IS
1852: SELECT pti.rowid row_id,pti.*
1853: FROM igs_pe_typ_instances_all pti,
1854: igs_pe_person_types ppt

Line 2268: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,

2264: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
2265: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2266: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2267: CURSOR c_aa (
2268: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
2269: cp_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE) IS
2270: SELECT adm_appl_status
2271: FROM IGS_AD_APPL
2272: WHERE person_id = cp_person_id AND

Line 2269: cp_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE) IS

2265: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2266: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2267: CURSOR c_aa (
2268: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
2269: cp_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE) IS
2270: SELECT adm_appl_status
2271: FROM IGS_AD_APPL
2272: WHERE person_id = cp_person_id AND
2273: admission_appl_number = cp_admission_appl_number;

Line 3130: IF NOT IGS_AD_PS_APPL_PKG.Get_PK_For_Validation (

3126: (new_references.admission_appl_number IS NULL) OR
3127: (new_references.nominated_course_cd IS NULL))) THEN
3128: NULL;
3129: ELSE
3130: IF NOT IGS_AD_PS_APPL_PKG.Get_PK_For_Validation (
3131: new_references.person_id,
3132: new_references.admission_appl_number,
3133: new_references.nominated_course_cd
3134: )THEN

Line 3237: IF NOT IGS_AD_PS_APPL_INST_PKG.Get_PK_For_Validation (

3233: (new_references.def_prev_term_adm_appl_num IS NULL) OR
3234: (new_references.def_prev_appl_sequence_num IS NULL))) THEN
3235: NULL;
3236: ELSE
3237: IF NOT IGS_AD_PS_APPL_INST_PKG.Get_PK_For_Validation (
3238: new_references.person_id,
3239: new_references.def_prev_term_adm_appl_num,
3240: new_references.nominated_course_cd,
3241: new_references.def_prev_appl_sequence_num

Line 3260: IF NOT IGS_AD_PS_APPL_INST_PKG.Get_PK_For_Validation (

3256: (new_references.def_term_adm_appl_num IS NULL) OR
3257: (new_references.def_appl_sequence_num IS NULL))) THEN
3258: NULL;
3259: ELSE
3260: IF NOT IGS_AD_PS_APPL_INST_PKG.Get_PK_For_Validation (
3261: new_references.person_id,
3262: new_references.def_term_adm_appl_num,
3263: new_references.nominated_course_cd,
3264: new_references.def_appl_sequence_num

Line 3301: IGS_AD_CREDENTIALS_PKG.get_fk_igs_ad_ps_appl_inst

3297: Change History
3298: Who When What
3299: nshee 07-feb-2001 Removed the call of IGS_AD_CREDENTIALS
3300: as part of Bug#2177686. The get_fk call
3301: IGS_AD_CREDENTIALS_PKG.get_fk_igs_ad_ps_appl_inst
3302: is no longer needed since this foreign key relation
3303: doesn't hold true with IGS_PE_CREDENTIALS table
3304: samaresh 21-dec-2001 Bug No 2158524
3305: Removed the call to get Fk to

Line 3331: Igs_Ad_Appl_Eval_Pkg.Get_FK_Igs_Ad_Ps_Appl_Inst (

3327:
3328:
3329: BEGIN
3330:
3331: Igs_Ad_Appl_Eval_Pkg.Get_FK_Igs_Ad_Ps_Appl_Inst (
3332: old_references.person_id,
3333: old_references.admission_appl_number,
3334: old_references.nominated_course_cd,
3335: old_references.sequence_number

Line 3337: Igs_Ad_Edugoal_Pkg.Get_FK_Igs_Ad_Ps_Appl_Inst (

3333: old_references.admission_appl_number,
3334: old_references.nominated_course_cd,
3335: old_references.sequence_number
3336: );
3337: Igs_Ad_Edugoal_Pkg.Get_FK_Igs_Ad_Ps_Appl_Inst (
3338: old_references.person_id,
3339: old_references.admission_appl_number,
3340: old_references.nominated_course_cd,
3341: old_references.sequence_number

Line 3343: Igs_Ad_Spl_Adm_Cat_Pkg.Get_FK_Igs_Ad_Ps_Appl_Inst (

3339: old_references.admission_appl_number,
3340: old_references.nominated_course_cd,
3341: old_references.sequence_number
3342: );
3343: Igs_Ad_Spl_Adm_Cat_Pkg.Get_FK_Igs_Ad_Ps_Appl_Inst (
3344: old_references.person_id,
3345: old_references.admission_appl_number,
3346: old_references.nominated_course_cd,
3347: old_references.sequence_number

Line 3349: Igs_Ad_Unit_Sets_Pkg.Get_FK_Igs_Ad_Ps_Appl_Inst (

3345: old_references.admission_appl_number,
3346: old_references.nominated_course_cd,
3347: old_references.sequence_number
3348: );
3349: Igs_Ad_Unit_Sets_Pkg.Get_FK_Igs_Ad_Ps_Appl_Inst (
3350: old_references.person_id,
3351: old_references.admission_appl_number,
3352: old_references.nominated_course_cd,
3353: old_references.sequence_number

Line 3355: IGS_AD_PS_APLINSTUNT_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3351: old_references.admission_appl_number,
3352: old_references.nominated_course_cd,
3353: old_references.sequence_number
3354: );
3355: IGS_AD_PS_APLINSTUNT_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3356: old_references.person_id,
3357: old_references.admission_appl_number,
3358: old_references.nominated_course_cd,
3359: old_references.sequence_number

Line 3361: IGS_RE_CANDIDATURE_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3357: old_references.admission_appl_number,
3358: old_references.nominated_course_cd,
3359: old_references.sequence_number
3360: );
3361: IGS_RE_CANDIDATURE_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3362: old_references.person_id,
3363: old_references.admission_appl_number,
3364: old_references.nominated_course_cd,
3365: old_references.sequence_number

Line 3367: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3363: old_references.admission_appl_number,
3364: old_references.nominated_course_cd,
3365: old_references.sequence_number
3366: );
3367: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3368: old_references.person_id,
3369: old_references.admission_appl_number,
3370: old_references.nominated_course_cd,
3371: old_references.sequence_number

Line 3373: IGS_AD_APPL_ARP_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3369: old_references.admission_appl_number,
3370: old_references.nominated_course_cd,
3371: old_references.sequence_number
3372: );
3373: IGS_AD_APPL_ARP_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3374: old_references.person_id,
3375: old_references.admission_appl_number,
3376: old_references.nominated_course_cd,
3377: old_references.sequence_number

Line 3381: IGS_AD_APLINS_ADMREQ_PKG.GET_FK_IGS_AD_PS_APPL_INST_ALL (

3377: old_references.sequence_number
3378: );
3379: -- added the following calls as per bug #2619603 -rghosh
3380:
3381: IGS_AD_APLINS_ADMREQ_PKG.GET_FK_IGS_AD_PS_APPL_INST_ALL (
3382: old_references.person_id,
3383: old_references.admission_appl_number,
3384: old_references.nominated_course_cd,
3385: old_references.sequence_number

Line 3387: IGS_AD_APPL_NOTES_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3383: old_references.admission_appl_number,
3384: old_references.nominated_course_cd,
3385: old_references.sequence_number
3386: );
3387: IGS_AD_APPL_NOTES_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3388: old_references.person_id,
3389: old_references.admission_appl_number,
3390: old_references.nominated_course_cd,
3391: old_references.sequence_number

Line 3393: IGS_AD_APPL_PGMAPPRV_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3389: old_references.admission_appl_number,
3390: old_references.nominated_course_cd,
3391: old_references.sequence_number
3392: );
3393: IGS_AD_APPL_PGMAPPRV_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3394: old_references.person_id,
3395: old_references.admission_appl_number,
3396: old_references.nominated_course_cd,
3397: old_references.sequence_number

Line 3399: IGS_AD_TSTSCR_USED_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3395: old_references.admission_appl_number,
3396: old_references.nominated_course_cd,
3397: old_references.sequence_number
3398: );
3399: IGS_AD_TSTSCR_USED_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3400: old_references.person_id,
3401: old_references.admission_appl_number,
3402: old_references.nominated_course_cd,
3403: old_references.sequence_number

Line 3406: IGS_PE_TYP_INSTANCES_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3402: old_references.nominated_course_cd,
3403: old_references.sequence_number
3404: );
3405:
3406: IGS_PE_TYP_INSTANCES_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3407: old_references.person_id,
3408: old_references.admission_appl_number,
3409: old_references.nominated_course_cd,
3410: old_references.sequence_number

Line 3421: 'BEGIN igs_he_ad_dtl_all_pkg.get_fk_igs_ad_ps_appl_inst_all(:1,:2,:3,:4); END;'

3417: OPEN c_hesa('IGS_HE_AD_DTL_ALL_PKG');
3418: FETCH c_hesa INTO l_hesa;
3419: IF c_hesa%FOUND THEN
3420: EXECUTE IMMEDIATE
3421: 'BEGIN igs_he_ad_dtl_all_pkg.get_fk_igs_ad_ps_appl_inst_all(:1,:2,:3,:4); END;'
3422: USING
3423: old_references.person_id,
3424: old_references.admission_appl_number,
3425: old_references.nominated_course_cd,

Line 3452: FROM igs_ad_ps_appl_inst_all

3448: (reverse chronological order - newest change first)
3449: ***************************************************************/
3450: CURSOR cur_rowid IS
3451: SELECT rowid
3452: FROM igs_ad_ps_appl_inst_all
3453: WHERE person_id = x_person_id
3454: AND admission_appl_number = x_admission_appl_number
3455: AND nominated_course_cd = x_nominated_course_cd
3456: AND sequence_number = x_sequence_number

Line 3488: FROM igs_ad_ps_appl_inst_all

3484: (reverse chronological order - newest change first)
3485: ***************************************************************/
3486: CURSOR cur_rowid IS
3487: SELECT rowid
3488: FROM igs_ad_ps_appl_inst_all
3489: WHERE person_id = x_person_id
3490: AND admission_appl_number = x_admission_appl_number
3491: AND nominated_course_cd = x_nominated_course_cd
3492: AND sequence_number = x_sequence_number;

Line 3520: FROM igs_ad_ps_appl_inst_all

3516: (reverse chronological order - newest change first)
3517: ***************************************************************/
3518: CURSOR cur_rowid1 IS
3519: SELECT rowid
3520: FROM igs_ad_ps_appl_inst_all
3521: WHERE pending_reason_id = x_code_id ;
3522: CURSOR cur_rowid2 IS
3523: SELECT rowid
3524: FROM igs_ad_ps_appl_inst_all

Line 3524: FROM igs_ad_ps_appl_inst_all

3520: FROM igs_ad_ps_appl_inst_all
3521: WHERE pending_reason_id = x_code_id ;
3522: CURSOR cur_rowid2 IS
3523: SELECT rowid
3524: FROM igs_ad_ps_appl_inst_all
3525: WHERE edu_goal_prior_enroll_id = x_code_id ;
3526: CURSOR cur_rowid3 IS
3527: SELECT rowid
3528: FROM igs_ad_ps_appl_inst_all

Line 3528: FROM igs_ad_ps_appl_inst_all

3524: FROM igs_ad_ps_appl_inst_all
3525: WHERE edu_goal_prior_enroll_id = x_code_id ;
3526: CURSOR cur_rowid3 IS
3527: SELECT rowid
3528: FROM igs_ad_ps_appl_inst_all
3529: WHERE app_source_id = x_code_id ;
3530: CURSOR cur_rowid5 IS
3531: SELECT rowid
3532: FROM igs_ad_ps_appl_inst_all

Line 3532: FROM igs_ad_ps_appl_inst_all

3528: FROM igs_ad_ps_appl_inst_all
3529: WHERE app_source_id = x_code_id ;
3530: CURSOR cur_rowid5 IS
3531: SELECT rowid
3532: FROM igs_ad_ps_appl_inst_all
3533: WHERE decision_reason_id = x_code_id ;
3534: CURSOR cur_rowid6 IS
3535: SELECT rowid
3536: FROM igs_ad_ps_appl_inst_all

Line 3536: FROM igs_ad_ps_appl_inst_all

3532: FROM igs_ad_ps_appl_inst_all
3533: WHERE decision_reason_id = x_code_id ;
3534: CURSOR cur_rowid6 IS
3535: SELECT rowid
3536: FROM igs_ad_ps_appl_inst_all
3537: WHERE entry_status = x_code_id ;
3538: CURSOR cur_rowid7 IS
3539: SELECT rowid
3540: FROM igs_ad_ps_appl_inst_all

Line 3540: FROM igs_ad_ps_appl_inst_all

3536: FROM igs_ad_ps_appl_inst_all
3537: WHERE entry_status = x_code_id ;
3538: CURSOR cur_rowid7 IS
3539: SELECT rowid
3540: FROM igs_ad_ps_appl_inst_all
3541: WHERE entry_level = x_code_id ;
3542: lv_rowid cur_rowid1%RowType;
3543: BEGIN
3544: Open cur_rowid1;

Line 3620: FROM igs_ad_ps_appl_inst_all

3616: (reverse chronological order - newest change first)
3617: ***************************************************************/
3618: CURSOR cur_rowid IS
3619: SELECT rowid
3620: FROM igs_ad_ps_appl_inst_all
3621: WHERE attent_other_inst_cd = x_institution_cd ;
3622: lv_rowid cur_rowid%RowType;
3623: BEGIN
3624: Open cur_rowid;

Line 3650: FROM IGS_AD_PS_APPL_INST_ALL

3646: (reverse chronological order - newest change first)
3647: ***************************************************************/
3648: CURSOR cur_rowid1 IS
3649: SELECT rowid
3650: FROM IGS_AD_PS_APPL_INST_ALL
3651: WHERE person_id = x_person_id ;
3652: CURSOR cur_rowid2 IS
3653: SELECT rowid
3654: FROM igs_ad_ps_appl_inst_all

Line 3654: FROM igs_ad_ps_appl_inst_all

3650: FROM IGS_AD_PS_APPL_INST_ALL
3651: WHERE person_id = x_person_id ;
3652: CURSOR cur_rowid2 IS
3653: SELECT rowid
3654: FROM igs_ad_ps_appl_inst_all
3655: WHERE decision_make_id = x_person_id ;
3656: lv_rowid cur_rowid1%RowType;
3657: BEGIN
3658: Open cur_rowid1;

Line 3685: FROM IGS_AD_PS_APPL_INST_ALL

3681: x_attendance_mode IN VARCHAR2
3682: ) IS
3683: CURSOR cur_rowid IS
3684: SELECT rowid
3685: FROM IGS_AD_PS_APPL_INST_ALL
3686: WHERE attendance_mode = x_attendance_mode ;
3687: lv_rowid cur_rowid%RowType;
3688: BEGIN
3689: Open cur_rowid;

Line 3707: FROM IGS_AD_PS_APPL_INST_ALL

3703: x_adm_offer_dfrmnt_status IN VARCHAR2
3704: ) IS
3705: CURSOR cur_rowid IS
3706: SELECT rowid
3707: FROM IGS_AD_PS_APPL_INST_ALL
3708: WHERE adm_offer_dfrmnt_status = x_adm_offer_dfrmnt_status ;
3709: lv_rowid cur_rowid%RowType;
3710: BEGIN
3711: Open cur_rowid;

Line 3729: FROM IGS_AD_PS_APPL_INST_ALL

3725: x_adm_offer_resp_status IN VARCHAR2
3726: ) IS
3727: CURSOR cur_rowid IS
3728: SELECT rowid
3729: FROM IGS_AD_PS_APPL_INST_ALL
3730: WHERE adm_offer_resp_status = x_adm_offer_resp_status ;
3731: lv_rowid cur_rowid%RowType;
3732: BEGIN
3733: Open cur_rowid;

Line 3751: FROM IGS_AD_PS_APPL_INST_ALL

3747: x_adm_outcome_status IN VARCHAR2
3748: ) IS
3749: CURSOR cur_rowid IS
3750: SELECT rowid
3751: FROM IGS_AD_PS_APPL_INST_ALL
3752: WHERE adm_outcome_status = x_adm_outcome_status ;
3753: lv_rowid cur_rowid%RowType;
3754: BEGIN
3755: Open cur_rowid;

Line 3772: FROM IGS_AD_PS_APPL_INST_ALL

3768: x_attendance_type IN VARCHAR2
3769: ) IS
3770: CURSOR cur_rowid IS
3771: SELECT rowid
3772: FROM IGS_AD_PS_APPL_INST_ALL
3773: WHERE attendance_type = x_attendance_type ;
3774: lv_rowid cur_rowid%RowType;
3775: BEGIN
3776: Open cur_rowid;

Line 3793: FROM IGS_AD_PS_APPL_INST_ALL

3789: x_correspondence_cat IN VARCHAR2
3790: ) IS
3791: CURSOR cur_rowid IS
3792: SELECT rowid
3793: FROM IGS_AD_PS_APPL_INST_ALL
3794: WHERE correspondence_cat = x_correspondence_cat ;
3795: lv_rowid cur_rowid%RowType;
3796: BEGIN
3797: Open cur_rowid;

Line 3822: FROM IGS_AD_PS_APPL_INST_ALL

3818: -- future_acad_cal_type,future_acad_ci_sequence_number,
3819: -------------------------------------------------------------------
3820: CURSOR cur_rowid IS
3821: SELECT rowid
3822: FROM IGS_AD_PS_APPL_INST_ALL
3823: WHERE (deferred_adm_cal_type = x_cal_type
3824: AND deferred_adm_ci_sequence_num = x_sequence_number)
3825: OR (adm_cal_type = x_cal_type
3826: AND adm_ci_sequence_number = x_sequence_number )

Line 3851: FROM IGS_AD_PS_APPL_INST_ALL

3847: x_course_cd IN VARCHAR2
3848: ) IS
3849: CURSOR cur_rowid IS
3850: SELECT rowid
3851: FROM IGS_AD_PS_APPL_INST_ALL
3852: WHERE course_cd = x_course_cd ;
3853: lv_rowid cur_rowid%RowType;
3854: BEGIN
3855: Open cur_rowid;

Line 3873: FROM IGS_AD_PS_APPL_INST_ALL

3869: x_version_number IN NUMBER
3870: ) IS
3871: CURSOR cur_rowid IS
3872: SELECT rowid
3873: FROM IGS_AD_PS_APPL_INST_ALL
3874: WHERE course_cd = x_course_cd
3875: AND crv_version_number = x_version_number ;
3876: lv_rowid cur_rowid%RowType;
3877: BEGIN

Line 3895: FROM IGS_AD_PS_APPL_INST_ALL

3891: x_enrolment_cat IN VARCHAR2
3892: ) IS
3893: CURSOR cur_rowid IS
3894: SELECT rowid
3895: FROM IGS_AD_PS_APPL_INST_ALL
3896: WHERE enrolment_cat = x_enrolment_cat ;
3897: lv_rowid cur_rowid%RowType;
3898: BEGIN
3899: Open cur_rowid;

Line 3916: FROM IGS_AD_PS_APPL_INST_ALL

3912: x_fee_cat IN VARCHAR2
3913: ) IS
3914: CURSOR cur_rowid IS
3915: SELECT rowid
3916: FROM IGS_AD_PS_APPL_INST_ALL
3917: WHERE fee_cat = x_fee_cat ;
3918: lv_rowid cur_rowid%RowType;
3919: BEGIN
3920: Open cur_rowid;

Line 3937: FROM IGS_AD_PS_APPL_INST_ALL

3933: x_funding_source IN VARCHAR2
3934: ) IS
3935: CURSOR cur_rowid IS
3936: SELECT rowid
3937: FROM IGS_AD_PS_APPL_INST_ALL
3938: WHERE funding_source = x_funding_source ;
3939: lv_rowid cur_rowid%RowType;
3940: BEGIN
3941: Open cur_rowid;

Line 3958: FROM IGS_AD_PS_APPL_INST_ALL

3954: x_hecs_payment_option IN VARCHAR2
3955: ) IS
3956: CURSOR cur_rowid IS
3957: SELECT rowid
3958: FROM IGS_AD_PS_APPL_INST_ALL
3959: WHERE hecs_payment_option = x_hecs_payment_option ;
3960: lv_rowid cur_rowid%RowType;
3961: BEGIN
3962: Open cur_rowid;

Line 3979: FROM IGS_AD_PS_APPL_INST_ALL

3975: x_location_cd IN VARCHAR2
3976: ) IS
3977: CURSOR cur_rowid IS
3978: SELECT rowid
3979: FROM IGS_AD_PS_APPL_INST_ALL
3980: WHERE location_cd = x_location_cd ;
3981: lv_rowid cur_rowid%RowType;
3982: BEGIN
3983: Open cur_rowid;

Line 4000: FROM IGS_AD_PS_APPL_INST_ALL

3996: x_tracking_id IN NUMBER
3997: ) IS
3998: CURSOR cur_rowid IS
3999: SELECT rowid
4000: FROM IGS_AD_PS_APPL_INST_ALL
4001: WHERE ass_tracking_id = x_tracking_id
4002: OR deferred_tracking_id = x_tracking_id ;
4003: lv_rowid cur_rowid%RowType;
4004: BEGIN

Line 4023: FROM IGS_AD_PS_APPL_INST_ALL

4019: x_version_number IN NUMBER
4020: ) IS
4021: CURSOR cur_rowid IS
4022: SELECT rowid
4023: FROM IGS_AD_PS_APPL_INST_ALL
4024: WHERE unit_set_cd = x_unit_set_cd
4025: AND us_version_number = x_version_number ;
4026: lv_rowid cur_rowid%RowType;
4027: BEGIN

Line 4050: FROM IGS_AD_PS_APPL_INST_ALL ainst, IGS_AD_APPL_ALL apl

4046: x_acad_cal_type VARCHAR2
4047: ) IS
4048: CURSOR cur_rowid IS
4049: SELECT ainst.rowid
4050: FROM IGS_AD_PS_APPL_INST_ALL ainst, IGS_AD_APPL_ALL apl
4051: WHERE ainst.person_id = apl.person_id
4052: AND ainst.admission_appl_number = apl.admission_appl_number
4053: AND ainst.unit_set_cd = x_unit_set_cd
4054: AND ainst.us_version_number = x_version_number

Line 4082: FROM IGS_AD_PS_APPL_INST_ALL

4078: x_admission_appl_number IN NUMBER
4079: ) IS
4080: CURSOR cur_rowid IS
4081: SELECT rowid
4082: FROM IGS_AD_PS_APPL_INST_ALL
4083: WHERE person_id = x_person_id
4084: AND admission_appl_number = x_admission_appl_number ;
4085: lv_rowid cur_rowid%RowType;
4086: BEGIN

Line 4099: PROCEDURE GET_FK_IGS_AD_PS_APPL (

4095: END IF;
4096: Close cur_rowid;
4097: END GET_FK_IGS_AD_APPL;
4098:
4099: PROCEDURE GET_FK_IGS_AD_PS_APPL (
4100: x_person_id IN NUMBER,
4101: x_admission_appl_number IN NUMBER,
4102: x_nominated_course_cd IN VARCHAR2
4103: ) IS

Line 4106: FROM IGS_AD_PS_APPL_INST_ALL

4102: x_nominated_course_cd IN VARCHAR2
4103: ) IS
4104: CURSOR cur_rowid IS
4105: SELECT rowid
4106: FROM IGS_AD_PS_APPL_INST_ALL
4107: WHERE person_id = x_person_id
4108: AND admission_appl_number = x_admission_appl_number
4109: AND nominated_course_cd = x_nominated_course_cd ;
4110: lv_rowid cur_rowid%RowType;

Line 4122: END GET_FK_IGS_AD_PS_APPL;

4118: App_Exception.Raise_Exception;
4119: Return;
4120: END IF;
4121: Close cur_rowid;
4122: END GET_FK_IGS_AD_PS_APPL;
4123:
4124: PROCEDURE GET_FK_IGS_AD_CNDNL_OFRSTAT (
4125: x_adm_cndtnl_offer_status IN VARCHAR2
4126: ) IS

Line 4129: FROM IGS_AD_PS_APPL_INST_ALL

4125: x_adm_cndtnl_offer_status IN VARCHAR2
4126: ) IS
4127: CURSOR cur_rowid IS
4128: SELECT rowid
4129: FROM IGS_AD_PS_APPL_INST_ALL
4130: WHERE adm_cndtnl_offer_status = x_adm_cndtnl_offer_status ;
4131: lv_rowid cur_rowid%RowType;
4132: BEGIN
4133: Open cur_rowid;

Line 4150: FROM IGS_AD_PS_APPL_INST_ALL

4146: x_adm_doc_status IN VARCHAR2
4147: ) IS
4148: CURSOR cur_rowid IS
4149: SELECT rowid
4150: FROM IGS_AD_PS_APPL_INST_ALL
4151: WHERE adm_doc_status = x_adm_doc_status ;
4152: lv_rowid cur_rowid%RowType;
4153: BEGIN
4154: Open cur_rowid;

Line 4171: FROM IGS_AD_PS_APPL_INST_ALL

4167: x_adm_entry_qual_status IN VARCHAR2
4168: ) IS
4169: CURSOR cur_rowid IS
4170: SELECT rowid
4171: FROM IGS_AD_PS_APPL_INST_ALL
4172: WHERE adm_entry_qual_status = x_adm_entry_qual_status ;
4173: lv_rowid cur_rowid%RowType;
4174: BEGIN
4175: Open cur_rowid;

Line 4192: FROM IGS_AD_PS_APPL_INST_ALL

4188: x_adm_fee_status IN VARCHAR2
4189: ) IS
4190: CURSOR cur_rowid IS
4191: SELECT rowid
4192: FROM IGS_AD_PS_APPL_INST_ALL
4193: WHERE late_adm_fee_status = x_adm_fee_status ;
4194: lv_rowid cur_rowid%RowType;
4195: BEGIN
4196: Open cur_rowid;

Line 4222: FROM igs_ad_ps_appl_inst_all

4218: (reverse chronological order - newest change first)
4219: ***************************************************************/
4220: CURSOR cur_rowid IS
4221: SELECT rowid
4222: FROM igs_ad_ps_appl_inst_all
4223: WHERE sch_apl_to_id = x_sch_apl_to_id;
4224: lv_rowid cur_rowid%RowType;
4225: BEGIN
4226: Open cur_rowid;

Line 4411: l_adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;

4407: admission_appl_number = cp_admission_appl_number;
4408:
4409: c_get_appl_details_rec c_get_appl_details%ROWTYPE;
4410: l_message_name VARCHAR2(30);
4411: l_adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
4412:
4413: --- begin apadegal ADTD001 RE-OPEN Build igs.m
4414: CURSOR cur_reconsider IS
4415: SELECT req_for_reconsideration_ind

Line 4416: FROM IGS_AD_PS_APPL_ALL apl

4412:
4413: --- begin apadegal ADTD001 RE-OPEN Build igs.m
4414: CURSOR cur_reconsider IS
4415: SELECT req_for_reconsideration_ind
4416: FROM IGS_AD_PS_APPL_ALL apl
4417: WHERE apl.person_id = new_references.person_id
4418: AND apl.admission_appl_number = new_references.admission_appl_number
4419: AND apl.nominated_course_cd = new_references.nominated_course_cd ;
4420:

Line 4703: FROM igs_ad_ps_appl_inst

4699: -- kamohan bug 2407628
4700: -- Added this cursor to check if there is an application instance already existing
4701: CURSOR appl_inst_exist_cur IS
4702: SELECT DISTINCT 1
4703: FROM igs_ad_ps_appl_inst
4704: WHERE row_id <> x_rowid
4705: AND person_id = new_references.person_id
4706: AND igs_ad_gen_008.admp_get_saors (adm_offer_resp_status) IN ('ACCEPTED', 'DEFERRAL');
4707:

Line 4743: FROM IGS_AD_PS_APPL_ALL

4739:
4740: CURSOR c_recon_flag (cp_person_id IN NUMBER, cp_adm_application_num IN NUMBER,
4741: cp_nomintaed_course_code IN VARCHAR2) IS
4742: SELECT REQ_FOR_RECONSIDERATION_IND
4743: FROM IGS_AD_PS_APPL_ALL
4744: WHERE PERSON_ID = cp_person_id
4745: AND ADMISSION_APPL_NUMBER = cp_adm_application_num
4746: AND NOMINATED_COURSE_CD = cp_nomintaed_course_code;
4747:

Line 4748: l_req_for_reconsideration_ind IGS_AD_PS_APPL_ALL.REQ_FOR_RECONSIDERATION_IND%TYPE;

4744: WHERE PERSON_ID = cp_person_id
4745: AND ADMISSION_APPL_NUMBER = cp_adm_application_num
4746: AND NOMINATED_COURSE_CD = cp_nomintaed_course_code;
4747:
4748: l_req_for_reconsideration_ind IGS_AD_PS_APPL_ALL.REQ_FOR_RECONSIDERATION_IND%TYPE;
4749: -- end ravi shar changes
4750:
4751: -- kamohan Bug 2407628
4752: -- Added in order to avoid the hit to the database every time the records are looped through

Line 5100: cursor C is select ROWID from IGS_AD_PS_APPL_INST_ALL

5096: Change History
5097: Who When What
5098: (reverse chronological order - newest change first)
5099: ***************************************************************/
5100: cursor C is select ROWID from IGS_AD_PS_APPL_INST_ALL
5101: where PERSON_ID= X_PERSON_ID
5102: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
5103: and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD
5104: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;

Line 5284: insert into IGS_AD_PS_APPL_INST_ALL (

5280: );
5281: IF (x_mode = 'S') THEN
5282: igs_sc_gen_001.set_ctx('R');
5283: END IF;
5284: insert into IGS_AD_PS_APPL_INST_ALL (
5285: ORG_ID,
5286: PERSON_ID
5287: ,ADMISSION_APPL_NUMBER
5288: ,NOMINATED_COURSE_CD

Line 5867: from IGS_AD_PS_APPL_INST_ALL

5863: , appl_inst_status --arvsrini igsm
5864: , ais_reason
5865: , decline_ofr_reason
5866:
5867: from IGS_AD_PS_APPL_INST_ALL
5868: where ROWID = X_ROWID
5869: for update nowait;
5870: tlinfo c1%rowtype;
5871: begin

Line 5876: IGS_AD_GEN_001.SET_TOKEN('From IGS_AD_PS_APPL_INST ->Parameter : Lock_row ');

5872: open c1;
5873: fetch c1 into tlinfo;
5874: if (c1%notfound) then
5875: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
5876: IGS_AD_GEN_001.SET_TOKEN('From IGS_AD_PS_APPL_INST ->Parameter : Lock_row ');
5877: IGS_GE_MSG_STACK.ADD;
5878: close c1;
5879: app_exception.raise_exception;
5880: return;

Line 6366: update IGS_AD_PS_APPL_INST_ALL set

6362: IF (x_mode = 'S') THEN
6363: igs_sc_gen_001.set_ctx('R');
6364: END IF;
6365:
6366: update IGS_AD_PS_APPL_INST_ALL set
6367: PREDICTED_GPA = NEW_REFERENCES.PREDICTED_GPA,
6368: ACADEMIC_INDEX = NEW_REFERENCES.ACADEMIC_INDEX,
6369: ADM_CAL_TYPE = NEW_REFERENCES.ADM_CAL_TYPE,
6370: APP_FILE_LOCATION = NEW_REFERENCES.APP_FILE_LOCATION,

Line 6682: cursor c1 is select ROWID from IGS_AD_PS_APPL_INST_ALL

6678: Change History
6679: Who When What
6680: (reverse chronological order - newest change first)
6681: ***************************************************************/
6682: cursor c1 is select ROWID from IGS_AD_PS_APPL_INST_ALL
6683: where PERSON_ID= X_PERSON_ID
6684: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
6685: and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD
6686: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;

Line 6984: delete from IGS_AD_PS_APPL_INST_ALL

6980: );
6981: IF (x_mode = 'S') THEN
6982: igs_sc_gen_001.set_ctx('R');
6983: END IF;
6984: delete from IGS_AD_PS_APPL_INST_ALL
6985: where ROWID = X_ROWID;
6986: if (sql%notfound) then
6987: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
6988: igs_ge_msg_stack.add;

Line 7021: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,

7017: END IF;
7018:
7019: end DELETE_ROW;
7020:
7021: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
7022: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
7023: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
7024: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7025: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,

Line 7022: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

7018:
7019: end DELETE_ROW;
7020:
7021: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
7022: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
7023: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
7024: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7025: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7026: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,

Line 7023: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,

7019: end DELETE_ROW;
7020:
7021: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
7022: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
7023: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
7024: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7025: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7026: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7027: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,

Line 7024: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,

7020:
7021: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
7022: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
7023: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
7024: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7025: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7026: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7027: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7028: p_person_id igs_pe_person.person_id%TYPE,

Line 7025: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,

7021: PROCEDURE ucas_user_hook (p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
7022: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
7023: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
7024: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7025: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7026: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7027: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7028: p_person_id igs_pe_person.person_id%TYPE,
7029: p_condition_category IN igs_uc_offer_conds.condition_category%TYPE,

Line 7026: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,

7022: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
7023: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
7024: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7025: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7026: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7027: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7028: p_person_id igs_pe_person.person_id%TYPE,
7029: p_condition_category IN igs_uc_offer_conds.condition_category%TYPE,
7030: p_condition_name IN igs_uc_offer_conds.condition_name%TYPE,

Line 7027: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,

7023: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
7024: p_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7025: p_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7026: p_adm_outcome_status_old igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
7027: p_cond_offer_status_old igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
7028: p_person_id igs_pe_person.person_id%TYPE,
7029: p_condition_category IN igs_uc_offer_conds.condition_category%TYPE,
7030: p_condition_name IN igs_uc_offer_conds.condition_name%TYPE,
7031: p_uc_tran_id OUT NOCOPY NUMBER )

Line 7435: END igs_ad_ps_appl_inst_pkg;

7431:
7432: END check_non_updateable_list;
7433:
7434:
7435: END igs_ad_ps_appl_inst_pkg;