Line 46: CURSOR C2 IS SELECT CSP_PARTS_LOOPS_B_S1.nextval FROM sys.dual;
42: p_DESCRIPTION VARCHAR2)
43:
44: IS
45: 46: CURSOR C2 IS SELECT CSP_PARTS_LOOPS_B_S1.nextval FROM sys.dual; 47: BEGIN
48: If (px_PARTS_LOOP_ID IS NULL) OR (px_PARTS_LOOP_ID = FND_API.G_MISS_NUM) then
49: OPEN C2;
50: FETCH C2 INTO px_PARTS_LOOP_ID;