507:
508: if (l_temp_attribute_id is not NULL)then
509: --raise error ask to rerun the ldts after deleting the child
510: --rows
511: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
512: fnd_message.set_token('TABLE_NAME',
513: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
514: fnd_message.raise_error;
515: end if;
508: if (l_temp_attribute_id is not NULL)then
509: --raise error ask to rerun the ldts after deleting the child
510: --rows
511: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
512: fnd_message.set_token('TABLE_NAME',
513: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
514: fnd_message.raise_error;
515: end if;
516:
510: --rows
511: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
512: fnd_message.set_token('TABLE_NAME',
513: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
514: fnd_message.raise_error;
515: end if;
516:
517: open csr_pbad_id(l_attribute_id);
518: fetch csr_pbad_id into l_temp_attribute_id;
520:
521: if(l_temp_attribute_id is not NULL)then
522: --raise error ask to rerun the ldts after deleting the child
523: --rows
524: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
525: fnd_message.set_token('TABLE_NAME',
526: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
527: fnd_message.raise_error;
528: end if;
521: if(l_temp_attribute_id is not NULL)then
522: --raise error ask to rerun the ldts after deleting the child
523: --rows
524: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
525: fnd_message.set_token('TABLE_NAME',
526: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
527: fnd_message.raise_error;
528: end if;
529:
523: --rows
524: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
525: fnd_message.set_token('TABLE_NAME',
526: 'PAY_BAL_ATTRIBUTE_DEFINITIONS');
527: fnd_message.raise_error;
528: end if;
529:
530: update PAY_BAL_ATTRIBUTE_DEFINITIONS
531: set ALTERABLE =p_ALTERABLE