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.

APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on AHL_VWP_RULES_PVT

Line 34: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

30: -- START: Defining local functions and procedures SIGNATURES --
31: --------------------------------------------------------------------
32: -- To Check_Visit_Task_Req_Items
33: PROCEDURE Check_Visit_Task_Req_Items (
34: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
35: x_return_status OUT NOCOPY VARCHAR2
36: );
37:
38: -- To Check_Visit_Task_UK_Items

Line 40: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

36: );
37:
38: -- To Check_Visit_Task_UK_Items
39: PROCEDURE Check_Visit_Task_UK_Items (
40: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
41: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
42: x_return_status OUT NOCOPY VARCHAR2
43: );
44:

Line 47: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,

43: );
44:
45: -- To Check_Task_Items
46: PROCEDURE Check_Task_Items (
47: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,
48: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
49: x_return_status OUT NOCOPY VARCHAR2
50: );
51:

Line 54: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type

50: );
51:
52: -- To assign Null to missing attributes of visit while creation/updation.
53: PROCEDURE Default_Missing_Attribs(
54: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
55: );
56:
57: -- To associated Service Request Or Serial Number to Tasks
58: PROCEDURE Asso_Inst_Dept_SR_to_Tasks (

Line 60: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

56:
57: -- To associated Service Request Or Serial Number to Tasks
58: PROCEDURE Asso_Inst_Dept_SR_to_Tasks (
59: p_module_type IN VARCHAR2 := 'JSP',
60: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
61:
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2

Line 84: ( p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type)

80: -- g_miss_date then Null else the value
81:
82: --------------------------------------------------------------------
83: PROCEDURE Default_Missing_Attribs
84: ( p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type)
85: AS
86: BEGIN
87: IF p_x_task_rec.DURATION = Fnd_Api.G_MISS_NUM THEN
88: p_x_task_rec.DURATION := NULL;

Line 258: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type,

254: -- by skpathak on 20-OCT-2008 while fixing bug 7016519
255: --------------------------------------------------------------------
256: PROCEDURE Asso_Inst_Dept_SR_To_Tasks (
257: p_module_type IN VARCHAR2,
258: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2
262: )

Line 336: AHL_VWP_RULES_PVT.Check_Item_name_Or_Id

332: IF (p_x_task_Rec.inventory_item_id IS NOT NULL AND
333: p_x_task_Rec.inventory_item_id <> Fnd_Api.G_MISS_NUM) AND
334: (p_x_task_Rec.item_organization_id IS NOT NULL AND
335: p_x_task_Rec.item_organization_id <> Fnd_Api.G_MISS_NUM) THEN
336: AHL_VWP_RULES_PVT.Check_Item_name_Or_Id
337: (p_item_id => p_x_task_Rec.inventory_item_id,
338: p_org_id => p_x_task_Rec.item_organization_id,
339: p_item_name => p_x_task_Rec.item_name,
340: x_item_id => l_item_id,

Line 413: AHL_VWP_RULES_PVT.Check_serial_name_Or_Id

409: -- Convert serial number to instance/ serial id
410: IF (p_x_task_Rec.serial_number IS NOT NULL AND p_x_task_Rec.serial_number <> Fnd_Api.G_MISS_CHAR) OR
411: (p_x_task_Rec.instance_id IS NOT NULL AND p_x_task_Rec.instance_id <> Fnd_Api.G_MISS_CHAR) THEN
412:
413: AHL_VWP_RULES_PVT.Check_serial_name_Or_Id
414: (p_item_id => p_x_task_Rec.inventory_item_id,
415: p_org_id => p_x_task_Rec.item_organization_id,
416: p_serial_id => Null,
417: p_serial_number => p_x_task_Rec.serial_number,

Line 449: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

445: IF c_visit_rec.organization_id IS NOT NULL THEN
446: -- Get dept code using dept description
447: IF (p_x_task_Rec.dept_name IS NOT NULL AND p_x_task_Rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
448:
449: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
450: (p_organization_id => c_visit_rec.organization_id,
451: p_dept_name => p_x_task_Rec.dept_name,
452: p_department_id => Null,
453: x_department_id => p_x_task_Rec.department_id,

Line 465: Ahl_vwp_rules_pvt.CHECK_DEPARTMENT_SHIFT

461: RAISE Fnd_Api.G_EXC_ERROR;
462: END IF;
463:
464: -- Changes for Post 11.5.10 by amagrawa
465: Ahl_vwp_rules_pvt.CHECK_DEPARTMENT_SHIFT
466: (P_DEPT_ID => p_x_task_Rec.department_id,
467: X_RETURN_STATUS => l_return_status);
468:
469: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN

Line 516: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type,

512: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
513: p_commit IN VARCHAR2 := Fnd_Api.g_false,
514: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
515: p_module_type IN VARCHAR2 := 'JSP',
516: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,
519: x_msg_data OUT NOCOPY VARCHAR2
520: )

Line 546: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;

542: INDEX BY BINARY_INTEGER;
543:
544: -- Defining variables to table types
545: MR_Id_tbl MR_tbl;
546: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;
547:
548: -- yazhou 15Nov2005 starts
549: -- Code clean up
550:

Line 740: AHL_VWP_RULES_PVT.update_visit_task_flag(

736:
737: OPEN C_VISIT(l_visit_id);
738: FETCH c_visit into l_visit_csr_rec;
739: IF C_VISIT%FOUND AND l_visit_csr_rec.Any_Task_Chg_Flag='N' THEN
740: AHL_VWP_RULES_PVT.update_visit_task_flag(
741: p_visit_id =>l_visit_csr_rec.visit_id,
742: p_flag =>'Y',
743: x_return_status =>x_return_status);
744: END IF;

Line 818: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

814: p_commit IN VARCHAR2 := Fnd_Api.g_false,
815: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
816: p_module_type IN VARCHAR2 := 'JSP',
817:
818: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
819: x_return_status OUT NOCOPY VARCHAR2,
820: x_msg_count OUT NOCOPY NUMBER,
821: x_msg_data OUT NOCOPY VARCHAR2
822: )

Line 829: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;

825: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Unplanned_Task';
826: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
827:
828: -- local variables defined for the procedure
829: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
830: l_return_status VARCHAR2(1);
831: l_msg_data VARCHAR2(2000);
832:
833: l_msg_count NUMBER;

Line 906: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

902: -- For DEPARTMENT
903: -- Convert department name to department id
904: IF (l_task_rec.dept_name IS NOT NULL AND l_task_rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
905:
906: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
907: (p_organization_id => c_visit_rec.organization_id,
908: p_dept_name => l_task_rec.dept_name,
909: p_department_id => NULL,
910: x_department_id => l_department_id,

Line 936: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

932: -- Convert cost parent number to id
933: IF (l_Task_rec.cost_parent_number IS NOT NULL AND
934: l_Task_rec.cost_parent_number <> Fnd_Api.G_MISS_NUM ) THEN
935:
936: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
937: (p_visit_task_id => l_Task_rec.cost_parent_id,
938: p_visit_task_number => l_Task_rec.cost_parent_number,
939: p_visit_id => l_Task_rec.visit_id,
940: x_visit_task_id => l_cost_parent_id,

Line 964: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop

960: -- To Check for cost parent task id not forming loop
961: IF (l_Task_rec.cost_parent_id IS NOT NULL AND
962: l_Task_rec.cost_parent_id <> Fnd_Api.G_MISS_NUM ) THEN
963:
964: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop
965: (p_visit_id => l_Task_rec.visit_id,
966: p_visit_task_id => l_Task_rec.visit_task_id ,
967: p_cost_parent_id => l_Task_rec.cost_parent_id
968: );

Line 1133: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update

1129: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1130: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
1131:
1132: --salogan added for supplier warranty starts
1133: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update
1134: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(
1135: p_task_rec => l_task_rec,
1136: x_warranty_entl_tbl => l_entl_rec_tbl);
1137:

Line 1134: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(

1130: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
1131:
1132: --salogan added for supplier warranty starts
1133: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update
1134: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(
1135: p_task_rec => l_task_rec,
1136: x_warranty_entl_tbl => l_entl_rec_tbl);
1137:
1138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1236: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

1232:
1233: END IF; -- Start_date_time check.
1234:
1235: IF c_visit_rec.any_task_chg_flag = 'N' THEN
1236: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
1237: (p_visit_id => l_task_rec.visit_id,
1238: p_flag => 'Y',
1239: x_return_status => x_return_status);
1240: END IF;

Line 1482: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1478: -- PURPOSE
1479: --
1480: ---------------------------------------------------------------------
1481: PROCEDURE Check_Task_Items (
1482: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1483: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1484:
1485: x_return_status OUT NOCOPY VARCHAR2
1486: )

Line 1535: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1531: --
1532: ---------------------------------------------------------------------
1533: /* Commented
1534: PROCEDURE Complete_Visit_Task_Rec (
1535: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1536: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
1537: )
1538: IS
1539: CURSOR c_Visit_Task IS

Line 1536: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type

1532: ---------------------------------------------------------------------
1533: /* Commented
1534: PROCEDURE Complete_Visit_Task_Rec (
1535: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1536: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
1537: )
1538: IS
1539: CURSOR c_Visit_Task IS
1540: SELECT *

Line 1572: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1568: -- PURPOSE
1569: --
1570: ---------------------------------------------------------------------
1571: PROCEDURE Check_Visit_Task_Req_Items (
1572: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1573: x_return_status OUT NOCOPY VARCHAR2
1574: )
1575: IS
1576:

Line 1612: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1608: -- PURPOSE
1609: --
1610: ---------------------------------------------------------------------
1611: PROCEDURE Check_Visit_Task_UK_Items (
1612: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1613: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1614: x_return_status OUT NOCOPY VARCHAR2
1615: )
1616: IS