APPS.FV_BE_FUND_PKG dependencies on FV_BE_TRX_DTLS

Line 353: UPDATE fv_be_trx_dtls

349: distribution_amount = NULL
350: WHERE doc_id = p_doc_id
351: AND doc_status = 'IP';
352:
353: UPDATE fv_be_trx_dtls
354: SET transaction_status = l_status,
355: approved_by_user_id = DECODE(l_status, 'AR',g_approver_id, NULL),
356: approval_date = DECODE(l_status,'AR',SYSDATE,NULL)
357: WHERE doc_id = p_doc_id

Line 406: DELETE FROM fv_be_trx_dtls

402: ELSE
403: l_doc_id := p_rpr_to_doc_id;
404: END IF;
405:
406: DELETE FROM fv_be_trx_dtls
407: WHERE doc_id = l_doc_id;
408:
409: DELETE FROM fv_be_trx_hdrs
410: WHERE doc_id = l_doc_id;

Line 458: UPDATE Fv_Be_Trx_Dtls

454: SET doc_status = DECODE(revision_num,0,'IN','RA')
455: WHERE doc_id = p_doc_id
456: AND doc_status = 'IP';
457:
458: UPDATE Fv_Be_Trx_Dtls
459: SET transaction_status = 'IN'
460: WHERE doc_id = p_doc_id
461: AND transaction_status = 'IP'
462: AND revision_num IN(SELECT revision_num