Line 57: CURSOR C2 IS SELECT CSD_REPAIR_JOB_XREF_S1.nextval FROM sys.dual;
53: p_ATTRIBUTE15 VARCHAR2,
54: P_QUANTITY_COMPLETED NUMBER)
55:
56: IS 57: CURSOR C2 IS SELECT CSD_REPAIR_JOB_XREF_S1.nextval FROM sys.dual; 58: BEGIN
59: If (px_REPAIR_JOB_XREF_ID IS NULL) OR (px_REPAIR_JOB_XREF_ID = FND_API.G_MISS_NUM) then
60: OPEN C2;
61: FETCH C2 INTO px_REPAIR_JOB_XREF_ID;