DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on GL_JE_CATEGORIES

Line 3313: -- This procedure retrieves the user_je_category_name from gl_je_categories

3309: p_return_status := fnd_api.g_ret_sts_unexp_error;
3310: END gl_je_source;
3311:
3312: -- ##########################################################################
3313: -- This procedure retrieves the user_je_category_name from gl_je_categories
3314: -- ##########################################################################
3315:
3316: PROCEDURE gl_je_cat( P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,
3317: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS

Line 3323: FROM gl_je_categories

3319: l_product VARCHAR2(3);
3320: BEGIN
3321: SELECT user_je_category_name
3322: INTO p_user_je_category_name
3323: FROM gl_je_categories
3324: WHERE je_category_name = 'OLD';
3325: EXCEPTION
3326: WHEN NO_DATA_FOUND THEN
3327: l_error := 'JE CATEGORY = OLD';