99: and element_code = p_element_code;
100:
101: if (p_select_flag = 'Y') then
102: l_creation_date := SYSDATE;
103: l_created_by := FND_GLOBAL.USER_ID;
104: l_last_update_date := SYSDATE;
105: l_last_updated_by := FND_GLOBAL.USER_ID;
106: l_last_update_login := FND_GLOBAL.USER_ID;
107: l_object_version_number := 1;
101: if (p_select_flag = 'Y') then
102: l_creation_date := SYSDATE;
103: l_created_by := FND_GLOBAL.USER_ID;
104: l_last_update_date := SYSDATE;
105: l_last_updated_by := FND_GLOBAL.USER_ID;
106: l_last_update_login := FND_GLOBAL.USER_ID;
107: l_object_version_number := 1;
108:
109: select AMW_SIGNIFICANT_ELEMENT_S.nextval into l_significant_element_id from dual;
102: l_creation_date := SYSDATE;
103: l_created_by := FND_GLOBAL.USER_ID;
104: l_last_update_date := SYSDATE;
105: l_last_updated_by := FND_GLOBAL.USER_ID;
106: l_last_update_login := FND_GLOBAL.USER_ID;
107: l_object_version_number := 1;
108:
109: select AMW_SIGNIFICANT_ELEMENT_S.nextval into l_significant_element_id from dual;
110: