[Home] [Help]
35: agairola 16-Dec-02 Bug 2584741: Added the code for the Deposits in get_crd_cat
36:
37: ********************************************************************************************** */
38:
39: g_v_rec_inst igs_fi_control.rec_installed%TYPE;
40: g_n_sob_id igs_fi_control.set_of_books_id%TYPE;
41: g_v_currency_cd igs_fi_control.currency_cd%TYPE;
42: g_v_accounting_method igs_fi_control.accounting_method%TYPE;
43: g_v_new CONSTANT VARCHAR2(10) := 'NEW';
36:
37: ********************************************************************************************** */
38:
39: g_v_rec_inst igs_fi_control.rec_installed%TYPE;
40: g_n_sob_id igs_fi_control.set_of_books_id%TYPE;
41: g_v_currency_cd igs_fi_control.currency_cd%TYPE;
42: g_v_accounting_method igs_fi_control.accounting_method%TYPE;
43: g_v_new CONSTANT VARCHAR2(10) := 'NEW';
44: g_v_actual CONSTANT VARCHAR2(3) := 'A';
37: ********************************************************************************************** */
38:
39: g_v_rec_inst igs_fi_control.rec_installed%TYPE;
40: g_n_sob_id igs_fi_control.set_of_books_id%TYPE;
41: g_v_currency_cd igs_fi_control.currency_cd%TYPE;
42: g_v_accounting_method igs_fi_control.accounting_method%TYPE;
43: g_v_new CONSTANT VARCHAR2(10) := 'NEW';
44: g_v_actual CONSTANT VARCHAR2(3) := 'A';
45: g_v_je_source_name CONSTANT VARCHAR2(80) := 'Student System';
38:
39: g_v_rec_inst igs_fi_control.rec_installed%TYPE;
40: g_n_sob_id igs_fi_control.set_of_books_id%TYPE;
41: g_v_currency_cd igs_fi_control.currency_cd%TYPE;
42: g_v_accounting_method igs_fi_control.accounting_method%TYPE;
43: g_v_new CONSTANT VARCHAR2(10) := 'NEW';
44: g_v_actual CONSTANT VARCHAR2(3) := 'A';
45: g_v_je_source_name CONSTANT VARCHAR2(80) := 'Student System';
46: g_v_user_je_src_name gl_je_sources.user_je_source_name%TYPE;
61: g_v_application igs_lookup_values.meaning%TYPE;
62:
63: --Added the constant variable for Tuition Waivers Build
64: g_v_waiver CONSTANT VARCHAR2(10) := 'Waivers';
65: g_v_post_waiver_gl_flag igs_fi_control.post_waiver_gl_flag%TYPE;
66:
67: PROCEDURE initialize IS
68: /***********************************************************************************************
69:
1006: l_d_end_date DATE;
1007: l_v_sob_name gl_sets_of_books.name%TYPE;
1008: l_log_line VARCHAR2(2000);
1009: l_v_message_name fnd_new_messages.message_name%TYPE;
1010: l_v_manage_accounts igs_fi_control.manage_accounts%TYPE;
1011:
1012: -- Cursor for selecting the information from the System Options
1013: CURSOR cur_ctrl IS
1014: SELECT rec_installed,
1015: currency_cd,
1016: set_of_books_id,
1017: accounting_method,
1018: post_waiver_gl_flag
1019: FROM igs_fi_control;
1020:
1021: CURSOR cur_sob(cp_sob_id gl_sets_of_books.set_of_books_id%TYPE) IS
1022: SELECT name
1023: FROM gl_sets_of_books
1025:
1026: -- Cursor for selecting the records from gl period statuses table
1027: CURSOR cur_glp(cp_app_id NUMBER,
1028: cp_gl_date_start DATE,
1029: cp_sob_id igs_fi_control.set_of_books_id%TYPE) IS
1030: SELECT period_name, end_date
1031: FROM gl_period_statuses a
1032: WHERE TRUNC(start_date) <= TRUNC(cp_gl_date_start)
1033: AND TRUNC(end_date) >= TRUNC(cp_gl_date_start)
1100:
1101: fnd_file.new_line(fnd_file.log);
1102:
1103: -- Added the code here to exit from this procedure if the Receivables is not installed
1104: -- If validations of igs_fi_control fails then log the corresponding message and return.
1105: IF NOT l_b_val_parm THEN
1106: fnd_message.set_name ( 'IGS', l_v_message_name );
1107: IF l_v_message_name = 'IGS_FI_INVALID_PROCESS' THEN
1108: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y'));