DBA Data[Home] [Help]

APPS.IGS_DA_XML_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 204: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,

200: ) RETURN VARCHAR2;
201:
202: PROCEDURE get_person_details
203: (
204: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
205: p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
206: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
207: p_person_number OUT NOCOPY hz_parties.party_number%TYPE
208: );

Line 205: p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,

201:
202: PROCEDURE get_person_details
203: (
204: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
205: p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
206: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
207: p_person_number OUT NOCOPY hz_parties.party_number%TYPE
208: );
209:

Line 213: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,

209:
210: PROCEDURE update_stdnts_err
211: (
212: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
213: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
214: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
215: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
216: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
217: x_return_status OUT NOCOPY VARCHAR2

Line 214: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,

210: PROCEDURE update_stdnts_err
211: (
212: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
213: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
214: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
215: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
216: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
217: x_return_status OUT NOCOPY VARCHAR2
218: ) ;

Line 223: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,

219:
220:
221: PROCEDURE update_req_students (
222: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
223: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
224: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
225: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
226: p_academicsubprogram_codes IN VARCHAR2,
227: p_program_code IN igs_da_req_stdnts.program_code%TYPE,

Line 224: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,

220:
221: PROCEDURE update_req_students (
222: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
223: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
224: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
225: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
226: p_academicsubprogram_codes IN VARCHAR2,
227: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
228: p_error_code IN igs_da_req_stdnts.error_code%TYPE,

Line 235: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,

231:
232: PROCEDURE insert_gpa
233: (
234: p_batch_id IN igs_pr_stu_acad_stat_int.batch_id%TYPE,
235: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
236: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
237: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
238: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
239: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,

Line 236: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,

232: PROCEDURE insert_gpa
233: (
234: p_batch_id IN igs_pr_stu_acad_stat_int.batch_id%TYPE,
235: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
236: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
237: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
238: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
239: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
240: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,

Line 252: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,

248:
249: PROCEDURE insert_program_completion
250: (
251: p_batch_id IN igs_pr_spa_complete_int.batch_id%TYPE,
252: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
253: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
254: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
255: p_program_complete IN VARCHAR2,
256: p_program_complete_date IN VARCHAR2,

Line 253: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,

249: PROCEDURE insert_program_completion
250: (
251: p_batch_id IN igs_pr_spa_complete_int.batch_id%TYPE,
252: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
253: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
254: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
255: p_program_complete IN VARCHAR2,
256: p_program_complete_date IN VARCHAR2,
257: x_return_status OUT NOCOPY VARCHAR2