63: INTO l_cost_id
64: FROM DUAL;
65:
66:
67: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
68: FND_LOG.String
69: (FND_LOG.level_procedure ,
70: L_LOG_MODULE ||'',
71: 'Before Inserting into the cost table. l_cost_id: '||l_cost_id
64: FROM DUAL;
65:
66:
67: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
68: FND_LOG.String
69: (FND_LOG.level_procedure ,
70: L_LOG_MODULE ||'',
71: 'Before Inserting into the cost table. l_cost_id: '||l_cost_id
72: );
65:
66:
67: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
68: FND_LOG.String
69: (FND_LOG.level_procedure ,
70: L_LOG_MODULE ||'',
71: 'Before Inserting into the cost table. l_cost_id: '||l_cost_id
72: );
73: END IF;
167: --commit the work
168: COMMIT;
169:
170:
171: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
172: FND_LOG.String
173: (FND_LOG.level_procedure ,
174: L_LOG_MODULE ||'',
175: 'After Inserting into the cost table. l_cost_id: '||l_cost_id
168: COMMIT;
169:
170:
171: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
172: FND_LOG.String
173: (FND_LOG.level_procedure ,
174: L_LOG_MODULE ||'',
175: 'After Inserting into the cost table. l_cost_id: '||l_cost_id
176: );
169:
170:
171: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
172: FND_LOG.String
173: (FND_LOG.level_procedure ,
174: L_LOG_MODULE ||'',
175: 'After Inserting into the cost table. l_cost_id: '||l_cost_id
176: );
177: END IF;
243: WHERE estimate_detail_id =p_estimate_detail_id;
244:
245:
246: BEGIN
247: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
248: FND_LOG.String
249: (FND_LOG.level_procedure ,
250: L_LOG_MODULE ||'',
251: 'Before Updating the cost table.p_cost_id: '||p_cost_id
244:
245:
246: BEGIN
247: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
248: FND_LOG.String
249: (FND_LOG.level_procedure ,
250: L_LOG_MODULE ||'',
251: 'Before Updating the cost table.p_cost_id: '||p_cost_id
252: );
245:
246: BEGIN
247: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
248: FND_LOG.String
249: (FND_LOG.level_procedure ,
250: L_LOG_MODULE ||'',
251: 'Before Updating the cost table.p_cost_id: '||p_cost_id
252: );
253: END IF;
316: END IF;
317:
318: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER+1;
319:
320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
321: FND_LOG.String
322: (FND_LOG.level_procedure ,
323: L_LOG_MODULE ||'',
324: 'After Updating the cost table. x_object_version_number: '||x_object_version_number
317:
318: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER+1;
319:
320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
321: FND_LOG.String
322: (FND_LOG.level_procedure ,
323: L_LOG_MODULE ||'',
324: 'After Updating the cost table. x_object_version_number: '||x_object_version_number
325: ) ;
318: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER+1;
319:
320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
321: FND_LOG.String
322: (FND_LOG.level_procedure ,
323: L_LOG_MODULE ||'',
324: 'After Updating the cost table. x_object_version_number: '||x_object_version_number
325: ) ;
326: END IF;
340: ) IS
341:
342: BEGIN
343:
344: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
345: FND_LOG.String
346: (FND_LOG.level_procedure ,
347: L_LOG_MODULE ||'',
348: 'Before Deleting the cost record . p_cost_id '||p_cost_id
341:
342: BEGIN
343:
344: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
345: FND_LOG.String
346: (FND_LOG.level_procedure ,
347: L_LOG_MODULE ||'',
348: 'Before Deleting the cost record . p_cost_id '||p_cost_id
349: );
342: BEGIN
343:
344: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
345: FND_LOG.String
346: (FND_LOG.level_procedure ,
347: L_LOG_MODULE ||'',
348: 'Before Deleting the cost record . p_cost_id '||p_cost_id
349: );
350: END IF;
355: IF (SQL%NOTFOUND) THEN
356: RAISE NO_DATA_FOUND;
357: END IF;
358:
359: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
360: FND_LOG.String
361: (FND_LOG.level_procedure ,
362: L_LOG_MODULE ||'',
363: 'After Deleting the cost record . p_cost_id : '||p_cost_id
356: RAISE NO_DATA_FOUND;
357: END IF;
358:
359: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
360: FND_LOG.String
361: (FND_LOG.level_procedure ,
362: L_LOG_MODULE ||'',
363: 'After Deleting the cost record . p_cost_id : '||p_cost_id
364: );
357: END IF;
358:
359: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
360: FND_LOG.String
361: (FND_LOG.level_procedure ,
362: L_LOG_MODULE ||'',
363: 'After Deleting the cost record . p_cost_id : '||p_cost_id
364: );
365: END IF;