[Home] [Help]
161: l_cash_receipt_id NUMBER;
162: l_hi_date DATE := TO_DATE('12/31/9999', 'MM/DD/YYYY');
163: l_business_activity_code fv_alc_addresses_all.business_activity_code%TYPE;
164: l_gwa_reporter_category_code fv_alc_gwa_categories.gwa_reporter_category_code%TYPE;
165: l_include_in_report fv_sf224_map.trx_category_coll%TYPE;
166:
167:
168:
169: CURSOR current_224_cur
650: 'P', trx_category_pay,
651: 'I', trx_category_intra,
652: 'I')
653: INTO l_include_in_report
654: FROM fv_sf224_map
655: WHERE NVL(business_activity_code, 'NULL') = NVL(l_business_activity_code, 'NULL')
656: AND NVL(gwa_reporter_category_code, 'NULL') = NVL(l_gwa_reporter_category_code, 'NULL');
657: EXCEPTION
658: WHEN NO_DATA_FOUND THEN
659: NULL;
660: WHEN OTHERS THEN
661: p_error_code := g_FAILURE;
662: p_error_desc := SQLERRM;
663: l_location := l_module_name||'select_fv_sf224_map';
664: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
665: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
666: END;
667: END IF;
4618: IF l_ia_flag = 'Y' THEN /*CHECK FOR INTER GOVERENMENTAL TRANSACTION */
4619: BEGIN
4620: SELECT mp.trx_category_intra
4621: INTO l_reportable
4622: FROM fv_sf224_map mp
4623: WHERE mp.business_activity_code = p_business_activity_code
4624: AND mp.GWA_REPORTER_CATEGORY_CODE = p_gwa_reporter_category_code;
4625: EXCEPTION
4626: WHEN no_data_found THEN
4634: END IF;
4635: BEGIN
4636: SELECT mp.trx_category_coll
4637: INTO l_reportable
4638: FROM fv_sf224_map mp
4639: WHERE mp.business_activity_code = p_business_activity_code
4640: AND mp.GWA_REPORTER_CATEGORY_CODE = p_gwa_reporter_category_code;
4641: EXCEPTION
4642: WHEN no_data_found THEN
4648: END IF;
4649: BEGIN
4650: SELECT mp.trx_category_pay
4651: INTO l_reportable
4652: FROM fv_sf224_map mp
4653: WHERE mp.business_activity_code = p_business_activity_code
4654: AND mp.GWA_REPORTER_CATEGORY_CODE = p_gwa_reporter_category_code;
4655: EXCEPTION
4656: WHEN no_data_found THEN