APPS.IGS_AD_IMP_001 dependencies on IGS_AD_INTERFACE_CTL

Line 307: UPDATE igs_ad_interface_ctl

303: );
304: COMMIT;
305:
306: -- Based upon person
307: UPDATE igs_ad_interface_ctl
308: SET status = '3'
309: WHERE interface_run_id = p_interface_run_id
310: AND EXISTS (SELECT 1
311: FROM igs_ad_interface

Line 316: UPDATE igs_ad_interface_ctl

312: WHERE interface_run_id = p_interface_run_id
313: AND (record_status <> '1' OR status <> '1'));
314:
315: IF SQL%NOTFOUND THEN
316: UPDATE igs_ad_interface_ctl
317: SET status = '1'
318: WHERE interface_run_id = p_interface_run_id;
319: END IF;
320: COMMIT;

Line 525: UPDATE igs_ad_interface_ctl

521: END;
522:
523: IF l_count1 = 1 OR l_count2 = 1 THEN
524: -- Failure Condition
525: UPDATE igs_ad_interface_ctl
526: SET status = '3'
527: WHERE interface_run_id = p_interface_run_id;
528: COMMIT;
529:

Line 585: || Called IGS_AD_INTERFACE_CTL tables TBH and assigned l_interface_run_id to the value from OUT NOCOPY parameter TBH

581: || with status '1' ,'2' and '4' .The parameter p_interface_run_id passed
582: || to prc_pe_dtls is also removed as no more updation of interface_run_id
583: || is required there.
584: || rrengara 4-OCT-2002 Changed the ordering of the parameters batch id and source type id for the Build bug 2604395
585: || Called IGS_AD_INTERFACE_CTL tables TBH and assigned l_interface_run_id to the value from OUT NOCOPY parameter TBH
586: ||
587: || ssawhney 28-oct-2002 SWS104- Jan03 build residency details import added. moved acad honors to person level
588: || IGS_AD_REFS_INT table obsoleted.
589: || sjalsaut Oct 31, 02 SWSCR012 Bug 2435520 Removed College Activities references

Line 606: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;

602:
603: l_batch_desc igs_ad_imp_batch_det.batch_desc%TYPE;
604: l_source_type igs_pe_src_types_all.system_source_type%TYPE;
605: l_match_set_name igs_pe_match_sets_all.match_set_name%TYPE;
606: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;
607: l_rowid VARCHAR2(100);
608: l_cnt_dup_process_run NUMBER;
609: l_err_msg VARCHAR2(4000);
610: BEGIN

Line 683: igs_ad_interface_ctl_pkg.insert_row (

679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id ||' '|| 'Source Type :' || l_source_type );
680: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id ||' '|| 'Match Set Name :' || l_match_set_name );
681: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
682: END IF;
683: igs_ad_interface_ctl_pkg.insert_row (
684: x_rowid => l_rowid,
685: x_interface_run_id => l_interface_run_id ,
686: x_source_type_id => p_source_type_id,
687: x_batch_id => p_batch_id,

Line 693: FROM igs_ad_interface_ctl

689: x_status => '2',
690: x_mode => 'R');
691: COMMIT;
692: SELECT COUNT (*) INTO l_cnt_dup_process_run
693: FROM igs_ad_interface_ctl
694: WHERE batch_id = p_batch_id
695: AND source_type_id = p_source_type_id
696: AND status = '2';
697: IF l_cnt_dup_process_run > 1 THEN

Line 811: UPDATE igs_ad_interface_ctl

807:
808: -- Failure Condition
809:
810: IF l_interface_run_id IS NOT NULL THEN
811: UPDATE igs_ad_interface_ctl
812: SET status = '3'
813: WHERE rowid = l_rowid;
814: COMMIT;
815: END IF;