APPS.OZF_THRESHOLD_RULES_PKG dependencies on FND_API

Line 94: IF (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM) THEN

90:
91:
92: BEGIN
93: /*
94: IF (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM) THEN
95: SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
96: INTO p_org_id
97: FROM DUAL;
98: END IF;

Line 317: object_version_number = DECODE( px_object_version_number, FND_API.g_miss_num, object_version_number + 1, px_object_version_number + 1),

313: attribute15 = p_attribute15,
314: --org_id = p_org_id,
315: security_group_id = p_security_group_id,
316: converted_days = p_converted_days,
317: object_version_number = DECODE( px_object_version_number, FND_API.g_miss_num, object_version_number + 1, px_object_version_number + 1),
318: comparison_type = p_comparison_type,
319: alert_type = p_alert_type
320: WHERE THRESHOLD_RULE_ID = p_THRESHOLD_RULE_ID
321: AND object_version_number = px_object_version_number;

Line 324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

320: WHERE THRESHOLD_RULE_ID = p_THRESHOLD_RULE_ID
321: AND object_version_number = px_object_version_number;
322:
323: IF (SQL%NOTFOUND) THEN
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:
327: px_object_version_number := px_object_version_number + 1;
328:

Line 355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

351: BEGIN
352: DELETE FROM OZF_THRESHOLD_RULES_ALL
353: WHERE THRESHOLD_RULE_ID = p_THRESHOLD_RULE_ID;
354: If (SQL%NOTFOUND) then
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: End If;
357: END Delete_Row ;
358:
359: