DBA Data[Home] [Help]

APPS.OZF_REASON_PVT dependencies on OZF_REASON_CODES_ALL_PKG

Line 114: -- Invoke table handler(OZF_reason_codes_All_PKG.Insert_Row)

110: -- Pass org_id from UI
111: l_org_id := p_reason_rec.ORG_ID;
112:
113:
114: -- Invoke table handler(OZF_reason_codes_All_PKG.Insert_Row)
115: OZF_reason_codes_All_PKG.Insert_Row(
116: px_REASON_CODE_ID => l_REASON_CODE_ID,
117: px_OBJECT_VERSION_NUMBER => l_object_version_number,
118: p_LAST_UPDATE_DATE => SYSDATE,

Line 115: OZF_reason_codes_All_PKG.Insert_Row(

111: l_org_id := p_reason_rec.ORG_ID;
112:
113:
114: -- Invoke table handler(OZF_reason_codes_All_PKG.Insert_Row)
115: OZF_reason_codes_All_PKG.Insert_Row(
116: px_REASON_CODE_ID => l_REASON_CODE_ID,
117: px_OBJECT_VERSION_NUMBER => l_object_version_number,
118: p_LAST_UPDATE_DATE => SYSDATE,
119: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 428: -- Invoke table handler(OZF_reason_codes_All_PKG.Update_Row)

424: END IF;
425:
426: l_object_version_number := l_reason_rec.OBJECT_VERSION_NUMBER + 1;
427:
428: -- Invoke table handler(OZF_reason_codes_All_PKG.Update_Row)
429: OZF_reason_codes_All_PKG.Update_Row(
430: p_REASON_CODE_ID => l_reason_rec.REASON_CODE_ID,
431: p_OBJECT_VERSION_NUMBER => l_object_version_number,
432: p_LAST_UPDATE_DATE => SYSDATE,

Line 429: OZF_reason_codes_All_PKG.Update_Row(

425:
426: l_object_version_number := l_reason_rec.OBJECT_VERSION_NUMBER + 1;
427:
428: -- Invoke table handler(OZF_reason_codes_All_PKG.Update_Row)
429: OZF_reason_codes_All_PKG.Update_Row(
430: p_REASON_CODE_ID => l_reason_rec.REASON_CODE_ID,
431: p_OBJECT_VERSION_NUMBER => l_object_version_number,
432: p_LAST_UPDATE_DATE => SYSDATE,
433: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 590: -- Invoke table handler(OZF_reason_codes_All_PKG.Delete_Row)

586: END IF;
587: RAISE FND_API.g_exc_error;
588: END IF;
589:
590: -- Invoke table handler(OZF_reason_codes_All_PKG.Delete_Row)
591: OZF_reason_codes_All_PKG.Delete_Row(
592: p_REASON_CODE_ID => p_REASON_CODE_ID);
593: --
594: -- End of API body

Line 591: OZF_reason_codes_All_PKG.Delete_Row(

587: RAISE FND_API.g_exc_error;
588: END IF;
589:
590: -- Invoke table handler(OZF_reason_codes_All_PKG.Delete_Row)
591: OZF_reason_codes_All_PKG.Delete_Row(
592: p_REASON_CODE_ID => p_REASON_CODE_ID);
593: --
594: -- End of API body
595: --

Line 1013: -- Invoke table handler(OZF_reason_codes_All_PKG.Delete_Row)

1009: IF OZF_DEBUG_HIGH_ON THEN
1010: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1011: END IF;
1012:
1013: -- Invoke table handler(OZF_reason_codes_All_PKG.Delete_Row)
1014: DELETE FROM ozf_reasons
1015: WHERE reason_type_id = p_reason_type_id
1016: AND object_version_number = p_object_version_number;
1017: