APPS.PQH_COMMITMENT_POSTING dependencies on GL_JE_CATEGORIES

Line 317: l_gl_je_categories_rec gl_je_categories%ROWTYPE;

313: l_gl_sets_of_books_rec gl_sets_of_books%ROWTYPE;
314: l_shared_types_rec per_shared_types%ROWTYPE;
315: l_gl_budget_versions_rec gl_budget_versions%ROWTYPE;
316: l_gl_je_sources_rec gl_je_sources%ROWTYPE;
317: l_gl_je_categories_rec gl_je_categories%ROWTYPE;
318: --
319: --
320: l_version_gl_status pqh_budget_versions.gl_status%TYPE;
321: --

Line 374: CURSOR csr_gl_je_categories IS

370: SELECT *
371: FROM gl_je_sources
372: WHERE je_source_name = 'Public Sector Budget';
373:
374: CURSOR csr_gl_je_categories IS
375: SELECT *
376: FROM gl_je_categories
377: WHERE je_category_name = 'Public Sector Budget';
378:

Line 376: FROM gl_je_categories

372: WHERE je_source_name = 'Public Sector Budget';
373:
374: CURSOR csr_gl_je_categories IS
375: SELECT *
376: FROM gl_je_categories
377: WHERE je_category_name = 'Public Sector Budget';
378:
379: CURSOR csr_table_route (p_table_alias IN varchar2 )IS
380: SELECT table_route_id

Line 837: OPEN csr_gl_je_categories;

833: END IF; -- gl_user_je_source_name IS NOT NULL
834: --
835: -- get the je category
836: --
837: OPEN csr_gl_je_categories;
838: FETCH csr_gl_je_categories INTO l_gl_je_categories_rec;
839: CLOSE csr_gl_je_categories;
840:
841: g_user_je_category_name := l_gl_je_categories_rec.user_je_category_name;

Line 838: FETCH csr_gl_je_categories INTO l_gl_je_categories_rec;

834: --
835: -- get the je category
836: --
837: OPEN csr_gl_je_categories;
838: FETCH csr_gl_je_categories INTO l_gl_je_categories_rec;
839: CLOSE csr_gl_je_categories;
840:
841: g_user_je_category_name := l_gl_je_categories_rec.user_je_category_name;
842: --

Line 839: CLOSE csr_gl_je_categories;

835: -- get the je category
836: --
837: OPEN csr_gl_je_categories;
838: FETCH csr_gl_je_categories INTO l_gl_je_categories_rec;
839: CLOSE csr_gl_je_categories;
840:
841: g_user_je_category_name := l_gl_je_categories_rec.user_je_category_name;
842: --
843: -- CHECK : if g_user_je_category_name IS NOT NULL

Line 841: g_user_je_category_name := l_gl_je_categories_rec.user_je_category_name;

837: OPEN csr_gl_je_categories;
838: FETCH csr_gl_je_categories INTO l_gl_je_categories_rec;
839: CLOSE csr_gl_je_categories;
840:
841: g_user_je_category_name := l_gl_je_categories_rec.user_je_category_name;
842: --
843: -- CHECK : if g_user_je_category_name IS NOT NULL
844: --
845: IF g_user_je_category_name IS NULL THEN