[Home] [Help]
682: p_session_date,
683: p_validation_start_date,
684: p_validation_end_date );
685: --
686: delete from hr_application_ownerships
687: where key_name = 'INPUT_VALUE_ID'
688: and key_value = fetched_input_value.input_value_id;
689: --
690: -- For date effective deletes, shut down the input value by ensuring its end
1306: -- entered. This could arise because the forms startup code also handles
1307: -- application ownerships where a user enters a pay value on the form, but
1308: -- this code is intended to handle third party insertion from the element
1309: --
1310: insert into hr_application_ownerships
1311: (key_name,
1312: key_value,
1313: product_name)
1314: select 'INPUT_VALUE_ID',
1313: product_name)
1314: select 'INPUT_VALUE_ID',
1315: p_input_value_id,
1316: ao.product_name
1317: from hr_application_ownerships ao
1318: where ao.key_name = 'ELEMENT_TYPE_ID'
1319: and ao.key_value = p_element_type_id
1320: and not exists (select 'INPUT_VALUE_ID',
1321: p_input_value_id,
1319: and ao.key_value = p_element_type_id
1320: and not exists (select 'INPUT_VALUE_ID',
1321: p_input_value_id,
1322: ao.product_name
1323: from hr_application_ownerships ao
1324: where ao.key_name = 'ELEMENT_TYPE_ID'
1325: and ao.key_value = p_element_type_id);
1326: --
1327: end if;