APPS.PQH_GL_POSTING dependencies on GL_LOOKUPS

Line 1701: CURSOR csr_gl_lookups(p_lookup_code IN varchar2 ) IS

1697: WHERE application_id = g_application_id
1698: AND set_of_books_id = g_set_of_books_id
1699: AND period_name = p_period_name;
1700:
1701: CURSOR csr_gl_lookups(p_lookup_code IN varchar2 ) IS
1702: SELECT description
1703: FROM gl_lookups
1704: WHERE lookup_type = 'FUNDS_CHECK_RESULT_CODE'
1705: AND lookup_code = p_lookup_code

Line 1703: FROM gl_lookups

1699: AND period_name = p_period_name;
1700:
1701: CURSOR csr_gl_lookups(p_lookup_code IN varchar2 ) IS
1702: SELECT description
1703: FROM gl_lookups
1704: WHERE lookup_type = 'FUNDS_CHECK_RESULT_CODE'
1705: AND lookup_code = p_lookup_code
1706: AND NVL(enabled_flag,'N') = 'Y';
1707:

Line 1715: FROM gl_lookups

1711: WHERE packet_id = p_packet_id;
1712:
1713: CURSOR csr_gl_status(p_lookup_code IN varchar2 ) IS
1714: SELECT description
1715: FROM gl_lookups
1716: WHERE lookup_type = 'FUNDS_CHECK_STATUS_CODE'
1717: AND lookup_code = p_lookup_code
1718: AND NVL(enabled_flag,'N') = 'Y';
1719:

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

1789: );
1790:
1791: hr_utility.set_location('GL Fund Checker return Code : '||l_fc_return,110);
1792:
1793: -- get the return code desc from GL lookups
1794: OPEN csr_gl_status(p_lookup_code => l_fc_return);
1795: FETCH csr_gl_status INTO l_packet_status_code;
1796: CLOSE csr_gl_status;
1797:

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

1831: OPEN csr_gl_packet_code(p_packet_id => l_packet_id);
1832: FETCH csr_gl_packet_code INTO l_packet_result_code;
1833: CLOSE csr_gl_packet_code;
1834:
1835: OPEN csr_gl_lookups(p_lookup_code => l_packet_result_code);
1836: FETCH csr_gl_lookups INTO l_fc_message;
1837: CLOSE csr_gl_lookups;
1838: END IF;
1839:

Line 1836: FETCH csr_gl_lookups INTO l_fc_message;

1832: FETCH csr_gl_packet_code INTO l_packet_result_code;
1833: CLOSE csr_gl_packet_code;
1834:
1835: OPEN csr_gl_lookups(p_lookup_code => l_packet_result_code);
1836: FETCH csr_gl_lookups INTO l_fc_message;
1837: CLOSE csr_gl_lookups;
1838: END IF;
1839:
1840: hr_utility.set_location('Fund Chk Error : '||substr(l_fc_message,1,50),120);

Line 1837: CLOSE csr_gl_lookups;

1833: CLOSE csr_gl_packet_code;
1834:
1835: OPEN csr_gl_lookups(p_lookup_code => l_packet_result_code);
1836: FETCH csr_gl_lookups INTO l_fc_message;
1837: CLOSE csr_gl_lookups;
1838: END IF;
1839:
1840: hr_utility.set_location('Fund Chk Error : '||substr(l_fc_message,1,50),120);
1841: