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.

[Home] [Help]

APPS.FV_BE_INT_PKG dependencies on FV_BE_TRX_HDRS

Line 185: v_doc_id fv_be_trx_hdrs.doc_id%TYPE;

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;
189: v_bud_segs fv_be_trx_hdrs.budgeting_segments%TYPE;

Line 186: v_doc_status fv_be_trx_hdrs.doc_status%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;
189: v_bud_segs fv_be_trx_hdrs.budgeting_segments%TYPE;
190: new_doc_id fv_be_trx_hdrs.doc_id%TYPE;

Line 187: v_int_rev_num fv_be_trx_hdrs.internal_revision_num%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;
189: v_bud_segs fv_be_trx_hdrs.budgeting_segments%TYPE;
190: new_doc_id fv_be_trx_hdrs.doc_id%TYPE;
191: v_ts_id fv_be_trx_hdrs.treasury_symbol_id%TYPE;

Line 188: v_revision_num fv_be_trx_hdrs.revision_num%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;
189: v_bud_segs fv_be_trx_hdrs.budgeting_segments%TYPE;
190: new_doc_id fv_be_trx_hdrs.doc_id%TYPE;
191: v_ts_id fv_be_trx_hdrs.treasury_symbol_id%TYPE;
192: ins_hdr BOOLEAN := FALSE;

Line 189: v_bud_segs fv_be_trx_hdrs.budgeting_segments%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;
189: v_bud_segs fv_be_trx_hdrs.budgeting_segments%TYPE;
190: new_doc_id fv_be_trx_hdrs.doc_id%TYPE;
191: v_ts_id fv_be_trx_hdrs.treasury_symbol_id%TYPE;
192: ins_hdr BOOLEAN := FALSE;
193: v_req_id NUMBER;

Line 190: new_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;
189: v_bud_segs fv_be_trx_hdrs.budgeting_segments%TYPE;
190: new_doc_id fv_be_trx_hdrs.doc_id%TYPE;
191: v_ts_id fv_be_trx_hdrs.treasury_symbol_id%TYPE;
192: ins_hdr BOOLEAN := FALSE;
193: v_req_id NUMBER;
194:

Line 191: v_ts_id fv_be_trx_hdrs.treasury_symbol_id%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;
189: v_bud_segs fv_be_trx_hdrs.budgeting_segments%TYPE;
190: new_doc_id fv_be_trx_hdrs.doc_id%TYPE;
191: v_ts_id fv_be_trx_hdrs.treasury_symbol_id%TYPE;
192: ins_hdr BOOLEAN := FALSE;
193: v_req_id NUMBER;
194:
195: v_segment1 VARCHAR2(25);

Line 1326: FROM fv_be_trx_hdrs

1322: END IF;
1323: BEGIN
1324: SELECT internal_revision_num, doc_id, revision_num
1325: INTO v_int_rev_num, v_doc_id, v_revision_num
1326: FROM fv_be_trx_hdrs
1327: WHERE set_of_books_id = valid_rec.set_of_books_id
1328: AND budget_level_id = valid_rec.budget_level_id
1329: AND doc_number = valid_rec.doc_number
1330: AND source = valid_rec.source

Line 1345: SELECT fv_be_trx_hdrs_s.nextval

1341: -- existing hdr from a new hdr and later update it
1342: -- to 0
1343: IF ins_hdr THEN
1344:
1345: SELECT fv_be_trx_hdrs_s.nextval
1346: INTO new_doc_id
1347: FROM DUAL;
1348:
1349: SELECT treasury_symbol_id

Line 1382: INSERT INTO fv_be_trx_hdrs (

1378: ROLLBACK;
1379: RETURN;
1380: END;
1381:
1382: INSERT INTO fv_be_trx_hdrs (
1383: budgeting_segments, budget_level_id,
1384: doc_id, doc_number, doc_status,
1385: doc_total, fund_value, internal_revision_num, revision_num,
1386: set_of_books_id,bu_group_id, source, transaction_date,

Line 1529: FROM fv_be_trx_hdrs fbh,

1525: v_segment17, v_segment18, v_segment19, v_segment20,
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

Line 1590: INSERT INTO fv_be_trx_hdrs (

1586: reset_control_status;
1587: RETURN;
1588: END;
1589:
1590: INSERT INTO fv_be_trx_hdrs (
1591: budgeting_segments, budget_level_id,
1592: doc_id, doc_number, doc_status,
1593: doc_total, fund_value, internal_revision_num, revision_num,
1594: set_of_books_id, bu_group_id,source, transaction_date,

Line 1813: UPDATE fv_be_trx_hdrs

1809: INTO v_amount FROM DUAL;
1810:
1811: -- set the doc status to IMPORTING to identify which
1812: -- header records status should be changed to IN
1813: UPDATE fv_be_trx_hdrs
1814: SET doc_status = 'IMPORTING',
1815: doc_total = doc_total + v_amount
1816: WHERE doc_id = v_doc_id;
1817:

Line 2235: FROM fv_be_trx_hdrs

2231: BEGIN
2232: l_module_name := g_module_name || 'validate_doc_number';
2233: SELECT doc_status, revision_num, doc_id, fund_value
2234: INTO l_doc_status, l_revision_num, l_doc_id, l_fund_value
2235: FROM fv_be_trx_hdrs
2236: WHERE set_of_books_id = v_set_of_books_id
2237: AND budget_level_id = v_budget_level_id
2238: AND doc_number = v_doc_number
2239: AND source = v_source;

Line 2487: UPDATE fv_be_trx_hdrs fbh

2483: l_module_name := g_module_name || 'update_cleanup';
2484: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING REV NUM IN HEADERS');
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)

Line 2498: UPDATE fv_be_trx_hdrs

2494: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING DOC STATUS IN HEADERS
2496: for existing recs');
2497: END IF;
2498: UPDATE fv_be_trx_hdrs
2499: SET doc_status = 'RA'
2500: WHERE doc_status = 'IMPORTING'
2501: AND internal_revision_num <> -9999;
2502:

Line 2507: UPDATE fv_be_trx_hdrs

2503: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2504: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING DOC STATUS, REV NUM IN
2505: headers for new recs');
2506: END IF;
2507: UPDATE fv_be_trx_hdrs
2508: SET doc_status = 'IN',
2509: internal_revision_num = 0
2510: WHERE doc_status = 'IMPORTING'
2511: AND internal_revision_num = -9999;