APPS.AHL_VWP_MR_CST_PR_PVT dependencies on AHL_VISIT_TASKS_B

Line 69: l_visit_task_id AHL_VISIT_TASKS_B.visit_task_id%TYPE;

65: where visit_task_id=c_visit_task_id;
66:
67: l_task_rec c_task_csr%rowtype;
68:
69: l_visit_task_id AHL_VISIT_TASKS_B.visit_task_id%TYPE;
70:
71: Cursor c_customer (c_incident_id in number)
72: Is
73: select customer_id

Line 222: From ahl_visits_b V, ahl_visit_tasks_b T

218: -- Cursor to retrieve visit info
219: Cursor c_visit_csr(c_visit_task_id in number)
220: Is
221: Select v.visit_id, v.any_task_chg_flag
222: From ahl_visits_b V, ahl_visit_tasks_b T
223: where T.visit_task_id=c_visit_task_id
224: AND V.visit_id = T.visit_id;
225:
226: l_visit_rec c_visit_csr%rowtype;

Line 490: From ahl_visit_tasks_b

486: estimated_price,
487: mr_id,
488: start_date_time,
489: end_date_time
490: From ahl_visit_tasks_b
491: where visit_task_id=c_visit_task_id;
492:
493: l_task_rec c_task_csr%rowtype;
494:

Line 520: from ahl_visit_tasks_b

516: task_type_code,
517: mr_id,
518: start_date_time,
519: end_date_time
520: from ahl_visit_tasks_b
521: where visit_id = c_visit_id
522: AND NVL(status_code, 'Y') <> NVL ('DELETED', 'X')
523: and originating_task_id = c_visit_task_id
524: and mr_id is not null;

Line 653: ' Visit Task not found in ahl_visit_tasks_b table ');

649:
650: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
652: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
653: ' Visit Task not found in ahl_visit_tasks_b table ');
654: END IF;
655:
656: CLOSE c_task_csr;
657: RAISE FND_API.G_EXC_ERROR;

Line 1126: Update AHL_VISIT_TASKS_B

1122: estimated_price=l_visit_rec.estimated_price
1123: where visit_id=l_visit_rec.visit_id;
1124:
1125:
1126: Update AHL_VISIT_TASKS_B
1127: set actual_price=l_actual_price,
1128: estimated_price=l_estimate_price
1129: where visit_task_id=l_task_rec.visit_task_id;
1130:

Line 1135: Update AHL_VISIT_TASKS_B

1131:
1132: Else -- called from Visit
1133:
1134:
1135: Update AHL_VISIT_TASKS_B
1136: set actual_price=l_actual_price,
1137: estimated_price=l_estimate_price
1138: where visit_task_id=l_task_rec.visit_task_id;
1139: End if;

Line 1277: from ahl_visit_tasks_b

1273: Cursor c_all_task_csr(c_visit_task_id in number,c_visit_id in number)
1274: Is
1275: Select visit_task_id,task_type_code,
1276: mr_id, start_date_time
1277: from ahl_visit_tasks_b
1278: where visit_id = c_visit_id
1279: AND NVL(status_code, 'Y') <> NVL ('DELETED', 'X')
1280: and originating_task_id = c_visit_task_id
1281: and mr_id is not null;

Line 1472: 'Visit Task not found in ahl_visit_tasks_b table'

1468: fnd_log.string
1469: (
1470: fnd_log.level_error,
1471: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1472: 'Visit Task not found in ahl_visit_tasks_b table'
1473: );
1474: END IF;
1475: CLOSE c_task_csr;
1476: RAISE FND_API.G_EXC_ERROR;