DBA Data[Home] [Help]

APPS.FV_COPY_YE_RECORDS_PKG dependencies on FV_TREASURY_SYMBOLS

Line 8: v_time_frame_new IN fv_treasury_symbols.time_frame%TYPE,--modified for Bug.1575992

4:
5: PROCEDURE copy_record
6: (v_ledger_id IN gl_ledgers.ledger_id%TYPE,
7: v_old_group_id IN fv_ye_groups.group_id%TYPE,
8: v_time_frame_new IN fv_treasury_symbols.time_frame%TYPE,--modified for Bug.1575992
9: v_fund_group_code_new IN VARCHAR2,
10: v_treasury_symbol_new IN fv_treasury_symbols.treasury_symbol%TYPE,
11: v_closing_method IN fv_ye_groups.closing_method%TYPE)--modified for Bug.1575992
12: AS

Line 10: v_treasury_symbol_new IN fv_treasury_symbols.treasury_symbol%TYPE,

6: (v_ledger_id IN gl_ledgers.ledger_id%TYPE,
7: v_old_group_id IN fv_ye_groups.group_id%TYPE,
8: v_time_frame_new IN fv_treasury_symbols.time_frame%TYPE,--modified for Bug.1575992
9: v_fund_group_code_new IN VARCHAR2,
10: v_treasury_symbol_new IN fv_treasury_symbols.treasury_symbol%TYPE,
11: v_closing_method IN fv_ye_groups.closing_method%TYPE)--modified for Bug.1575992
12: AS
13:
14: CURSOR c_sequences

Line 34: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

30: v_set_of_books_id NUMBER;
31: v_new_group_id fv_ye_groups.group_id%TYPE;
32: v_sequence_id fv_ye_group_sequences.sequence_id%TYPE;
33: --pkpatel:Declared a new variable to fix Bug. 1575992
34: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
35:
36: BEGIN
37:
38: v_login := fnd_global.user_id;

Line 50: FROM fv_treasury_symbols

46: IF v_treasury_symbol_new IS NOT NULL THEN
47:
48: SELECT treasury_symbol_id
49: INTO v_treasury_symbol_id
50: FROM fv_treasury_symbols
51: WHERE treasury_symbol = v_treasury_symbol_new
52: AND set_of_books_id = v_ledger_id;
53: END IF;
54: