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 23: vp_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;

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

Line 24: vp_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;

20: vp_retcode NUMBER ;
21: vp_post_to_gl VARCHAR2(1) ;
22: vp_mode VARCHAR2(1) ;
23: vp_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
24: vp_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
25: vp_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
26: vp_closing_fyr Gl_Periods.period_year%TYPE ;
27: --year end process
28: vp_closing_num Gl_Periods.period_num%TYPE ;

Line 25: vp_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;

21: vp_post_to_gl VARCHAR2(1) ;
22: vp_mode VARCHAR2(1) ;
23: vp_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
24: vp_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
25: vp_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
26: vp_closing_fyr Gl_Periods.period_year%TYPE ;
27: --year end process
28: vp_closing_num Gl_Periods.period_num%TYPE ;
29:

Line 47: vg_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;

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

Line 48: vg_trsymbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;

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

Line 74: vg_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;

70:
71: e_error EXCEPTION;
72: e_invalid EXCEPTION;
73:
74: vg_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
75: vg_acct_val_set_id Fnd_Flex_Values.flex_value_set_id%TYPE;
76: vg_num_segs NUMBER;
77: vg_factsi_attr_exists VARCHAR2(1) ;
78: vg_factsi_bal_cnt NUMBER;

Line 836: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;

832: IS
833: TYPE t_checkpara IS REF CURSOR;
834: vc_checkpara t_checkpara;
835:
836: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
837: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
838: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
839: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
840: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;

Line 837: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;

833: TYPE t_checkpara IS REF CURSOR;
834: vc_checkpara t_checkpara;
835:
836: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
837: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
838: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
839: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
840: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
841: vl_rec_found_flag VARCHAR2(1) ;

Line 838: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;

834: vc_checkpara t_checkpara;
835:
836: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
837: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
838: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
839: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
840: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
841: vl_rec_found_flag VARCHAR2(1) ;
842: vl_fundgroup_temp Fv_Treasury_Symbols.fund_group_code%TYPE;

Line 839: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;

835:
836: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
837: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
838: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
839: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
840: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
841: vl_rec_found_flag VARCHAR2(1) ;
842: vl_fundgroup_temp Fv_Treasury_Symbols.fund_group_code%TYPE;
843: l_module_name VARCHAR2(200) ;

Line 840: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;

836: vl_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
837: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
838: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
839: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
840: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
841: vl_rec_found_flag VARCHAR2(1) ;
842: vl_fundgroup_temp Fv_Treasury_Symbols.fund_group_code%TYPE;
843: l_module_name VARCHAR2(200) ;
844:

Line 842: vl_fundgroup_temp Fv_Treasury_Symbols.fund_group_code%TYPE;

838: vl_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
839: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
840: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
841: vl_rec_found_flag VARCHAR2(1) ;
842: vl_fundgroup_temp Fv_Treasury_Symbols.fund_group_code%TYPE;
843: l_module_name VARCHAR2(200) ;
844:
845: BEGIN
846:

Line 879: FROM Fv_Treasury_Symbols

875:
876: OPEN vc_checkpara FOR
877: 'SELECT time_frame,fund_group_code,
878: expiration_date,cancellation_date
879: FROM Fv_Treasury_Symbols
880: WHERE treasury_symbol = :trsymbol
881: AND set_of_books_id = :sob'
882: USING vp_trsymbol,vg_sob_id;
883:

Line 922: FROM Fv_Treasury_symbols

918: -- processed. Bug 2527452.
919: IF (vp_timeframe = 'A') THEN -- timeframe 1 --CGAC
920: OPEN vc_checkpara FOR
921: 'SELECT treasury_symbol
922: FROM Fv_Treasury_symbols
923: WHERE set_of_books_id = :sob
924: AND time_frame = :timeframe
925: AND fund_group_code = :fundgroup
926: AND ((expiration_date <= :end_date)

Line 938: FROM Fv_Treasury_symbols

934:
935: ELSIF vp_timeframe='ALL' THEN
936: OPEN vc_checkpara FOR
937: 'SELECT treasury_symbol,fund_group_code
938: FROM Fv_Treasury_symbols
939: WHERE set_of_books_id = :sob_id
940: AND ORDER BY treasury_symbol'
941: USING vg_sob_id;
942:

Line 946: FROM Fv_Treasury_symbols

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

Line 965: FROM Fv_Treasury_symbols

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

Line 976: FROM Fv_Treasury_symbols

972: ELSIF vp_timeframe='ALL' THEN
973:
974: OPEN vc_checkpara FOR
975: 'SELECT treasury_symbol,fund_group_code, time_frame
976: FROM Fv_Treasury_symbols
977: WHERE set_of_books_id = :sob_id
978: ORDER BY treasury_symbol'
979: USING vg_sob_id;
980: ELSE -- timeframe 2

Line 983: FROM Fv_Treasury_symbols

979: USING vg_sob_id;
980: ELSE -- timeframe 2
981: OPEN vc_checkpara FOR
982: 'SELECT treasury_symbol,fund_group_code
983: FROM Fv_Treasury_symbols
984: WHERE set_of_books_id = :sob_id
985: AND time_frame = :timeframe
986: ORDER BY treasury_symbol'
987: USING vg_sob_id,vp_timeframe;

Line 1073: FROM Fv_Treasury_Symbols

1069: fundgroup VARCHAR2,
1070: timeframe VARCHAR2 ) IS
1071: CURSOR get_trsymid_cur IS
1072: SELECT treasury_symbol_id
1073: FROM Fv_Treasury_Symbols
1074: WHERE treasury_symbol = trsymbol
1075: AND set_of_books_id = vg_sob_id;
1076:
1077: TYPE t_getgroupid IS REF CURSOR;

Line 1351: FROM Fv_Treasury_Symbols fts, Fv_Fund_Parameters ffp

1347: CURSOR acctflag_cur IS
1348: SELECT fts.expiration_date,
1349: fts.cancellation_date,
1350: fts.time_frame
1351: FROM Fv_Treasury_Symbols fts, Fv_Fund_Parameters ffp
1352: WHERE fts.treasury_symbol_id = vg_trsymbol_id
1353: AND fts.treasury_symbol_id = ffp.treasury_symbol_id
1354: AND ffp.fund_value = vg_fund_value
1355: AND fts.treasury_symbol_id = ffp.treasury_symbol_id

Line 1359: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;

1355: AND fts.treasury_symbol_id = ffp.treasury_symbol_id
1356: AND fts.set_of_books_id = vg_sob_id
1357: AND ffp.set_of_books_id = fts.set_of_books_id;
1358:
1359: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
1360: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
1361: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE;
1362: vl_status_flag VARCHAR2(1);
1363: l_module_name VARCHAR2(200) ;

Line 1360: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;

1356: AND fts.set_of_books_id = vg_sob_id
1357: AND ffp.set_of_books_id = fts.set_of_books_id;
1358:
1359: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
1360: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
1361: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE;
1362: vl_status_flag VARCHAR2(1);
1363: l_module_name VARCHAR2(200) ;
1364: BEGIN

Line 1361: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE;

1357: AND ffp.set_of_books_id = fts.set_of_books_id;
1358:
1359: vl_exp_date Fv_Treasury_Symbols.expiration_date%TYPE;
1360: vl_can_date Fv_Treasury_Symbols.cancellation_date%TYPE;
1361: vl_timeframe Fv_Treasury_Symbols.time_frame%TYPE;
1362: vl_status_flag VARCHAR2(1);
1363: l_module_name VARCHAR2(200) ;
1364: BEGIN
1365:

Line 1528: FROM fv_treasury_symbols

1524: --Process this year end record only if closing method of year end record matched closing method of process
1525: IF vg_closing_method = vp_closing_method THEN
1526:
1527: /*SELECT close_requisitions into treasury_closing_method
1528: FROM fv_treasury_symbols
1529: WHERE treasury_symbol = vg_trsymbol and set_of_books_id = vg_sob_id;*/
1530:
1531: -- Bug 10399298: Pick close_requisitions from fv_fund_parameters instead of fv_treasury_symbols
1532: SELECT fund.close_requisitions into treasury_closing_method

Line 1531: -- Bug 10399298: Pick close_requisitions from fv_fund_parameters instead of fv_treasury_symbols

1527: /*SELECT close_requisitions into treasury_closing_method
1528: FROM fv_treasury_symbols
1529: WHERE treasury_symbol = vg_trsymbol and set_of_books_id = vg_sob_id;*/
1530:
1531: -- Bug 10399298: Pick close_requisitions from fv_fund_parameters instead of fv_treasury_symbols
1532: SELECT fund.close_requisitions into treasury_closing_method
1533: FROM fv_treasury_symbols tas, fv_fund_parameters fund
1534: WHERE tas.treasury_symbol = vg_trsymbol and tas.set_of_books_id = vg_sob_id
1535: AND fund.treasury_symbol_id = tas.treasury_symbol_id

Line 1533: FROM fv_treasury_symbols tas, fv_fund_parameters fund

1529: WHERE treasury_symbol = vg_trsymbol and set_of_books_id = vg_sob_id;*/
1530:
1531: -- Bug 10399298: Pick close_requisitions from fv_fund_parameters instead of fv_treasury_symbols
1532: SELECT fund.close_requisitions into treasury_closing_method
1533: FROM fv_treasury_symbols tas, fv_fund_parameters fund
1534: WHERE tas.treasury_symbol = vg_trsymbol and tas.set_of_books_id = vg_sob_id
1535: AND fund.treasury_symbol_id = tas.treasury_symbol_id
1536: AND fund.fund_value = vg_fund_value;
1537:

Line 2853: FROM fv_fund_parameters ffp, fv_treasury_symbols fts

2849: PROCEDURE Update_Closing_Status IS
2850:
2851: CURSOR get_closereq_cur IS
2852: SELECT ffp.close_requisitions
2853: FROM fv_fund_parameters ffp, fv_treasury_symbols fts
2854: WHERE fts.treasury_symbol = vg_trsymbol
2855: AND ffp.fund_value = vg_fund_value
2856: AND ffp.treasury_symbol_id = fts.treasury_symbol_id
2857: AND ffp.set_of_books_id = vg_sob_id

Line 4188: fv_treasury_symbols fts

4184:
4185: L_select_stmt := ' SELECT ffp.fund_value
4186: FROM fv_fund_parameters ffp,
4187: Fv_Ye_Groups fyg ,
4188: fv_treasury_symbols fts
4189: WHERE fyg.fund_group_code = fts.fund_group_code
4190: AND fts.time_frame = fyg.fund_time_frame
4191: AND fts.treasury_symbol_id = fyg.treasury_symbol_id
4192: AND fts.treasury_symbol_id = ffp.treasury_symbol_id