APPS.IGS_AD_IMP_025 dependencies on IGS_PE_FELONY_DTLS_PKG

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 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 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 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,