[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
1321: -- entered. This could arise because the forms startup code also handles
1322: -- application ownerships where a user enters a pay value on the form, but
1323: -- this code is intended to handle third party insertion from the element
1324: --
1325: insert into hr_application_ownerships
1326: (key_name,
1327: key_value,
1328: product_name)
1329: select 'INPUT_VALUE_ID',
1328: product_name)
1329: select 'INPUT_VALUE_ID',
1330: p_input_value_id,
1331: ao.product_name
1332: from hr_application_ownerships ao
1333: where ao.key_name = 'ELEMENT_TYPE_ID'
1334: and ao.key_value = p_element_type_id
1335: and not exists (select 'INPUT_VALUE_ID',
1336: p_input_value_id,
1334: and ao.key_value = p_element_type_id
1335: and not exists (select 'INPUT_VALUE_ID',
1336: p_input_value_id,
1337: ao.product_name
1338: from hr_application_ownerships ao
1339: where ao.key_name = 'ELEMENT_TYPE_ID'
1340: and ao.key_value = p_element_type_id);
1341: --
1342: end if;