Line 48: CURSOR C2 IS SELECT CSP_TASK_PARTS_S1.nextval FROM sys.dual;
44: P_ROLLUP_QUANTITY_USED NUMBER,
45: P_ROLLUP_TIMES_USED NUMBER,
46: P_SUBSTITUTE_ITEM NUMBER)
47: IS 48: CURSOR C2 IS SELECT CSP_TASK_PARTS_S1.nextval FROM sys.dual; 49: BEGIN
50: If (px_TASK_PART_ID IS NULL) OR (px_TASK_PART_ID = FND_API.G_MISS_NUM) then
51: OPEN C2;
52: FETCH C2 INTO px_TASK_PART_ID;