Rem
Rem $Header: paf_filetransfer_register_102040.sql 06-aug-2007.17:35:33 rahgupta Exp $
Rem
Rem paf_filetransfer_register_102040.sql
Rem
Rem Copyright (c) 2007, Oracle.  All rights reserved.  
Rem
Rem    NAME
Rem      paf_filetransfer_register_102040.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    rahgupta    07/17/07 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

DECLARE
l_jobtype_guid VARCHAR2(32);
l_group_transfer_guid VARCHAR2(32);

BEGIN
  SELECT jobtype_guid INTO l_jobtype_guid FROM mgmt_paf_jobtypes 
  WHERE jobtype = 'PAFFileTransfer';

  -- register TRANSFER group
  MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM_GROUP(
    p_jobtype_guid => l_jobtype_guid,
    p_name => 'PA_FILE_TRANSFER_TRANSFER_HDR@oracle.sysman.pp.paf.ui.resource.PAResourceBundle',
    p_group_order => 4,
    x_guid => l_group_transfer_guid
  );

  MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM(
    p_guid => l_jobtype_guid,
    p_name => 'PA_USE_FTP_TRANSFER@oracle.sysman.pp.paf.ui.resource.PAResourceBundle',
    p_param_name => 'ftp_transfer',
    p_param_value => 'false',
    p_order => 9,
    p_group_guid => l_group_transfer_guid
  );

EXCEPTION WHEN OTHERS THEN NULL;

END;
/

COMMIT;