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 781: AHL_VWP_RULES_PVT.update_visit_task_flag(

777:
778: OPEN C_VISIT(l_visit_id);
779: FETCH c_visit into l_visit_csr_rec;
780: IF C_VISIT%FOUND AND l_visit_csr_rec.Any_Task_Chg_Flag='N' THEN
781: AHL_VWP_RULES_PVT.update_visit_task_flag(
782: p_visit_id =>l_visit_csr_rec.visit_id,
783: p_flag =>'Y',
784: x_return_status =>x_return_status);
785: END IF;

Line 859: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

855: p_commit IN VARCHAR2 := Fnd_Api.g_false,
856: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
857: p_module_type IN VARCHAR2 := 'JSP',
858:
859: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
860: x_return_status OUT NOCOPY VARCHAR2,
861: x_msg_count OUT NOCOPY NUMBER,
862: x_msg_data OUT NOCOPY VARCHAR2
863: )

Line 870: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;

866: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Unplanned_Task';
867: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
868:
869: -- local variables defined for the procedure
870: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
871: l_return_status VARCHAR2(1);
872: l_msg_data VARCHAR2(2000);
873:
874: l_msg_count NUMBER;

Line 946: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

942: -- For DEPARTMENT
943: -- Convert department name to department id
944: IF (l_task_rec.dept_name IS NOT NULL AND l_task_rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
945:
946: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
947: (p_organization_id => c_visit_rec.organization_id,
948: p_dept_name => l_task_rec.dept_name,
949: p_department_id => NULL,
950: x_department_id => l_department_id,

Line 976: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

972: -- Convert cost parent number to id
973: IF (l_Task_rec.cost_parent_number IS NOT NULL AND
974: l_Task_rec.cost_parent_number <> Fnd_Api.G_MISS_NUM ) THEN
975:
976: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
977: (p_visit_task_id => l_Task_rec.cost_parent_id,
978: p_visit_task_number => l_Task_rec.cost_parent_number,
979: p_visit_id => l_Task_rec.visit_id,
980: x_visit_task_id => l_cost_parent_id,

Line 1004: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop

1000: -- To Check for cost parent task id not forming loop
1001: IF (l_Task_rec.cost_parent_id IS NOT NULL AND
1002: l_Task_rec.cost_parent_id <> Fnd_Api.G_MISS_NUM ) THEN
1003:
1004: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop
1005: (p_visit_id => l_Task_rec.visit_id,
1006: p_visit_task_id => l_Task_rec.visit_task_id ,
1007: p_cost_parent_id => l_Task_rec.cost_parent_id
1008: );

Line 1206: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

1202:
1203: END IF; -- Start_date_time check.
1204:
1205: IF c_visit_rec.any_task_chg_flag = 'N' THEN
1206: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
1207: (p_visit_id => l_task_rec.visit_id,
1208: p_flag => 'Y',
1209: x_return_status => x_return_status);
1210: END IF;

Line 1452: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1448: -- PURPOSE
1449: --
1450: ---------------------------------------------------------------------
1451: PROCEDURE Check_Task_Items (
1452: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1453: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1454:
1455: x_return_status OUT NOCOPY VARCHAR2
1456: )

Line 1505: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1501: --
1502: ---------------------------------------------------------------------
1503: /* Commented
1504: PROCEDURE Complete_Visit_Task_Rec (
1505: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1506: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
1507: )
1508: IS
1509: CURSOR c_Visit_Task IS

Line 1506: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type

1502: ---------------------------------------------------------------------
1503: /* Commented
1504: PROCEDURE Complete_Visit_Task_Rec (
1505: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1506: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
1507: )
1508: IS
1509: CURSOR c_Visit_Task IS
1510: SELECT *

Line 1542: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1538: -- PURPOSE
1539: --
1540: ---------------------------------------------------------------------
1541: PROCEDURE Check_Visit_Task_Req_Items (
1542: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1543: x_return_status OUT NOCOPY VARCHAR2
1544: )
1545: IS
1546:

Line 1582: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

1578: -- PURPOSE
1579: --
1580: ---------------------------------------------------------------------
1581: PROCEDURE Check_Visit_Task_UK_Items (
1582: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
1583: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1584: x_return_status OUT NOCOPY VARCHAR2
1585: )
1586: IS