APPS.FV_SF224_TRANSACTIONS dependencies on FV_REFUNDS_VOIDS_ALL

Line 603: UPDATE fv_refunds_voids_all

599: END IF;
600:
601: IF (l_processed_flag(i) = 'Y' AND l_reported_month(i) like '%CURRENT%') then
602: BEGIN
603: UPDATE fv_refunds_voids_all
604: SET processed_flag = 'Y',
605: period_reported = p_gl_period,
606: last_updated_by = g_user_id,
607: last_update_date = g_sysdate,

Line 617: l_location := l_module_name||'update_fv_refunds_voids_all';

613: EXCEPTION
614: WHEN OTHERS THEN
615: p_error_code := g_FAILURE;
616: p_error_desc := SQLERRM;
617: l_location := l_module_name||'update_fv_refunds_voids_all';
618: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
619: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
620: END;
621: END IF;

Line 2945: FROM fv_refunds_voids_all

2941: c_fund_code VARCHAR2
2942: ) IS
2943: SELECT obligation_date,
2944: refund_amount
2945: FROM fv_refunds_voids_all
2946: WHERE cash_receipt_id = c_cash_receipt_id
2947: AND type = 'AP_REFUND'
2948: AND fund_value = c_fund_code;
2949:

Line 4468: FROM fv_refunds_voids_all

4464: -- Bug 10240460: As the obligation date is same for a particular invoice_id and since multiple
4465: -- distribution_line_number can contain the same invoice_id, using max(obligation_date).
4466: SELECT max(obligation_date)
4467: INTO l_obligation_date
4468: FROM fv_refunds_voids_all
4469: WHERE set_of_books_id = sob
4470: AND org_id = g_org_id
4471: AND TYPE = 'PAYABLE_REFUND'
4472: AND invoice_id = l_reference_2;

Line 5413: -- And this process submit the Report which lists all the imported data from AP to FV table (FV_REFUNDS_VOIDS_all)

5409: -- ==============================================================================================
5410: -- This procedure populate all the Refunds information from AP to FV table.
5411: -- This procedure is called from FMS224 Populate Payables Refunds Process.
5412: -- And this process takes mainly two parameters GL Period Low and GL period high
5413: -- And this process submit the Report which lists all the imported data from AP to FV table (FV_REFUNDS_VOIDS_all)
5414: -- with con request Id as the parameter
5415: -- Logic :
5416: -- This process takes all the posted Refunds (ie, Payment Type Flag = 'R' (Refund) and
5417: -- Posted Flag = Y (Accounted) and Entry exist in GL_JE_LINES (Posted in GL),

Line 5512: INSERT INTO FV_REFUNDS_VOIDS_ALL

5508: RAISE;
5509: END;
5510:
5511: -- Populate the the data from AP tables to FV table
5512: INSERT INTO FV_REFUNDS_VOIDS_ALL
5513: ( refunds_voids_id,
5514: TYPE ,
5515: invoice_id,
5516: processed_flag,

Line 5625: ( SELECT 1 FROM fv_refunds_voids_all

5621: AND reversal_inv_pmt_id IS NULL
5622: AND ap_checks_pkg.get_posting_status(apc.check_id) IN ('Y','P')
5623: AND TRUNC(apc.check_date) BETWEEN TRUNC(l_gl_start_date) AND TRUNC(l_gl_end_date)
5624: AND NOT EXISTS
5625: ( SELECT 1 FROM fv_refunds_voids_all
5626: WHERE invoice_payment_id = apip.invoice_payment_id)
5627: /*
5628: Commented for bug 14022463
5629: AND EXISTS (SELECT 1

Line 5697: DELETE FROM fv_refunds_voids_all

5693: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5694: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
5695: 'Deleting all the Data from FV table inserted by the current process') ;
5696: END IF;
5697: DELETE FROM fv_refunds_voids_all
5698: WHERE TYPE = 'PAYABLE_REFUND' AND conc_request_id = l_conc_request_id;
5699: COMMIT;
5700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5701: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,