DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on AHL_WARRANTY_CONTRACTS_PVT

Line 3896: IF(ahl_warranty_contracts_pvt.is_instance_warranty_available(p_instance_id) = 'Y') THEN

3892: FND_MSG_PUB.add;
3893: END IF;
3894:
3895: -- Instance warranty enabled
3896: IF(ahl_warranty_contracts_pvt.is_instance_warranty_available(p_instance_id) = 'Y') THEN
3897: OPEN c_get_entl_for_NR_task(p_service_req_id);
3898: FETCH c_get_entl_for_NR_task into l_warranty_entl_id,l_ovn;
3899: IF(c_get_entl_for_NR_task%FOUND) THEN
3900: l_entitlement_rec.warranty_entitlement_id := l_warranty_entl_id;

Line 4111: IF (AHL_WARRANTY_CONTRACTS_PVT.Is_Instance_Warranty_Available (p_task_rec.instance_id) = 'Y') THEN

4107: * Call APIs to fetch value of Task and Instance Warranty available flags which would be useful
4108: * when they are passed as null in the record (API Get_Warranty_Rec_for_Create does the same).
4109: */
4110: --IF(p_task_rec.instance_warranty = 'Y') THEN -- If Instance warranty enabled
4111: IF (AHL_WARRANTY_CONTRACTS_PVT.Is_Instance_Warranty_Available (p_task_rec.instance_id) = 'Y') THEN
4112: OPEN c_old_entitlement_rec(p_task_rec.visit_task_id);
4113: FETCH c_old_entitlement_rec into l_old_contract_id, l_old_contract_num, l_old_entl_status, l_ovn;
4114: CLOSE c_old_entitlement_rec;
4115:

Line 4603: AHL_WARRANTY_CONTRACTS_PVT.IS_INSTANCE_WARRANTY_AVAILABLE(ATSK.INSTANCE_ID) INSTANCE_WARRANTY,

4599: AWCL.CLAIM_NAME,
4600: LKUP2.MEANING CLAIM_STATUS,
4601: AWCL.CLAIM_STATUS_CODE,
4602: AHL_WARRANTY_ENTL_PVT.IS_TASK_WARRANTY_AVAILABLE(ATSK.VISIT_TASK_ID) TASK_WARRANTY,
4603: AHL_WARRANTY_CONTRACTS_PVT.IS_INSTANCE_WARRANTY_AVAILABLE(ATSK.INSTANCE_ID) INSTANCE_WARRANTY,
4604: 'Y' WARRANTY_NOT_APPL_FLAG
4605: FROM AHL_VISIT_TASKS_B ATSK,
4606: AHL_WARRANTY_ENTITLEMENTS ASWE,
4607: AHL_WARRANTY_CLAIMS_B AWCL,