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_INST_ALL

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 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 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 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 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 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 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 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 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;