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_PLAN_TASKS_PVT dependencies on AHL_VWP_RULES_PVT

Line 36: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

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

Line 42: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

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

Line 49: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,

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

Line 79: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,

75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
77: p_commit IN VARCHAR2 := Fnd_Api.g_false,
78: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
79: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2
83: );

Line 87: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type

83: );
84: */
85: -- To assign Null to missing attributes of visit while creation/updation.
86: PROCEDURE Default_Missing_Attribs(
87: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
88: );
89:
90: -- To associated Service Request Or Serial Number to Tasks
91: PROCEDURE Asso_Inst_Dept_to_Tasks (

Line 93: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type

89:
90: -- To associated Service Request Or Serial Number to Tasks
91: PROCEDURE Asso_Inst_Dept_to_Tasks (
92: p_module_type IN VARCHAR2,
93: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
94: );
95:
96: --------------------------------------------------------------------
97: -- END: Defining local functions and procedures SIGNATURES --

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

109: -- g_miss_date then Null else the value
110:
111: --------------------------------------------------------------------
112: PROCEDURE Default_Missing_Attribs
113: ( p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type)
114: AS
115: BEGIN
116: IF p_x_task_rec.DURATION = Fnd_Api.G_MISS_NUM THEN
117: p_x_task_rec.DURATION := NULL;

Line 294: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type

290: --------------------------------------------------------------------
291: PROCEDURE Asso_Inst_Dept_to_Tasks
292: (
293: p_module_type IN VARCHAR2,
294: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type
295: )
296: IS
297: L_API_NAME CONSTANT VARCHAR2(30) := 'Asso_Inst_Dept_to_Tasks';
298: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;

Line 333: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

329:
330: IF c_visit_rec.organization_id IS NOT NULL THEN
331: -- Get dept code using dept description
332: IF (p_x_task_Rec.dept_name IS NOT NULL AND p_x_task_Rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
333: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
334: (p_organization_id => c_visit_rec.organization_id,
335: p_dept_name => p_x_task_Rec.dept_name,
336: p_department_id => Null,
337: x_department_id => p_x_task_Rec.department_id,

Line 348: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT

344: RAISE Fnd_Api.G_EXC_ERROR;
345: END IF;
346:
347: -- Changes for Post 11.5.10 by amagrawa
348: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT
349: (P_DEPT_ID => p_x_task_Rec.department_id,
350: X_RETURN_STATUS => l_return_status);
351:
352: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN

Line 381: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id

377: END IF; -- End of if visit org exists
378:
379: /*Convert service request number to service request id
380: IF (p_x_task_Rec.service_request_number IS NOT NULL AND p_x_task_Rec.service_request_number <> Fnd_Api.G_MISS_CHAR ) THEN
381: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id
382: (p_service_id => Null,
383: p_service_number => p_x_task_Rec.service_request_number,
384: x_service_id => p_x_task_Rec.service_request_id,
385: x_return_status => l_return_status,

Line 415: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type,

411: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
412: p_commit IN VARCHAR2 := Fnd_Api.g_false,
413: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
414: p_module_type IN VARCHAR2 := 'JSP',
415: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.task_rec_type,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2
419: )

Line 546: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;

542: INDEX BY BINARY_INTEGER;
543:
544: -- Table type for storing 'MR_Serial_Rec_Type' record datatype
545: MR_Header_Tbl MR_Header_Tbl_Type;
546: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;
547:
548: -- To find visit related information
549: CURSOR c_Visit (p_visit_id IN NUMBER) IS
550: SELECT Any_Task_Chg_Flag, Visit_Id

Line 647: AHL_VWP_RULES_PVT.Validate_Service_Type(

643: l_past_task_start_date := p_x_task_Rec.past_task_start_date;
644: l_past_task_end_date := p_x_task_Rec.past_task_end_date;
645:
646: -- PRAKKUM :: FP:PIE :: 13-OCT-2010 :: validate Service Type attributes
647: AHL_VWP_RULES_PVT.Validate_Service_Type(
648: p_service_type => p_x_task_Rec.service_type,
649: p_module_type => p_module_type,
650: p_unit_effectivity_id => p_x_task_Rec.unit_effectivity_id,
651: p_x_service_type_code => p_x_task_Rec.service_type_code

Line 745: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks');

741: FETCH c_item_info INTO l_serial_id,l_service_req_id,l_org_id,l_item_id;
742: CLOSE c_item_info;
743:
744: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
745: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks');
746: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue_id =>' || l_unit_effectivity_id);
747: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
748: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
749: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);

Line 759: AHL_VWP_RULES_PVT.Insert_Tasks

755: FETCH c_task_for_ue INTO l_parent_task_id;
756: /*NR-MR Changes - sowsubra*/
757: --Call Insert_Tasks only if summary task for the SR has not already been created.
758: IF c_task_for_ue%NOTFOUND THEN
759: AHL_VWP_RULES_PVT.Insert_Tasks
760: (p_visit_id => l_visit_id,
761: p_unit_id => l_unit_effectivity_id,
762: p_serial_id => l_serial_id,
763: p_service_id => l_service_req_id,

Line 785: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');

781: x_msg_data => l_msg_data
782: );
783:
784: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
785: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
786: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_return_status' || l_return_status);
787: END IF;
788:
789: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 836: IF AHL_VWP_RULES_PVT.instance_in_config_tree(l_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN

832:
833: -- NR-MR Changes - sowsubra
834: -- Done to allow creation of a task for an instance that has already been removed.
835: /***
836: IF AHL_VWP_RULES_PVT.instance_in_config_tree(l_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN
837: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
838: Fnd_Msg_Pub.ADD;
839: RAISE Fnd_Api.G_EXC_ERROR;
840: END IF; ***/

Line 844: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');

840: END IF; ***/
841:
842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
843: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Inside No Child UEs ELSE BLOCK');
844: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
845: END IF;
846:
847: -- Create a Planned Task
848: AHL_VWP_RULES_PVT.Insert_Tasks

Line 848: AHL_VWP_RULES_PVT.Insert_Tasks

844: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
845: END IF;
846:
847: -- Create a Planned Task
848: AHL_VWP_RULES_PVT.Insert_Tasks
849: (p_visit_id => l_visit_id,
850: p_unit_id => l_unit_effectivity_id,
851: p_serial_id => l_serial_id,
852: p_service_id => l_service_req_id,

Line 877: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task - l_return_status : '|| l_return_status);

873: x_msg_data => l_msg_data
874: );
875:
876: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
877: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task - l_return_status : '|| l_return_status);
878: END IF;
879:
880: -- TCHIMIRA::ER 9368251 ::17-JUN-2010::Begin
881: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 886: ', return_status from AHL_VWP_RULES_PVT.Insert_Tasks: ' || l_return_status );

882: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
883: 'Id of the newly created Task: ' || l_task_id ||
884: 'Id of the parent summary Task: ' || l_parent_task_id ||
885: ', p_x_task_Rec.duration: ' || p_x_task_Rec.duration ||
886: ', return_status from AHL_VWP_RULES_PVT.Insert_Tasks: ' || l_return_status );
887: END IF;
888: IF (NVL(l_return_status,'x') = FND_API.G_RET_STS_SUCCESS AND l_task_id IS NOT NULL AND p_x_task_Rec.duration IS NOT NULL) THEN
889: -- Update the duration column for the Planned task as well as its parent summary task with the user entered Estimated Duration
890: UPDATE AHL_VISIT_TASKS_B

Line 1016: AHL_VWP_RULES_PVT.update_visit_task_flag(

1012: OPEN C_VISIT(l_visit_id);
1013: fetch c_visit into l_visit_csr_rec;
1014: IF C_VISIT%FOUND THEN
1015: IF l_visit_csr_rec.Any_Task_Chg_Flag='N' THEN
1016: AHL_VWP_RULES_PVT.update_visit_task_flag(
1017: p_visit_id =>l_visit_csr_rec.visit_id,
1018: p_flag =>'Y',
1019: x_return_status =>x_return_status);
1020: END IF;

Line 1219: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;

1215:
1216:
1217: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || 'CREATE_MR_TASKS';
1218: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
1219: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;
1220:
1221: BEGIN
1222: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1223: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin', 'At the start of the procedure..');

Line 1277: IF AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN

1273:
1274: -- NR-MR Changes - sowsubra
1275: -- Done to allow creation of a task for an instance that has already been removed.
1276: /***
1277: IF AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, l_serial_id) = FND_API.G_RET_STS_ERROR THEN
1278: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
1279: Fnd_Msg_Pub.ADD;
1280: RAISE Fnd_Api.G_EXC_ERROR;
1281: END IF;

Line 1285: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling ahl_vwp_rules_pvt.create_tasks_for_mr');

1281: END IF;
1282: ***/
1283:
1284: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1285: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling ahl_vwp_rules_pvt.create_tasks_for_mr');
1286: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_visit_id =>' || p_visit_id);
1287: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_serial_id =>' || l_serial_id);
1288: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);
1289: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);

Line 1296: ahl_vwp_rules_pvt.create_tasks_for_mr(p_visit_id => p_visit_id,

1292: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1293: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_quantity =>' || p_quantity);
1294: END IF;
1295:
1296: ahl_vwp_rules_pvt.create_tasks_for_mr(p_visit_id => p_visit_id,
1297: p_unit_id => l_unit_eff_id,
1298: p_item_id => NULL,
1299: p_org_id => NULL,
1300: p_serial_id => l_serial_id,

Line 1318: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After ahl_vwp_rules_pvt.create_tasks_for_mr');

1314: x_return_status => l_return_status
1315: );
1316:
1317: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1318: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After ahl_vwp_rules_pvt.create_tasks_for_mr');
1319: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id = ' || l_parent_MR_Id );
1320: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'x_return_status is ' || l_return_status );
1321: END IF;
1322:

Line 1332: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling AHL_VWP_RULES_PVT.Tech_Dependency');

1328: MR_Serial_Tbl(0).Serial_ID := l_serial_id;
1329: --SKPATHAK : BUG 13997419 :: 26-APR-2012 :: pass the ue id as well
1330: MR_Serial_Tbl(0).UE_ID := l_unit_eff_id;
1331: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1332: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling AHL_VWP_RULES_PVT.Tech_Dependency');
1333: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).MR_ID -->'|| MR_Serial_Tbl(0).MR_ID);
1334: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).Serial_ID'|| MR_Serial_Tbl(0).Serial_ID);
1335: END IF;
1336:

Line 1337: AHL_VWP_RULES_PVT.Tech_Dependency

1333: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).MR_ID -->'|| MR_Serial_Tbl(0).MR_ID);
1334: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).Serial_ID'|| MR_Serial_Tbl(0).Serial_ID);
1335: END IF;
1336:
1337: AHL_VWP_RULES_PVT.Tech_Dependency
1338: (p_visit_id => p_visit_id,
1339: p_task_type => 'PLANNED',
1340: p_MR_Serial_Tbl => MR_Serial_Tbl,
1341: x_return_status => l_return_status

Line 1345: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Tech_Dependency - l_return_status : '||l_return_status);

1341: x_return_status => l_return_status
1342: );
1343:
1344: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1345: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Tech_Dependency - l_return_status : '||l_return_status);
1346: END IF;
1347:
1348: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1349: RAISE Fnd_Api.G_EXC_ERROR;

Line 1432: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

1428: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1429: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1430: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1431: p_module_type IN VARCHAR2 := 'JSP',
1432: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
1433: x_return_status OUT NOCOPY VARCHAR2,
1434: x_msg_count OUT NOCOPY NUMBER,
1435: x_msg_data OUT NOCOPY VARCHAR2
1436: )

Line 1444: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;

1440: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
1441: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
1442:
1443: -- local variables defined for the procedure
1444: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
1445: l_return_status VARCHAR2(1);
1446: l_msg_data VARCHAR2(2000);
1447: l_planned_order_flag VARCHAR2(1);
1448: l_msg_count NUMBER;

Line 1520: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

1516: -- For DEPARTMENT
1517: -- Convert department name to department id
1518: IF (l_task_rec.dept_name IS NOT NULL AND l_task_rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
1519:
1520: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
1521: (p_organization_id => c_visit_rec.organization_id,
1522: p_dept_name => l_task_rec.dept_name,
1523: p_department_id => NULL,
1524: x_department_id => l_department_id,

Line 1550: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

1546: -- Convert cost parent number to id
1547: IF (l_Task_rec.cost_parent_number IS NOT NULL AND
1548: l_Task_rec.cost_parent_number <> Fnd_Api.G_MISS_NUM ) THEN
1549:
1550: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
1551: (p_visit_task_id => l_Task_rec.cost_parent_id,
1552: p_visit_task_number => l_Task_rec.cost_parent_number,
1553: p_visit_id => l_Task_rec.visit_id,
1554: x_visit_task_id => l_cost_parent_id,

Line 1578: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop

1574: -- To Check for cost parent task id not forming loop
1575: IF (l_Task_rec.cost_parent_id IS NOT NULL AND
1576: l_Task_rec.cost_parent_id <> Fnd_Api.G_MISS_NUM ) THEN
1577:
1578: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop
1579: (p_visit_id => l_Task_rec.visit_id,
1580: p_visit_task_id => l_Task_rec.visit_task_id ,
1581: p_cost_parent_id => l_Task_rec.cost_parent_id
1582: );

Line 1751: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update

1747:
1748: --salogan added for supplier warranty starts
1749: --added the SR id from c_task_rec cursor whuch gets data from DB to l_task_rec for SR-VWP-SW changes
1750: l_task_rec.SERVICE_REQUEST_ID := c_task_rec.service_request_id;
1751: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update
1752: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(
1753: p_task_rec => l_task_rec,
1754: x_warranty_entl_tbl => l_entl_rec_tbl);
1755:

Line 1752: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(

1748: --salogan added for supplier warranty starts
1749: --added the SR id from c_task_rec cursor whuch gets data from DB to l_task_rec for SR-VWP-SW changes
1750: l_task_rec.SERVICE_REQUEST_ID := c_task_rec.service_request_id;
1751: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update
1752: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(
1753: p_task_rec => l_task_rec,
1754: x_warranty_entl_tbl => l_entl_rec_tbl);
1755:
1756: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1860: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

1856: END IF;
1857: END IF;
1858:
1859: IF c_visit_rec.any_task_chg_flag = 'N' THEN
1860: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
1861: (p_visit_id => l_task_rec.visit_id,
1862: p_flag => 'Y',
1863: x_return_status => x_return_status);
1864: END IF;

Line 2082: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

2078: -- PURPOSE
2079: --
2080: ---------------------------------------------------------------------
2081: PROCEDURE Check_Task_Items (
2082: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
2083: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
2084:
2085: x_return_status OUT NOCOPY VARCHAR2
2086: )

Line 2143: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

2139: --
2140: ---------------------------------------------------------------------
2141: /* It doesn't seem to be used anywhere
2142: PROCEDURE Complete_Visit_Task_Rec (
2143: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
2144: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
2145: )
2146: IS
2147: CURSOR c_Visit_Task IS

Line 2144: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type

2140: ---------------------------------------------------------------------
2141: /* It doesn't seem to be used anywhere
2142: PROCEDURE Complete_Visit_Task_Rec (
2143: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
2144: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
2145: )
2146: IS
2147: CURSOR c_Visit_Task IS
2148: SELECT *

Line 2180: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

2176: -- PURPOSE
2177: --
2178: ---------------------------------------------------------------------
2179: PROCEDURE Check_Visit_Task_Req_Items (
2180: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
2181: x_return_status OUT NOCOPY VARCHAR2
2182: )
2183: IS
2184: l_api_name CONSTANT VARCHAR2(30) := 'Check_Visit_Task_Req_Items';

Line 2227: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

2223: -- PURPOSE
2224: --
2225: ---------------------------------------------------------------------
2226: PROCEDURE Check_Visit_Task_UK_Items (
2227: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
2228: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
2229: x_return_status OUT NOCOPY VARCHAR2
2230: )
2231: IS