[Home] [Help]
1368: -- To find the repair batch task ID for a given instance
1369: CURSOR c_get_rprbatch_task (p_instance_id IN NUMBER,
1370: p_org_id IN NUMBER) IS
1371: SELECT visit_task_id FROM ahl_visit_tasks_b
1372: WHERE repair_batch_name = (AHL_CMP_UTIL_PKG.Get_Rpr_Batch_For_Inst(p_instance_id,
1373: p_org_id));
1374: CURSOR c_task_dtls (p_task_id IN NUMBER) IS
1375: SELECT task_type_code, cost_parent_id, instance_id FROM ahl_visit_tasks_b
1376: WHERE visit_task_id = p_task_id;
1422: 'Visit Id = ' || c_visit_rec.visit_id ||
1423: ', Status Code = ' || c_visit_rec.status_code);
1424: END IF;
1425: -- Kasridha: Changes for Component Maintenance Planning
1426: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit(l_task_rec.visit_id);
1427: -- SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: STARTS
1428: IF (l_task_rec.PAST_TASK_START_DATE IS NOT NULL
1429: AND l_task_rec.PAST_TASK_START_DATE <> Fnd_Api.G_MISS_DATE) THEN
1430: IF (l_task_rec.PAST_TASK_END_DATE IS NULL
6213: * change similar to the way Visit status changes as Repair Batches are like mini-visits.
6214: * So, if Repair Batch is in 'PARTIALLY RELEASED' status and after task deletion,
6215: * no other task is in Planning status, then change Repair Batch status to RELEASED.
6216: */
6217: IF (AHL_CMP_UTIL_PKG.Is_Comp_Visit (c_visit_rec.visit_id) = 'Y') THEN
6218:
6219: -- find which Repair Batch, the deleted task belongs to
6220: OPEN get_rpr_batch_for_task_csr (p_visit_task_id);
6221: FETCH get_rpr_batch_for_task_csr INTO l_repair_batch_name, l_rpr_batch_status_code;
7491: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011
7492: * There is no need to consider Stage materials for Component Visits
7493: * as there won't be any Stage associated with them.
7494: */
7495: IF (AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_visit_id) = 'N') THEN
7496:
7497: -- SKPATHAK :: 20-JUN-2011 :: VWPE: ER:12673125 :: START
7498: -- For every MR, dis-associate the materials based on the MR Profile to the stage tasks
7499: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7536: END IF;
7537: END IF;
7538: -- SKPATHAK :: 20-JUN-2011 :: VWPE: ER:12673125 :: END
7539:
7540: END IF; -- if AHL_CMP_UTIL_PKG.Is_Comp_Visit (l_visit_id) = 'N'
7541:
7542: IF l_origin_id is not null THEN
7543: IF (l_log_statement >= l_log_current_level)THEN
7544: fnd_log.string(l_log_statement,
8847: CURSOR c_get_target_qty (p_instance_id IN NUMBER, p_org_id IN NUMBER) IS
8848: SELECT target_qty
8849: FROM ahl_visit_tasks_b
8850: WHERE repair_batch_name =
8851: AHL_CMP_UTIL_PKG.Get_Rpr_Batch_For_Inst(p_instance_id,
8852: p_org_id);
8853: -- To find the repair batch task ID for a given instance
8854: CURSOR c_get_rprbatch_task (p_instance_id IN NUMBER, p_org_id NUMBER) IS
8855: SELECT visit_task_id FROM ahl_visit_tasks_b
8852: p_org_id);
8853: -- To find the repair batch task ID for a given instance
8854: CURSOR c_get_rprbatch_task (p_instance_id IN NUMBER, p_org_id NUMBER) IS
8855: SELECT visit_task_id FROM ahl_visit_tasks_b
8856: WHERE repair_batch_name = (AHL_CMP_UTIL_PKG.Get_Rpr_Batch_For_Inst(p_instance_id,
8857: p_org_id));
8858: CURSOR c_task_dtls (p_task_id IN NUMBER) IS
8859: SELECT task_type_code, cost_parent_id, instance_id, status_code FROM ahl_visit_tasks_b
8860: WHERE visit_task_id = p_task_id;
8928: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: Tasks cannot be created for locked visits
8929: -- Added for Component maintenance Planning project
8930: -- Flag to identify whether its a component visit
8931: -- Added for Bug #13737408
8932: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit (c_visit_rec.visit_id);
8933: IF l_is_comp_visit = 'N' AND c_visit_rec.locked_flag = 'Y' THEN
8934: Fnd_Message.SET_NAME('AHL','AHL_VWP_LOCKED_VISIT');
8935: Fnd_Msg_Pub.ADD;
8936: RAISE Fnd_Api.G_EXC_ERROR;