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_025 dependencies on IGS_PE_FLNY_DTL_INT

Line 534: FROM igs_pe_flny_dtl_int ai,

530:
531: --Pick up the records for processing from the Felony Details Interface Table
532: CURSOR felony_dtls_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
533: SELECT ai.*, i.person_id
534: FROM igs_pe_flny_dtl_int ai,
535: igs_ad_interface_all i
536: WHERE ai.interface_id = i.interface_id
537: AND ai.status = '2'
538: AND ai.interface_run_id=cp_interface_run_id

Line 552: l_status IGS_PE_FLNY_DTL_INT.status%TYPE;

548:
549: dup_chk_rec dup_chk_cur%ROWTYPE;
550:
551: l_rule VARCHAR2(1);
552: l_status IGS_PE_FLNY_DTL_INT.status%TYPE;
553: l_error_code IGS_PE_FLNY_DTL_INT.error_code%TYPE;
554: l_processed_records NUMBER(5) := 0;
555: l_message_name VARCHAR2(30) := NULL;
556: l_app VARCHAR2(50) := NULL;

Line 553: l_error_code IGS_PE_FLNY_DTL_INT.error_code%TYPE;

549: dup_chk_rec dup_chk_cur%ROWTYPE;
550:
551: l_rule VARCHAR2(1);
552: l_status IGS_PE_FLNY_DTL_INT.status%TYPE;
553: l_error_code IGS_PE_FLNY_DTL_INT.error_code%TYPE;
554: l_processed_records NUMBER(5) := 0;
555: l_message_name VARCHAR2(30) := NULL;
556: l_app VARCHAR2(50) := NULL;
557:

Line 560: l_error_code IGS_PE_FLNY_DTL_INT.error_code%TYPE;

556: l_app VARCHAR2(50) := NULL;
557:
558: -- Start of Local Procedure validate_felony_dtls
559: FUNCTION validate_felony_dtls(p_felony_dtls_cur felony_dtls_cur%ROWTYPE) RETURN BOOLEAN IS
560: l_error_code IGS_PE_FLNY_DTL_INT.error_code%TYPE;
561: BEGIN
562:
563: -- Convict_Indicator Validation
564: IF p_felony_dtls_cur.convict_ind NOT IN('Y','N') THEN

Line 580: igs_ad_imp_001.logerrormessage(p_felony_dtls_cur.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');

576: RETURN TRUE;
577: EXCEPTION
578: WHEN NO_DATA_FOUND THEN
579: IF l_enable_log = 'Y' THEN
580: igs_ad_imp_001.logerrormessage(p_felony_dtls_cur.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');
581: END IF;
582:
583: UPDATE igs_pe_flny_dtl_int
584: SET status = '3',

Line 583: UPDATE igs_pe_flny_dtl_int

579: IF l_enable_log = 'Y' THEN
580: igs_ad_imp_001.logerrormessage(p_felony_dtls_cur.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');
581: END IF;
582:
583: UPDATE igs_pe_flny_dtl_int
584: SET status = '3',
585: error_code = l_error_code
586: WHERE interface_felony_dtls_id = p_felony_dtls_cur.interface_felony_dtls_id;
587: RETURN FALSE;

Line 671: igs_ad_imp_001.logerrormessage(p_felony_dtls_rec.interface_felony_dtls_id,p_error_code,'IGS_PE_FLNY_DTL_INT');

667: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
668: END IF;
669: END IF;
670: IF l_enable_log = 'Y' THEN
671: igs_ad_imp_001.logerrormessage(p_felony_dtls_rec.interface_felony_dtls_id,p_error_code,'IGS_PE_FLNY_DTL_INT');
672: END IF;
673: END crt_pe_felony_dtls;
674: --
675: -- End of Local Procedure crt_pe_felony_dtls

Line 708: UPDATE igs_pe_flny_dtl_int pfi

704:
705: -- 1. If the rule is E or I, and the match ind column is not null, update all the records to status 3 as they are invalids.
706:
707: IF ((l_rule='E') OR (l_rule='I')) THEN
708: UPDATE igs_pe_flny_dtl_int pfi
709: SET status = '3',
710: error_code = 'E695'
711: WHERE pfi.status = '2' AND
712: pfi.interface_run_id = l_interface_run_id AND

Line 719: UPDATE igs_pe_flny_dtl_int pfi

715:
716: -- 2 . If rule is E and the match ind is null, we update the interface table for all duplicate records with status 1 and match ind 19.
717:
718: IF (l_rule = 'E') THEN
719: UPDATE igs_pe_flny_dtl_int pfi
720: SET status = '1',
721: match_ind = '19'
722: WHERE pfi.status = '2' AND
723: pfi.interface_run_id = l_interface_run_id AND

Line 738: UPDATE igs_pe_flny_dtl_int pfi

734:
735: -- 3. If rule is R and the record status is 18,19,22,23 these records have been processed, but didn't get updated. Update them to 1
736:
737: IF (l_rule='R') THEN
738: UPDATE igs_pe_flny_dtl_int pfi
739: SET status = 1
740: WHERE pfi.status = '2' AND
741: pfi.interface_run_id = l_interface_run_id AND
742: pfi.match_ind IN ('18','19','22','23');

Line 748: UPDATE igs_pe_flny_dtl_int pfi

744:
745: -- 4. If rule is R and the match ind is not null and is neither 21 nor 25, update it to errored record.
746:
747: IF (l_rule = 'R') THEN
748: UPDATE igs_pe_flny_dtl_int pfi
749: SET status = 3,
750: error_code = 'E695'
751: WHERE pfi.status = '2' AND
752: pfi.interface_run_id = l_interface_run_id AND

Line 759: UPDATE igs_pe_flny_dtl_int pfi

755:
756: -- 5. If rule = 'R' and there is no discprepency in duplicate records, update them to status 1 and match ind 23.
757:
758: IF (l_rule ='R') THEN
759: UPDATE igs_pe_flny_dtl_int pfi
760: SET status = '1',
761: match_ind = '23'
762: WHERE pfi.status = '2' AND
763: pfi.interface_run_id = l_interface_run_id AND

Line 783: UPDATE igs_pe_flny_dtl_int pfi

779: -- 6. If rule is R and there are still some records, they are the ones for which there is some discrepency existing. Update them to status 3
780: -- and value from the OSS table.
781:
782: IF (l_rule ='R') THEN
783: UPDATE igs_pe_flny_dtl_int pfi
784: SET status='3',
785: match_ind='20',
786: dup_felony_details_id=(SELECT pi.FELONY_DETAILS_ID
787: FROM igs_pe_felony_dtls pi,

Line 840: UPDATE igs_pe_flny_dtl_int

836: x_convict_ind => felony_dtls_rec.convict_ind,
837: x_disp_action_info => nvl(felony_dtls_rec.disp_action_info,dup_chk_rec.disp_action_info),
838: x_mode => 'R'
839: );
840: UPDATE igs_pe_flny_dtl_int
841: SET status = '1',
842: error_code=NULL,
843: match_ind='18'
844: WHERE interface_felony_dtls_id = felony_dtls_rec.interface_felony_dtls_id;

Line 880: igs_ad_imp_001.logerrormessage(felony_dtls_rec.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');

876: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
877: END IF;
878: END IF;
879: IF l_enable_log = 'Y' THEN
880: igs_ad_imp_001.logerrormessage(felony_dtls_rec.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');
881: END IF;
882:
883: UPDATE igs_pe_flny_dtl_int
884: SET status = l_status ,

Line 883: UPDATE igs_pe_flny_dtl_int

879: IF l_enable_log = 'Y' THEN
880: igs_ad_imp_001.logerrormessage(felony_dtls_rec.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');
881: END IF;
882:
883: UPDATE igs_pe_flny_dtl_int
884: SET status = l_status ,
885: error_code = l_error_code
886: WHERE interface_felony_dtls_id = felony_dtls_rec.interface_felony_dtls_id;
887: END;

Line 902: UPDATE igs_pe_flny_dtl_int

898: x_disp_action_info => NVL(felony_dtls_rec.disp_action_info,dup_chk_rec.disp_action_info),
899: x_mode => 'R'
900: );
901:
902: UPDATE igs_pe_flny_dtl_int
903: SET status = '1',
904: match_ind='18',
905: error_code=NULL
906: WHERE interface_felony_dtls_id = felony_dtls_rec.interface_felony_dtls_id;

Line 945: igs_ad_imp_001.logerrormessage(felony_dtls_rec.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');

941: END IF;
942: END IF;
943:
944: IF l_enable_log = 'Y' THEN
945: igs_ad_imp_001.logerrormessage(felony_dtls_rec.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');
946: END IF;
947:
948: UPDATE igs_pe_flny_dtl_int
949: SET status = l_status ,

Line 948: UPDATE igs_pe_flny_dtl_int

944: IF l_enable_log = 'Y' THEN
945: igs_ad_imp_001.logerrormessage(felony_dtls_rec.interface_felony_dtls_id,l_error_code,'IGS_PE_FLNY_DTL_INT');
946: END IF;
947:
948: UPDATE igs_pe_flny_dtl_int
949: SET status = l_status ,
950: error_code = l_error_code
951: WHERE interface_felony_dtls_id = felony_dtls_rec.interface_felony_dtls_id;
952: END;

Line 961: UPDATE igs_pe_flny_dtl_int

957: crt_pe_felony_dtls(
958: p_felony_dtls_rec => felony_dtls_rec,
959: p_status =>l_status,
960: p_error_code =>l_error_code );
961: UPDATE igs_pe_flny_dtl_int
962: SET status = l_status,
963: error_code = l_error_code
964: WHERE interface_felony_dtls_id = felony_dtls_rec.interface_felony_dtls_id;
965: END IF;-- For Dup_cur