310: level for further logic */
311:
312: SELECT decode(substr(patch_level,1,9), 'R12.AP.A.', 'N', 'R12.AP.B.', 'N', 'Y')
313: INTO l_ap_patch_level
314: FROM fnd_product_installations
315: WHERE application_id = 200;
316:
317: l_debug_info := 'Is AP patch set level above branchline :'||l_ap_patch_level;
318: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
326:
327: BEGIN
328: SELECT decode(substr(patch_level,1,9), 'R12.JA.A.', 'N', 'R12.JA.B.', 'N', 'Y')
329: INTO l_il_patch_level
330: FROM fnd_product_installations
331: WHERE application_id = 7000;
332:
333: IF (l_il_patch_level = 'Y') THEN
334: