DBA Data[Home] [Help]

APPS.HR_STARTUP_DATA_API_SUPPORT dependencies on HR_OWNER_DEFINITIONS

Line 62: INSERT INTO hr_owner_definitions

58: --
59: hr_utility.trace('create_owner_definition');
60: hr_utility.trace('session id: ' || to_char(hr_startup_data_api_support.g_session_id));
61: hr_utility.trace('product_short_name: ' || p_product_shortname);
62: INSERT INTO hr_owner_definitions
63: (session_id
64: ,product_short_name)
65: VALUES
66: (hr_startup_data_api_support.g_session_id

Line 103: DELETE FROM hr_owner_definitions

99: -- Issue savepoint
100: SAVEPOINT del_owner_defs;
101: --
102: -- Delete rows for current session
103: DELETE FROM hr_owner_definitions
104: WHERE session_id = userenv('sessionid');
105: --
106: -- When in validation mode, raise validation enabled exception
107: IF p_validate THEN

Line 163: FROM hr_owner_definitions def

159: ) IS
160: --
161: CURSOR csr_check_exists (p_session_id number) IS
162: SELECT 'Y'
163: FROM hr_owner_definitions def
164: WHERE def.session_id = p_session_id;
165: --
166: l_exists varchar2(1);
167: l_mode varchar2(10);