APPS.FV_SF224_TRANSACTIONS dependencies on FV_SF224_MAP

Line 165: l_include_in_report fv_sf224_map.trx_category_coll%TYPE;

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: CURSOR current_224_cur
169: (

Line 277: CURSOR select_fv_sf224_map_cur(g_txn_category varchar2) is

273: l_reported_flag reported_flag_t;
274: l_je_from_sla_flag je_from_sla_flag_t;
275:
276: -- Bug 9066910
277: CURSOR select_fv_sf224_map_cur(g_txn_category varchar2) is
278: SELECT DECODE(g_txn_category, 'C', trx_category_coll,
279: 'P', trx_category_pay,
280: 'I', trx_category_intra,
281: 'I')

Line 282: FROM fv_sf224_map

278: SELECT DECODE(g_txn_category, 'C', trx_category_coll,
279: 'P', trx_category_pay,
280: 'I', trx_category_intra,
281: 'I')
282: FROM fv_sf224_map
283: WHERE NVL(business_activity_code, 'NULL') = NVL(l_business_activity_code, 'NULL')
284: AND NVL(gwa_reporter_category_code, 'NULL') = NVL(l_gwa_reporter_category_code, 'NULL');
285:
286: BEGIN

Line 666: FROM fv_sf224_map

662: 'P', trx_category_pay,
663: 'I', trx_category_intra,
664: 'I')
665: INTO l_include_in_report
666: FROM fv_sf224_map
667: WHERE NVL(business_activity_code, 'NULL') = NVL(l_business_activity_code, 'NULL')
668: AND NVL(gwa_reporter_category_code, 'NULL') = NVL(l_gwa_reporter_category_code, 'NULL');*/
669:
670: open select_fv_sf224_map_cur(l_txn_category(i));

Line 670: open select_fv_sf224_map_cur(l_txn_category(i));

666: FROM fv_sf224_map
667: WHERE NVL(business_activity_code, 'NULL') = NVL(l_business_activity_code, 'NULL')
668: AND NVL(gwa_reporter_category_code, 'NULL') = NVL(l_gwa_reporter_category_code, 'NULL');*/
669:
670: open select_fv_sf224_map_cur(l_txn_category(i));
671: fetch select_fv_sf224_map_cur into l_include_in_report;
672: close select_fv_sf224_map_cur;
673: EXCEPTION
674: WHEN NO_DATA_FOUND THEN

Line 671: fetch select_fv_sf224_map_cur into l_include_in_report;

667: WHERE NVL(business_activity_code, 'NULL') = NVL(l_business_activity_code, 'NULL')
668: AND NVL(gwa_reporter_category_code, 'NULL') = NVL(l_gwa_reporter_category_code, 'NULL');*/
669:
670: open select_fv_sf224_map_cur(l_txn_category(i));
671: fetch select_fv_sf224_map_cur into l_include_in_report;
672: close select_fv_sf224_map_cur;
673: EXCEPTION
674: WHEN NO_DATA_FOUND THEN
675: NULL;

Line 672: close select_fv_sf224_map_cur;

668: AND NVL(gwa_reporter_category_code, 'NULL') = NVL(l_gwa_reporter_category_code, 'NULL');*/
669:
670: open select_fv_sf224_map_cur(l_txn_category(i));
671: fetch select_fv_sf224_map_cur into l_include_in_report;
672: close select_fv_sf224_map_cur;
673: EXCEPTION
674: WHEN NO_DATA_FOUND THEN
675: NULL;
676: WHEN OTHERS THEN

Line 679: l_location := l_module_name||'select_fv_sf224_map';

675: NULL;
676: WHEN OTHERS THEN
677: p_error_code := g_FAILURE;
678: p_error_desc := SQLERRM;
679: l_location := l_module_name||'select_fv_sf224_map';
680: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
681: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
682: END;
683: END IF;

Line 4760: FROM fv_sf224_map mp

4756: IF l_ia_flag = 'Y' THEN /*CHECK FOR INTER GOVERENMENTAL TRANSACTION */
4757: BEGIN
4758: SELECT mp.trx_category_intra
4759: INTO l_reportable
4760: FROM fv_sf224_map mp
4761: WHERE mp.business_activity_code = p_business_activity_code
4762: AND mp.GWA_REPORTER_CATEGORY_CODE = p_gwa_reporter_category_code;
4763: EXCEPTION
4764: WHEN no_data_found THEN

Line 4776: FROM fv_sf224_map mp

4772: END IF;
4773: BEGIN
4774: SELECT mp.trx_category_coll
4775: INTO l_reportable
4776: FROM fv_sf224_map mp
4777: WHERE mp.business_activity_code = p_business_activity_code
4778: AND mp.GWA_REPORTER_CATEGORY_CODE = p_gwa_reporter_category_code;
4779: EXCEPTION
4780: WHEN no_data_found THEN

Line 4790: FROM fv_sf224_map mp

4786: END IF;
4787: BEGIN
4788: SELECT mp.trx_category_pay
4789: INTO l_reportable
4790: FROM fv_sf224_map mp
4791: WHERE mp.business_activity_code = p_business_activity_code
4792: AND mp.GWA_REPORTER_CATEGORY_CODE = p_gwa_reporter_category_code;
4793: EXCEPTION
4794: WHEN no_data_found THEN