APPS.PQH_GL_POSTING dependencies on GL_JE_CATEGORIES

Line 374: l_gl_je_categories_rec gl_je_categories%ROWTYPE;

370: l_gl_sets_of_books_rec gl_sets_of_books%ROWTYPE;
371: l_shared_types_rec per_shared_types%ROWTYPE;
372: l_gl_budget_versions_rec gl_budget_versions%ROWTYPE;
373: l_gl_je_sources_rec gl_je_sources%ROWTYPE;
374: l_gl_je_categories_rec gl_je_categories%ROWTYPE;
375: l_transfer_to_gl_flag varchar2(10);
376: l_message_text pqh_process_log.message_text%TYPE;
377: l_message_text_out fnd_new_messages.message_text%TYPE;
378: l_error_flag varchar2(10) := 'N';

Line 431: CURSOR csr_gl_je_categories IS

427: SELECT *
428: FROM gl_je_sources
429: WHERE je_source_name = 'Public Sector Budget';
430:
431: CURSOR csr_gl_je_categories IS
432: SELECT *
433: FROM gl_je_categories
434: WHERE je_category_name = 'Public Sector Budget';
435:

Line 433: FROM gl_je_categories

429: WHERE je_source_name = 'Public Sector Budget';
430:
431: CURSOR csr_gl_je_categories IS
432: SELECT *
433: FROM gl_je_categories
434: WHERE je_category_name = 'Public Sector Budget';
435:
436: CURSOR csr_flex_maps_counts (p_budget_id IN number)IS
437: SELECT COUNT(*)

Line 722: OPEN csr_gl_je_categories;

718:
719: END IF; -- g_user_je_source_name IS NOT NULL
720:
721: -- get the je category
722: OPEN csr_gl_je_categories;
723: FETCH csr_gl_je_categories INTO l_gl_je_categories_rec;
724: CLOSE csr_gl_je_categories;
725:
726: g_user_je_category_name := l_gl_je_categories_rec.user_je_category_name;

Line 723: FETCH csr_gl_je_categories INTO l_gl_je_categories_rec;

719: END IF; -- g_user_je_source_name IS NOT NULL
720:
721: -- get the je category
722: OPEN csr_gl_je_categories;
723: FETCH csr_gl_je_categories INTO l_gl_je_categories_rec;
724: CLOSE csr_gl_je_categories;
725:
726: g_user_je_category_name := l_gl_je_categories_rec.user_je_category_name;
727:

Line 724: CLOSE csr_gl_je_categories;

720:
721: -- get the je category
722: OPEN csr_gl_je_categories;
723: FETCH csr_gl_je_categories INTO l_gl_je_categories_rec;
724: CLOSE csr_gl_je_categories;
725:
726: g_user_je_category_name := l_gl_je_categories_rec.user_je_category_name;
727:
728: -- CHECK : if g_user_je_category_name IS NOT NULL

Line 726: g_user_je_category_name := l_gl_je_categories_rec.user_je_category_name;

722: OPEN csr_gl_je_categories;
723: FETCH csr_gl_je_categories INTO l_gl_je_categories_rec;
724: CLOSE csr_gl_je_categories;
725:
726: g_user_je_category_name := l_gl_je_categories_rec.user_je_category_name;
727:
728: -- CHECK : if g_user_je_category_name IS NOT NULL
729: IF g_user_je_category_name IS NULL THEN
730: -- get message text for PQH_INVALID_JE_CATEGORY_NAME