APPS.PQH_COMMITMENT_POSTING dependencies on GL_JE_SOURCES

Line 316: l_gl_je_sources_rec gl_je_sources%ROWTYPE;

312: --
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;

Line 369: CURSOR csr_gl_je_sources IS

365: FROM gl_budget_versions
366: WHERE budget_name =p_gl_budget_name AND
367: status in ('O','C');
368:
369: CURSOR csr_gl_je_sources IS
370: SELECT *
371: FROM gl_je_sources
372: WHERE je_source_name = 'Public Sector Budget';
373:

Line 371: FROM gl_je_sources

367: status in ('O','C');
368:
369: CURSOR csr_gl_je_sources 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 *

Line 805: OPEN csr_gl_je_sources;

801: --
802: --
803: -- get the je_source
804: --
805: OPEN csr_gl_je_sources;
806: FETCH csr_gl_je_sources INTO l_gl_je_sources_rec;
807: CLOSE csr_gl_je_sources;
808: --
809: g_user_je_source_name := l_gl_je_sources_rec.user_je_source_name;

Line 806: FETCH csr_gl_je_sources INTO l_gl_je_sources_rec;

802: --
803: -- get the je_source
804: --
805: OPEN csr_gl_je_sources;
806: FETCH csr_gl_je_sources INTO l_gl_je_sources_rec;
807: CLOSE csr_gl_je_sources;
808: --
809: g_user_je_source_name := l_gl_je_sources_rec.user_je_source_name;
810: --

Line 807: CLOSE csr_gl_je_sources;

803: -- get the je_source
804: --
805: OPEN csr_gl_je_sources;
806: FETCH csr_gl_je_sources INTO l_gl_je_sources_rec;
807: CLOSE csr_gl_je_sources;
808: --
809: g_user_je_source_name := l_gl_je_sources_rec.user_je_source_name;
810: --
811: -- CHECK : if g_user_je_source_name IS NOT NULL

Line 809: g_user_je_source_name := l_gl_je_sources_rec.user_je_source_name;

805: OPEN csr_gl_je_sources;
806: FETCH csr_gl_je_sources INTO l_gl_je_sources_rec;
807: CLOSE csr_gl_je_sources;
808: --
809: g_user_je_source_name := l_gl_je_sources_rec.user_je_source_name;
810: --
811: -- CHECK : if g_user_je_source_name IS NOT NULL
812: --
813: IF g_user_je_source_name IS NULL THEN