DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_PVT dependencies on ONT_DBI_CHANGE_LOG

Line 76: DELETE from ONT_DBI_CHANGE_LOG

72: IF G_DBI_INSTALLED = 'Y' THEN
73:
74: -- Delete from DBI log tables
75: FORALL i IN 1..G_ERROR_REC.order_source_id.COUNT
76: DELETE from ONT_DBI_CHANGE_LOG
77: WHERE header_id = G_ERROR_REC.header_id(i);
78:
79: END IF;
80:

Line 223: INSERT INTO ONT_DBI_CHANGE_LOG

219: FOR I IN 1..p_line_rec.line_id.count LOOP
220:
221: IF p_line_rec.booked_flag(I) = 'Y' THEN
222:
223: INSERT INTO ONT_DBI_CHANGE_LOG
224: ( HEADER_ID
225: ,LINE_ID
226: ,SET_OF_BOOKS_ID
227: ,CURRENCY_CODE