APPS.IGS_AD_WF_001 dependencies on IGS_AD_APPL

Line 41: FROM igs_ad_appl

37: WHERE person_id = p_person_id;
38:
39: CURSOR get_application_id IS
40: SELECT application_id
41: FROM igs_ad_appl
42: WHERE person_id = p_person_id
43: AND admission_appl_number = p_admission_appl_number;
44:
45: CURSOR cur_user_name IS

Line 56: l_application_id igs_ad_appl_all.application_id%TYPE;

52: lv_raise_event VARCHAR2(100);
53: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
54: l_person_number igs_pe_person_base_v.person_number%TYPE;
55: l_person_name igs_pe_person_base_v.full_name%TYPE;
56: l_application_id igs_ad_appl_all.application_id%TYPE;
57: l_wf_role fnd_user.user_name%TYPE;
58:
59:
60: BEGIN

Line 138: l_application_id igs_ad_appl_all.application_id%TYPE;

134: lv_item_type VARCHAR2(100) ;
135: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
136: l_person_number igs_pe_person_base_v.person_number%TYPE;
137: l_person_name igs_pe_person_base_v.full_name%TYPE;
138: l_application_id igs_ad_appl_all.application_id%TYPE;
139: l_wf_role fnd_user.user_name%TYPE;
140:
141:
142: -- Get a unique sequence number

Line 155: FROM igs_ad_appl

151: WHERE person_id = p_person_id;
152:
153: CURSOR get_application_id IS
154: SELECT application_id
155: FROM igs_ad_appl
156: WHERE person_id = p_person_id
157: AND admission_appl_number = p_admission_appl_number;
158:
159: CURSOR cur_user_name IS

Line 271: lv_raise_event := 'oracle.apps.igs.ad.appl.mult_trns';

267:
268:
269: BEGIN
270:
271: lv_raise_event := 'oracle.apps.igs.ad.appl.mult_trns';
272: -- Get the sequence value
273: OPEN c_seq_num;
274: FETCH c_seq_num INTO ln_seq_val ;
275: CLOSE c_seq_num ;