132:
133: if (p_select_flag = 'Y') then
134:
135: l_creation_date := SYSDATE;
136: l_created_by := FND_GLOBAL.USER_ID;
137: l_last_update_date := SYSDATE;
138: l_last_updated_by := FND_GLOBAL.USER_ID;
139: l_last_update_login := FND_GLOBAL.USER_ID;
140: l_object_version_number := 1;
134:
135: l_creation_date := SYSDATE;
136: l_created_by := FND_GLOBAL.USER_ID;
137: l_last_update_date := SYSDATE;
138: l_last_updated_by := FND_GLOBAL.USER_ID;
139: l_last_update_login := FND_GLOBAL.USER_ID;
140: l_object_version_number := 1;
141:
142: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;
135: l_creation_date := SYSDATE;
136: l_created_by := FND_GLOBAL.USER_ID;
137: l_last_update_date := SYSDATE;
138: l_last_updated_by := FND_GLOBAL.USER_ID;
139: l_last_update_login := FND_GLOBAL.USER_ID;
140: l_object_version_number := 1;
141:
142: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;
143: