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_FELONY_DTLS

Line 17: || kumma 21-OCT-2002 Added one more parameter for disp_action_info to the Igs_Pe_Felony_Dtls_Pkg.insert_row

13: || npalanis 6-JAN-2003 Bug : 2734697
14: || code added to commit after import of every
15: || 100 records .New variable l_processed_records added
16: || sarakshi 12-Nov-2001 Added procedure prc_pe_felony_dtls,prc_pe_hearing_dtls,prc_pe_disciplinary_dtls
17: || kumma 21-OCT-2002 Added one more parameter for disp_action_info to the Igs_Pe_Felony_Dtls_Pkg.insert_row
18: || and update_row in PROCEDURE crt_pe_felony_dtls , #2608360
19: || npalanis 30_OCT-2002 Bug : 2608360
20: || Trunc function added to crime date and nvl added for
21: || disp_action_info in prc_pe_felony_dtls.

Line 26: || Added a condition in exception section of crt_pe_felony_dtls after calling igs_pe_felony_dtls_pkg.update_row

22: || gmaheswa 1-Nov-2004 Bug : 3770362 removed code related to the effective dates(start_date , end_date)of housing status as they are obsoleted
23: || pkpatel 29-Nov-204 Bug : 3770362 In the Load Cal validation of Housing status modified to TRUNC of sysdate
24: || (reverse chronological order - newest change first)
25: || skpandey 08-JUL-2005 Bug : 4327807
26: || Added a condition in exception section of crt_pe_felony_dtls after calling igs_pe_felony_dtls_pkg.update_row
27: || and igs_pe_felony_dtls_pkg.insert_row to set status and error code
28: */
29: --
30: -- Starts procedure PRC_PE_HOUSE_STATUS

Line 27: || and igs_pe_felony_dtls_pkg.insert_row to set status and error code

23: || pkpatel 29-Nov-204 Bug : 3770362 In the Load Cal validation of Housing status modified to TRUNC of sysdate
24: || (reverse chronological order - newest change first)
25: || skpandey 08-JUL-2005 Bug : 4327807
26: || Added a condition in exception section of crt_pe_felony_dtls after calling igs_pe_felony_dtls_pkg.update_row
27: || and igs_pe_felony_dtls_pkg.insert_row to set status and error code
28: */
29: --
30: -- Starts procedure PRC_PE_HOUSE_STATUS
31: --

Line 544: FROM igs_pe_felony_dtls pf

540:
541: --Cursor to check whether the Record in Interface Table already exists in OSS table
542: CURSOR dup_chk_cur ( felony_dtls_rec felony_dtls_cur%ROWTYPE)IS
543: SELECT pf.rowid,pf.* -- select all the feilds from the OSS table to avoid opening the cursor below.
544: FROM igs_pe_felony_dtls pf
545: WHERE person_id = felony_dtls_rec.person_id
546: AND UPPER(crime_nature) = UPPER(felony_dtls_rec.crime_nature)
547: AND TRUNC(crime_date) = TRUNC(felony_dtls_rec.crime_date);
548:

Line 592: -- kumma, added one more parameter to the Igs_Pe_Felony_Dtls_Pkg.insert_row, #2608360

588: END validate_felony_dtls;
589: -- End Local Validate_Felony_Dtls
590:
591: -- Start of local procedure crt_pe_felony_dtls
592: -- kumma, added one more parameter to the Igs_Pe_Felony_Dtls_Pkg.insert_row, #2608360
593:
594: PROCEDURE crt_pe_felony_dtls( p_felony_dtls_rec felony_dtls_cur%ROWTYPE,
595: p_status OUT NOCOPY VARCHAR2,
596: p_error_code OUT NOCOPY VARCHAR2) AS

Line 599: l_felony_dtls_id IGS_PE_FELONY_DTLS.felony_details_id%TYPE;

595: p_status OUT NOCOPY VARCHAR2,
596: p_error_code OUT NOCOPY VARCHAR2) AS
597:
598: l_rowid VARCHAR2(25);
599: l_felony_dtls_id IGS_PE_FELONY_DTLS.felony_details_id%TYPE;
600:
601: BEGIN
602: -- Call Log header
603:

Line 618: Igs_Pe_Felony_Dtls_Pkg.insert_row (

614: l_label,
615: l_debug_str, NULL,
616: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
617: END IF;
618: Igs_Pe_Felony_Dtls_Pkg.insert_row (
619: x_rowid => l_rowid ,
620: x_felony_details_id => l_felony_dtls_id,
621: x_person_id => p_felony_dtls_rec.person_id,
622: x_crime_nature => p_felony_dtls_rec.crime_nature,

Line 726: FROM igs_pe_felony_dtls pi,

722: WHERE pfi.status = '2' AND
723: pfi.interface_run_id = l_interface_run_id AND
724: pfi.match_ind IS NULL AND
725: EXISTS (SELECT 1
726: FROM igs_pe_felony_dtls pi,
727: igs_ad_interface_all aii
728: WHERE pfi.interface_id = aii.interface_id
729: AND aii.interface_run_id = l_interface_run_id
730: AND aii.person_id = pi.person_id

Line 767: FROM igs_pe_felony_dtls pi,

763: pfi.interface_run_id = l_interface_run_id AND
764: pfi.match_ind IS NULL AND
765: EXISTS
766: (SELECT 1
767: FROM igs_pe_felony_dtls pi,
768: igs_ad_interface_all aii
769: WHERE pfi.interface_id = aii.interface_id
770: AND aii.interface_run_id = l_interface_run_id
771: AND NVL(aii.person_id,-99)= NVL(pi.person_id,-99)

Line 787: FROM igs_pe_felony_dtls pi,

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,
788: igs_ad_interface_all aii
789: WHERE pfi.interface_id = aii.interface_id
790: AND aii.interface_run_id = l_interface_run_id
791: AND aii.person_id = pi.person_id

Line 799: FROM igs_pe_felony_dtls pi,

795: pfi.interface_run_id = l_interface_run_id AND
796: pfi.match_ind IS NULL AND
797: EXISTS
798: (SELECT 1
799: FROM igs_pe_felony_dtls pi,
800: igs_ad_interface_all aii
801: WHERE pfi.interface_id = aii.interface_id
802: AND aii.interface_run_id = l_interface_run_id
803: AND aii.person_id = pi.person_id

Line 819: -- already exists in the table igs_pe_felony_dtls.

815: felony_dtls_rec.crime_date := TRUNC(felony_dtls_rec.crime_date);
816: --Validate the record picked up from interface table
817: IF validate_felony_dtls( felony_dtls_rec) THEN
818: -- for every record check whether a corresponding row
819: -- already exists in the table igs_pe_felony_dtls.
820: dup_chk_rec.felony_details_id :=NULL;
821: OPEN dup_chk_cur ( felony_dtls_rec );
822: FETCH dup_chk_cur INTO dup_chk_rec;
823: CLOSE dup_chk_cur;

Line 830: igs_pe_felony_dtls_pkg.update_row(

826: --If its a duplicate record find the source category rule for that Source Category.
827:
828: IF l_rule = 'I' THEN
829: BEGIN
830: igs_pe_felony_dtls_pkg.update_row(
831: x_rowid => dup_chk_rec.rowid,
832: x_felony_details_id=> dup_chk_rec.felony_details_id,
833: x_person_id =>NVL( felony_dtls_rec.person_id,dup_chk_rec.person_id),
834: x_crime_nature => dup_chk_rec.crime_nature,

Line 891: igs_pe_felony_dtls_pkg.update_row(

887: END;
888: ELSIF l_rule = 'R' THEN
889: IF felony_dtls_rec.match_ind = '21' THEN
890: BEGIN
891: igs_pe_felony_dtls_pkg.update_row(
892: x_rowid => dup_chk_rec.rowid,
893: x_felony_details_id=> dup_chk_rec.felony_details_id,
894: x_person_id =>NVL( dup_chk_rec.person_id,dup_chk_rec.person_id),
895: x_crime_nature =>felony_dtls_rec.crime_nature,