APPS.PQH_COMMITMENT_POSTING dependencies on GL_LOOKUPS

Line 2734: CURSOR csr_gl_lookups(p_lookup_code IN varchar2 ) IS

2730: WHERE application_id = g_application_id
2731: AND set_of_books_id = g_set_of_books_id
2732: AND period_name = p_period_name;
2733: --
2734: CURSOR csr_gl_lookups(p_lookup_code IN varchar2 ) IS
2735: SELECT description
2736: FROM gl_lookups
2737: WHERE lookup_type = 'FUNDS_CHECK_RESULT_CODE'
2738: AND lookup_code = p_lookup_code

Line 2736: FROM gl_lookups

2732: AND period_name = p_period_name;
2733: --
2734: CURSOR csr_gl_lookups(p_lookup_code IN varchar2 ) IS
2735: SELECT description
2736: FROM gl_lookups
2737: WHERE lookup_type = 'FUNDS_CHECK_RESULT_CODE'
2738: AND lookup_code = p_lookup_code
2739: AND NVL(enabled_flag,'N') = 'Y';
2740: --

Line 2748: FROM gl_lookups

2744: WHERE packet_id = p_packet_id;
2745: --
2746: CURSOR csr_gl_status(p_lookup_code IN varchar2 ) IS
2747: SELECT description
2748: FROM gl_lookups
2749: WHERE lookup_type = 'FUNDS_CHECK_STATUS_CODE'
2750: AND lookup_code = p_lookup_code
2751: AND NVL(enabled_flag,'N') = 'Y';
2752: --

Line 2841: -- get the return code desc from GL lookups

2837: );
2838:
2839: hr_utility.set_location('GL Fund Checker return Code : '||l_fc_return,110);
2840: --
2841: -- get the return code desc from GL lookups
2842: --
2843: OPEN csr_gl_status(p_lookup_code => l_fc_return);
2844: FETCH csr_gl_status INTO l_packet_status_code;
2845: CLOSE csr_gl_status;

Line 2874: OPEN csr_gl_lookups(p_lookup_code => l_packet_result_code);

2870: OPEN csr_gl_packet_code(p_packet_id => l_packet_id);
2871: FETCH csr_gl_packet_code INTO l_packet_result_code;
2872: CLOSE csr_gl_packet_code;
2873:
2874: OPEN csr_gl_lookups(p_lookup_code => l_packet_result_code);
2875: FETCH csr_gl_lookups INTO l_fc_message;
2876: CLOSE csr_gl_lookups;
2877: END IF;
2878: --

Line 2875: FETCH csr_gl_lookups INTO l_fc_message;

2871: FETCH csr_gl_packet_code INTO l_packet_result_code;
2872: CLOSE csr_gl_packet_code;
2873:
2874: OPEN csr_gl_lookups(p_lookup_code => l_packet_result_code);
2875: FETCH csr_gl_lookups INTO l_fc_message;
2876: CLOSE csr_gl_lookups;
2877: END IF;
2878: --
2879: hr_utility.set_location('Fund Chk Error : '||substr(l_fc_message,1,50),120);

Line 2876: CLOSE csr_gl_lookups;

2872: CLOSE csr_gl_packet_code;
2873:
2874: OPEN csr_gl_lookups(p_lookup_code => l_packet_result_code);
2875: FETCH csr_gl_lookups INTO l_fc_message;
2876: CLOSE csr_gl_lookups;
2877: END IF;
2878: --
2879: hr_utility.set_location('Fund Chk Error : '||substr(l_fc_message,1,50),120);
2880: --