APPS.FV_COPY_YE_RECORDS_PKG dependencies on FV_YE_GROUPS

Line 7: v_old_group_id IN fv_ye_groups.group_id%TYPE,

3: g_module_name VARCHAR2(100) := 'fv.plsql.fv_copy_ye_records_pkg.';
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

Line 11: v_closing_method IN fv_ye_groups.closing_method%TYPE)--modified for Bug.1575992

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
15: IS

Line 31: v_new_group_id fv_ye_groups.group_id%TYPE;

27: l_module_name VARCHAR2(200) := g_module_name || 'copy_record';
28: l_errbuff VARCHAR2(300);
29: v_login NUMBER;
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:

Line 40: SELECT fv_ye_groups_id_s.NEXTVAL

36: BEGIN
37:
38: v_login := fnd_global.user_id;
39:
40: SELECT fv_ye_groups_id_s.NEXTVAL
41: INTO v_new_group_id
42: FROM dual;
43: --pkpatel:Added code to fix Bug.1575992
44:

Line 57: 'INSERTING TO FV_YE_GROUPS');

53: END IF;
54:
55: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
56: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
57: 'INSERTING TO FV_YE_GROUPS');
58: END IF;
59: -- create fv_ye_groups record for new record.
60: INSERT INTO fv_ye_groups
61: (group_id,

Line 59: -- create fv_ye_groups record for new record.

55: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
56: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
57: 'INSERTING TO FV_YE_GROUPS');
58: END IF;
59: -- create fv_ye_groups record for new record.
60: INSERT INTO fv_ye_groups
61: (group_id,
62: set_of_books_id,
63: fund_time_frame,

Line 60: INSERT INTO fv_ye_groups

56: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
57: 'INSERTING TO FV_YE_GROUPS');
58: END IF;
59: -- create fv_ye_groups record for new record.
60: INSERT INTO fv_ye_groups
61: (group_id,
62: set_of_books_id,
63: fund_time_frame,
64: fund_group_code,