DBA Data[Home] [Help]

APPS.FV_BE_INT_PKG dependencies on FV_BE_TRX_DTLS

Line 177: v_amount fv_be_trx_dtls.amount%TYPE;

173: v_delimiter VARCHAR2(1);
174: dtl_index NUMBER;
175: v_rej_rec_count NUMBER;
176:
177: v_amount fv_be_trx_dtls.amount%TYPE;
178: v_tt_id fv_be_transaction_types.be_tt_id%TYPE;
179: v_gl_date fv_be_trx_dtls.gl_date%TYPE;
180: v_quarter_num fv_be_trx_dtls.quarter_num%TYPE;
181: v_doc_id fv_be_trx_hdrs.doc_id%TYPE;

Line 179: v_gl_date fv_be_trx_dtls.gl_date%TYPE;

175: v_rej_rec_count NUMBER;
176:
177: v_amount fv_be_trx_dtls.amount%TYPE;
178: v_tt_id fv_be_transaction_types.be_tt_id%TYPE;
179: v_gl_date fv_be_trx_dtls.gl_date%TYPE;
180: v_quarter_num fv_be_trx_dtls.quarter_num%TYPE;
181: v_doc_id fv_be_trx_hdrs.doc_id%TYPE;
182: v_doc_status fv_be_trx_hdrs.doc_status%TYPE;
183: v_int_rev_num fv_be_trx_hdrs.internal_revision_num%TYPE;

Line 180: v_quarter_num fv_be_trx_dtls.quarter_num%TYPE;

176:
177: v_amount fv_be_trx_dtls.amount%TYPE;
178: v_tt_id fv_be_transaction_types.be_tt_id%TYPE;
179: v_gl_date fv_be_trx_dtls.gl_date%TYPE;
180: v_quarter_num fv_be_trx_dtls.quarter_num%TYPE;
181: v_doc_id fv_be_trx_hdrs.doc_id%TYPE;
182: v_doc_status fv_be_trx_hdrs.doc_status%TYPE;
183: v_int_rev_num fv_be_trx_hdrs.internal_revision_num%TYPE;
184: v_revision_num fv_be_trx_hdrs.revision_num%TYPE;

Line 1454: fv_be_trx_dtls fbd

1450: v_segment21, v_segment22, v_segment23, v_segment24,
1451: v_segment25, v_segment26, v_segment27, v_segment28,
1452: v_segment29, v_segment30
1453: FROM fv_be_trx_hdrs fbh,
1454: fv_be_trx_dtls fbd
1455: WHERE fbh.fund_value = valid_rec.fund_value
1456: AND fbh.set_of_books_id = valid_rec.set_of_books_id
1457: AND fbh.doc_id = fbd.doc_id
1458: AND fbh.set_of_books_id = fbd.set_of_books_id

Line 1464: FROM fv_be_trx_dtls

1460: AND rownum < 2
1461: AND fbh.budget_level_id =
1462: (SELECT MAX(budget_level_id)
1463: -- FROM fv_budget_distribution_dtl
1464: FROM fv_be_trx_dtls
1465: WHERE fund_value = valid_rec.fund_value
1466: AND set_of_books_id = valid_rec.set_of_books_id
1467: AND budget_level_id < valid_rec.budget_level_id
1468: );

Line 1574: INSERT INTO fv_be_trx_dtls

1570: END IF;
1571: validate_gl_date(valid_rec.gl_date,
1572: valid_rec.set_of_books_id,
1573: v_quarter_num);
1574: INSERT INTO fv_be_trx_dtls
1575: (
1576: amount,
1577: budgeting_segments,
1578: doc_id,

Line 1661: fv_be_trx_dtls_s.nextval,

1657: valid_rec.increase_decrease_flag,
1658: v_revision_num,
1659: valid_rec.set_of_books_id,
1660: valid_rec.sub_type,
1661: fv_be_trx_dtls_s.nextval,
1662: 'IN',
1663: v_tt_id,
1664: valid_rec.source,
1665: valid_rec.group_id,

Line 2255: desc_flex_name => 'FV_BE_TRX_DTLS_DESC'

2251:
2252: l_validation_result := fnd_flex_descval.validate_desccols
2253: (
2254: appl_short_name => 'FV',
2255: desc_flex_name => 'FV_BE_TRX_DTLS_DESC'
2256: );
2257:
2258: IF (NOT l_validation_result) THEN
2259: v_error_mesg := fnd_flex_descval.error_message;

Line 2399: FROM fv_be_trx_dtls fbd

2395: END IF;
2396: UPDATE fv_be_trx_hdrs fbh
2397: SET revision_num =
2398: (SELECT MAX(revision_num)
2399: FROM fv_be_trx_dtls fbd
2400: WHERE fbh.doc_id = fbd.doc_id)
2401: WHERE fbh.doc_status = 'IMPORTING';
2402:
2403: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN