eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_BE_RPR_PKG dependencies on FV_BE_TRX_HDRS

Line 28: l_trx_hdr_rec fv_be_trx_hdrs%ROWTYPE;

24: l_module_name VARCHAR2(200);
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;

Line 30: l_from_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;

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:
34: l_from_doc_id NUMBER(15);

Line 31: l_to_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;

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:
34: l_from_doc_id NUMBER(15);
35: l_to_doc_id NUMBER(15);

Line 165: UPDATE fv_be_trx_hdrs

161: WHERE transaction_id = l_rpr_rec.transaction_id;
162:
163: COMMIT;
164:
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

Line 293: -- Rolling back the row created in fv_be_trx_hdrs.

289: Fv_Utility.Debug_Mesg(Fnd_Log.Level_Statement, l_module_name,
290: 'EXCEPTION ENCOUNTERED IN MAIN ');
291: END IF;
292:
293: -- Rolling back the row created in fv_be_trx_hdrs.
294: ROLLBACK ;
295:
296: --Reset transaction status to Incomplete if error encountered
297: UPDATE fv_be_rpr_transactions

Line 320: p_trx_hdr_rec OUT NOCOPY fv_be_trx_hdrs%ROWTYPE,

316: END ; --procedure main
317:
318:
319: PROCEDURE set_hdr_fields (p_count NUMBER,
320: p_trx_hdr_rec OUT NOCOPY fv_be_trx_hdrs%ROWTYPE,
321: p_rpr_rec fv_be_rpr_transactions%ROWTYPE)
322: IS
323: l_module_name VARCHAR2(200);
324:

Line 327: SELECT fv_be_trx_hdrs_s.NEXTVAL

323: l_module_name VARCHAR2(200);
324:
325: BEGIN
326: l_module_name := g_module_name || 'set_hdr_fields';
327: SELECT fv_be_trx_hdrs_s.NEXTVAL
328: INTO p_trx_hdr_rec.doc_id
329: FROM dual;
330:
331: IF (p_count=1) THEN

Line 612: PROCEDURE insert_hdr_record(p_trx_hdr_rec fv_be_trx_hdrs%ROWTYPE) IS

608: '.final_exception',g_errbuf);
609:
610: END; --procedure set_dtl_fields
611:
612: PROCEDURE insert_hdr_record(p_trx_hdr_rec fv_be_trx_hdrs%ROWTYPE) IS
613: l_module_name VARCHAR2(200);
614:
615: BEGIN
616: l_module_name := g_module_name || 'insert_hdr_record';

Line 618: INSERT INTO fv_be_trx_hdrs

614:
615: BEGIN
616: l_module_name := g_module_name || 'insert_hdr_record';
617:
618: INSERT INTO fv_be_trx_hdrs
619: (doc_id ,
620: doc_number ,
621: revision_num ,
622: internal_revision_num ,

Line 866: UPDATE fv_be_trx_hdrs

862: l_module_name VARCHAR2(200);
863:
864: BEGIN
865: l_module_name := g_module_name || 'reset_doc_status';
866: UPDATE fv_be_trx_hdrs
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: