APPS.OZF_RESALE_LOGS_PKG dependencies on OZF_RESALE_LOGS_ALL

Line 72: INSERT INTO OZF_RESALE_LOGS_ALL(

68: END IF;
69: END IF;
70: -- End: bug # 5997978 fixed
71:
72: INSERT INTO OZF_RESALE_LOGS_ALL(
73: resale_log_id,
74: resale_id,
75: resale_id_type,
76: error_code,

Line 121: Update OZF_RESALE_LOGS_ALL

117: p_org_id NUMBER)
118:
119: IS
120: BEGIN
121: Update OZF_RESALE_LOGS_ALL
122: SET
123: resale_log_id = p_resale_log_id,
124: resale_id = p_resale_id,
125: resale_id_type = p_resale_id_type,

Line 159: DELETE FROM OZF_RESALE_LOGS_ALL

155: PROCEDURE Delete_Row(
156: p_RESALE_LOG_ID NUMBER)
157: IS
158: BEGIN
159: DELETE FROM OZF_RESALE_LOGS_ALL
160: WHERE RESALE_LOG_ID = p_RESALE_LOG_ID;
161: If (SQL%NOTFOUND) then
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: End If;

Line 197: FROM OZF_RESALE_LOGS_ALL

193:
194: IS
195: CURSOR C IS
196: SELECT *
197: FROM OZF_RESALE_LOGS_ALL
198: WHERE RESALE_LOG_ID = p_RESALE_LOG_ID
199: FOR UPDATE of RESALE_LOG_ID NOWAIT;
200: Recinfo C%ROWTYPE;
201: BEGIN