1: PACKAGE BODY ad_patch_analysis_engine
2: /* $Header: adpaengb.pls 120.10.12010000.2 2008/12/05 11:37:34 mkumandu ship $ */
3: AS
4:
5: ----------------------------------------------------------------------------
30: BEGIN
31: debugPrint ('--------------------------------------------------');
32: debugPrint ('------------Compare 2 Codelevels------------------');
33: debugPrint ('--------------------------------------------------');
34: debugPrint (' ad_patch_analysis_engine.compareLevel(
36: debugPrint ('------------ Run the Analysis Engine ------------------');
37: debugPrint ('--------------------------------------------------');
38: debugPrint (' ad_patch_analysis_engine.getPatchStatus( '
34: debugPrint (' ad_patch_analysis_engine.compareLevel(
35: debugPrint ('--------------------------------------------------');
36: debugPrint ('------------ Run the Analysis Engine ------------------');
37: debugPrint ('--------------------------------------------------');
38: debugPrint (' ad_patch_analysis_engine.getPatchStatus( '
39: ||'
40: ||'
41: ||'
42: ||'
44: debugPrint ('RETURNS patch_status ');
45: debugPrint ('--------------------------------------------------');
46: debugPrint ('----- Run the Analysis Engine and Update database------');
47: debugPrint ('--------------------------------------------------');
48: debugPrint (' ad_patch_analysis_engine.getPatchStatus( '
49: ||'
50: ||'
51: ||'
52: ||'
709: END;
710:
711: -- var p varchar2(100)
712: -- var c varchar2(100)
713: --- exec :p := ad_patch_analysis_engine.getPatchStatus(9000002,'R12','R12', :c);
714: --- exec :p := ad_patch_analysis_engine.getPatchStatus(7000002,'AD.1.0','R12', :c, 4652175, 4);
715: --- exec :p := ad_patch_analysis_engine.getPatchStatus(8000004,'R12','R12', :c);
716: --- exec :p := ad_patch_analysis_engine.compareLevel('AD.1.2','AD.1')
717: -- select ad_patch_analysis_engine.compareLevel('120.22','33') from dual
710:
711: -- var p varchar2(100)
712: -- var c varchar2(100)
713: --- exec :p := ad_patch_analysis_engine.getPatchStatus(9000002,'R12','R12', :c);
714: --- exec :p := ad_patch_analysis_engine.getPatchStatus(7000002,'AD.1.0','R12', :c, 4652175, 4);
715: --- exec :p := ad_patch_analysis_engine.getPatchStatus(8000004,'R12','R12', :c);
716: --- exec :p := ad_patch_analysis_engine.compareLevel('AD.1.2','AD.1')
717: -- select ad_patch_analysis_engine.compareLevel('120.22','33') from dual
718:
711: -- var p varchar2(100)
712: -- var c varchar2(100)
713: --- exec :p := ad_patch_analysis_engine.getPatchStatus(9000002,'R12','R12', :c);
714: --- exec :p := ad_patch_analysis_engine.getPatchStatus(7000002,'AD.1.0','R12', :c, 4652175, 4);
715: --- exec :p := ad_patch_analysis_engine.getPatchStatus(8000004,'R12','R12', :c);
716: --- exec :p := ad_patch_analysis_engine.compareLevel('AD.1.2','AD.1')
717: -- select ad_patch_analysis_engine.compareLevel('120.22','33') from dual
718:
719: END ad_patch_analysis_engine;
712: -- var c varchar2(100)
713: --- exec :p := ad_patch_analysis_engine.getPatchStatus(9000002,'R12','R12', :c);
714: --- exec :p := ad_patch_analysis_engine.getPatchStatus(7000002,'AD.1.0','R12', :c, 4652175, 4);
715: --- exec :p := ad_patch_analysis_engine.getPatchStatus(8000004,'R12','R12', :c);
716: --- exec :p := ad_patch_analysis_engine.compareLevel('AD.1.2','AD.1')
717: -- select ad_patch_analysis_engine.compareLevel('120.22','33') from dual
718:
719: END ad_patch_analysis_engine;
713: --- exec :p := ad_patch_analysis_engine.getPatchStatus(9000002,'R12','R12', :c);
714: --- exec :p := ad_patch_analysis_engine.getPatchStatus(7000002,'AD.1.0','R12', :c, 4652175, 4);
715: --- exec :p := ad_patch_analysis_engine.getPatchStatus(8000004,'R12','R12', :c);
716: --- exec :p := ad_patch_analysis_engine.compareLevel('AD.1.2','AD.1')
717: -- select ad_patch_analysis_engine.compareLevel('120.22','33') from dual
718:
719: END ad_patch_analysis_engine;
715: --- exec :p := ad_patch_analysis_engine.getPatchStatus(8000004,'R12','R12', :c);
716: --- exec :p := ad_patch_analysis_engine.compareLevel('AD.1.2','AD.1')
717: -- select ad_patch_analysis_engine.compareLevel('120.22','33') from dual
718:
719: END ad_patch_analysis_engine;