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_INT_PKG dependencies on FV_BE_TRX_HDRS

Line 181: v_doc_id fv_be_trx_hdrs.doc_id%TYPE;

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

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

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

Line 184: v_revision_num fv_be_trx_hdrs.revision_num%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;
185: v_bud_segs fv_be_trx_hdrs.budgeting_segments%TYPE;
186: new_doc_id fv_be_trx_hdrs.doc_id%TYPE;
187: v_ts_id fv_be_trx_hdrs.treasury_symbol_id%TYPE;
188: ins_hdr BOOLEAN := FALSE;

Line 185: v_bud_segs fv_be_trx_hdrs.budgeting_segments%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;
185: v_bud_segs fv_be_trx_hdrs.budgeting_segments%TYPE;
186: new_doc_id fv_be_trx_hdrs.doc_id%TYPE;
187: v_ts_id fv_be_trx_hdrs.treasury_symbol_id%TYPE;
188: ins_hdr BOOLEAN := FALSE;
189: v_req_id NUMBER;

Line 186: new_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;
185: v_bud_segs fv_be_trx_hdrs.budgeting_segments%TYPE;
186: new_doc_id fv_be_trx_hdrs.doc_id%TYPE;
187: v_ts_id fv_be_trx_hdrs.treasury_symbol_id%TYPE;
188: ins_hdr BOOLEAN := FALSE;
189: v_req_id NUMBER;
190:

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

Line 1254: FROM fv_be_trx_hdrs

1250: END IF;
1251: BEGIN
1252: SELECT internal_revision_num, doc_id, revision_num
1253: INTO v_int_rev_num, v_doc_id, v_revision_num
1254: FROM fv_be_trx_hdrs
1255: WHERE set_of_books_id = valid_rec.set_of_books_id
1256: AND budget_level_id = valid_rec.budget_level_id
1257: AND doc_number = valid_rec.doc_number
1258: AND source = valid_rec.source

Line 1273: SELECT fv_be_trx_hdrs_s.nextval

1269: -- existing hdr from a new hdr and later update it
1270: -- to 0
1271: IF ins_hdr THEN
1272:
1273: SELECT fv_be_trx_hdrs_s.nextval
1274: INTO new_doc_id
1275: FROM DUAL;
1276:
1277: SELECT treasury_symbol_id

Line 1308: INSERT INTO fv_be_trx_hdrs (

1304: ROLLBACK;
1305: RETURN;
1306: END;
1307:
1308: INSERT INTO fv_be_trx_hdrs (
1309: budgeting_segments, budget_level_id,
1310: doc_id, doc_number, doc_status,
1311: doc_total, fund_value, internal_revision_num, revision_num,
1312: set_of_books_id,bu_group_id, source, transaction_date,

Line 1453: FROM fv_be_trx_hdrs fbh,

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

Line 1508: INSERT INTO fv_be_trx_hdrs (

1504: reset_control_status;
1505: RETURN;
1506: END;
1507:
1508: INSERT INTO fv_be_trx_hdrs (
1509: budgeting_segments, budget_level_id,
1510: doc_id, doc_number, doc_status,
1511: doc_total, fund_value, internal_revision_num, revision_num,
1512: set_of_books_id, bu_group_id,source, transaction_date,

Line 1731: UPDATE fv_be_trx_hdrs

1727: INTO v_amount FROM DUAL;
1728:
1729: -- set the doc status to IMPORTING to identify which
1730: -- header records status should be changed to IN
1731: UPDATE fv_be_trx_hdrs
1732: SET doc_status = 'IMPORTING',
1733: doc_total = doc_total + v_amount
1734: WHERE doc_id = v_doc_id;
1735:

Line 2144: FROM fv_be_trx_hdrs

2140: BEGIN
2141: l_module_name := g_module_name || 'validate_doc_number';
2142: SELECT doc_status, revision_num, doc_id, fund_value
2143: INTO l_doc_status, l_revision_num, l_doc_id, l_fund_value
2144: FROM fv_be_trx_hdrs
2145: WHERE set_of_books_id = v_set_of_books_id
2146: AND budget_level_id = v_budget_level_id
2147: AND doc_number = v_doc_number
2148: AND source = v_source;

Line 2396: UPDATE fv_be_trx_hdrs fbh

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

Line 2407: UPDATE fv_be_trx_hdrs

2403: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2404: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING DOC STATUS IN HEADERS
2405: for existing recs');
2406: END IF;
2407: UPDATE fv_be_trx_hdrs
2408: SET doc_status = 'RA'
2409: WHERE doc_status = 'IMPORTING'
2410: AND internal_revision_num <> -9999;
2411:

Line 2416: UPDATE fv_be_trx_hdrs

2412: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2413: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATING DOC STATUS, REV NUM IN
2414: headers for new recs');
2415: END IF;
2416: UPDATE fv_be_trx_hdrs
2417: SET doc_status = 'IN',
2418: internal_revision_num = 0
2419: WHERE doc_status = 'IMPORTING'
2420: AND internal_revision_num = -9999;