[Home] [Help]
124: vs.start_date_time,
125: vs.close_date_time,
126: ci.customer_id
127:
128: FROM ahl_visit_tasks_b vt,
129: ahl_visits_b vs,
130: cs_incidents_all_b ci
131:
132: WHERE vt.visit_task_id = C_VISIT_TASK_ID
161: --Added by amagrawa to retrieve task number from Task ID
162: CURSOR c_task_number (p_task_id IN NUMBER)
163: IS
164: SELECT VISIT_TASK_NUMBER
165: FROM ahl_visit_tasks_b
166: where visit_task_id = p_task_id;
167:
168: --Standard local variables
169: l_task_number number;
265: fnd_log.string
266: (
267: fnd_log.level_error,
268: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
269: 'Visit Task not found in ahl_visit_tasks_b table'
270: );
271: END IF;
272: CLOSE Get_task_cost_price_cur;
273: RAISE FND_API.G_EXC_ERROR;
976: fnd_log.string
977: (
978: fnd_log.level_error,
979: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
980: 'Task id not found in ahl_visit_tasks_b table'
981: );
982: END IF;
983: CLOSE Get_visit_task_dtls_cur;
984: RAISE FND_API.G_EXC_ERROR;
1183: fnd_log.string
1184: (
1185: fnd_log.level_statement,
1186: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1187: ' Before Update Ahl Visit Tasks B Table, Price List Id: ' || l_cost_price_rec.price_list_id
1188: );
1189: fnd_log.string
1190: (
1191: fnd_log.level_statement,
1189: fnd_log.string
1190: (
1191: fnd_log.level_statement,
1192: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1193: ' Before Update Ahl Visit Tasks B Table, Estimated Price: ' || l_cost_price_rec.estimated_price
1194: );
1195: fnd_log.string
1196: (
1197: fnd_log.level_statement,
1195: fnd_log.string
1196: (
1197: fnd_log.level_statement,
1198: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1199: ' Before Update Ahl Visit Tasks B Table, Actual Price: ' || l_cost_price_rec.actual_price
1200: );
1201: fnd_log.string
1202: (
1203: fnd_log.level_statement,
1201: fnd_log.string
1202: (
1203: fnd_log.level_statement,
1204: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1205: ' Before Update Ahl Visit Tasks B Table, Actual Cost: ' || l_cost_price_rec.actual_cost
1206: );
1207: END IF;
1208:
1209: -- Update the task record with cost details
1206: );
1207: END IF;
1208:
1209: -- Update the task record with cost details
1210: UPDATE AHL_VISIT_TASKS_B SET
1211: PRICE_LIST_ID = l_cost_price_rec.price_list_id,
1212: ESTIMATED_PRICE = l_cost_price_rec.estimated_price,
1213: ACTUAL_PRICE = l_cost_price_rec.actual_price,
1214: ACTUAL_COST = l_cost_price_rec.actual_cost,
1316: IS
1317: SELECT vt.visit_id,
1318: vt.visit_task_id,
1319: vs.any_task_chg_flag
1320: FROM ahl_visit_tasks_b vt,
1321: ahl_visits_b vs
1322: WHERE vt.visit_task_id = C_VISIT_TASK_ID
1323: AND vt.visit_id = vs.visit_id
1324: AND NVL(vt.status_code, 'Y') <> NVL ('DELETED', 'X');
1650: vt.mr_id,
1651: vt.mr_route_id,
1652: vt.actual_price,
1653: vt.estimated_price
1654: FROM ahl_visit_tasks_b vt
1655: WHERE visit_id = C_VISIT_ID
1656: AND NVL(vt.status_code, 'Y') <> NVL ('DELETED', 'X')
1657: START WITH visit_task_id = C_ORIG_TASK_ID
1658: CONNECT BY PRIOR originating_task_id = visit_task_id;
1753: fnd_log.string
1754: (
1755: fnd_log.level_error,
1756: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1757: 'Visit Task not found in ahl_visit_tasks_b table'
1758: );
1759: END IF;
1760: CLOSE Get_visit_task_dtls_cur;
1761: RAISE FND_API.G_EXC_ERROR;
2424: fnd_log.string
2425: (
2426: fnd_log.level_statement,
2427: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2428: ' Before updating parent task ahl_visit_tasks_b, Actual Price: ' || l_parent_task_rec.actual_price
2429: );
2430: fnd_log.string
2431: (
2432: fnd_log.level_statement,
2430: fnd_log.string
2431: (
2432: fnd_log.level_statement,
2433: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2434: ' Before updating parent task ahl_visit_tasks_b, Estimated Price: ' || l_parent_task_rec.estimated_price
2435: );
2436:
2437: END IF;
2438:
2436:
2437: END IF;
2438:
2439: -- Update visit tasks table with new actual and estimate prices
2440: UPDATE ahl_visit_tasks_b
2441: SET actual_price = l_parent_task_rec.actual_price,
2442: estimated_price = l_parent_task_rec.estimated_price,
2443: object_version_number = l_parent_task_rec.object_version_number + 1
2444: WHERE visit_task_id = l_parent_task_rec.visit_task_id;
2443: object_version_number = l_parent_task_rec.object_version_number + 1
2444: WHERE visit_task_id = l_parent_task_rec.visit_task_id;
2445: ELSE
2446: -- If null adjust with derived values
2447: UPDATE ahl_visit_tasks_b
2448: SET actual_price = l_cost_price_rec.actual_price,
2449: estimated_price = l_cost_price_rec.estimated_price,
2450: object_version_number = l_parent_task_rec.object_version_number + 1
2451: WHERE visit_task_id = l_parent_task_rec.visit_task_id;
2501: fnd_log.string
2502: (
2503: fnd_log.level_statement,
2504: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2505: ' Before updating task ahl_visit_tasks_b, Actual Price: ' || l_actual_price
2506: );
2507: fnd_log.string
2508: (
2509: fnd_log.level_statement,
2507: fnd_log.string
2508: (
2509: fnd_log.level_statement,
2510: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2511: ' Before updating task ahl_visit_tasks_b, Estimated Price: ' || l_estimated_price
2512: );
2513:
2514: END IF;
2515:
2517:
2518: END IF; -- Module type is JSP
2519:
2520: -- Update task cost details with new values
2521: UPDATE AHL_VISIT_TASKS_B
2522: SET actual_price = l_cost_price_rec.actual_price,
2523: estimated_price = l_cost_price_rec.estimated_price,
2524: object_version_number = l_visit_task_dtls_rec.task_object_version_number + 1
2525: WHERE visit_task_id = l_visit_task_dtls_rec.visit_task_id;
3076: fnd_log.string
3077: (
3078: fnd_log.level_error,
3079: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3080: 'Visit Task not found in ahl_visit_tasks_b table'
3081: );
3082: END IF;
3083: CLOSE c_task_csr;
3084: RAISE FND_API.G_EXC_ERROR;
3671:
3672: Cursor c_task_csr (c_visit_task_id in number)
3673: Is
3674: Select a.mr_route_id,a.mr_id,b.organization_id
3675: From AHL_VISIT_TASKS_B a,ahl_visits_b b
3676: Where a.visit_task_id=c_visit_task_id
3677: and a.visit_id=b.visit_id;
3678:
3679: l_task_rec c_task_csr%rowtype;