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_PURGED_TREASURY_SYMBOLS dependencies on FV_TREASURY_SYMBOLS

Line 30: gbl_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%type;

26: gbl_creation_date date;
27: gbl_created_by number(15);
28: gbl_cancellation_date date;
29: gbl_treasury_symbol varchar2(100);
30: gbl_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%type;
31: gbl_time_frame varchar2(100);
32: gbl_year_established number;
33: gbl_new_established_year number;
34: gbl_request_id Number;

Line 56: from fv_treasury_symbols

52: new_established_year IN NUMBER) is
53: select treasury_symbol_id,treasury_symbol,
54: set_of_books_id,
55: fund_group_code
56: from fv_treasury_symbols
57: where set_of_books_id = gbl_set_of_books_id
58: and treasury_symbol= nvl(v_treasury_symbol,treasury_symbol)
59: and time_frame = nvl(v_time_frame,time_frame)
60: and established_fiscal_yr = NVL(n_year_established,established_fiscal_yr)

Line 382: insert ALL into fv_treasury_symbols_history

378: begin
379: BEGIN
380: ---dbms_output.put_line('inside populate_history_tab');
381: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' inside populate_history_tab');
382: insert ALL into fv_treasury_symbols_history
383: (treasury_symbol_id,
384: treasury_symbol,
385: set_of_books_id,
386: sf224_type_code,

Line 423: from fv_treasury_symbols

419: federal_acct_symbol_id,
420: dept_transfer,
421: gbl_request_id,
422: populate_history_tab.v_flag
423: from fv_treasury_symbols
424: where treasury_symbol_id = tres_id
425: and set_of_books_id = gbl_set_of_books_id;
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN

Line 515: from fv_treasury_symbols_history

511: n_cnt number;
512: l_module_name varchar2(200) := g_module_name || 'INQUIRE_HISTORY_TAB';
513: begin
514: select count(1) into n_cnt
515: from fv_treasury_symbols_history
516: where treasury_symbol_id = tres_id
517: and set_of_books_id = gbl_set_of_books_id
518: and date_purged is null;
519: if n_cnt > 0 then

Line 541: update fv_treasury_symbols_history

537: ----dbms_output.put_line(' inside update_history_tab');
538: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' inside update_history_tab');
539: IF v_flag in ('Y','N') then
540: ---dbms_output.put_line(' inside update_history_tab updating for flag <>d');
541: update fv_treasury_symbols_history
542: set open_flag = v_flag ,
543: request_id = gbl_request_id,
544: last_update_date = sysdate,
545: last_updated_by = gbl_last_update_by,

Line 553: update fv_treasury_symbols_history

549: where treasury_symbol_id = tres_id
550: and set_of_books_id = gbl_set_of_books_id;
551: ELSIF v_flag = 'D' and gbl_error_code = 0 then ---called while deleting treasury symbols ---------
552: ---dbms_output.put_line(' inside update_history_tab updating for flag = d');
553: update fv_treasury_symbols_history
554: set date_purged = TRUNC(sysdate),
555: request_id = gbl_request_id,
556: last_update_date = sysdate,
557: last_updated_by = gbl_last_update_by,

Line 567: update fv_treasury_symbols_history

563: and request_id = gbl_prelim_req_id
564: and date_purged is null;
565: ELSIF v_flag = 'R' then --- called when report runs unsuccessfully thus rollback all the changes-------
566:
567: update fv_treasury_symbols_history
568: set date_purged = null,
569: request_id = gbl_prelim_req_id,
570: last_update_date = sysdate,
571: last_updated_by = gbl_last_update_by,

Line 605: from fv_treasury_symbols_history fts

601: v_open_flag varchar2(1);
602: l_module_name VARCHAR2(200):='INS_DELETE_TREASURY_SYMBOLS';
603: cursor c1_treas_symbol is
604: select treasury_symbol,treasury_symbol_id,set_of_books_id,do_not_purge_flag,open_flag
605: from fv_treasury_symbols_history fts
606: where set_of_books_id = gbl_set_of_books_id
607: and treasury_symbol= nvl(gbl_treasury_symbol,treasury_symbol)
608: and time_frame = nvl(gbl_time_frame,time_frame)
609: and established_fiscal_yr = NVL(gbl_year_established,established_fiscal_yr)

Line 813: from fv_treasury_symbols_history fts

809: begin
810: BEGIN
811: delete from fv_fund_parameters ffp
812: where exists ( select treasury_symbol_id
813: from fv_treasury_symbols_history fts
814: where fts.set_of_books_id = gbl_set_of_books_id
815: and fts.treasury_symbol_id = ffp.treasury_symbol_id
816: and fts.request_id = gbl_request_id
817: and fts.date_purged is not null)

Line 835: delete from fv_treasury_symbols fts

831: return;
832: END;
833:
834: BEGIN
835: delete from fv_treasury_symbols fts
836: where exists ( select treasury_symbol_id
837: from fv_treasury_symbols_history ftsh
838: where ftsh.set_of_books_id = gbl_set_of_books_id
839: and ftsh.treasury_symbol_id = fts.treasury_symbol_id

Line 837: from fv_treasury_symbols_history ftsh

833:
834: BEGIN
835: delete from fv_treasury_symbols fts
836: where exists ( select treasury_symbol_id
837: from fv_treasury_symbols_history ftsh
838: where ftsh.set_of_books_id = gbl_set_of_books_id
839: and ftsh.treasury_symbol_id = fts.treasury_symbol_id
840: and ftsh.request_id = gbl_request_id
841: and ftsh.date_purged is not null)

Line 873: from fv_treasury_symbols_history fts

869:
870: delete from fv_fund_parameters_history ffp
871: where ffp.set_of_books_id = gbl_set_of_books_id
872: and exists ( select treasury_symbol_id
873: from fv_treasury_symbols_history fts
874: where fts.set_of_books_id= gbl_set_of_books_id
875: and fts.treasury_symbol_id = ffp.treasury_symbol_id
876: and date_purged is null);
877:

Line 878: delete from fv_treasury_symbols_history fts

874: where fts.set_of_books_id= gbl_set_of_books_id
875: and fts.treasury_symbol_id = ffp.treasury_symbol_id
876: and date_purged is null);
877:
878: delete from fv_treasury_symbols_history fts
879: where fts.set_of_books_id= gbl_set_of_books_id
880: and date_purged is null;
881:
882: