APPS.IGS_CO_SUBMIT dependencies on IGS_PE_PERSON

Line 194: l_person_id_dy igs_pe_person.person_id%TYPE;

190: l_gen_request_id igs_co_ou_co_ref.request_id%TYPE;
191: l_fulfillment_req NUMBER;
192: l_crm_user_id NUMBER;
193: l_email_address_dy hz_parties.email_address%TYPE;
194: l_person_id_dy igs_pe_person.person_id%TYPE;
195: l_adm_appl_number_dy igs_co_interac_hist.adm_application_number%TYPE;
196: l_nominated_course_cd_dy igs_co_interac_hist.nominated_course_cd%TYPE;
197: l_appl_sequence_number_dy igs_co_interac_hist.ci_sequence_number%TYPE;
198: l_panel_code_dy igs_ad_interview_letters_v.panel_code%TYPE;

Line 212: FROM igs_pe_person_base_v

208: -- Added cursor to print the person number in case of no email for bug 2742586
209: CURSOR c_person_number (pa_person_id NUMBER)
210: IS
211: SELECT person_number, full_name
212: FROM igs_pe_person_base_v
213: WHERE person_id = pa_person_id;
214:
215: l_person_number igs_pe_person_base_v.person_number%TYPE;
216: l_full_name igs_pe_person_base_v.full_name%TYPE;

Line 215: l_person_number igs_pe_person_base_v.person_number%TYPE;

211: SELECT person_number, full_name
212: FROM igs_pe_person_base_v
213: WHERE person_id = pa_person_id;
214:
215: l_person_number igs_pe_person_base_v.person_number%TYPE;
216: l_full_name igs_pe_person_base_v.full_name%TYPE;
217: l_cursor_id NUMBER (15);
218: l_num_of_rows NUMBER (15);
219: l_dsql_debug VARCHAR2 (32767);

Line 216: l_full_name igs_pe_person_base_v.full_name%TYPE;

212: FROM igs_pe_person_base_v
213: WHERE person_id = pa_person_id;
214:
215: l_person_number igs_pe_person_base_v.person_number%TYPE;
216: l_full_name igs_pe_person_base_v.full_name%TYPE;
217: l_cursor_id NUMBER (15);
218: l_num_of_rows NUMBER (15);
219: l_dsql_debug VARCHAR2 (32767);
220: l_person_processed NUMBER (10) := 0;

Line 1857: FROM igs_pe_person_base_v

1853: -- Cursor to log the person's processed
1854: CURSOR c_per_processed (cp_person_id NUMBER)
1855: IS
1856: SELECT person_number, full_name
1857: FROM igs_pe_person_base_v
1858: WHERE person_id = cp_person_id;
1859:
1860: -- Get version id of content for interaction history
1861: CURSOR c_content_version (

Line 1903: l_full_name igs_pe_person_base_v.full_name%TYPE;

1899: l_extended_header igs_co_prev_reqs.extended_header%TYPE;
1900: l_distribution_id igs_co_prev_reqs.distribution_id%TYPE;
1901: l_award_prd_cd igs_co_prev_reqs.award_prd_cd%TYPE;
1902: -- Person details...
1903: l_full_name igs_pe_person_base_v.full_name%TYPE;
1904: l_person_number igs_pe_person_base_v.person_number%TYPE;
1905: -- Version
1906: l_version ibc_citems_v.version%TYPE;
1907: -- Return status

Line 1904: l_person_number igs_pe_person_base_v.person_number%TYPE;

1900: l_distribution_id igs_co_prev_reqs.distribution_id%TYPE;
1901: l_award_prd_cd igs_co_prev_reqs.award_prd_cd%TYPE;
1902: -- Person details...
1903: l_full_name igs_pe_person_base_v.full_name%TYPE;
1904: l_person_number igs_pe_person_base_v.person_number%TYPE;
1905: -- Version
1906: l_version ibc_citems_v.version%TYPE;
1907: -- Return status
1908: l_return_status VARCHAR2 (30);