APPS.IGS_SV_UTIL dependencies on IGS_SV_PERSONS

Line 215: l_person_rec igs_sv_persons%ROWTYPE;

211: l_gen_xml_flg BOOLEAN := TRUE ;
212: l_batch_id igs_sv_batches.batch_id%TYPE;
213: l_tmp_btch_id igs_sv_batches.batch_id%TYPE;
214: l_batch_rec igs_sv_batches%ROWTYPE;
215: l_person_rec igs_sv_persons%ROWTYPE;
216: l_tbl_name VARCHAR2 (30);
217: l_extra_criteria VARCHAR2 (100);
218: l_rec_count NUMBER;
219: l_query VARCHAR2(2000);

Line 220: l_pers_status igs_sv_persons.record_status%TYPE;

216: l_tbl_name VARCHAR2 (30);
217: l_extra_criteria VARCHAR2 (100);
218: l_rec_count NUMBER;
219: l_query VARCHAR2(2000);
220: l_pers_status igs_sv_persons.record_status%TYPE;
221: l_batch_status igs_sv_batches.BATCH_TYPE%TYPE;
222:
223: CURSOR batch_crsr (cp_batch_id NUMBER)
224: IS

Line 239: from igs_sv_persons

235: CURSOR pers_rec_status (cp_person_id NUMBER,cp_batch_id NUMBER)
236: IS
237: select
238: record_status
239: from igs_sv_persons
240: where person_id = cp_person_id and batch_id = cp_batch_id;
241:
242: BEGIN
243: SAVEPOINT batch_sav_pnt;

Line 392: l_person_rec igs_sv_persons%ROWTYPE;

388:
389: ******************************************************************/
390: l_batch_id igs_sv_batches.batch_id%TYPE;
391: l_batch_rec igs_sv_batches%ROWTYPE;
392: l_person_rec igs_sv_persons%ROWTYPE;
393: l_rec_count NUMBER;
394:
395: CURSOR batch_crsr (cp_batch_id NUMBER)
396: IS

Line 404: FROM igs_sv_persons

400:
401: CURSOR person_crsr (cp_person_id NUMBER, cp_batch_id NUMBER)
402: IS
403: SELECT *
404: FROM igs_sv_persons
405: WHERE batch_id = cp_batch_id AND person_id = cp_person_id;
406:
407: CURSOR chk_rec_count_crsr (cp_person_id NUMBER, cp_batch_id NUMBER)
408: IS

Line 451: UPDATE igs_sv_persons

447: CLOSE chk_rec_count_crsr;
448:
449: IF (l_rec_count = 1 and p_caller <> 'CONN_JOB')
450: THEN
451: UPDATE igs_sv_persons
452: SET batch_id = l_batch_id
453: WHERE batch_id = p_batch_id AND person_id = p_person_id;
454: ELSE
455: INSERT INTO igs_sv_persons

Line 455: INSERT INTO igs_sv_persons

451: UPDATE igs_sv_persons
452: SET batch_id = l_batch_id
453: WHERE batch_id = p_batch_id AND person_id = p_person_id;
454: ELSE
455: INSERT INTO igs_sv_persons
456: (batch_id, person_id,
457: record_number, form_id,
458: print_form, pdso_sevis_id,
459: record_status,

Line 528: l_person_rec igs_sv_persons%ROWTYPE;

524:
525: ******************************************************************/
526: l_batch_id igs_sv_batches.batch_id%TYPE;
527: l_batch_rec igs_sv_batches%ROWTYPE;
528: l_person_rec igs_sv_persons%ROWTYPE;
529: l_rec_count NUMBER;
530:
531:
532: CURSOR person_crsr (cp_person_id NUMBER, cp_batch_id NUMBER)

Line 535: FROM igs_sv_persons

531:
532: CURSOR person_crsr (cp_person_id NUMBER, cp_batch_id NUMBER)
533: IS
534: SELECT *
535: FROM igs_sv_persons
536: WHERE batch_id = cp_batch_id AND person_id = cp_person_id;
537:
538: BEGIN
539:

Line 544: INSERT INTO igs_sv_persons

540: OPEN person_crsr (p_person_id, p_old_batch_id);
541: FETCH person_crsr INTO l_person_rec;
542: CLOSE person_crsr;
543:
544: INSERT INTO igs_sv_persons
545: (batch_id, person_id,
546: record_number, form_id,
547: print_form, pdso_sevis_id,
548: record_status,