187: WHEN NO_DATA_FOUND THEN
188:
189: SELECT pa_resource_assignments_s.nextval
190: INTO X_Resource_Assignment_Id
191: FROM sys.dual;
192:
193: -- insert into pa_resource_assignments if necessary
194: insert into pa_resource_assignments(
195: resource_assignment_id,
323: END IF;
324:
325: SELECT pa_budget_lines_s.nextval
326: INTO l_budget_line_id
327: FROM DUAL;
328:
329: INSERT INTO pa_budget_lines(
330: budget_line_id, /* FPB2 */
331: budget_version_id, /* FPB2 */