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

Line 22: vp_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;

18: g_module_name VARCHAR2(100) ;
19: vp_errbuf VARCHAR2(1000) ;
20: vp_retcode NUMBER ;
21: vp_journal_import VARCHAR2(1) ;
22: vp_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
23: vp_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
24: vp_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
25: vp_closing_fyr Gl_Periods.period_year%TYPE ;
26:

Line 23: vp_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;

19: vp_errbuf VARCHAR2(1000) ;
20: vp_retcode NUMBER ;
21: vp_journal_import VARCHAR2(1) ;
22: vp_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
23: vp_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
24: vp_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
25: vp_closing_fyr Gl_Periods.period_year%TYPE ;
26:
27: -- ======================================================================

Line 24: vp_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;

20: vp_retcode NUMBER ;
21: vp_journal_import VARCHAR2(1) ;
22: vp_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
23: vp_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
24: vp_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
25: vp_closing_fyr Gl_Periods.period_year%TYPE ;
26:
27: -- ======================================================================
28: -- Other Global Variable Declarations

Line 44: vg_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;

40: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
41: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
42: vg_acct_segnum NUMBER(4);
43: vg_bal_seg_val_opt_code gl_ledgers_public_v.bal_seg_value_option_code%TYPE;
44: vg_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
45: vg_trsymbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;
46: vg_fund_value Fv_Fund_Parameters.fund_value%TYPE;
47: vg_group_id Fv_Ye_Groups.group_id%TYPE;
48: vg_seq_id Fv_Ye_Group_Sequences.sequence_id%TYPE;

Line 45: vg_trsymbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;

41: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
42: vg_acct_segnum NUMBER(4);
43: vg_bal_seg_val_opt_code gl_ledgers_public_v.bal_seg_value_option_code%TYPE;
44: vg_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
45: vg_trsymbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;
46: vg_fund_value Fv_Fund_Parameters.fund_value%TYPE;
47: vg_group_id Fv_Ye_Groups.group_id%TYPE;
48: vg_seq_id Fv_Ye_Group_Sequences.sequence_id%TYPE;
49: vg_seq Fv_Ye_Group_Sequences.SEQUENCE%TYPE;

Line 66: vg_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;

62:
63: e_error EXCEPTION;
64: e_invalid EXCEPTION;
65:
66: vg_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
67: vg_acct_val_set_id Fnd_Flex_Values.flex_value_set_id%TYPE;
68: vg_num_segs NUMBER;
69: vg_factsi_attr_exists VARCHAR2(1) ;
70: vg_factsi_bal_cnt NUMBER;

Line 843: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;

839: IS
840: TYPE t_checkpara IS REF CURSOR;
841: vc_checkpara t_checkpara;
842:
843: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
844: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
845: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
846: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
847: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;

Line 844: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;

840: TYPE t_checkpara IS REF CURSOR;
841: vc_checkpara t_checkpara;
842:
843: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
844: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
845: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
846: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
847: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
848: vl_rec_found_flag VARCHAR2(1) ;

Line 845: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;

841: vc_checkpara t_checkpara;
842:
843: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
844: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
845: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
846: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
847: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
848: vl_rec_found_flag VARCHAR2(1) ;
849: vl_fundgroup_temp Fv_Treasury_Symbols.fund_group_code%TYPE;

Line 846: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;

842:
843: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
844: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
845: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
846: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
847: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
848: vl_rec_found_flag VARCHAR2(1) ;
849: vl_fundgroup_temp Fv_Treasury_Symbols.fund_group_code%TYPE;
850: l_module_name VARCHAR2(200) ;

Line 847: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;

843: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
844: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
845: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
846: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
847: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
848: vl_rec_found_flag VARCHAR2(1) ;
849: vl_fundgroup_temp Fv_Treasury_Symbols.fund_group_code%TYPE;
850: l_module_name VARCHAR2(200) ;
851:

Line 849: vl_fundgroup_temp Fv_Treasury_Symbols.fund_group_code%TYPE;

845: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
846: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
847: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
848: vl_rec_found_flag VARCHAR2(1) ;
849: vl_fundgroup_temp Fv_Treasury_Symbols.fund_group_code%TYPE;
850: l_module_name VARCHAR2(200) ;
851:
852: BEGIN
853:

Line 886: FROM Fv_Treasury_Symbols

882:
883: OPEN vc_checkpara FOR
884: 'SELECT time_frame,fund_group_code,
885: expiration_date,cancellation_date
886: FROM Fv_Treasury_Symbols
887: WHERE treasury_symbol = :trsymbol
888: AND set_of_books_id = :sob'
889: USING vp_trsymbol,vg_sob_id;
890:

Line 929: FROM Fv_Treasury_symbols

925: -- processed. Bug 2527452.
926: IF (vp_timeframe = 'SINGLE') THEN -- timeframe 1
927: OPEN vc_checkpara FOR
928: 'SELECT treasury_symbol
929: FROM Fv_Treasury_symbols
930: WHERE set_of_books_id = :sob
931: AND time_frame = :timeframe
932: AND fund_group_code = :fundgroup
933: AND ((expiration_date <= :end_date)

Line 945: FROM Fv_Treasury_symbols

941:
942: ELSE -- timeframe 1
943: OPEN vc_checkpara FOR
944: 'SELECT treasury_symbol
945: FROM Fv_Treasury_symbols
946: WHERE set_of_books_id = :sob_id
947: AND time_frame = :timeframe
948: AND fund_group_code = :fundgroup
949: ORDER BY treasury_symbol'

Line 964: FROM Fv_Treasury_symbols

960: -- processed. Bug 2527452.
961: IF (vp_timeframe = 'SINGLE') THEN -- timeframe 2
962: OPEN vc_checkpara FOR
963: 'SELECT treasury_symbol,fund_group_code
964: FROM Fv_Treasury_symbols
965: WHERE set_of_books_id = :sob_id
966: AND time_frame = :timeframe
967: AND ((expiration_date <= :end_date)
968: OR (cancellation_date <= :end_date))

Line 974: FROM Fv_Treasury_symbols

970: USING vg_sob_id,vp_timeframe,vg_end_date,vg_end_date;
971: ELSE -- timeframe 2
972: OPEN vc_checkpara FOR
973: 'SELECT treasury_symbol,fund_group_code
974: FROM Fv_Treasury_symbols
975: WHERE set_of_books_id = :sob_id
976: AND time_frame = :timeframe
977: ORDER BY treasury_symbol'
978: USING vg_sob_id,vp_timeframe;

Line 1060: FROM Fv_Treasury_Symbols

1056: fundgroup VARCHAR2,
1057: timeframe VARCHAR2 ) IS
1058: CURSOR get_trsymid_cur IS
1059: SELECT treasury_symbol_id
1060: FROM Fv_Treasury_Symbols
1061: WHERE treasury_symbol = trsymbol
1062: AND set_of_books_id = vg_sob_id;
1063:
1064: TYPE t_getgroupid IS REF CURSOR;

Line 1335: FROM Fv_Treasury_Symbols fts, Fv_Fund_Parameters ffp

1331: CURSOR acctflag_cur IS
1332: SELECT fts.expiration_date,
1333: fts.cancellation_date,
1334: fts.time_frame
1335: FROM Fv_Treasury_Symbols fts, Fv_Fund_Parameters ffp
1336: WHERE fts.treasury_symbol_id = vg_trsymbol_id
1337: AND fts.treasury_symbol_id = ffp.treasury_symbol_id
1338: AND ffp.fund_value = vg_fund_value
1339: AND fts.treasury_symbol_id = ffp.treasury_symbol_id

Line 1343: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;

1339: AND fts.treasury_symbol_id = ffp.treasury_symbol_id
1340: AND fts.set_of_books_id = vg_sob_id
1341: AND ffp.set_of_books_id = fts.set_of_books_id;
1342:
1343: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
1344: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
1345: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE;
1346: vl_status_flag VARCHAR2(1);
1347: l_module_name VARCHAR2(200) ;

Line 1344: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;

1340: AND fts.set_of_books_id = vg_sob_id
1341: AND ffp.set_of_books_id = fts.set_of_books_id;
1342:
1343: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
1344: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
1345: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE;
1346: vl_status_flag VARCHAR2(1);
1347: l_module_name VARCHAR2(200) ;
1348: BEGIN

Line 1345: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE;

1341: AND ffp.set_of_books_id = fts.set_of_books_id;
1342:
1343: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
1344: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
1345: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE;
1346: vl_status_flag VARCHAR2(1);
1347: l_module_name VARCHAR2(200) ;
1348: BEGIN
1349:

Line 2804: FROM fv_fund_parameters ffp, fv_treasury_symbols fts

2800: PROCEDURE Update_Closing_Status IS
2801:
2802: CURSOR get_closereq_cur IS
2803: SELECT ffp.close_requisitions
2804: FROM fv_fund_parameters ffp, fv_treasury_symbols fts
2805: WHERE fts.treasury_symbol = vg_trsymbol
2806: AND ffp.fund_value = vg_fund_value
2807: AND ffp.treasury_symbol_id = fts.treasury_symbol_id
2808: AND ffp.set_of_books_id = vg_sob_id;

Line 3984: fv_treasury_symbols fts

3980:
3981: L_select_stmt := ' SELECT ffp.fund_value
3982: FROM fv_fund_parameters ffp,
3983: Fv_Ye_Groups fyg ,
3984: fv_treasury_symbols fts
3985: WHERE fyg.fund_group_code = fts.fund_group_code
3986: AND fts.time_frame = fyg.fund_time_frame
3987: AND fts.treasury_symbol_id = fyg.treasury_symbol_id
3988: AND fts.treasury_symbol_id = ffp.treasury_symbol_id