APPS.IGS_FI_GL_INTERFACE dependencies on GL_JE_CATEGORIES

Line 404: CURSOR cur_je_cat(cp_je_cat gl_je_categories.je_category_name%TYPE) IS

400: l_n_amnt gl_interface.entered_dr%TYPE;
401: l_n_user_id gl_interface.created_by%TYPE;
402: l_v_user_je_cat gl_interface.user_je_category_name%TYPE;
403:
404: CURSOR cur_je_cat(cp_je_cat gl_je_categories.je_category_name%TYPE) IS
405: SELECT user_je_category_name
406: FROM gl_je_categories
407: WHERE je_category_name = cp_je_cat;
408:

Line 406: FROM gl_je_categories

402: l_v_user_je_cat gl_interface.user_je_category_name%TYPE;
403:
404: CURSOR cur_je_cat(cp_je_cat gl_je_categories.je_category_name%TYPE) IS
405: SELECT user_je_category_name
406: FROM gl_je_categories
407: WHERE je_category_name = cp_je_cat;
408:
409: BEGIN
410: l_n_dr_ccid := p_dr_ccid;

Line 545: l_v_crd_cat gl_je_categories.je_category_name%TYPE;

541: AND cra.cr_gl_ccid IS NOT NULL
542: AND cra.status <> g_v_transferred;
543:
544: l_b_exception_flag BOOLEAN;
545: l_v_crd_cat gl_je_categories.je_category_name%TYPE;
546: l_v_crd_desc gl_interface.reference10%TYPE;
547: l_b_waiver_flag BOOLEAN;
548:
549: BEGIN

Line 642: l_v_inv_cat gl_je_categories.je_category_name%TYPE;

638: is set to NULL, it has to be treated as a valid transaction
639: i.e. error_account is treated as 'N'
640: ********************************************************************************************** */
641: l_b_exception_flag BOOLEAN;
642: l_v_inv_cat gl_je_categories.je_category_name%TYPE;
643: l_v_inv_desc gl_interface.reference10%TYPE;
644:
645: -- Cursor for selecting the Charge transactions from the Invoice Lines table
646: CURSOR cur_chg(cp_gl_date_start igs_fi_invln_int.gl_date%TYPE,

Line 771: l_v_app_cat gl_je_categories.je_category_name%TYPE;

767: Who When What
768: bannamal 05-Jul-05 Bug# 3392095, Tuition Waivers Build.
769: Added code to skip the waiver application record if the post_waiver_gl_flag is set to 'N'.
770: ********************************************************************************************** */
771: l_v_app_cat gl_je_categories.je_category_name%TYPE;
772: l_v_app_desc gl_interface.reference10%TYPE;
773: l_b_exception_flag BOOLEAN;
774: l_b_waiver_flag BOOLEAN;
775:

Line 892: l_v_adm_cat gl_je_categories.je_category_name%TYPE;

888: pathipat 14-Jun-2003 Enh 2831587 - Credit Card Fund Transfer build
889: Modified call to igs_ad_app_req_pkg.update_row - added 3 new parameters
890: ********************************************************************************************** */
891: l_b_exception_flag BOOLEAN;
892: l_v_adm_cat gl_je_categories.je_category_name%TYPE;
893: l_v_adm_desc gl_interface.reference10%TYPE;
894:
895: -- Cursor for selecting the records from the admission application table
896: CURSOR cur_adm(cp_gl_date_start DATE,