APPS.OZF_RESALE_BATCH_LINE_MAPS_PKG dependencies on OZF_RESALE_BATCH_LINE_MAPS_ALL

Line 97: INSERT INTO OZF_RESALE_BATCH_LINE_MAPS_ALL(

93:
94: px_object_version_number := 1;
95:
96:
97: INSERT INTO OZF_RESALE_BATCH_LINE_MAPS_ALL(
98: resale_batch_line_map_id,
99: resale_batch_id,
100: resale_line_id,
101: object_version_number,

Line 213: Update OZF_RESALE_BATCH_LINE_MAPS_ALL

209: p_org_id NUMBER)
210:
211: IS
212: BEGIN
213: Update OZF_RESALE_BATCH_LINE_MAPS_ALL
214: SET
215: resale_batch_line_map_id = p_resale_batch_line_map_id,
216: resale_batch_id = p_resale_batch_id,
217: resale_line_id = p_resale_line_id,

Line 273: DELETE FROM OZF_RESALE_BATCH_LINE_MAPS_ALL

269: PROCEDURE Delete_Row(
270: p_RESALE_BATCH_LINE_MAP_ID NUMBER)
271: IS
272: BEGIN
273: DELETE FROM OZF_RESALE_BATCH_LINE_MAPS_ALL
274: WHERE RESALE_BATCH_LINE_MAP_ID = p_RESALE_BATCH_LINE_MAP_ID;
275: If (SQL%NOTFOUND) then
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: End If;

Line 334: FROM OZF_RESALE_BATCH_LINE_MAPS_ALL

330:
331: IS
332: CURSOR C IS
333: SELECT *
334: FROM OZF_RESALE_BATCH_LINE_MAPS_ALL
335: WHERE RESALE_BATCH_LINE_MAP_ID = p_RESALE_BATCH_LINE_MAP_ID
336: FOR UPDATE of RESALE_BATCH_LINE_MAP_ID NOWAIT;
337: Recinfo C%ROWTYPE;
338: BEGIN