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 440: from fv_treasury_symbols

436: receipt_account_indicator,
437: NVL(auto_create,'N'),
438: availability_type_code,
439: sub_level_prefix_code
440: from fv_treasury_symbols
441: where treasury_symbol_id = tres_id
442: and set_of_books_id = gbl_set_of_books_id;
443: EXCEPTION
444: WHEN NO_DATA_FOUND THEN

Line 542: from fv_treasury_symbols_history

538: n_cnt number;
539: l_module_name varchar2(200) := g_module_name || 'INQUIRE_HISTORY_TAB';
540: begin
541: select count(1) into n_cnt
542: from fv_treasury_symbols_history
543: where treasury_symbol_id = tres_id
544: and set_of_books_id = gbl_set_of_books_id
545: and date_purged is null;
546: if n_cnt > 0 then

Line 568: update fv_treasury_symbols_history

564: ----dbms_output.put_line(' inside update_history_tab');
565: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' inside update_history_tab');
566: IF v_flag in ('Y','N') then
567: ---dbms_output.put_line(' inside update_history_tab updating for flag <>d');
568: update fv_treasury_symbols_history
569: set open_flag = v_flag ,
570: request_id = gbl_request_id,
571: last_update_date = sysdate,
572: last_updated_by = gbl_last_update_by,

Line 580: update fv_treasury_symbols_history

576: where treasury_symbol_id = tres_id
577: and set_of_books_id = gbl_set_of_books_id;
578: ELSIF v_flag = 'D' and gbl_error_code = 0 then ---called while deleting treasury symbols ---------
579: ---dbms_output.put_line(' inside update_history_tab updating for flag = d');
580: update fv_treasury_symbols_history
581: set date_purged = TRUNC(sysdate),
582: request_id = gbl_request_id,
583: last_update_date = sysdate,
584: last_updated_by = gbl_last_update_by,

Line 594: update fv_treasury_symbols_history

590: and request_id = gbl_prelim_req_id
591: and date_purged is null;
592: ELSIF v_flag = 'R' then --- called when report runs unsuccessfully thus rollback all the changes-------
593:
594: update fv_treasury_symbols_history
595: set date_purged = null,
596: request_id = gbl_prelim_req_id,
597: last_update_date = sysdate,
598: last_updated_by = gbl_last_update_by,

Line 632: from fv_treasury_symbols_history fts

628: v_open_flag varchar2(1);
629: l_module_name VARCHAR2(200):='INS_DELETE_TREASURY_SYMBOLS';
630: cursor c1_treas_symbol is
631: select treasury_symbol,treasury_symbol_id,set_of_books_id,do_not_purge_flag,open_flag
632: from fv_treasury_symbols_history fts
633: where set_of_books_id = gbl_set_of_books_id
634: and treasury_symbol= nvl(gbl_treasury_symbol,treasury_symbol)
635: and time_frame = nvl(gbl_time_frame,time_frame)
636: and established_fiscal_yr = NVL(gbl_year_established,established_fiscal_yr)

Line 843: from fv_treasury_symbols_history fts

839: begin
840: BEGIN
841: delete from fv_fund_parameters ffp
842: where exists ( select treasury_symbol_id
843: from fv_treasury_symbols_history fts
844: where fts.set_of_books_id = gbl_set_of_books_id
845: and fts.treasury_symbol_id = ffp.treasury_symbol_id
846: and fts.request_id = gbl_request_id
847: and fts.date_purged is not null)

Line 865: delete from fv_treasury_symbols fts

861: return;
862: END;
863:
864: BEGIN
865: delete from fv_treasury_symbols fts
866: where exists ( select treasury_symbol_id
867: from fv_treasury_symbols_history ftsh
868: where ftsh.set_of_books_id = gbl_set_of_books_id
869: and ftsh.treasury_symbol_id = fts.treasury_symbol_id

Line 867: from fv_treasury_symbols_history ftsh

863:
864: BEGIN
865: delete from fv_treasury_symbols fts
866: where exists ( select treasury_symbol_id
867: from fv_treasury_symbols_history ftsh
868: where ftsh.set_of_books_id = gbl_set_of_books_id
869: and ftsh.treasury_symbol_id = fts.treasury_symbol_id
870: and ftsh.request_id = gbl_request_id
871: and ftsh.date_purged is not null)

Line 903: from fv_treasury_symbols_history fts

899:
900: delete from fv_fund_parameters_history ffp
901: where ffp.set_of_books_id = gbl_set_of_books_id
902: and exists ( select treasury_symbol_id
903: from fv_treasury_symbols_history fts
904: where fts.set_of_books_id= gbl_set_of_books_id
905: and fts.treasury_symbol_id = ffp.treasury_symbol_id
906: and date_purged is null);
907:

Line 908: delete from fv_treasury_symbols_history fts

904: where fts.set_of_books_id= gbl_set_of_books_id
905: and fts.treasury_symbol_id = ffp.treasury_symbol_id
906: and date_purged is null);
907:
908: delete from fv_treasury_symbols_history fts
909: where fts.set_of_books_id= gbl_set_of_books_id
910: and date_purged is null;
911:
912: