APPS.OZF_THRESHOLD_RULES_PKG dependencies on OZF_THRESHOLD_RULES_ALL

Line 104: INSERT INTO OZF_THRESHOLD_RULES_ALL(

100:
101: px_object_version_number := 1;
102:
103:
104: INSERT INTO OZF_THRESHOLD_RULES_ALL(
105: threshold_rule_id,
106: last_update_date,
107: last_updated_by,
108: last_update_login,

Line 272: Update OZF_THRESHOLD_RULES_ALL

268: )
269:
270: IS
271: BEGIN
272: Update OZF_THRESHOLD_RULES_ALL
273: SET
274: threshold_rule_id = p_threshold_rule_id,
275: last_update_date = p_last_update_date,
276: last_updated_by = p_last_updated_by,

Line 352: DELETE FROM OZF_THRESHOLD_RULES_ALL

348: PROCEDURE Delete_Row(
349: p_THRESHOLD_RULE_ID NUMBER)
350: IS
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;

Line 428: FROM OZF_THRESHOLD_RULES_ALL

424:
425: IS
426: CURSOR C IS
427: SELECT *
428: FROM OZF_THRESHOLD_RULES_ALL
429: WHERE THRESHOLD_RULE_ID = p_THRESHOLD_RULE_ID
430: FOR UPDATE of THRESHOLD_RULE_ID NOWAIT;
431: Recinfo C%ROWTYPE;
432: BEGIN