APPS.AHL_WARRANTY_ENTL_PVT dependencies on AHL_WARRANTY_ENTITLEMENTS

Line 744: FROM AHL_VISIT_TASKS_B VTK, AHL_WARRANTY_ENTITLEMENTS ENT

740: ) RETURN NUMBER IS
741:
742: CURSOR get_visit_task_inst_csr (c_entl_id NUMBER) IS
743: SELECT VTK.instance_id
744: FROM AHL_VISIT_TASKS_B VTK, AHL_WARRANTY_ENTITLEMENTS ENT
745: WHERE VTK.visit_task_id = ENT.visit_task_id
746: AND ENT.warranty_entitlement_id = c_entl_id;
747:
748: CURSOR get_osp_line_inst_csr (c_entl_id NUMBER) IS

Line 751: AHL_OSP_ORDER_LINES OSP, AHL_WARRANTY_ENTITLEMENTS ENT

747:
748: CURSOR get_osp_line_inst_csr (c_entl_id NUMBER) IS
749: SELECT VTK.instance_id
750: FROM AHL_VISIT_TASKS_B VTK, AHL_WORKORDERS WO,
751: AHL_OSP_ORDER_LINES OSP, AHL_WARRANTY_ENTITLEMENTS ENT
752: WHERE VTK.visit_task_id = WO.visit_task_id
753: AND WO.workorder_id = OSP.workorder_id
754: AND OSP.workorder_id IS NOT NULL
755: AND OSP.osp_order_line_id = ENT.osp_order_line_id

Line 760: AHL_WARRANTY_ENTITLEMENTS ENT

756: AND ENT.warranty_entitlement_id = c_entl_id
757: UNION ALL
758: SELECT CSI.instance_id
759: FROM AHL_OSP_ORDER_LINES OSP, CSI_ITEM_INSTANCES CSI,
760: AHL_WARRANTY_ENTITLEMENTS ENT
761: WHERE CSI.last_vld_organization_id = OSP.inventory_org_id
762: AND CSI.inventory_item_id = OSP.inventory_item_id
763: AND CSI.serial_number = OSP.serial_number
764: AND OSP.workorder_id IS NULL

Line 1123: SELECT AHL_WARRANTY_ENTITLEMENTS_S.NEXTVAL INTO p_x_warranty_entl_rec.warranty_entitlement_id FROM DUAL;

1119: RETURN;
1120: END IF;
1121:
1122: -- prepare for insert
1123: SELECT AHL_WARRANTY_ENTITLEMENTS_S.NEXTVAL INTO p_x_warranty_entl_rec.warranty_entitlement_id FROM DUAL;
1124: -- setting object version number for create
1125: p_x_warranty_entl_rec.object_version_number := 1;
1126: -- setting up user/create/update information
1127: p_x_warranty_entl_rec.created_by := FND_GLOBAL.USER_ID;

Line 1144: AHL_WARRANTY_ENTITLEMENTS_PKG.Insert_Row(

1140: IF (l_log_statement >= l_log_current_level) THEN
1141: FND_LOG.string(l_log_statement, l_full_name, 'Before Insert_Row');
1142: END IF;
1143:
1144: AHL_WARRANTY_ENTITLEMENTS_PKG.Insert_Row(
1145: x_row_id => l_dummy_char,
1146: x_warranty_entitlement_id => p_x_warranty_entl_rec.warranty_entitlement_id,
1147: x_object_version_number => p_x_warranty_entl_rec.object_version_number,
1148: x_warranty_contract_id => p_x_warranty_entl_rec.warranty_contract_id,

Line 1227: FROM AHL_WARRANTY_ENTITLEMENTS

1223: ) IS
1224:
1225: CURSOR warranty_entl_csr(c_warranty_entl_id NUMBER) IS
1226: SELECT *
1227: FROM AHL_WARRANTY_ENTITLEMENTS
1228: WHERE warranty_entitlement_id = c_warranty_entl_id;
1229:
1230: --
1231: l_api_name CONSTANT VARCHAR2(30) := 'Update_Warranty_Entitlement';

Line 1444: AHL_WARRANTY_ENTITLEMENTS_PKG.Update_Row(

1440: IF (l_log_statement >= l_log_current_level) THEN
1441: FND_LOG.string(l_log_statement, l_full_name, 'Before Update_Row');
1442: END IF;
1443:
1444: AHL_WARRANTY_ENTITLEMENTS_PKG.Update_Row(
1445: x_warranty_entitlement_id => p_x_warranty_entl_rec.warranty_entitlement_id,
1446: x_object_version_number => p_x_warranty_entl_rec.object_version_number,
1447: x_warranty_contract_id => p_x_warranty_entl_rec.warranty_contract_id,
1448: x_old_warranty_contract_id => l_contract_id,

Line 1548: AHL_WARRANTY_ENTITLEMENTS_PKG.Delete_Row(

1544: FND_LOG.string(l_log_statement, l_full_name, 'Before Delete_Row');
1545: END IF;
1546:
1547: -- delete row
1548: AHL_WARRANTY_ENTITLEMENTS_PKG.Delete_Row(
1549: x_warranty_entitlement_id => p_x_warranty_entl_rec.warranty_entitlement_id
1550: );
1551:
1552: IF (l_log_statement >= l_log_current_level) THEN

Line 1572: FROM AHL_WARRANTY_ENTITLEMENTS

1568: ) IS
1569:
1570: CURSOR warranty_entl_csr(c_warranty_entl_id NUMBER) IS
1571: SELECT *
1572: FROM AHL_WARRANTY_ENTITLEMENTS
1573: WHERE warranty_entitlement_id = c_warranty_entl_id;
1574:
1575: CURSOR chk_war_cont_id_csr (c_contract_id NUMBER) IS
1576: SELECT 'X'

Line 1711: UPDATE AHL_WARRANTY_ENTITLEMENTS SET

1707: FND_LOG.string(l_log_statement, l_full_name, 'Before approval update');
1708: END IF;
1709:
1710: -- update the warranty contract id, old contract id and the status
1711: UPDATE AHL_WARRANTY_ENTITLEMENTS SET
1712: warranty_contract_id = l_contract_id,
1713: old_warranty_contract_id = l_contract_id,
1714: entitlement_status_code = l_entl_status
1715: WHERE warranty_entitlement_id = p_x_warranty_entl_rec.warranty_entitlement_id;