DBA Data[Home] [Help]

APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_WARRANTY_CONTRACTS_PVT

Line 882: l_uc_details_tbl(l_curr_row).is_warranty_available := AHL_WARRANTY_CONTRACTS_PVT.Is_Instance_Warranty_Available(l_uc_details_tbl(l_curr_row).curr_instance_id);

878: FETCH is_instance_unit INTO l_uc_details_tbl(l_curr_row).is_unit;
879: CLOSE is_instance_unit;
880:
881: -- Is warranty Available
882: l_uc_details_tbl(l_curr_row).is_warranty_available := AHL_WARRANTY_CONTRACTS_PVT.Is_Instance_Warranty_Available(l_uc_details_tbl(l_curr_row).curr_instance_id);
883:
884: -- Other Visits available
885: OPEN get_other_visits(l_uc_details_tbl(l_curr_row).curr_instance_id, p_visit_id);
886: FETCH get_other_visits INTO l_uc_details_tbl(l_curr_row).is_visit_available;

Line 1087: l_inst_details_tbl(l_curr_row).is_warranty_available := AHL_WARRANTY_CONTRACTS_PVT.Is_Instance_Warranty_Available(p_item_instance_id);

1083: --unit NHA
1084: l_inst_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(p_item_instance_id);
1085:
1086: -- Is warranty Available
1087: l_inst_details_tbl(l_curr_row).is_warranty_available := AHL_WARRANTY_CONTRACTS_PVT.Is_Instance_Warranty_Available(p_item_instance_id);
1088: -- Decode the values Y or N to T or F resp
1089: IF l_inst_details_tbl(l_curr_row).is_warranty_available = 'Y' THEN
1090: l_inst_details_tbl(l_curr_row).is_warranty_available := 'T';
1091: ELSE