eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XNP_STANDARD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 394


PROCEDURE SMS_DELETE_PORTED_NUMBER
 (p_WORKITEM_INSTANCE_ID IN NUMBER
 ,x_ERROR_CODE           OUT NOCOPY NUMBER
 ,x_ERROR_MESSAGE        OUT NOCOPY VARCHAR2
 )
IS
l_starting_number VARCHAR2(20);

Line: 419


  XNP_CORE.SMS_DELETE_PORTED_NUMBER
    (p_STARTING_NUMBER=>l_starting_number
    ,p_ENDING_NUMBER=>l_ending_number
    ,x_ERROR_CODE=>x_ERROR_CODE
    ,x_ERROR_MESSAGE=>x_ERROR_MESSAGE
    );

Line: 426


END SMS_DELETE_PORTED_NUMBER;

Line: 461


PROCEDURE SOA_UPDATE_CUTOFF_DATE
 ( p_ORDER_ID             IN  NUMBER,
   p_LINEITEM_ID          IN  NUMBER,
   p_WORKITEM_INSTANCE_ID IN  NUMBER,
   p_FA_INSTANCE_ID       IN  NUMBER,
   p_CUR_STATUS_TYPE_CODE     VARCHAR2,
   x_ERROR_CODE           OUT NOCOPY NUMBER,
   x_ERROR_MESSAGE        OUT NOCOPY VARCHAR2
 )
IS
l_porting_id      VARCHAR2(40) := null;

Line: 521


    XNP_CORE.SOA_UPDATE_CUTOFF_DATE
     (p_porting_id            => l_porting_id
     ,p_old_sp_cutoff_due_date=> xnp_utils.canonical_to_date(l_cutoff_date)
     ,p_local_sp_id           => l_LOCAL_SP_ID
     ,p_order_id              => p_order_id
     ,p_lineitem_id           => p_lineitem_id
     ,p_workitem_instance_id  => p_workitem_instance_id
     ,p_fa_instance_id        => p_fa_instance_id
     ,x_error_code            => x_ERROR_CODE
     ,x_error_message         => x_ERROR_MESSAGE
     );

Line: 535


    XNP_CORE.SOA_UPDATE_CUTOFF_DATE
     (p_starting_number       => l_starting_number
     ,p_ending_number         => l_ending_number
     ,p_CUR_STATUS_TYPE_CODE  => p_CUR_STATUS_TYPE_CODE
     ,p_local_sp_id           => l_LOCAL_SP_ID
     ,p_old_sp_cutoff_due_date=> xnp_utils.canonical_to_date(l_cutoff_date)
     ,p_order_id              => p_order_id
     ,p_lineitem_id           => p_lineitem_id
     ,p_workitem_instance_id  => p_workitem_instance_id
     ,p_fa_instance_id        => p_fa_instance_id
     ,x_error_code            => x_ERROR_CODE
     ,x_error_message         => x_ERROR_MESSAGE
     );

Line: 556


        fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE');

Line: 560


END SOA_UPDATE_CUTOFF_DATE;

Line: 1388


PROCEDURE SOA_UPDATE_SV_STATUS
 ( p_ORDER_ID               IN  NUMBER,
   p_LINEITEM_ID            IN  NUMBER,
   p_WORKITEM_INSTANCE_ID   IN  NUMBER,
   p_FA_INSTANCE_ID         IN  NUMBER,
   p_CUR_STATUS_TYPE_CODE       VARCHAR2,
   p_NEW_STATUS_TYPE_CODE       VARCHAR2,
   p_STATUS_CHANGE_CAUSE_CODE   VARCHAR2,
   x_ERROR_CODE             OUT NOCOPY NUMBER,
   x_ERROR_MESSAGE          OUT NOCOPY VARCHAR2
 )

IS
l_starting_number     VARCHAR2(20);

Line: 1466


  XNP_CORE.SOA_UPDATE_SV_STATUS
   (p_STARTING_NUMBER          => l_starting_number
   ,p_ENDING_NUMBER            => l_ending_number
   ,p_CUR_STATUS_TYPE_CODE     => p_cur_status_type_code
   ,p_LOCAL_SP_ID              => l_LOCAL_SP_ID
   ,P_NEW_STATUS_TYPE_CODE     => p_new_status_type_code
   ,P_STATUS_CHANGE_CAUSE_CODE => p_status_change_cause_code
   ,p_ORDER_ID                 => p_ORDER_ID
   ,p_LINEITEM_ID              => p_LINEITEM_ID
   ,p_WORKITEM_INSTANCE_ID     => p_WORKITEM_INSTANCE_ID
   ,p_FA_INSTANCE_ID           => p_FA_INSTANCE_ID
   ,X_ERROR_CODE               => x_ERROR_CODE
   ,X_ERROR_MESSAGE            => x_ERROR_MESSAGE
   );

Line: 1487


        fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');

Line: 1491


END SOA_UPDATE_SV_STATUS;

Line: 1502


PROCEDURE SOA_UPDATE_CHARGING_INFO
 ( p_ORDER_ID               IN  NUMBER,
   p_LINEITEM_ID            IN  NUMBER,
   p_WORKITEM_INSTANCE_ID   IN  NUMBER,
   p_FA_INSTANCE_ID         IN  NUMBER,
   p_CUR_STATUS_TYPE_CODE       VARCHAR2,
   x_ERROR_CODE             OUT NOCOPY NUMBER,
   x_ERROR_MESSAGE          OUT NOCOPY VARCHAR2
 )
IS
l_PORTING_ID       VARCHAR2(80) := null;

Line: 1592


    XNP_CORE.SOA_UPDATE_CHARGING_INFO
     (p_porting_id           =>l_porting_id
     ,p_LOCAL_SP_ID          =>l_LOCAL_SP_ID
     ,p_INVOICE_DUE_DATE     =>XNP_UTILS.CANONICAL_TO_DATE(l_invoice_due_date)
     ,p_CHARGING_INFO        =>l_charging_info
     ,p_BILLING_ID           =>l_BILLING_ID
     ,p_USER_LOCTN_VALUE     =>l_USER_LOCTN_VALUE
     ,p_USER_LOCTN_TYPE      =>l_USER_LOCTN_TYPE
     ,p_PRICE_CODE           =>l_PRICE_CODE
     ,p_PRICE_PER_CALL       =>l_PRICE_PER_CALL
     ,p_PRICE_PER_MINUTE     =>l_PRICE_PER_MINUTE
     ,p_ORDER_ID             =>p_ORDER_ID
     ,p_LINEITEM_ID          =>p_LINEITEM_ID
     ,p_WORKITEM_INSTANCE_ID =>p_WORKITEM_INSTANCE_ID
     ,p_FA_INSTANCE_ID       =>p_FA_INSTANCE_ID
     ,x_ERROR_CODE           =>x_ERROR_CODE
     ,x_ERROR_MESSAGE        =>x_ERROR_MESSAGE
     );

Line: 1617


        fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CHARGING_INFO');

Line: 1621


END SOA_UPDATE_CHARGING_INFO;

Line: 2426


PROCEDURE SMS_DELETE_FE_MAP
 (p_WORKITEM_INSTANCE_ID IN NUMBER
 ,p_FE_ID IN                NUMBER
 ,p_FEATURE_TYPE            VARCHAR2
 ,x_ERROR_CODE          OUT NOCOPY NUMBER
 ,x_ERROR_MESSAGE       OUT NOCOPY VARCHAR2
 )
IS
l_STARTING_NUMBER VARCHAR2(40);

Line: 2454


   XNP_CORE.SMS_DELETE_FE_MAP
    (l_STARTING_NUMBER
    ,l_ENDING_NUMBER
    ,p_FE_ID
    ,p_FEATURE_TYPE
    ,x_ERROR_CODE
    ,x_ERROR_MESSAGE
    );

Line: 2470


          ,'XNP_STANDARD.SMS_DELETE_FE_MAP');

Line: 2474


END SMS_DELETE_FE_MAP;

Line: 2672


PROCEDURE SMS_UPDATE_FE_MAP_STATUS
 (p_ORDER_ID             IN NUMBER,
  p_LINEITEM_ID          IN NUMBER,
  p_WORKITEM_INSTANCE_ID IN NUMBER,
  p_FA_INSTANCE_ID       IN NUMBER,
  p_FEATURE_TYPE            VARCHAR2,
  p_FE_ID                   NUMBER,
  p_PROV_STATUS             VARCHAR2,
  x_ERROR_CODE          OUT NOCOPY NUMBER,
  x_ERROR_MESSAGE       OUT NOCOPY VARCHAR2
 )
IS
l_STARTING_NUMBER VARCHAR2(20);

Line: 2705


  XNP_CORE.SMS_UPDATE_FE_MAP_STATUS
   (p_STARTING_NUMBER      => l_STARTING_NUMBER
   ,p_ENDING_NUMBER        => l_ENDING_NUMBER
   ,p_FE_ID                => p_FE_ID
   ,p_PROV_STATUS          => p_PROV_STATUS
   ,p_FEATURE_TYPE         => p_FEATURE_TYPE
   ,p_ORDER_ID             => p_ORDER_ID
   ,p_LINEITEM_ID          => p_LINEITEM_ID
   ,p_WORKITEM_INSTANCE_ID => p_WORKITEM_INSTANCE_ID
   ,p_FA_INSTANCE_ID       => p_FA_INSTANCE_ID
   ,x_ERROR_CODE           => x_ERROR_CODE
   ,x_ERROR_MESSAGE        => x_ERROR_MESSAGE
   );

Line: 2727


         ,'XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS');

Line: 2731


END SMS_UPDATE_FE_MAP_STATUS;

Line: 3108


PROCEDURE SOA_UPDATE_SV_STATUS
 ( p_ORDER_ID               IN  NUMBER,
   p_LINEITEM_ID            IN  NUMBER,
   p_WORKITEM_INSTANCE_ID   IN  NUMBER,
   p_FA_INSTANCE_ID         IN  NUMBER,
   p_NEW_STATUS_TYPE_CODE       VARCHAR2,
   p_STATUS_CHANGE_CAUSE_CODE   VARCHAR2,
   x_ERROR_CODE             OUT NOCOPY NUMBER,
   x_ERROR_MESSAGE          OUT NOCOPY VARCHAR2
 )
IS
l_porting_id           VARCHAR2(80) := NULL;

Line: 3129


  SELECT status_type_code
    FROM xnp_sv_soa
   WHERE object_reference = l_porting_id;

Line: 3205


  XNP_CORE.SOA_UPDATE_SV_STATUS
   (p_PORTING_ID               => l_porting_id
   ,p_LOCAL_SP_ID              => l_LOCAL_SP_ID
   ,P_NEW_STATUS_TYPE_CODE     => p_new_status_type_code
   ,P_STATUS_CHANGE_CAUSE_CODE => p_status_change_cause_code
   ,p_ORDER_ID                 => p_ORDER_ID
   ,p_LINEITEM_ID              => p_LINEITEM_ID
   ,p_WORKITEM_INSTANCE_ID     => p_WORKITEM_INSTANCE_ID
   ,p_FA_INSTANCE_ID           => p_FA_INSTANCE_ID
   ,X_ERROR_CODE               => x_ERROR_CODE
   ,X_ERROR_MESSAGE            => x_ERROR_MESSAGE
   );

Line: 3224


        fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_SV_STATUS');

Line: 3228


END SOA_UPDATE_SV_STATUS;

Line: 3235


PROCEDURE SOA_UPDATE_NOTES_INFO
 ( p_ORDER_ID               IN  NUMBER,
   p_LINEITEM_ID            IN  NUMBER,
   p_WORKITEM_INSTANCE_ID   IN  NUMBER,
   p_FA_INSTANCE_ID         IN  NUMBER,
   x_ERROR_CODE             OUT NOCOPY NUMBER,
   x_ERROR_MESSAGE          OUT NOCOPY VARCHAR2
 )
IS
  l_PORTING_ID                  VARCHAR2(40) := null;

Line: 3286


  XNP_CORE.SOA_UPDATE_NOTES_INFO
  (p_PORTING_ID                 => l_PORTING_ID
  ,p_LOCAL_SP_ID                => l_LOCAL_SP_ID
  ,p_PREORDER_AUTHORIZATION_CODE=> l_PREORDER_AUTHORIZATION_CODE
  ,p_COMMENTS                   => l_COMMENTS
  ,p_NOTES                      => l_NOTES
  ,p_ORDER_ID                   => p_ORDER_ID
  ,p_LINEITEM_ID                => p_LINEITEM_ID
  ,p_WORKITEM_INSTANCE_ID       => p_WORKITEM_INSTANCE_ID
  ,p_FA_INSTANCE_ID             => p_FA_INSTANCE_ID
  ,x_ERROR_CODE                 => x_ERROR_CODE
  ,x_ERROR_MESSAGE              => x_ERROR_MESSAGE
  );

Line: 3310


        fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NOTES_INFO');

Line: 3314


END SOA_UPDATE_NOTES_INFO;

Line: 3327


PROCEDURE SOA_UPDATE_NETWORK_INFO
 ( p_ORDER_ID               IN  NUMBER,
   p_LINEITEM_ID            IN  NUMBER,
   p_WORKITEM_INSTANCE_ID   IN  NUMBER,
   p_FA_INSTANCE_ID         IN  NUMBER,
   x_ERROR_CODE             OUT NOCOPY NUMBER,
   x_ERROR_MESSAGE          OUT NOCOPY VARCHAR2
 )
IS
  l_LOCAL_SP_ID       NUMBER := 0;

Line: 3463


   XNP_CORE.SOA_UPDATE_NETWORK_INFO
    (p_porting_id           => l_porting_id
    ,p_LOCAL_SP_ID          => l_LOCAL_SP_ID
    ,p_ROUTING_NUMBER_ID    => l_ROUTING_NUMBER_ID
    ,p_CNAM_ADDRESS         => l_CNAM_ADDRESS
    ,p_CNAM_SUBSYSTEM       => l_CNAM_SUBSYSTEM
    ,p_ISVM_ADDRESS         => l_ISVM_ADDRESS
    ,p_ISVM_SUBSYSTEM       => l_ISVM_SUBSYSTEM
    ,p_LIDB_ADDRESS         => l_LIDB_ADDRESS
    ,p_LIDB_SUBSYSTEM       => l_LIDB_SUBSYSTEM
    ,p_CLASS_ADDRESS        => l_CLASS_ADDRESS
    ,p_CLASS_SUBSYSTEM      => l_CLASS_SUBSYSTEM
    ,p_WSMSC_ADDRESS        => l_WSMSC_ADDRESS
    ,p_WSMSC_SUBSYSTEM      => l_WSMSC_SUBSYSTEM
    ,p_RN_ADDRESS           => l_RN_ADDRESS
    ,p_RN_SUBSYSTEM         => l_RN_SUBSYSTEM
    ,p_ORDER_ID             => p_ORDER_ID
    ,p_LINEITEM_ID          => p_LINEITEM_ID
    ,p_WORKITEM_INSTANCE_ID => p_WORKITEM_INSTANCE_ID
    ,p_FA_INSTANCE_ID       => p_FA_INSTANCE_ID
    ,x_ERROR_CODE           => x_ERROR_CODE
    ,x_ERROR_MESSAGE        => x_ERROR_MESSAGE
    );

Line: 3496


        fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_NETWORK_INFO');

Line: 3500


END SOA_UPDATE_NETWORK_INFO;

Line: 3509


PROCEDURE SOA_UPDATE_CUSTOMER_INFO
 ( p_ORDER_ID               IN  NUMBER,
   p_LINEITEM_ID            IN  NUMBER,
   p_WORKITEM_INSTANCE_ID   IN  NUMBER,
   p_FA_INSTANCE_ID         IN  NUMBER,
   x_ERROR_CODE             OUT NOCOPY NUMBER,
   x_ERROR_MESSAGE          OUT NOCOPY VARCHAR2
 )
IS
  l_PORTING_ID                VARCHAR2(40) := null;

Line: 3653


  XNP_CORE.SOA_UPDATE_CUSTOMER_INFO
    (p_PORTING_ID                => l_PORTING_ID
    ,p_LOCAL_SP_ID               => l_LOCAL_SP_ID
    ,p_CUSTOMER_ID               => l_CUSTOMER_ID
    ,p_CUSTOMER_NAME             => l_CUSTOMER_NAME
    ,p_CUSTOMER_TYPE             => l_CUSTOMER_TYPE
    ,p_ADDRESS_LINE1             => l_ADDRESS_LINE1
    ,p_ADDRESS_LINE2             => l_ADDRESS_LINE2
    ,p_CITY                      => l_CITY
    ,p_PHONE                     => l_PHONE
    ,p_FAX                       => l_FAX
    ,p_EMAIL                     => l_EMAIL
    ,p_PAGER                     => l_PAGER
    ,p_PAGER_PIN                 => l_PAGER_PIN
    ,p_INTERNET_ADDRESS          => l_INTERNET_ADDRESS
    ,p_ZIP_CODE                  => l_ZIP_CODE
    ,p_COUNTRY                   => l_COUNTRY
    ,p_CUSTOMER_CONTACT_REQ_FLAG => l_CUSTOMER_CONTACT_REQ_FLAG
    ,p_CONTACT_NAME              => l_CONTACT_NAME
    ,p_ORDER_ID                  => p_ORDER_ID
    ,p_LINEITEM_ID               => p_LINEITEM_ID
    ,p_WORKITEM_INSTANCE_ID      => p_WORKITEM_INSTANCE_ID
    ,p_FA_INSTANCE_ID            => p_FA_INSTANCE_ID
    ,x_ERROR_CODE                => x_ERROR_CODE
    ,x_ERROR_MESSAGE             => x_ERROR_MESSAGE
    );

Line: 3689


        fnd_message.set_token('ERROR_LOCN','XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO');

Line: 3693


END SOA_UPDATE_CUSTOMER_INFO;