DBA Data[Home] [Help]

APPS.PA_BUDGET_LINES_V_PKG dependencies on PA_RESOURCE_ASSIGNMENTS_S

Line 172: pa_resource_assignments_s will not get incremented unnecessarily 23-MAR-2001 */

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

Line 189: SELECT pa_resource_assignments_s.nextval

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