[Home] [Help]
5: || Created By : Sridhar
6: || Created On : 25-NOV-2000
7: || Purpose : Package creates a flat file with header,corrected records and trailer
8: || to be sent to CPS. After the file is created igf_ap_isir_corr,
9: || igf_ap_fa_base_rec tables are updated to change the correction_status.
10: || Known limitations, enhancements or remarks :
11: || Change History :
12: || Who When What
13: || bkkumar 07-May-2004 Bug 3598933 Added the fnd logging messages
88: CURSOR match_isirs (p_base_id NUMBER) IS
89: SELECT isirm.isir_id, isirm.s_email_address, isirm.transaction_num, isirm.original_ssn,
90: isirm.orig_name_id, isirm.first_name, isirm.last_name, isirm.base_id, PE.party_number person_number
91: FROM igf_ap_isir_matched_all isirm,
92: igf_ap_fa_base_rec_all far,
93: hz_parties pe
94: WHERE isirm.base_id = far.base_id
95: AND far.person_id = pe.party_Id
96: AND isirm.system_record_type = 'ORIGINAL'
412: || (reverse chronological order - newest change first)
413: */
414:
415:
416: CURSOR cur_get_sar_name (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,
417: l_sar_number igf_fc_sar_cd_mst.sar_field_number%TYPE ) IS
418: SELECT sar.sar_field_name
419: FROM igf_ap_batch_aw_map map,
420: igf_ap_fa_base_rec_all fabase ,
416: CURSOR cur_get_sar_name (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,
417: l_sar_number igf_fc_sar_cd_mst.sar_field_number%TYPE ) IS
418: SELECT sar.sar_field_name
419: FROM igf_ap_batch_aw_map map,
420: igf_ap_fa_base_rec_all fabase ,
421: igf_fc_sar_cd_mst sar
422: WHERE fabase.base_id = cp_base_id
423: AND map.ci_cal_type = fabase.ci_cal_type
424: AND map.ci_sequence_number = fabase.ci_sequence_number
959: /*
960: || Created By : Sridhar
961: || Created On : 25-NOV-2000
962: || Purpose : Updates the status of the records written into output file to batched
963: || in IGF_AP_ISIR_CORR and IGF_AP_FA_BASE_REC tables.
964: || Known limitations, enhancements or remarks :
965: || Change History :
966: || Who When What
967: || ugummall 26-SEP-2003 FA 126 - Multiple FA Offices.
965: || Change History :
966: || Who When What
967: || ugummall 26-SEP-2003 FA 126 - Multiple FA Offices.
968: || added new parameter assoc_org_num to TBH call
969: || igf_ap_fa_base_rec_pkg.update_row w.r.t. FA 126
970: ||
971: || masehgal 11-Nov-2002 FA 101 - SAP Obsoletion
972: || removed packaging hold
973: || masehgal 25-Sep-2002 FA 104 -To Do Enhancements
971: || masehgal 11-Nov-2002 FA 101 - SAP Obsoletion
972: || removed packaging hold
973: || masehgal 25-Sep-2002 FA 104 -To Do Enhancements
974: || Added manual_disb_hold in update of Fa Base Rec
975: || rbezawad 22-Jun-2001 igf_ap_fa_base_rec_pkg.update_row call modified by
976: || passing gv_batchnum to parameter x_ede_correction_batch_id
977: || w.r.t. Bug ID: 1821811
978: || (reverse chronological order - newest change first)
979: */
984: AND correction_status = cp_corr_stat ;
985:
986: CURSOR get_baserec IS
987: SELECT f.*
988: FROM igf_ap_fa_base_rec f
989: WHERE base_id = gn_baseid;
990:
991: pn_rec corr_rec%ROWTYPE;
992: base_rec get_baserec%ROWTYPE;
1034:
1035: IF get_baserec%NOTFOUND THEN
1036: NULL;
1037: ELSE
1038: igf_ap_fa_base_rec_pkg.update_row(
1039: x_mode => 'R',
1040: x_rowid => base_rec.row_id,
1041: x_base_id => base_rec.base_id,
1042: x_ci_cal_type => base_rec.ci_cal_type,