[Home] [Help]
475:
476: -- Define local cursors
477: -- To find visit related information
478: CURSOR c_visit (x_id IN NUMBER) IS
479: SELECT * FROM AHL_VISITS_VL
480: WHERE VISIT_ID = x_id;
481: c_visit_rec c_visit%ROWTYPE;
482:
483: -- To find task related information when its for a visit
815: ATSK.Attribute13,
816: ATSK.Attribute14,
817: ATSK.Attribute15
818: --manisaga added all the attributes and ROUTE_ID as part of DFF Enablement 0n 18-Feb-2010--End
819: FROM AHL_VISITS_VL AVTS,
820: AHL_VISIT_TASKS_VL ATSK,
821: AHL_VISIT_TASKS_VL ORIGTSK,
822: CSI_ITEM_INSTANCES CSIS,
823: CS_INCIDENTS_ALL_B SR,
854:
855: -- To find all task related information which is not in visit/template search views
856: CURSOR c_task_data(p_task_id IN NUMBER) IS
857: SELECT T1.*, T2.TEMPLATE_FLAG, T2.ORGANIZATION_ID
858: FROM AHL_VISIT_TASKS_VL T1, AHL_VISITS_VL T2
859: WHERE T1.visit_task_id = p_task_id
860: AND T1.VISIT_ID = T2.VISIT_ID;
861: c_task_data_rec c_task_data%ROWTYPE;
862:
1351: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
1352:
1353: -- To find visit related information
1354: CURSOR c_visit(x_id IN NUMBER) IS
1355: SELECT * FROM AHL_VISITS_VL
1356: WHERE VISIT_ID = x_id;
1357: c_visit_rec c_visit%ROWTYPE;
1358:
1359: --Kasridha:Changes for Component Maintenance Planning Begins
1862: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type; --salogan added for supplier warranty
1863:
1864: -- To find visit related information
1865: CURSOR c_visit(x_id IN NUMBER) IS
1866: SELECT * FROM AHL_VISITS_VL
1867: WHERE VISIT_ID = x_id;
1868: c_visit_rec c_visit%ROWTYPE;
1869:
1870: -- To find Item ID and Item OrgID for Instance Id
2653: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type;
2654:
2655: -- To find visit related information
2656: CURSOR c_visit(x_id IN NUMBER) IS
2657: SELECT * FROM AHL_VISITS_VL
2658: WHERE VISIT_ID = x_id;
2659: c_visit_rec c_visit%ROWTYPE;
2660:
2661: -- bug fix #4181411
3706: ATTRIBUTE12 ,
3707: ATTRIBUTE13 ,
3708: ATTRIBUTE14 ,
3709: ATTRIBUTE15
3710: FROM Ahl_Visits_VL
3711: WHERE VISIT_ID = p_visit_id;
3712:
3713: l_Visit_rec c_Visit%ROWTYPE;
3714: l_Task_rec AHL_VWP_RULES_PVT.Task_Rec_Type default p_x_task_rec;
4642: c_upd_Task_rec c_Task%ROWTYPE;
4643:
4644: -- To find visit related information
4645: CURSOR c_Visit (x_id IN NUMBER) IS
4646: SELECT * FROM Ahl_Visits_VL
4647: WHERE VISIT_ID = x_id;
4648: c_Visit_rec c_Visit%ROWTYPE;
4649:
4650: BEGIN
5297: c_Task_rec c_Task%ROWTYPE;
5298:
5299: -- To find visit related information
5300: CURSOR c_Visit (x_id IN NUMBER) IS
5301: SELECT * FROM Ahl_Visits_VL
5302: WHERE VISIT_ID = x_id;
5303: c_Visit_rec c_Visit%ROWTYPE;
5304:
5305: BEGIN
5864: c_Task_rec c_Task%ROWTYPE;
5865:
5866: -- To find visit related information
5867: CURSOR c_Visit (x_id IN NUMBER) IS
5868: SELECT * FROM Ahl_Visits_VL
5869: WHERE VISIT_ID = x_id;
5870: c_Visit_rec c_Visit%ROWTYPE;
5871:
5872: CURSOR c_sr_ovn(c_sr_id IN NUMBER) IS
6421:
6422: -- To find visit related information
6423: CURSOR c_Visit (x_id IN NUMBER) IS
6424: SELECT *
6425: FROM Ahl_Visits_VL
6426: WHERE VISIT_ID = x_id;
6427: c_visit_rec c_Visit%ROWTYPE;
6428:
6429: -- To find any task which have primary visit task id as deleted task id
6859:
6860: -- To find visit related information
6861: CURSOR c_Visit (x_id IN NUMBER) IS
6862: SELECT *
6863: FROM Ahl_Visits_VL
6864: WHERE VISIT_ID = x_id;
6865: c_visit_rec c_Visit%ROWTYPE;
6866:
6867: -- To find any task which have primary visit task id as deleted task id
7370: l_task_rec c_Task%ROWTYPE;
7371: -- To find visit related information
7372: CURSOR c_Visit (x_id IN NUMBER) IS
7373: SELECT *
7374: FROM Ahl_Visits_VL
7375: WHERE VISIT_ID = x_id;
7376: c_visit_rec c_Visit%ROWTYPE;
7377:
7378: -- To find any task which have primary visit task id as deleted task id
8232: z NUMBER:=0;
8233:
8234: -- To find the task's related visit information
8235: CURSOR c_visit (x_id IN NUMBER) IS
8236: SELECT * FROM AHL_VISITS_VL
8237: WHERE VISIT_ID = x_id;
8238: c_visit_rec c_visit%ROWTYPE;
8239:
8240: -- To find task type code, start, end time of a task
8814: l_past_dates_flag VARCHAR(1):= 'N' ;
8815:
8816: -- To find visit related information
8817: CURSOR c_visit(x_id IN NUMBER) IS
8818: SELECT * FROM AHL_VISITS_VL
8819: WHERE VISIT_ID = x_id;
8820: c_visit_rec c_visit%ROWTYPE;
8821:
8822: -- Begin changes by rnahata for Issue 105
10302:
10303: -- To find visit related information
10304: CURSOR c_Visit (x_id IN NUMBER) IS
10305: SELECT *
10306: FROM Ahl_Visits_VL
10307: WHERE VISIT_ID = x_id;
10308: c_visit_rec c_Visit%ROWTYPE;
10309:
10310: -- To find any task which have primary visit task id as deleted task id