APPS.IGS_AD_SS_GEN_001 dependencies on IGS_SS_APP_REQ_STG

Line 87: p_adm_appl_id IN igs_ss_app_req_stg.ss_adm_appl_id%TYPE,

83: x_return_status OUT NOCOPY VARCHAR2);
84: -- Bug # 2389273 [ APPLICATION FEE SAVED IN SS IS NOT SAVED TO FORMS ]
85: --** added by nshee
86: PROCEDURE insert_application_fee(p_person_id IN igs_ad_app_req.person_id%TYPE,
87: p_adm_appl_id IN igs_ss_app_req_stg.ss_adm_appl_id%TYPE,
88: p_adm_appl_number IN igs_ad_app_req.admission_appl_number%TYPE);
89: --** end of addtion by nshee
90:
91:

Line 1390: DELETE FROM igs_ss_app_req_stg

1386: DELETE FROM igs_ss_ad_sec_stat
1387: WHERE person_id = p_person_id
1388: AND ss_adm_appl_id = p_adm_appl_number;
1389:
1390: DELETE FROM igs_ss_app_req_stg
1391: WHERE ss_adm_appl_id = p_adm_appl_number
1392: AND person_id = p_person_id;
1393:
1394: -- dvivekan

Line 3292: p_adm_appl_id IN igs_ss_app_req_stg.ss_adm_appl_id%TYPE,

3288: END validate_prog_inst;
3289:
3290: -- Bug # 2389273 [ APPLICATION FEE SAVED IN SS IS NOT SAVED TO FORMS ]
3291: PROCEDURE insert_application_fee(p_person_id IN igs_ad_app_req.person_id%TYPE,
3292: p_adm_appl_id IN igs_ss_app_req_stg.ss_adm_appl_id%TYPE,
3293: p_adm_appl_number IN igs_ad_app_req.admission_appl_number%TYPE) AS
3294: /*----------------------------------------------------------------------------
3295: || Created By :
3296: || Created On :

Line 3320: FROM IGS_SS_APP_REQ_STG

3316: fee_date,
3317: fee_payment_method,
3318: fee_amount,
3319: reference_num
3320: FROM IGS_SS_APP_REQ_STG
3321: WHERE person_id = p_person_id
3322: AND ss_adm_appl_id = p_adm_appl_id;
3323: lv_mode VARCHAR2(1) DEFAULT 'R';
3324: BEGIN