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 498: from fv_be_trx_dtls d , fv_be_trx_hdrs h

494: p_trx_hdr_rec.segment27,
495: p_trx_hdr_rec.segment28,
496: p_trx_hdr_rec.segment29,
497: p_trx_hdr_rec.segment30
498: from fv_be_trx_dtls d , fv_be_trx_hdrs h
499: where d.budgeting_segments = p_rpr_rec.distribution_from
500: and h.doc_id = d.doc_id
501: and h.budget_level_id = p_rpr_rec.budget_level_id
502: and rownum = 1;

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

655: '.final_exception',g_errbuf);
656:
657: END; --procedure set_dtl_fields
658:
659: PROCEDURE insert_hdr_record(p_trx_hdr_rec fv_be_trx_hdrs%ROWTYPE) IS
660: l_module_name VARCHAR2(200);
661:
662: BEGIN
663: l_module_name := g_module_name || 'insert_hdr_record';

Line 665: INSERT INTO fv_be_trx_hdrs

661:
662: BEGIN
663: l_module_name := g_module_name || 'insert_hdr_record';
664:
665: INSERT INTO fv_be_trx_hdrs
666: (doc_id ,
667: doc_number ,
668: revision_num ,
669: internal_revision_num ,

Line 913: UPDATE fv_be_trx_hdrs

909: l_module_name VARCHAR2(200);
910:
911: BEGIN
912: l_module_name := g_module_name || 'reset_doc_status';
913: UPDATE fv_be_trx_hdrs
914: SET doc_status = 'IN',
915: approved_by_user_id = NULL
916: WHERE doc_id IN (p_from_doc_id, p_to_doc_id);
917: