Saturday, June 18, 2011

Deleting a concurrent program from back end and compile form

DECLARE
   v_program_short_name    VARCHAR2 (200);
   v_program_application   VARCHAR2 (200);
   v_request_group1        VARCHAR2 (200);
   v_group_application     VARCHAR2 (200);
BEGIN
   v_program_short_name  := 'X1_APXPBFTR_WS';
   v_program_application := 'SQLAP';
   v_request_group1       := 'All Reports';
   v_group_application   := 'SQLAP';
   --+=======================================================================
   --+Remove Concurrent Program From Request Group
   --+=======================================================================   
   apps.fnd_program.remove_from_group
         (program_short_name       => v_program_short_name,
          program_application      => v_program_application,
          request_group            => v_request_group1,
         group_application        => v_group_application
                               );
                                                           
      
                                                           
   COMMIT;
   --+=======================================================================
   --+Remove Concurrent Program Definition and Executable
   --+=======================================================================
   apps.fnd_program.delete_program(v_program_short_name,v_program_application); 
   apps.fnd_program.delete_executable(v_program_short_name,v_program_application); 
   DELETE FROM APPS.XDO_LOBS WHERE LOB_CODE = v_program_short_name;
   APPS.XDO_TEMPLATES_PKG.DELETE_ROW(v_program_application, v_program_short_name);
   DELETE FROM APPS.XDO_DS_DEFINITIONS_TL WHERE DATA_SOURCE_CODE = v_program_short_name;
   DELETE FROM APPS.XDO_DS_DEFINITIONS_B WHERE DATA_SOURCE_CODE = v_program_short_name;
   COMMIT; 
END;
/
EXIT

/



Deleting a concurrent Program


Begin
fnd_program.delete_program('program short name','
APPLICATION_SHORT_NAME');
fnd_program.delete_executable('program short name','
APPLICATION_SHORT_NAME');
commit;
End;



Deleting a xml template 


BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW(APPLICATION_SHORT_NAME ,TEMPLATE_CODE);
COMMIT;
END;

 


 COMPILE THE FORM IN ORACLE R12


 frmcmp_batch module=XX_GATE_ENTRY.fmb userid=apps/fserver output_file=/oracle2/VIS1211/apps/apps_st/appl/po/12.0.0/forms/US/XX_GATE_ENTRY.fmx compile_all=YES



 COMPILE THE FORM IN ORACLE 11i

 f60gen module=XX_GATE_ENTRY.fmb userid=apps/fserver output_file=/oracle2/VIS1211/apps/apps_st/appl/po/12.0.0/forms/US/XX_GATE_ENTRY.fmx compile_all=YES

No comments:

Post a Comment