168: -- where-NOT-Exists code)
169: --
170: /* The following code is modified as first check for the resource_Assignment_id,
171: If not exists then insert the record, by having the code like this the sequence
172: pa_resource_assignments_s will not get incremented unnecessarily 23-MAR-2001 */
173:
174: BEGIN
175:
176: select resource_assignment_id
185: l_rows_inserted := 0;
186: EXCEPTION
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