eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_001 dependencies on IGS_AD_INTERFACE

Line 58: PROCEDURE print_stats(p_interface_run_id IN igs_ad_interface_all.interface_run_id%TYPE) AS

54:
55: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
56: END logerrormessage;
57:
58: PROCEDURE print_stats(p_interface_run_id IN igs_ad_interface_all.interface_run_id%TYPE) AS
59: /*****************************************************************
60: Created By : asbala
61: Creation date : 9/23/2003
62: Purpose : This function is to print the statistics from igs_ad_imp_stats.

Line 290: UPDATE igs_ad_interface ad

286: END;
287: END IF;
288:
289: -- Based upon person child
290: UPDATE igs_ad_interface ad
291: SET record_status = '3',
292: status = '4',
293: error_code = 'E347'
294: WHERE status = '1'

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 311: FROM igs_ad_interface

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
312: WHERE interface_run_id = p_interface_run_id
313: AND (record_status <> '1' OR status <> '1'));
314:
315: IF SQL%NOTFOUND THEN

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 477: FROM igs_ad_interface int,

473: BEGIN
474: SELECT 1 INTO l_count1
475: FROM DUAL
476: WHERE EXISTS (SELECT 1
477: FROM igs_ad_interface int,
478: igs_uc_qual_ints qint
479: WHERE int.interface_id = qint.interface_id
480: AND int.source_type_id = p_source_type_id
481: AND int.batch_id = p_batch_id

Line 493: FROM igs_ad_interface int,

489: BEGIN
490: SELECT 1 INTO l_count2
491: FROM DUAL
492: WHERE EXISTS (SELECT 1
493: FROM igs_ad_interface int,
494: igs_ad_apl_int aplint,
495: igs_ad_apphist_int applhist
496: WHERE int.interface_id = aplint.interface_id
497: AND aplint.interface_appl_id = applhist.interface_appl_id

Line 505: FROM igs_ad_interface int,

501: AND aplint.status IN ('1', '4', '2')
502: AND applhist.status = '2'
503: UNION ALL
504: SELECT 1
505: FROM igs_ad_interface int,
506: igs_ad_apl_int aplint,
507: igs_ad_ps_appl_inst_int aplinst,
508: igs_ad_insthist_int applinsthist
509: WHERE int.interface_id = aplint.interface_id

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 580: || npalanis 21-May-2002 Code is added to update interface_run_id in igs_ad_interface records

576: || gmuralid 4-DEC-2002 Change by gmuralid, removed reference to table igs_ad_intl_int,
577: || igs_pe_fund_dep_int.Included references to igs_pe_visa_int,
578: || igs_pe_vst_hist_int,igs_pe_passport_int,igs_pe_eit_int in delete logic
579: || As a part of BUG 2599109, SEVIS Build
580: || npalanis 21-May-2002 Code is added to update interface_run_id in igs_ad_interface records
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

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 718: -- Update the interface_run_id for IGS_AD_INTERFACE records with status in 1,2,4 for Bug - 2377123

714:
715: RETURN;
716: END IF;
717: END IF;
718: -- Update the interface_run_id for IGS_AD_INTERFACE records with status in 1,2,4 for Bug - 2377123
719: UPDATE igs_ad_interface_all
720: SET interface_run_id = l_interface_run_id
721: WHERE batch_id = p_batch_id
722: AND source_type_id = p_source_type_id

Line 719: UPDATE igs_ad_interface_all

715: RETURN;
716: END IF;
717: END IF;
718: -- Update the interface_run_id for IGS_AD_INTERFACE records with status in 1,2,4 for Bug - 2377123
719: UPDATE igs_ad_interface_all
720: SET interface_run_id = l_interface_run_id
721: WHERE batch_id = p_batch_id
722: AND source_type_id = p_source_type_id
723: AND status IN ('1','2','4');

Line 727: UPDATE igs_ad_interface_all int1

723: AND status IN ('1','2','4');
724: COMMIT;
725:
726: -- Update the interface records if the interface ids are duplicate (within the batch and across the batch)
727: UPDATE igs_ad_interface_all int1
728: SET status ='3',
729: error_code = 'E712'
730: WHERE EXISTS ( SELECT 1 FROM igs_ad_interface_all
731: WHERE interface_id = int1.interface_id

Line 730: WHERE EXISTS ( SELECT 1 FROM igs_ad_interface_all

726: -- Update the interface records if the interface ids are duplicate (within the batch and across the batch)
727: UPDATE igs_ad_interface_all int1
728: SET status ='3',
729: error_code = 'E712'
730: WHERE EXISTS ( SELECT 1 FROM igs_ad_interface_all
731: WHERE interface_id = int1.interface_id
732: AND rowid <> int1.rowid )
733: AND interface_run_id = l_interface_run_id;
734: COMMIT;

Line 741: tabname => 'IGS_AD_INTERFACE_ALL',

737: l_return := fnd_installation.get_app_info('IGS', l_status, l_industry, l_schema);
738:
739: -- Gather statistics of interface tables
740: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
741: tabname => 'IGS_AD_INTERFACE_ALL',
742: cascade => TRUE);
743:
744: -------------------------------------------------------
745: -- disable HZ security policy before starting the import.

Line 777: DELETE FROM igs_ad_interface_all

773:
774: igs_ad_imp_015.del_cmpld_ad_records (p_source_type_id => p_source_type_id,
775: p_batch_id => p_batch_id,
776: p_interface_run_id => l_interface_run_id);
777: DELETE FROM igs_ad_interface_all
778: WHERE status = '1'
779: AND record_status ='1'
780: AND interface_run_id = l_interface_run_id;
781:

Line 782: UPDATE igs_ad_interface_all

778: WHERE status = '1'
779: AND record_status ='1'
780: AND interface_run_id = l_interface_run_id;
781:
782: UPDATE igs_ad_interface_all
783: SET record_status = '3'
784: WHERE interface_run_id = l_interface_run_id
785: AND status <> '1';
786: COMMIT;

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;