APPS.XNP_FA_CB SQL Statements

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

Line: 48

   select FE_ID
   from XDP_FA_RUNTIME_LIST
   where FA_INSTANCE_ID = l_fa_instance_id;

Line: 107

    SELECT order_id
      INTO l_order_id
      FROM xdp_fulfill_worklist
     WHERE workitem_instance_id = l_workitem_instance_id ;

Line: 215

      XNP_MESSAGE.UPDATE_STATUS
         (p_message_id
	   ,'FAILED'
	   ,l_fnd_message
         ) ;

Line: 234

      XNP_MESSAGE.UPDATE_STATUS
         (p_message_id
	   ,'FAILED'
	   ,x_error_message
         ) ;

Line: 248

      XNP_MESSAGE.UPDATE_STATUS
         (p_message_id
	   ,'FAILED'
	   ,x_error_message
         ) ;

Line: 277

  XNP_CORE.SMS_UPDATE_FE_MAP_STATUS
   (p_STARTING_NUMBER       =>p_STARTING_NUMBER
   ,p_ENDING_NUMBER         =>p_ENDING_NUMBER
   ,p_FE_ID                 =>p_FE_ID
   ,p_FEATURE_TYPE          =>p_FEATURE_TYPE
   ,p_PROV_STATUS           =>p_PROV_STATUS
   ,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: 311

    XNP_CORE.SMS_UPDATE_FE_MAP_STATUS
     (P_STARTING_NUMBER       =>P_STARTING_NUMBER
     ,p_ENDING_NUMBER         =>P_ENDING_NUMBER
     ,p_FE_ID                 =>p_FE_ID
     ,p_FEATURE_TYPE          =>p_FEATURE_TYPE
     ,p_PROV_STATUS           =>p_PROV_STATUS
     ,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: 347

  XNP_CORE.SMS_DELETE_FE_MAP
     (p_STARTING_NUMBER => p_starting_number
     ,p_ENDING_NUMBER => p_ending_number
     ,p_FE_ID => p_fe_id
     ,p_FEATURE_TYPE => p_feature_type
     ,x_ERROR_CODE => x_error_code
     ,x_ERROR_MESSAGE => x_error_message
     );

Line: 356

  XNP_CORE.SMS_DELETE_PORTED_NUMBER
     (p_STARTING_NUMBER => p_starting_number
     ,p_ENDING_NUMBER => p_ending_number
     ,x_ERROR_CODE => x_error_code
     ,x_ERROR_MESSAGE => x_error_message
     );