APPS.HXC_UPGRADE_PKG dependencies on HXC_UPGRADE_DEFINITIONS

Line 24: FROM hxc_upgrade_definitions

20: l_request_id NUMBER;
21:
22: CURSOR get_status (c_upg_type varchar2)
23: IS SELECT status
24: FROM hxc_upgrade_definitions
25: WHERE upg_type = c_upg_type;
26:
27: CURSOR get_id
28: IS SELECT /*+ FIRST_ROWS */

Line 797: UPDATE hxc_upgrade_definitions

793: END;
794:
795: IF l_exists = 0
796: THEN
797: UPDATE hxc_upgrade_definitions
798: SET status = 'COMPLETE',
799: last_update_date = SYSDATE,
800: last_updated_by = FND_GLOBAL.user_id
801: WHERE upg_type = p_type;

Line 1832: FROM hxc_upgrade_definitions

1828: BEGIN
1829:
1830: SELECT 1
1831: INTO l_upgrade
1832: FROM hxc_upgrade_definitions
1833: WHERE upg_type = 'LATEST_DETAILS'
1834: AND status = 'COMPLETE';
1835:
1836: IF l_upgrade = 1

Line 1862: FROM hxc_upgrade_definitions

1858: BEGIN
1859:
1860: SELECT 1
1861: INTO l_upgrade
1862: FROM hxc_upgrade_definitions
1863: WHERE upg_type = 'DEPOSIT_TRANSACTIONS'
1864: AND status = 'COMPLETE';
1865:
1866: IF l_upgrade = 1

Line 1885: INSERT INTO HXC_UPGRADE_DEFINITIONS

1881: IS
1882:
1883: BEGIN
1884:
1885: INSERT INTO HXC_UPGRADE_DEFINITIONS
1886: ( UPG_TYPE,
1887: STATUS,
1888: last_updated_by,
1889: last_update_date)

Line 1926: WHERE lookup_type = 'HXC_UPGRADE_DEFINITIONS'

1922:
1923: CURSOR get_upg_name(p_lookup_code IN VARCHAR2)
1924: IS SELECT meaning
1925: FROM fnd_lookup_values
1926: WHERE lookup_type = 'HXC_UPGRADE_DEFINITIONS'
1927: AND lookup_code = p_lookup_code
1928: AND language = USERENV('LANG');
1929:
1930: l_lookup_name VARCHAR2(100);

Line 1959: FROM hxc_upgrade_definitions

1955: BEGIN
1956:
1957: SELECT 1
1958: INTO l_upgrade
1959: FROM hxc_upgrade_definitions
1960: WHERE upg_type = p_upg_type
1961: AND status = 'COMPLETE';
1962:
1963: IF l_upgrade = 1