APPS.PQH_GL_POSTING dependencies on GL_JE_SOURCES

Line 373: l_gl_je_sources_rec gl_je_sources%ROWTYPE;

369: l_budget_versions_rec pqh_budget_versions%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;

Line 426: CURSOR csr_gl_je_sources IS

422: FROM gl_budget_versions
423: WHERE budget_name = p_gl_budget_name AND
424: status in ('O','C');
425:
426: CURSOR csr_gl_je_sources IS
427: SELECT *
428: FROM gl_je_sources
429: WHERE je_source_name = 'Public Sector Budget';
430:

Line 428: FROM gl_je_sources

424: status in ('O','C');
425:
426: CURSOR csr_gl_je_sources 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 *

Line 694: OPEN csr_gl_je_sources;

690: */
691: get_default_currency;
692:
693: -- get the je_source
694: OPEN csr_gl_je_sources;
695: FETCH csr_gl_je_sources INTO l_gl_je_sources_rec;
696: CLOSE csr_gl_je_sources;
697:
698: g_user_je_source_name := l_gl_je_sources_rec.user_je_source_name;

Line 695: FETCH csr_gl_je_sources INTO l_gl_je_sources_rec;

691: get_default_currency;
692:
693: -- get the je_source
694: OPEN csr_gl_je_sources;
695: FETCH csr_gl_je_sources INTO l_gl_je_sources_rec;
696: CLOSE csr_gl_je_sources;
697:
698: g_user_je_source_name := l_gl_je_sources_rec.user_je_source_name;
699:

Line 696: CLOSE csr_gl_je_sources;

692:
693: -- get the je_source
694: OPEN csr_gl_je_sources;
695: FETCH csr_gl_je_sources INTO l_gl_je_sources_rec;
696: CLOSE csr_gl_je_sources;
697:
698: g_user_je_source_name := l_gl_je_sources_rec.user_je_source_name;
699:
700: -- CHECK : if g_user_je_source_name IS NOT NULL

Line 698: g_user_je_source_name := l_gl_je_sources_rec.user_je_source_name;

694: OPEN csr_gl_je_sources;
695: FETCH csr_gl_je_sources INTO l_gl_je_sources_rec;
696: CLOSE csr_gl_je_sources;
697:
698: g_user_je_source_name := l_gl_je_sources_rec.user_je_source_name;
699:
700: -- CHECK : if g_user_je_source_name IS NOT NULL
701: IF g_user_je_source_name IS NULL THEN
702: -- get message text for PQH_INVALID_JE_SOURCE_NAME