AD Applied Patches R12.2

Description
Categories: Enginatics
Repository: Github
Check if a specific patch is applied in 12.2
select 
decode(ad_patch.is_patch_applied(:ebs_release, :appltop_id, :patch_num &lang),'EXPLICIT','APPLIED','NOT_APPLIED','NOT APPLIED') applied_check
from dual
Parameter NameSQL textValidation
EBS release version
 
Char
Appl top id
 
Number
Patch number
 
Number
Patch language
,:language
Char