APPS.FV_BE_FUND_PKG dependencies on FV_BE_TRX_DTLS

Line 348: UPDATE fv_be_trx_dtls

344: distribution_amount = NULL
345: WHERE doc_id = p_doc_id
346: AND doc_status = 'IP';
347:
348: UPDATE fv_be_trx_dtls
349: SET transaction_status = l_status,
350: approved_by_user_id = DECODE(l_status, 'AR',g_approver_id, NULL),
351: approval_date = DECODE(l_status,'AR',SYSDATE,NULL)
352: WHERE doc_id = p_doc_id

Line 400: DELETE FROM fv_be_trx_dtls

396: ELSE
397: l_doc_id := p_rpr_to_doc_id;
398: END IF;
399:
400: DELETE FROM fv_be_trx_dtls
401: WHERE doc_id = l_doc_id;
402:
403: DELETE FROM fv_be_trx_hdrs
404: WHERE doc_id = l_doc_id;

Line 452: UPDATE Fv_Be_Trx_Dtls

448: SET doc_status = DECODE(revision_num,0,'IN','RA')
449: WHERE doc_id = p_doc_id
450: AND doc_status = 'IP';
451:
452: UPDATE Fv_Be_Trx_Dtls
453: SET transaction_status = 'IN'
454: WHERE doc_id = p_doc_id
455: AND transaction_status = 'IP'
456: AND revision_num IN(SELECT revision_num