APPS.FV_BE_INT_PKG dependencies on FV_BE_TRX_DTLS

Line 181: v_amount fv_be_trx_dtls.amount%TYPE;

177: v_delimiter VARCHAR2(1);
178: dtl_index NUMBER;
179: v_rej_rec_count NUMBER;
180:
181: v_amount fv_be_trx_dtls.amount%TYPE;
182: v_tt_id fv_be_transaction_types.be_tt_id%TYPE;
183: v_gl_date fv_be_trx_dtls.gl_date%TYPE;
184: v_quarter_num fv_be_trx_dtls.quarter_num%TYPE;
185: v_doc_id fv_be_trx_hdrs.doc_id%TYPE;

Line 183: v_gl_date fv_be_trx_dtls.gl_date%TYPE;

179: v_rej_rec_count NUMBER;
180:
181: v_amount fv_be_trx_dtls.amount%TYPE;
182: v_tt_id fv_be_transaction_types.be_tt_id%TYPE;
183: v_gl_date fv_be_trx_dtls.gl_date%TYPE;
184: v_quarter_num fv_be_trx_dtls.quarter_num%TYPE;
185: v_doc_id fv_be_trx_hdrs.doc_id%TYPE;
186: v_doc_status fv_be_trx_hdrs.doc_status%TYPE;
187: v_int_rev_num fv_be_trx_hdrs.internal_revision_num%TYPE;

Line 184: v_quarter_num fv_be_trx_dtls.quarter_num%TYPE;

180:
181: v_amount fv_be_trx_dtls.amount%TYPE;
182: v_tt_id fv_be_transaction_types.be_tt_id%TYPE;
183: v_gl_date fv_be_trx_dtls.gl_date%TYPE;
184: v_quarter_num fv_be_trx_dtls.quarter_num%TYPE;
185: v_doc_id fv_be_trx_hdrs.doc_id%TYPE;
186: v_doc_status fv_be_trx_hdrs.doc_status%TYPE;
187: v_int_rev_num fv_be_trx_hdrs.internal_revision_num%TYPE;
188: v_revision_num fv_be_trx_hdrs.revision_num%TYPE;

Line 1530: fv_be_trx_dtls fbd

1526: v_segment21, v_segment22, v_segment23, v_segment24,
1527: v_segment25, v_segment26, v_segment27, v_segment28,
1528: v_segment29, v_segment30
1529: FROM fv_be_trx_hdrs fbh,
1530: fv_be_trx_dtls fbd
1531: WHERE fbh.fund_value = valid_rec.fund_value
1532: AND fbh.set_of_books_id = valid_rec.set_of_books_id
1533: AND fbh.doc_id = fbd.doc_id
1534: AND fbh.set_of_books_id = fbd.set_of_books_id

Line 1540: FROM fv_be_trx_dtls

1536: AND rownum < 2
1537: AND fbh.budget_level_id =
1538: (SELECT MAX(budget_level_id)
1539: -- FROM fv_budget_distribution_dtl
1540: FROM fv_be_trx_dtls
1541: WHERE fund_value = valid_rec.fund_value
1542: AND set_of_books_id = valid_rec.set_of_books_id
1543: AND budget_level_id < valid_rec.budget_level_id
1544: );

Line 1656: INSERT INTO fv_be_trx_dtls

1652: END IF;
1653: validate_gl_date(valid_rec.gl_date,
1654: valid_rec.set_of_books_id,
1655: v_quarter_num);
1656: INSERT INTO fv_be_trx_dtls
1657: (
1658: amount,
1659: budgeting_segments,
1660: doc_id,

Line 1743: fv_be_trx_dtls_s.nextval,

1739: valid_rec.increase_decrease_flag,
1740: v_revision_num,
1741: valid_rec.set_of_books_id,
1742: valid_rec.sub_type,
1743: fv_be_trx_dtls_s.nextval,
1744: 'IN',
1745: v_tt_id,
1746: valid_rec.source,
1747: valid_rec.group_id,

Line 2346: desc_flex_name => 'FV_BE_TRX_DTLS_DESC'

2342:
2343: l_validation_result := fnd_flex_descval.validate_desccols
2344: (
2345: appl_short_name => 'FV',
2346: desc_flex_name => 'FV_BE_TRX_DTLS_DESC'
2347: );
2348:
2349: IF (NOT l_validation_result) THEN
2350: v_error_mesg := fnd_flex_descval.error_message;

Line 2490: FROM fv_be_trx_dtls fbd

2486: END IF;
2487: UPDATE fv_be_trx_hdrs fbh
2488: SET revision_num =
2489: (SELECT MAX(revision_num)
2490: FROM fv_be_trx_dtls fbd
2491: WHERE fbh.doc_id = fbd.doc_id)
2492: WHERE fbh.doc_status = 'IMPORTING';
2493:
2494: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN