eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AHL_VWP_TASKS_PVT dependencies on AHL_VISIT_TASKS_B

Line 277: nvl(VST.INVENTORY_ITEM_ID, (select inventory_item_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),

273: WIP.SCHEDULED_COMPLETION_DATE SCHEDULED_END_DATE,
274: WO.ACTUAL_START_DATE ACTUAL_START_DATE,
275: WO.ACTUAL_END_DATE ACTUAL_END_DATE,
276: NVL2( WO.VISIT_TASK_ID,
277: nvl(VST.INVENTORY_ITEM_ID, (select inventory_item_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),
278: VST.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID,
279: NVL2( WO.VISIT_TASK_ID,
280: nvl (VST.ITEM_INSTANCE_ID, (select instance_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),
281: VST.ITEM_INSTANCE_ID) ITEM_INSTANCE_ID,

Line 280: nvl (VST.ITEM_INSTANCE_ID, (select instance_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),

276: NVL2( WO.VISIT_TASK_ID,
277: nvl(VST.INVENTORY_ITEM_ID, (select inventory_item_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),
278: VST.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID,
279: NVL2( WO.VISIT_TASK_ID,
280: nvl (VST.ITEM_INSTANCE_ID, (select instance_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),
281: VST.ITEM_INSTANCE_ID) ITEM_INSTANCE_ID,
282: WO.MASTER_WORKORDER_FLAG MASTER_WORKORDER_FLAG,
283: VST.PROJECT_ID PROJECT_ID,
284: NVL2( WO.VISIT_TASK_ID,VTS.PROJECT_TASK_ID,TO_NUMBER(NULL)) PROJECT_TASK_ID,

Line 288: AHL_VISIT_TASKS_B VTS,

284: NVL2( WO.VISIT_TASK_ID,VTS.PROJECT_TASK_ID,TO_NUMBER(NULL)) PROJECT_TASK_ID,
285: NVL2( WO.VISIT_TASK_ID,VTS.SERVICE_REQUEST_ID,TO_NUMBER(NULL)) INCIDENT_ID
286: FROM AHL_WORKORDERS WO,
287: AHL_VISITS_B VST,
288: AHL_VISIT_TASKS_B VTS,
289: WIP_DISCRETE_JOBS WIP
290: WHERE WIP.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
291: AND WO.VISIT_ID = VST.VISIT_ID
292: AND WO.VISIT_ID = VTS.VISIT_ID(+)

Line 493: FROM ahl_visit_tasks_b

489: */
490:
491: CURSOR c_task_type (x_T_id IN NUMBER) IS
492: SELECT TASK_TYPE_CODE,MR_ID
493: FROM ahl_visit_tasks_b
494: WHERE VISIT_TASK_ID = x_T_id;
495: c_task_type_rec c_task_type%ROWTYPE;
496:
497: -- PRAKKUM :: FP:PIE :: 13-OCT-2010

Line 573: AHL_VISIT_TASKS_B ATSK,

569: ATSK.Attribute14,
570: ATSK.Attribute15
571: --manisaga added all the attributes and ROUTE_ID as part of DFF Enablement 0n 18-Feb-2010--End
572: FROM AHL_VISITS_B AVTS,
573: AHL_VISIT_TASKS_B ATSK,
574: AHL_VISIT_TASKS_TL ATSKL,
575: AHL_VISIT_TASKS_VL ORIGTSK,
576: AHL_MR_ROUTES AMRR,
577: AHL_MR_HEADERS_VL AMRH,

Line 701: AHL_VISIT_TASKS_B ATSK,

697: ATSK.Attribute14,
698: ATSK.Attribute15
699: --manisaga added all the attributes and ROUTE_ID as part of DFF Enablement 0n 18-Feb-2010--End
700: FROM AHL_VISITS_B AVTS,
701: AHL_VISIT_TASKS_B ATSK,
702: AHL_VISIT_TASKS_TL ATSKL,
703: AHL_VISIT_TASKS_VL ORIGTSK,
704: AHL_MR_HEADERS_VL AMRH,
705: AHL_UNIT_EFFECTIVITIES_B AUEF,

Line 919: SELECT Visit_Task_Number FROM Ahl_Visit_Tasks_B

915: c_unitofmeasure_rec c_unitofmeasure%ROWTYPE;
916:
917: -- To find task number for cost_parent_id and originating task id
918: CURSOR c_number(x_id IN NUMBER) IS
919: SELECT Visit_Task_Number FROM Ahl_Visit_Tasks_B
920: WHERE Visit_Task_Id = x_id;
921:
922: -- To find project task nubmer for project's task
923: CURSOR c_proj_task (x_id IN NUMBER) IS

Line 1371: SELECT visit_task_id FROM ahl_visit_tasks_b

1367:
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

Line 1375: SELECT task_type_code, cost_parent_id, instance_id FROM ahl_visit_tasks_b

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;
1377:
1378: --Cursor to get the repair batch name for a given task
1379: CURSOR c_get_repair_batch_name(p_task_id IN NUMBER) IS

Line 1380: SELECT repair_batch_name FROM ahl_visit_tasks_b WHERE

1376: WHERE visit_task_id = p_task_id;
1377:
1378: --Cursor to get the repair batch name for a given task
1379: CURSOR c_get_repair_batch_name(p_task_id IN NUMBER) IS
1380: SELECT repair_batch_name FROM ahl_visit_tasks_b WHERE
1381: visit_task_id = p_task_id
1382: AND repair_batch_name IS NOT NULL;
1383:
1384: --Kasridha:Changes for Component Maintenance Planning Ends

Line 1740: UPDATE AHL_VISIT_TASKS_B

1736: END IF;
1737:
1738: IF( l_summary_task_id IS NOT NULL AND l_rpr_batch_task_id IS NOT NULL
1739: AND l_rpr_batch_task_id <> l_task_rec.VISIT_TASK_ID) THEN
1740: UPDATE AHL_VISIT_TASKS_B
1741: SET cost_parent_id = l_rpr_batch_task_id
1742: WHERE visit_task_id = l_summary_task_id;
1743:
1744: IF (l_log_statement >= l_log_current_level) THEN

Line 2508: select VISIT_TASK_NUMBER INTO p_x_task_rec.Visit_Task_Number from AHL_VISIT_TASKS_B where VISIT_TASK_ID = p_x_task_rec.Visit_Task_ID;

2504: -- set OUT value
2505: p_x_task_rec.Visit_Task_ID := l_task_rec.Visit_Task_ID;
2506: --TCHIMIRA::BUG 9303368 :: 02-02-2010::Fetch the regenerated visit task number from DB using visit task ID
2507: --p_x_task_rec.Visit_Task_Number := l_task_rec.Visit_Task_Number;
2508: select VISIT_TASK_NUMBER INTO p_x_task_rec.Visit_Task_Number from AHL_VISIT_TASKS_B where VISIT_TASK_ID = p_x_task_rec.Visit_Task_ID;
2509:
2510: IF (c_visit_rec.Any_Task_Chg_Flag = 'N') THEN
2511:
2512: AHL_VWP_RULES_PVT.update_visit_task_flag(

Line 2665: FROM ahl_visit_tasks_b

2661: -- bug fix #4181411
2662: -- yazhou 17-Feb-2005
2663: CURSOR get_task_inst_dtls(c_visit_id IN NUMBER) IS
2664: SELECT inventory_item_id,item_organization_id
2665: FROM ahl_visit_tasks_b
2666: WHERE visit_id = c_visit_id
2667: AND nvl(status_code,'x') <> 'DELETED'
2668: AND ROWNUM = 1;
2669:

Line 3227: select VISIT_TASK_NUMBER INTO p_x_task_rec.Visit_Task_Number from AHL_VISIT_TASKS_B where VISIT_TASK_ID = p_x_task_rec.Visit_Task_ID;

3223: -- set OUT value
3224: p_x_task_rec.Visit_Task_ID := l_task_rec.Visit_Task_ID;
3225: --TCHIMIRA::BUG 9246386 :: 02-02-2010::Fetch the regenerated visit task number from DB using visit task ID
3226: --p_x_task_rec.Visit_Task_Number := l_task_rec.Visit_Task_Number;
3227: select VISIT_TASK_NUMBER INTO p_x_task_rec.Visit_Task_Number from AHL_VISIT_TASKS_B where VISIT_TASK_ID = p_x_task_rec.Visit_Task_ID;
3228:
3229: IF c_visit_rec.Any_Task_Chg_Flag='N' THEN
3230: AHL_VWP_RULES_PVT.update_visit_task_flag(
3231: p_visit_id =>c_visit_rec.visit_id,

Line 3942: UPDATE AHL_VISIT_TASKS_B

3938: FETCH c_all_task INTO l_all_task_rec;
3939: EXIT WHEN c_all_task%NOTFOUND;
3940: -- Tasks found for visit
3941: -- To set prices to NULL in case if the visit's department is changed
3942: UPDATE AHL_VISIT_TASKS_B
3943: SET ACTUAL_PRICE = NULL, ESTIMATED_PRICE = NULL,
3944: OBJECT_VERSION_NUMBER = l_all_task_rec.object_version_number + 1
3945: WHERE VISIT_TASK_ID = l_all_task_rec.visit_task_id;
3946: END LOOP;

Line 5884: FROM ahl_visit_tasks_b

5880:
5881: CURSOR c_visit_task_exists(p_visit_id IN NUMBER)
5882: IS
5883: SELECT 'x'
5884: FROM ahl_visit_tasks_b
5885: WHERE visit_id = p_visit_id
5886: AND STATUS_CODE = 'PLANNING';
5887:
5888: -- yazhou end

Line 5913: FROM AHL_VISIT_TASKS_B

5909: -- MANESING::Bug 13713141, 16-Apr-2012, added following cursors
5910: -- Cursor to find out the Repair Batch for the given task
5911: CURSOR get_rpr_batch_for_task_csr (c_visit_task_id NUMBER) IS
5912: SELECT repair_batch_name, status_code
5913: FROM AHL_VISIT_TASKS_B
5914: WHERE cost_parent_id IS NULL
5915: START WITH visit_task_id = c_visit_task_id
5916: CONNECT BY visit_task_id = Prior cost_parent_id;
5917:

Line 5921: FROM AHL_VISIT_TASKS_B

5917:
5918: -- Cursor to check if Repair Batch has planned tasks
5919: CURSOR chk_rpr_batch_has_planed_tasks (c_repair_batch_name VARCHAR2) IS
5920: SELECT 'X'
5921: FROM AHL_VISIT_TASKS_B
5922: WHERE cost_parent_id IS NOT NULL -- to filter repair batch task
5923: AND status_code = 'PLANNING'
5924: START WITH repair_batch_name = c_repair_batch_name
5925: CONNECT BY cost_parent_id = Prior visit_task_id;

Line 6235: UPDATE AHL_VISIT_TASKS_B

6231: IF (l_log_statement >= l_log_current_level) THEN
6232: FND_LOG.string(l_log_statement, l_debug_key, 'Repair Batch ' || l_repair_batch_name || ' has no planned tasks.');
6233: END IF;
6234:
6235: UPDATE AHL_VISIT_TASKS_B
6236: SET status_code = 'RELEASED',
6237: object_version_number = object_version_number + 1,
6238: last_update_date = SYSDATE,
6239: last_updated_by = Fnd_Global.USER_ID,

Line 6441: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

6437: c_primary_rec c_primary%ROWTYPE;
6438:
6439: -- To find any task links for a deleted task
6440: CURSOR c_links (x_id IN NUMBER) IS
6441: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
6442: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
6443: AND T.VISIT_TASK_ID = x_id;
6444:
6445: -- To find if WIP job is created for the Visit

Line 6623: UPDATE AHL_VISIT_TASKS_B SET PRIMARY_VISIT_TASK_ID = NULL,

6619: LOOP
6620: FETCH c_primary INTO c_primary_rec;
6621: EXIT WHEN c_primary%NOTFOUND;
6622: IF c_primary_rec.visit_task_id IS NOT NULL THEN
6623: UPDATE AHL_VISIT_TASKS_B SET PRIMARY_VISIT_TASK_ID = NULL,
6624: OBJECT_VERSION_NUMBER = c_primary_rec.object_version_number + 1
6625: WHERE --VISIT_ID = l_visit_id AND
6626: VISIT_TASK_ID = c_primary_rec.visit_task_id;
6627: IF (l_log_statement >= l_log_current_level) THEN

Line 6630: 'Updated AHL_VISIT_TASKS_B for Visit Task Id = ' || c_primary_rec.visit_task_id);

6626: VISIT_TASK_ID = c_primary_rec.visit_task_id;
6627: IF (l_log_statement >= l_log_current_level) THEN
6628: fnd_log.string(l_log_statement,
6629: L_DEBUG_KEY,
6630: 'Updated AHL_VISIT_TASKS_B for Visit Task Id = ' || c_primary_rec.visit_task_id);
6631: END IF;
6632: END IF;
6633: END LOOP;
6634: CLOSE c_primary;

Line 6701: -- Delete task base (AHL_VISIT_TASKS_B) table data

6697: END IF;
6698: RAISE Fnd_Api.g_exc_error;
6699: END IF;
6700:
6701: -- Delete task base (AHL_VISIT_TASKS_B) table data
6702: DELETE FROM Ahl_Visit_Tasks_B
6703: WHERE Visit_Task_ID = l_task_id;
6704:
6705: IF (SQL%NOTFOUND) THEN

Line 6702: DELETE FROM Ahl_Visit_Tasks_B

6698: RAISE Fnd_Api.g_exc_error;
6699: END IF;
6700:
6701: -- Delete task base (AHL_VISIT_TASKS_B) table data
6702: DELETE FROM Ahl_Visit_Tasks_B
6703: WHERE Visit_Task_ID = l_task_id;
6704:
6705: IF (SQL%NOTFOUND) THEN
6706: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');

Line 6712: UPDATE AHL_VISIT_TASKS_B

6708: RAISE Fnd_Api.g_exc_error;
6709: END IF;
6710:
6711: ELSE
6712: UPDATE AHL_VISIT_TASKS_B
6713: SET STATUS_CODE='DELETED',UNIT_EFFECTIVITY_ID=NULL,
6714: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
6715: WHERE VISIT_TASK_ID=l_task_id;
6716:

Line 6879: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

6875: c_primary_rec c_primary%ROWTYPE;
6876:
6877: -- To find any task links for a deleted task
6878: CURSOR c_links (x_id IN NUMBER) IS
6879: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
6880: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID
6881: OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
6882: AND T.VISIT_TASK_ID = x_id;
6883:

Line 6894: FROM ahl_visit_tasks_b

6890:
6891: CURSOR c_SR_tasks(c_visit_id NUMBER, c_sr_id NUMBER)
6892: IS
6893: SELECT visit_task_id
6894: FROM ahl_visit_tasks_b
6895: WHERE visit_id = c_visit_id
6896: -- SKPATHAK :: Bug 9745921 :: 31-MAY-2010
6897: -- Added the below condition as the tasks fetched should not be in deleted status
6898: AND status_code <> 'DELETED'

Line 7113: UPDATE AHL_VISIT_TASKS_B

7109: FETCH c_primary INTO c_primary_rec;
7110: EXIT WHEN c_primary%NOTFOUND;
7111: IF c_primary_rec.visit_task_id IS NOT NULL
7112: THEN
7113: UPDATE AHL_VISIT_TASKS_B
7114: SET PRIMARY_VISIT_TASK_ID = NULL,
7115: OBJECT_VERSION_NUMBER = c_primary_rec.object_version_number + 1
7116: WHERE --VISIT_ID = l_visit_id AND
7117: VISIT_TASK_ID = c_primary_rec.visit_task_id;

Line 7178: UPDATE AHL_VISIT_TASKS_B

7174: END IF;
7175:
7176: --IF NVL(l_workorder_present,'X') ='Y' THEN
7177: IF c_task_rec.service_request_id IS NOT NULL THEN
7178: UPDATE AHL_VISIT_TASKS_B
7179: SET STATUS_CODE='DELETED',UNIT_EFFECTIVITY_ID=NULL,
7180: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
7181: WHERE VISIT_TASK_ID=l_task_id;
7182:

Line 7233: -- Delete task base (AHL_VISIT_TASKS_B) table data

7229: CLOSE c_SR_tasks;
7230: RAISE Fnd_Api.g_exc_error;
7231: END IF;
7232:
7233: -- Delete task base (AHL_VISIT_TASKS_B) table data
7234:
7235: IF (l_log_statement >= l_log_current_level) THEN
7236: fnd_log.string(l_log_statement,
7237: L_DEBUG_KEY,

Line 7241: DELETE FROM Ahl_Visit_Tasks_B

7237: L_DEBUG_KEY,
7238: ':Delete from base task table');
7239: END IF;
7240:
7241: DELETE FROM Ahl_Visit_Tasks_B
7242: WHERE Visit_Task_ID = l_task_id;
7243:
7244: IF (SQL%NOTFOUND) THEN
7245: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)

Line 7384: NVL((SELECT distinct 'Y' FROM ahl_visit_tasks_b avt

7380: -- SKPATHAK :: Bug 10414592 :: 21-DEC-2010
7381: -- Added Planned_Flag to this cursor to denote if the simulated visit's task belongs to a planned MR or not
7382: CURSOR c_primary (x_task_id IN NUMBER) IS
7383: SELECT task.Visit_Task_Id, task.object_version_number, task.unit_effectivity_id,
7384: NVL((SELECT distinct 'Y' FROM ahl_visit_tasks_b avt
7385: WHERE avt.unit_effectivity_id = task.unit_effectivity_id
7386: AND avt.task_type_code = 'PLANNED'), 'N') Planned_Flag
7387: FROM Ahl_Visit_Tasks_B task
7388: WHERE task.PRIMARY_VISIT_TASK_ID = x_task_id

Line 7387: FROM Ahl_Visit_Tasks_B task

7383: SELECT task.Visit_Task_Id, task.object_version_number, task.unit_effectivity_id,
7384: NVL((SELECT distinct 'Y' FROM ahl_visit_tasks_b avt
7385: WHERE avt.unit_effectivity_id = task.unit_effectivity_id
7386: AND avt.task_type_code = 'PLANNED'), 'N') Planned_Flag
7387: FROM Ahl_Visit_Tasks_B task
7388: WHERE task.PRIMARY_VISIT_TASK_ID = x_task_id
7389: AND task.STATUS_CODE <> 'DELETED';
7390: c_primary_rec c_primary%ROWTYPE;
7391:

Line 7394: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

7390: c_primary_rec c_primary%ROWTYPE;
7391:
7392: -- To find any task links for a deleted task
7393: CURSOR c_links (x_id IN NUMBER) IS
7394: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
7395: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID
7396: OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
7397: AND T.VISIT_TASK_ID = x_id;
7398:

Line 7412: FROM ahl_visit_tasks_b

7408:
7409: --Dup-MR ER#6338208 - sowsubra
7410: CURSOR c_all_tasks(c_visit_id NUMBER, c_task_id NUMBER) IS
7411: SELECT visit_task_id
7412: FROM ahl_visit_tasks_b
7413: WHERE visit_id = c_visit_id
7414: AND STATUS_CODE <> 'DELETED'
7415: START WITH visit_task_id = c_task_id
7416: CONNECT BY PRIOR visit_task_id = originating_task_id

Line 7424: SELECT 'X' from ahl_visit_tasks_b where unit_effectivity_id = c_ue_id and

7420:
7421: --Added by mpothuku on 02/03/05
7422: --To check if the unplanned tasks UE is associated with any other visits other than itself before its deletion.
7423: CURSOR check_unplanned_ue_assoc(c_ue_id IN NUMBER) IS
7424: SELECT 'X' from ahl_visit_tasks_b where unit_effectivity_id = c_ue_id and
7425: status_code <> 'DELETED';
7426: BEGIN
7427: IF (l_log_procedure >= l_log_current_level) THEN
7428: fnd_log.string(l_log_procedure,

Line 7742: UPDATE AHL_VISIT_TASKS_B

7738: THEN
7739: -- SKPATHAK :: Bug 10414592 :: 21-DEC-2010
7740: -- If the simulated visit's task belongs to a planned requirement, dis-associate all such tasks' UE and set the status as 'DELETED'
7741: IF (c_primary_rec.Planned_Flag = 'Y') THEN
7742: UPDATE AHL_VISIT_TASKS_B
7743: SET PRIMARY_VISIT_TASK_ID = NULL,
7744: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7745: UNIT_EFFECTIVITY_ID = NULL,
7746: STATUS_CODE = 'DELETED'

Line 7750: UPDATE AHL_VISIT_TASKS_B

7746: STATUS_CODE = 'DELETED'
7747: WHERE UNIT_EFFECTIVITY_ID = c_primary_rec.UNIT_EFFECTIVITY_ID
7748: AND PRIMARY_VISIT_TASK_ID IS NOT NULL;
7749: ELSE
7750: UPDATE AHL_VISIT_TASKS_B
7751: SET PRIMARY_VISIT_TASK_ID = NULL,
7752: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
7753: WHERE VISIT_TASK_ID = c_primary_rec.visit_task_id
7754: AND PRIMARY_VISIT_TASK_ID IS NOT NULL;

Line 7823: UPDATE AHL_VISIT_TASKS_B

7819: l_task_type := l_task_rec.TASK_TYPE_CODE;
7820: l_unit_effectivity_id := l_task_rec.UNIT_EFFECTIVITY_ID;
7821: END IF;
7822: END IF;
7823: UPDATE AHL_VISIT_TASKS_B
7824: SET STATUS_CODE='DELETED',UNIT_EFFECTIVITY_ID=NULL,
7825: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
7826: WHERE VISIT_TASK_ID=l_task_id;
7827:

Line 7882: -- Delete task base (AHL_VISIT_TASKS_B) table data

7878: CLOSE c_all_tasks;
7879: RAISE Fnd_Api.g_exc_error;
7880: END IF;
7881:
7882: -- Delete task base (AHL_VISIT_TASKS_B) table data
7883: IF (l_log_statement >= l_log_current_level)THEN
7884: fnd_log.string(l_log_statement,
7885: L_DEBUG_KEY,
7886: ':Delete from base task table');

Line 7889: DELETE FROM Ahl_Visit_Tasks_B

7885: L_DEBUG_KEY,
7886: ':Delete from base task table');
7887: END IF;
7888:
7889: DELETE FROM Ahl_Visit_Tasks_B
7890: WHERE Visit_Task_ID = l_task_id;
7891:
7892: IF (SQL%NOTFOUND) THEN
7893: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)

Line 8030: UPDATE AHL_VISIT_TASKS_B

8026: LOOP
8027: FETCH c_primary INTO c_primary_rec;
8028: EXIT WHEN c_primary%NOTFOUND;
8029: IF c_primary_rec.visit_task_id IS NOT NULL THEN
8030: UPDATE AHL_VISIT_TASKS_B
8031: SET PRIMARY_VISIT_TASK_ID = NULL,
8032: OBJECT_VERSION_NUMBER = c_primary_rec.object_version_number + 1
8033: WHERE --VISIT_ID = l_visit_id AND
8034: VISIT_TASK_ID = c_primary_rec.visit_task_id;

Line 8078: UPDATE AHL_VISIT_TASKS_B

8074: RAISE Fnd_Api.G_EXC_ERROR;
8075: END IF;
8076:
8077: -- Update Task status to 'DELETED'
8078: UPDATE AHL_VISIT_TASKS_B
8079: SET STATUS_CODE='DELETED',UNIT_EFFECTIVITY_ID=NULL,
8080: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
8081: WHERE VISIT_TASK_ID=l_task_id;
8082:

Line 8130: -- Delete task base (AHL_VISIT_TASKS_B) table data

8126: Fnd_Msg_Pub.ADD;
8127: RAISE Fnd_Api.g_exc_error;
8128: END IF;
8129:
8130: -- Delete task base (AHL_VISIT_TASKS_B) table data
8131: IF (l_log_statement >= l_log_current_level) THEN
8132: fnd_log.string(l_log_statement,
8133: L_DEBUG_KEY,
8134: ':Delete from base task table');

Line 8137: DELETE FROM Ahl_Visit_Tasks_B

8133: L_DEBUG_KEY,
8134: ':Delete from base task table');
8135: END IF;
8136:
8137: DELETE FROM Ahl_Visit_Tasks_B
8138: WHERE Visit_Task_ID = l_task_id;
8139:
8140: IF (SQL%NOTFOUND) THEN
8141: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');

Line 8244: FROM AHL_VISIT_TASKS_B

8240: -- To find task type code, start, end time of a task
8241: --POST 11.5.10 cxcheng change --------------
8242: CURSOR get_task_times_csr (p_task_id IN NUMBER) IS
8243: SELECT task_type_code, start_date_time, end_date_time
8244: FROM AHL_VISIT_TASKS_B
8245: WHERE VISIT_TASK_ID = p_task_id;
8246:
8247: BEGIN
8248: --------------------- initialize -----------------------

Line 8849: FROM ahl_visit_tasks_b

8845:
8846: --To fetch the repair batch quantity for a given instance
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

Line 8855: SELECT visit_task_id FROM ahl_visit_tasks_b

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
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

Line 8859: SELECT task_type_code, cost_parent_id, instance_id, status_code FROM ahl_visit_tasks_b

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;
8861:
8862: -- Cursor to get the RTS workorder for a repair batch
8863: CURSOR c_get_rts_wo_id(p_rpr_batch_task_id NUMBER, p_instance_id NUMBER) IS

Line 8868: (SELECT vt.visit_task_id FROM AHL_VISIT_TASKS_B vt

8864: SELECT wip_entity_id FROM ahl_workorders
8865: WHERE status_code IN ('1', '3', '6', '19', '20', '17')
8866: --unreleased, released, on-hold, parts hold and pending QA approval(open workorders)
8867: AND visit_task_id IN
8868: (SELECT vt.visit_task_id FROM AHL_VISIT_TASKS_B vt
8869: WHERE vt.cost_parent_id IS NOT NULL
8870: AND NVL(vt.return_to_supply_flag,'N') = 'Y'
8871: AND vt.instance_id = p_instance_id
8872: START WITH vt.visit_task_id = p_rpr_batch_task_id

Line 8877: SELECT repair_batch_name FROM ahl_visit_tasks_b WHERE

8873: CONNECT BY PRIOR vt.visit_task_id = vt.cost_parent_id
8874: );
8875: --Cursor to get the repair batch name for a given task
8876: CURSOR c_get_repair_batch_name(p_task_id IN NUMBER) IS
8877: SELECT repair_batch_name FROM ahl_visit_tasks_b WHERE
8878: visit_task_id = p_task_id
8879: AND repair_batch_name IS NOT NULL;
8880: --Kasridha:Changes for Component Maintenance Planning Ends
8881:

Line 9345: UPDATE AHL_VISIT_TASKS_B SET cost_parent_id = l_rpr_batch_task_id

9341: IF( l_summary_task_id IS NOT NULL AND
9342: l_rpr_batch_task_id IS NOT NULL AND
9343: l_rpr_batch_task_id <> l_task_tbl(i).VISIT_TASK_ID) THEN
9344:
9345: UPDATE AHL_VISIT_TASKS_B SET cost_parent_id = l_rpr_batch_task_id
9346: WHERE visit_task_id = l_summary_task_id;
9347:
9348: l_is_cost_parent_setting_done := TRUE;
9349: l_repair_batch_task_id := l_rpr_batch_task_id;

Line 9388: UPDATE AHL_VISIT_TASKS_B

9384: IF (l_log_statement >= l_log_current_level) THEN
9385: FND_LOG.string(l_log_statement, l_debug_key, 'Changing Repair Batch ' || l_repair_batch_task_id || ' status to Partially Implemented.');
9386: END IF;
9387:
9388: UPDATE AHL_VISIT_TASKS_B
9389: SET status_code = 'PARTIALLY RELEASED',
9390: object_version_number = object_version_number + 1,
9391: last_update_date = SYSDATE,
9392: last_updated_by = Fnd_Global.USER_ID,

Line 10322: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

10318: c_primary_rec c_primary%ROWTYPE;
10319:
10320: -- To find any task links for a deleted task
10321: CURSOR c_links (x_id IN NUMBER) IS
10322: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
10323: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
10324: AND T.VISIT_TASK_ID = x_id;
10325:
10326: -- To find if WIP job is created for the Visit

Line 10514: UPDATE AHL_VISIT_TASKS_B

10510: L_DEBUG_KEY,
10511: 'Value of l_workorder_present = ' || l_workorder_present);
10512: END IF;
10513:
10514: UPDATE AHL_VISIT_TASKS_B
10515: SET STATUS_CODE='DELETED',UNIT_EFFECTIVITY_ID=NULL,
10516: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
10517: WHERE VISIT_TASK_ID=l_task_id;
10518: