APPS.FV_BE_RPR_PKG dependencies on FV_BE_TRX_DTLS

Line 29: l_trx_dtl_rec fv_be_trx_dtls%ROWTYPE;

25: e_error EXCEPTION;
26:
27: l_rpr_rec fv_be_rpr_transactions%ROWTYPE;
28: l_trx_hdr_rec fv_be_trx_hdrs%ROWTYPE;
29: l_trx_dtl_rec fv_be_trx_dtls%ROWTYPE;
30: l_from_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;
31: l_to_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;
32: l_workflow_flag fv_budget_options.workflow_flag%TYPE;
33:

Line 169: UPDATE fv_be_trx_dtls

165: UPDATE fv_be_trx_hdrs
166: SET doc_status = 'IP'
167: WHERE doc_id IN (l_from_doc_id, l_to_doc_id);
168:
169: UPDATE fv_be_trx_dtls
170: SET transaction_status = 'IP'
171: WHERE doc_id IN (l_from_doc_id, l_to_doc_id);
172:
173: COMMIT;

Line 478: p_trx_dtl_rec OUT NOCOPY fv_be_trx_dtls%ROWTYPE,

474: '.final_exception',g_errbuf);
475: END; --procedure set_hdr_fields
476:
477: PROCEDURE set_dtl_fields (p_count NUMBER,
478: p_trx_dtl_rec OUT NOCOPY fv_be_trx_dtls%ROWTYPE,
479: p_rpr_rec fv_be_rpr_transactions%ROWTYPE)
480: IS
481: l_module_name VARCHAR2(200);
482:

Line 485: SELECT fv_be_trx_dtls_s.NEXTVAL

481: l_module_name VARCHAR2(200);
482:
483: BEGIN
484: l_module_name := g_module_name || 'set_dtl_fields';
485: SELECT fv_be_trx_dtls_s.NEXTVAL
486: INTO p_trx_dtl_rec.transaction_id
487: FROM dual;
488:
489: p_trx_dtl_rec.revision_num := 0;

Line 735: PROCEDURE insert_dtl_record (p_trx_dtl_rec fv_be_trx_dtls%ROWTYPE) IS

731: '.final_exception',g_errbuf);
732:
733: END; --procedure insert_hdr_record
734:
735: PROCEDURE insert_dtl_record (p_trx_dtl_rec fv_be_trx_dtls%ROWTYPE) IS
736: l_module_name VARCHAR2(200);
737:
738: BEGIN
739: l_module_name := g_module_name || 'insert_dtl_record';

Line 740: INSERT INTO fv_be_trx_dtls

736: l_module_name VARCHAR2(200);
737:
738: BEGIN
739: l_module_name := g_module_name || 'insert_dtl_record';
740: INSERT INTO fv_be_trx_dtls
741: (transaction_id ,
742: doc_id ,
743: revision_num ,
744: transaction_status ,

Line 871: UPDATE fv_be_trx_dtls

867: SET doc_status = 'IN',
868: approved_by_user_id = NULL
869: WHERE doc_id IN (p_from_doc_id, p_to_doc_id);
870:
871: UPDATE fv_be_trx_dtls
872: SET transaction_status = 'IN'
873: WHERE doc_id IN (p_from_doc_id, p_to_doc_id);
874:
875: COMMIT;